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
Order Utilities
Viewed 1145 times since Tue, Jul 3, 2012
Allow Job Code Input to be Dependent on Order Status
Viewed 2185 times since Wed, Jun 13, 2012
Detail Optional 2
Viewed 1677 times since Wed, Jul 4, 2012
Order Enquiry
Viewed 1366 times since Tue, Jul 3, 2012
Additional Options for Order Authorisation
Viewed 1541 times since Fri, Jun 8, 2012
Detail Back-2-Back
Viewed 1700 times since Wed, Jul 4, 2012
Document Processing - Alternative Extra Text Items
Viewed 929 times since Fri, Jun 19, 2020
Additional Deposit Processing Print Items (SOP Only)
Viewed 1307 times since Wed, Jun 13, 2012
View – View Order Header
Viewed 665 times since Tue, Jul 3, 2012
System Profiles
Viewed 1432 times since Wed, Jul 4, 2012