Period Values From History

Document path 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 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 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.

Field

Description

Parts usage from Inventory Movement History

Check this option to set period usage for all parts.

Customer Turnover

Check this option to set period turnover for all customers.

Use A/R ledger transaction history

Check this option to ledger transaction history rather than sales history.

Supplier Turnover

Check this option to set period turnover for all suppliers.

Use A/P ledger transaction history

Check this option to ledger transaction history rather than purchase history.

Period 1

Check to calculate and update period 1.

Period 1 Start Date

Enter the start date for period 1 here.

Period 2

Check to calculate and update period 2.

Period 2 Start Date

Enter the start date for period 2 here.

Period 3

Check to calculate and update period 3.

Period 3 Start Date

Enter the start date for period 3 here.

Button

Action

Process

Process the function.

See also: -

Compiled in Program Version 3.10. Help data last modified 4 APR 2003 14:10. Class wPeriodAnal last modified 1 MAY 2009 05:22:26.

Document path Reference Contents > Manager Controls > Period Values From History