Within the Order Processing applications, options are available for user accumulation items.These allow you to reference a data item on the order detail file to be accumulated up to the order header file as a total – allowing you to accumulate items such as Order Quantity, Delivered Qty and Invoiced Quantity. As well as enquiry this allows you to, for example, have a landing page tab to see orders that have items that have been delivered but not invoiced.
Existing features allowed you to define up to six user accumulation items, this has now been increased to twelve items.
Set Database Profiles
You reference the data items for accumulation within the Database Profiles for the application.Select Installation from the main menu followed by Application Manager and Set Database Profiles.Choose the required application.
For Sales Order Processing you reference the detail items to be accumulated up to the order header in the parameter screen Detail Optional 7
Up to twelve items can be referenced and you can reference numeric data items with a K, L or M data item type or a calculated field. You can also reference a Boolean Y/N field (this will accumulate 1 for Y or 0 for blank/No).
Header Optional 6 allows you to reference the corresponding twelve items on the order header.
Note the items referenced here can only be numeric K, L or M items – K or L for 2dp values, M for 4dp values.
The equivalent profiles screens for Purchase Order Processing are Detail Optional 7 and Header Optional 5.
Note
If referencing items on the order detail with existing values, you can use the Audit Pointers option within the Controls & Audit Manager to accumulate these items to the order header.
Article ID: 2385
Created On: Thu, Oct 24, 2024 at 1:57 PM
Last Updated On: Thu, Oct 24, 2024 at 1:58 PM
Online URL: https://kb.datafile.co.uk/article/additional-user-accumulation-items-2385.html