Manager Controls: Period Values From History

Period Values From History

Reference Contents > Manager Controls > Period Values From History

The three usage and turnover values for Parts, Customers and Suppliers are generated automatically by updating of period one value, and subsequent roll-over actions processed from the Period file update dialog, or automatically if set to do so in the Ledger Manager Controls.

This automatic process has some limitations, particularly with respect to Customers and Suppliers when Ledgers are being used. These are:

1. In general, it is not possible to re-calculate values if you forget to process a roll-over on time.
2. Supplier turnover accumulates values only on purchase order prices when goods are received and do not take account of additional expenses or credits that do not go through the PO system.
3. Particularly for those using ledgers, some suppliers cause expenses to be incurred without purchase orders.

These limitations can be avoided by using this window to re-generate values based on history records. It provides a number of options.

You can select any or all of Parts, Customers and Suppliers.
Parts use Inventory History and record the net quantity in the period for all movements of types: A = SO dispatch, B = SO return, E = General issue, F = General return, G = PO kit issue, H = PO kit return, I = WO kit issue, J = WO kit return, U = Bonded, V = Released from bonding and X = WO extra issue (ABEFGHIJUVX).

Customers use sales history or, if Ledgers is licensed, you can optionally choose A/R transaction history (in which case it sums transactions of type 10 (Dispatch Invoice) and 12 (Return Credit).

Suppliers use purchase history or, if Ledgers is licensed, you can optionally choose A/P transaction history (in which case it sums only transactions of type 30 (Purchase Invoices and Credits).

You can selectively choose to update each period and enter the starting date for each. However, dates for each selected period must be in sequence with the earliest date first. Also you must select later periods inclusively. I.E. You must set period 1, if period 2 is to be calculated, and 2 if 3 is to be calculated.

NOTE: In all cases you must have history extending back far enough to cover the periods you choose. This may vary substantially, especially if you have upgraded to Ledgers or implemented different parts of the system at significantly different times.

NOTE: The normal updating of period 1 will still take place after this manual re-setting process. As a consequence, period 1 values may need to be reset at regular intervals.

Compiled in Program Version 5.10. Help data last modified 24 Apr 2012 06:50:00.00. Class wPeriodAnal last modified 10 Oct 2017 11:48:29.

Reference Contents > Manager Controls > Period Values From History