web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / FIFO settlement error
Microsoft Dynamics AX (Archived)

FIFO settlement error

(0) ShareShare
ReportReport
Posted on by Community Member

Hello everyone,

I have an issue with FFIO adjustment and settlement for one of my sales orders, kindly have a look into below figures first.

Physical date Financial date Reference Adjustment Number Receipt Issue Quantity Cost/unit Cost amount Financial cost amount Unit price Financially closed
12/04/2016 31/05/2016 Purchase order AU-16/00126 Purchased 2 402.795 805.59 805.59 401.15 31/05/2016
15/04/2016 31/05/2016 Purchase order AU-16/00136 Purchased 210 402.1306667 84,447.44 84,447.44 401.15 31/05/2016
19/05/2016 7/06/2016 Purchase order 748.41 AU-16/00184 Purchased 530 403.9935472 214,116.58 213,368.17 401.15 30/06/2016
19/05/2016 7/06/2016 Purchase order 10.31 AU-16/00184 Purchased 7 404.0557143 2,828.39 2,818.08 401.15 30/06/2016

Physical date Financial date Reference Adjustment Number Receipt Issue Quantity Cost/unit Cost amount Financial cost amount Unit price Financially closed
21/04/2016 22/04/2016 Sales order -808.00 RF0181528 Sold -2 404 -808.00 437.85 31/05/2016

so I have put all the information related to one of my items, in top I listed the first 4 purchase orders and the first sales order as well for this item.

the closing and adjustment date are also in the table which is financial closing date.

am using FIFO principle without include physical value check box.

the issue is that my first sales order has picked up the cost after the closing of the month from the 3rd purchase order ( Unit cost is 404) instead of using the cost from the first purchase order ( unit cost is 402.79).

kindly I will be glad if someone can explain what is going on

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Bob,

    With this table I cannot say if it is really coming from the third PO or not. can you check the detailed settlements of the closing job? Then you know exactly what was linked or not. I assume you have included the recalculated cost amounts in this table?

    Are there more sales related to this item? Are you using reservations? Are the purchase and sales transaction marked?

  • Community Member Profile Picture
    Community Member on at

    3rd purchase order cost after settlement is 404 and sales order cost is 404 as well that's why its coming from 3rd PO instead of first 2 purchase orders.

    there is no marking or reservations to this item.

    there is other sales orders of course but this is the first sales order which should be derived from first purchase order cost as per FIFO principle.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Bob,

    I don't think we are on the same page. Inventory postings are complex. That is why I asked to check more related details. Just stating that 404 = 404 so it should be line 3 or not is too simple.

    Did you check the settlements like I suggested? If you don't know where to start, you can download the Cost Management whitepaper. The contents is valid for both AX2009 and AX2012. If you cannot find the real reason yourself, probably you can better hire an expert to have a look on-site to also check all other related tables and field values.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans