Dynamics Community Forum Thread Details

Good day Folks

I have an interesting challenge around Inventoried items and Return Purchase Orders and Landed Costs and I'd appreciate any guidance please. Here is the scenario.

1 Item uses FIFO costing method.
2 The adjust cost job runs overnight which is why it is set to 'never' in the Inventory setup.
3 Purchase Order receipt no PR1234 is posted for an item qty of 5 @ 50.00 and is invoice matched.
4 Purchase Order is moved to archives.
5 Purchase Return order is posted against that receipt no PR1234 for a qty of 2.
6 Post a Purchase Invoice for landed costs for a total currency value of 20.00 and assign to receipt no PR1234 (this assigns over the full qty of 5 and calcuates to a unit cost of 4.00 each)
7 The adjust cost job debits the Direct Cost GL account and credits the Inventory BS stock account with the currency value off the landed cost invoice for the qty of 2 which were returned : 2 x 4.00 = 8.00

The Total cost of the item in the ILE is 162.00

The remaining qty is 3 which equates to a unit cost of 54.00

The Direct Cost GL account should not carry a balance but now the 8.00 is the problem. I'm wondering if I'm missing a step because I have to manually journalise the value to credit the Direct Cost GL account and that is what I'm questioning.

Would anyone be able to guide me around this please as to how I can avoid needing to do a general journal?

Thank you

Categories:

Financial Management

Quick Links

Leaderboard