Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Ian Gorman]

Hello,

We have a 2012R3 CU11 environment and use FIFO for item costs.

When creating a Counting Journal at our sites for month-end, we notice that the ‘Cost Amount’ column contains the same price for multiple locations.

An example:

Item #1 – Site 001 – Warehouse TRUCK1 – Location TRUCK1 – Cost Amount $10.00
Item #1 – Site 001 – Warehouse TRUCK2 – Location TRUCK2 – Cost Amount $10.00
Item #1 – Site 001 – Warehouse TRUCK3 – Location TRUCK3 – Cost Amount $10.00
Item #1 – Site 001 – Warehouse TRUCK4 – Location TRUCK4 – Cost Amount $10.00

When we post the counting journal and it applies to the GL, we notice cost variances within a few dollars for each TRUCK. 

Depending upon the item quantity, the variance between the counting journal and the GL can be upwards of +- $100 – $500.

Is this because the counting journal displays costs as a weighted avg. and the GL side converts it to FIFO?

How can we make our counting journals display accurate pricing by TRUCK so our end users can accurately calculate their usage?

——————————
Ian Gorman, PMP
ERP Financial Manager
——————————

[André Arnaud de Calavon]

Hi Ian,

When using FIFO, you can’t control the cost price manually. It will use an average cost until you use the inventory closing or recalculation. The cost price is shown for positive adjustments. It will then take that price into consideration. 
An accurate price does not exist for FIFO. You could consider a customization for having an information field (display method) for the current cost per location, but this could be changed afterwards due to the inventory closing or recalculation.

——————————
kind regards,

André Arnaud de Calavon [Designation]
Kaya Consulting
The Netherlands
——————————
——————————————-