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

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Unanswered

D365F&O | Landed cost accounting

(1) ShareShare
ReportReport
Posted on by 338

Dear Experts,

 

I'm encountering an issue with the Landed Cost module in D365FO when tracking costs, particularly in cases where the PO isn't closed immediately after partial receipt. Here's a breakdown of the scenario:

 

Case : PO Left Open After Partial Receipt, Then Closed Later

  1. A purchase order is created for 100 units of item A at $2 each.

  2. Estimated landed cost is entered as $50.

  3. Product receipt is done for 95 units, but the PO remains open (5 units still pending). This could be due to oversight or uncertainty about when to close the PO.

  4. Invoice is posted for the 95 units received.

  5. Actual landed cost invoice is $60. When posted, only $57 is absorbed into inventory, which is acceptable since 5 units are still open.

  6. Later, I decide to close the PO. I expect the remaining $3 to be absorbed into inventory, but it isn’t. It disappears, and there’s no variance line in the voucher. I have to manually clear the $3 from the landed cost clearing account.


  7.  

Question:

 

Is there a workaround or functionality that ensures the remaining ALC amount ($3) is properly absorbed into inventory when the PO is closed late or after forgetting to cancel the remaining quantity?

 

Thanks in advance. Regards,

P.

 
I have the same question (0)
  • Suggested answer
    CA Neeraj Kumar Profile Picture
    4,004 on at
    D365F&O | Landed cost accounting
     
    Have you tried the functionality of over/under transactions available for Landed costs module? 
     
    To absorb the inventory costs of remaining $3, you can create a charges code with credit side = Ledger (Landed cost clearing).
    And from the posted invoice journal, you can load it as charges like we do for third party charges at later stages after invoicing.
     
    It will increase the inventory amount on posted inventory (if inventory is available), and also nullify the Landed cost clearing GL.
     
    If you need any further assistance on how to perform the above steps, please let us know.. i will explain with more details and screenshots.

    Regards,
    Neeraj Kumar

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,105

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 215 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans