Exact Cost Reversing Mandatory explained in Dynamics 365 Business Central.

Revisit your inventory returns costing policy

Hello everyone, my name is Christos Pittis, and I am a Dynamics 365 Business Central/LS Express consultant, and I work for Memorli Business Solutions. In this episode I am going to show you how to make use of the Exact Cost Reversing Mandatory functionality in Dynamics 365 Business Central so to ensure that returned items, both in sales and purchases, are valued at the same cost as the original transaction when being put back on inventory/drawn from inventory.

When a Purchase Order is returned from inventory, how should it be valued? And, conversely, when a Sales Return is put back into stock, how it should be valued?

Users need to ensure that returned items, both in sales and purchases, are valued at the same cost as the original transaction when being put back on inventory/drawn from inventory.

After going through this exercise, you might want to revisit your inventory returns costing policy in Dynamics 365 Business Central.

Go ahead and create a new Item, named “test-exact” and set the costing method to FIFO.

The Automatic Cost Posting and Automatic Cost Adjustment fields in Inventory Setup are off for now

Now let’s create 3 Purchase Orders and post them all:

Check the Item Ledger Entries.

Notice the entries are open aka not applied to any outbound entries yet (Sales, Purchase Returns etc.) Check the Value Entries of each Item Ledger Entry.

Visit the Purchases & Payables Setup and Sales & Receivable Setup and activate the Exact Cost Reversing Mandatory fields.

Create a Purchase Return Order for the 23/01/20 Unit Cost £10.

The proper way is to use the Copy Document function so to copy the correct invoice information and apply this outbound entry to the correct inbound entry. For now, I will do it the manual way so to demonstrate where the problem is.

WRONG:

Notice the Direct Unit Cost (Excl. VAT) is set to £30 instead of £10. That is because the system takes the Last Direct Cost from the Item Card and the Appl.-to Item Entry field is empty.

I will now delete the lines and use the Copy Document function.

CORRECT:

The Direct Unit Cost (Excl. VAT) is set to £10 as expected, and the Appl.-to Item Entry field is filled in with the Purchase entry.

Post it. Have a look at the Item Ledger Entries again; you will see that are not open anymore.

Visit the following for the return Item Ledger Entry: Value Entries and Applied Entries.

Value Entries

Applied Item Entries

In simple words, the return entry has used to correct unit cost and has been closed off because it linked to the correct purchase entry.

I will run the Adjust Cost – Item Entries batch job.

The Unit Cost has now changed to £25; it’s two entries open: Quantity 1, Unit Cost £20 Quantity 1, Unit Cost £30

(*** Remember, Adjust Cost is not set to run automatically in this example) (*** FIFO uses the Average logic to calculate this field)

I will run the Post Inventory Cost to G/L.