Home » Categories » Multiple Categories

Pack Quantity Support in Quick Forms

Datafile Software

Pack Quantity Support in Quick Forms

Stock items can be set to be sold or purchased in packs; during order entry this allows you to enter 1/0 as the quantity for 1 pack or 2/3 for 2 packs and 3 units.However if using the quick form processes to generate order details you had to enter the pack detail as units meaning that any generated order details / documents also showed the quantity in units.This new feature allows you to enter pack quantities within the quick form itself.


Installation

Database Changes

Each Quick Form is held within a separate database – named CCC-SNNN.DFD for sales order quick forms and CCC-PNNN.DFD for purchase order quick forms where CCC is the company id and NNN is the quick form entry number – and to support entry in pack quantity format each of the existing quick form databases need to be update.For new quick forms you need to update the layout of the BASE-F1.DFD database.

The Quick Form databases are a fixed structure file so the new data item below must be created at the exact item position noted. To restructure the Quick Form databases you need to select Database Systems from the main menu followed by Datafile Database Utilities, Create/Amend Database Structures and Restructure a Database. When prompted enter the path of the database to change as above (F4-Select is available if required) and the current data items are listed.



The new item must be created as Item 7 so move the cursor down to this item number and press <Enter> to add the new item.

Item Name Type Description

SPLIT-QTY M Holds the quantity of the item required in a four dp value where the significant values are the number of packs and the decimal values are the number of units. This value is used for internal purposes and when displayed shows as 1/0003 (for example).The standard quantity item (field 2) continues to be updated with the number of units.

 Once the new item has been added press <ESC> and then select the UPDATE button to update the database changes. When prompted confirm you wish to extract the existing data. Once updated you will be prompted if you wish to remove the old database – respond as required.

Remember that you will need to make this change for all the existing quick form databases where you wish to use enter the quantity in packs together with the BASE-F1 database so that any new quick forms created automatically include the SPLIT-QTY data item.

Custom Fields
  • Release ID: 6.3
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Quick Forms - Select by Alternate Account (SOP Only)
Viewed 186 times since Thu, Jan 2, 2025
Allow Account Data Items within Fax Parameters
Viewed 1778 times since Wed, Jun 13, 2012
Order Processing and Other Files
Viewed 1512 times since Tue, Jul 3, 2012
Document Parameters
Viewed 2220 times since Wed, Jul 4, 2012
Auto Accept Entered Batch Details
Viewed 2058 times since Wed, Jun 13, 2012
Sales/Purchase Order Header File – Item Screen Design
Viewed 1214 times since Wed, Jul 4, 2012
Delivery Notes / Goods Received Notes - Application User Facilities
Viewed 1857 times since Wed, Jul 4, 2012
Batch Import Orders
Viewed 1404 times since Tue, Jul 3, 2012
Revalue a Currency Order
Viewed 1462 times since Tue, Jul 3, 2012
Change Order References
Viewed 1760 times since Wed, Jun 13, 2012