Dynamics Community Forum Thread Details

Inventory doesn't tie with Stock on Hand ledger

Hi all

We had entered a 'Receiving Transaction Entry' for stock received from a supplier. We then realised the invoice received was wrong and had to delete the incorrect invoice in GP. We voided the transaction using 'Void Open Transactions'. This has offset the amounts in the General Ledgers of Stock on Hand and Trade Creditors - but when we run a stock status report the inventory is still there.

Going forward we know to use the 'Returns Transaction Entry' instead of voiding (we are still new to the software! haha) to avoid this issue.

I've tried using the 'Transactions Entry' window in Inventory to decrease the amount, but it won't let me choose the unit cost and defaults to an amount that I am not sure where it is sourced. When I go to item maintenance, the current/standard cost is $3.99, but when I process through Transactions Entry the amount changes to $1.88. I've had a further investigation and this amount comes from the last invoice entered into the system in relation to the same inventory item. Is there anyway to override this amount?

What is the best way to decrease our stock amount without hitting the stock on hand ledger twice as this would then understate the ledger?

Quick Links

Leaderboard