Does the Aged Report in SIMS gives the same values of the Valuation Report?

Does the Aged Report in SIMS gives the same values of the Valuation Report?

SIMS provides for the printing of an aged report from the Reports Menu, Stock Items, Aged Stock List. The aged report is based on the Last Purchase Date field available on each stock card.


The options available are the following:
  1. Option to Group the report by one of the available fields
  2. Print the report in summary format
  3. Enter the base date of the report (based on last purchase date)
  4. Number of months required for analyses 12 = one year
  5. Option to print the report by location



Supporting the above options, the report also includes the standard filtering functions available in SIMS. While analysing this report, it is important to note the following:

The report prints the quantity in stock as at today and not the quantity balance as at the user entered date.

If a stock item had a balance of 10 with a purchase date of 15 June 2015 and another 100 units were purchased again on 15 February 2016, the total quantity of 110 will be shown under the column of 15 February 2016 and not split in two. The system considered the total quantity with last refreshed date.

The date selected by the user is the main reporting criteria of the report as the system will only include the stock items where the last purchase date is less or equal to the date entered by the user. This means that if a user enters the aged date as 31/12/2015, the system will only print the items which were purchased on or before 31/12/2015 and it will not include any items purchased after this date.

For those stock items which do not have a last purchase date, they will be shown under the last column of the report. The system will update the last purchase date with Purchases (local and foreign) and Receipt of Finished Goods but not with the adjustment add.

Last Purchase date and Last Receipt mean the same thing.

Question: Should the total of the Aged Report tally with the Valuation Report?
As detailed above, the aged report includes items where the last date is equal or less to the user entered date and prints the quantities as at today. This means that the user can never compare the valuation to a given date with an aged report. Entering the aged date report with a backdated value (31/12/2015) is not analysing the quantity as at that date but reporting only the stock items still in stock today but with the purchase date of less than or equal to 31/12/2015. The valuation to a given date works out the quantity as at the user given date which is completely different from the aged report.

For your own confirmation that both report totals do tally in the valuation, enter the aged report date with a future date to cover all the purchase date in the system and compare the result with the valuation to date and not to a given date.
    • Related Articles

    • Why do I have a difference in the valuation to a given date?

      The main reason why you may have differences when you print the valuation report to a given date is mainly because of back posting. Please note that SIMS works in the weighted average costs formula to compute the cost of the valuation of all items in ...
    • Valuation to a given date; filter by location

      When issuing a valuation to a given date but filtered for particular locations, the quantity will still be printed correctly but there might by some anomalies with the value of stock. This is explained in the example below.
    • Managing BCRS Purchase Charges in SIMS

      Introduction All purchases in SIMS are only allowed to inventory products and not to non-inventory items.  With the implementation of BCRS from Monday 14th November 2022, and if you purchase products that fall within this new scheme, you will be ...
    • How to run the SIMS Archive process

      The SIMS Archive function reduces the size of the data store in Live by splitting the same data set in a different database, within the same company. This process improves the SIMS performance as it compacts the Live data set. Users can then access ...
    • SIMS Release Notes

      2024 9th May 2024 | v.3.0.69 Enhancements We have added the first batch/expiry available in the location transfer document printing query, to help you pick the right batch/expiry more easily. You can now change SP1 after importing RD through the EDI ...