Field help (REFDAT1)

This field identifies the latest date of the transactions that can be included in the calculations for this report. It is set to today's date, by default. The report will reflect the calculated value of stock from the records selected for the report as of today.

You can change the default date to any date prior to today. The report will reflect the calculated value of stock from the records selected for the report up to and including the selected date:

• If the Accounting date check box is selected, all transactions with an accounting date (ACCDAT) on or before the selected date will be included in the calculations for this report.
• If the Accounting date check box is clear, all transactions with an allocation date (IPTDAT) on or before the selected date will be included in the calculations for this report.
  If the Accounting date check box is clear, the transaction creation date (CREDAT) is applied to price adjustment movements, and to value change movements (and not the allocation date (IPTDAT)) if the Adjust issues cost field defined on the valuation method defined for the product-site record is set to No.
  

Sage advises that you set theCosting mode to eitherPrimary issue method orSecondary issue method if you change this date from the default of today's date. Additionally, you must define aStart date if theAccounting date check box is selected, and theCosting mode is set toPrimary issue method orSecondary issue method.