When running the following reports, certain settings are required in order to reconcile to the General Ledger:
Products, Reports, Periodical, Product Status by Date.
Products, Reports, Old Reports, Product Status by Date.
Products, Reports, Periodical, Product Status.
Products, Reports, Old Reports, Product Status.
Products, Period End, Transaction Reports, Status.
Use the following settings:
All products: Leave First Product and Last Product as the full range of product codes.
Location should include all locations:
Only applicable if you have Locations activated.
Leave blank to include all Locations.
No Product Group filter.
Do not change the Supplier Number or enter a Supplier.
[Only for reports 1 and 2 above] Date Type must be Transaction Date.
[Only for reports 1 and 2 above] Status as at Date: Enter the end date of the GL period eg: "31/03/2022".
Sequence: Location/Group/Product: If you do not use Locations then just Group/Product.
Qty Code for Column (these will not affect the balance, they only change the report columns included). Suggested settings:
In Stock.
Customer Order.
Back Ordered.
Reserved.
Consigned.
Available.
Include Inactive Products = Yes.
Include Superseded Products = Yes.
Include Service Items = No.
Include Available Stock = Yes.
Include Zero Available Stock = Yes.
Include Negative Available Stock = Yes.
All 'Add Qty on' = No. As per preference these settings will not affect reconciliation.
Product Status by Date report requirements
Please note that the Product Status by Date report requires Quantity file data to be present in order for the report to produce valid numbers. If you regularly purge your Quantity File, then running this report for older dates may produce incorrect results. For more information on the Quantity file, see: Delete the Quantity Changes File.
Typically, files such as the Quantity File are purged up to a year before the End of Year date when performing End of Year Housekeeping. If you need to run this report for a prior year, do so from the relevant Prior Year company, not from the Live data.