nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Value of Inventory Items Backdating

annbrinck

Morning

We are having an issue with our Inventory Value Reconcilation (IVR).

When finalising our September reports, we noticed that the IVR report was out from previous months reported and changes had been back dated to the beginning of Jan this year.

We have done some checking through back ups and the last time the report was balanced and correct was 6th Sept. Some COS and Finished Goods codes are different from what was reported on 6/9 and what was appearing in the current file.

We drilled down on the Aug P&L for one of the COS codes and noticed that all invoices for a particular product had a different inventory value on the current report to what is showing on the file from 6/9. Please see attached file. We can find no reason for this to have happened. The build for the product is exactly the same in both AR files.

Prices of raw materials and our sale items do change, but these are always updated before processing starts for a new financial month, and we have never had this problem before. We are worried this is a software issue as it has backdated through previous months.

Any assistance, insight or ideas are appreciated. I have had to start processing for October, but will checking the IVR constantly for any changes.

Thanks Ann

Drill down example of MYOB error.xlsx

Find more posts tagged with

Accepted answers

Mike_James

Hi @annbrinck , changing the referral source is probably enough to trigger a re-recording of the invoice when you click OK; this will then use the present-moment average cost of stock, which may differ from the cost when the invoice was first recorded. (I haven't tested this type of change myself, but I do know that changing a (non-financial) line description does the same).

When raw material prices change, the historical amounts used in autobuilds will not change; I note that the autobuilds in the item registers did not change between file versions.

Prior purchase transaction journals can be changed, in cases where:

- purchase orders are used, and

- receive items are used, and

- the price on the final purchase bill needs to be changed, and

- sales of that purchased stock have taken place before the bill is recorded.

AccountRight regards the cost of sale on such invoices as provisional until then, and will automatically make cost of sales adjustments. These adjustments used to appear as separate inventory journals in v19, but in the current program they are accumulated with the original purchase journal, which is tidy but not auditable.

The average cost of an item is recalculated after each recorded transaction (purchase, inventory journal); every sales invoice uses the average cost of stock onhand when that invoice is recorded.

All comments

annbrinck

Hi Mike

Thanks for your response.

Attached is an extract of the Item Register Detail as you suggested.

As mentioned in my post, our buy and sell prices do change, sometimes monthly, especially at the moment. Where possible these are updated at the beginning of every month. However we have had prices change mid-month before and while there have been changes to the inventory reconciliation report in the past ($00's max) they have never impacted on previous months reports and have never caused our Inv Rec to be out by $000's.

We did have a major price increase to a large part of our sales items effective 1st Sept. But surely that couldn't have caused the problem?

All businesses must put their prices up at some stage. Why should that affect previous reports?

For the record, we also had an increase on similar items in Feb this year and there were no problems.

Please advise how it might be possible to change the buy/sell prices of materials without this problem occuring.

Thanks

Ann

(P.S. No, I did not mean to upload the whole file, thank you for letting me know).

Item Detail.xlsx

Mike_James

Hi @annbrinck , a printout of the "item register detail report" for this item for the period from both files might shed more light on this.

From your other posts I note that you use purchase orders and receive items, which if not accurately costed from the start can result in back-dated purchase transaction adjustments, and you may already be aware that editing/changing even non-financial info on prior item sales transactions will lead to changes, because the COGS amount gets updated to the current average cost.

PS did you intend to publish the whole excel file to this (public) forum?