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
Omit Print of Account Items on Documents
Viewed 1312 times since Wed, Jun 13, 2012
Detail Optional 3
Viewed 1500 times since Wed, Jul 4, 2012
Only Allow Order Amendments Subject to Selection Criteria
Viewed 1443 times since Wed, Jun 13, 2012
Application User Facilities
Viewed 1357 times since Wed, Jul 4, 2012
Document Processing – Additional Comment Text per Order Detail
Viewed 1153 times since Wed, Jun 13, 2012
POP Accessories Reports
Viewed 1174 times since Tue, Jul 3, 2012
Order Utilities
Viewed 1082 times since Tue, Jul 3, 2012
SOP Accessories Reports
Viewed 1225 times since Tue, Jul 3, 2012
Document Processing
Viewed 1199 times since Tue, Jul 3, 2012
Replicate – Copy a Order (Excluding Compact)
Viewed 703 times since Tue, Jul 3, 2012