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 :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Landed cost module - H...
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Landed cost module - How to mass upload/update voyages, po lines, actuals ...etc?

(0) ShareShare
ReportReport
Posted on by Unknown geen idee 132

How to mass upload/update voyages, po lines, actuals ...etc in the D365 Landed cost module?

The sheer amount of inbound voyages/PO lines for our organization makes manual input a hell of a workload. So far I have not yet come across any tool/technique which would facilitate easier data upload/update.

For example, I have not seen an intercompany setup which would feed outbound ASN from another organziation into a voyage at the Landed cost module. Nor does there seem to be any Excel data connector available to copy-paste and load via Excel. I am starting up a test to see if we could auto-create voyages via the data entities, but this is going a bit slow due to internal obstacles.

Does anybody have any ideas/experience how to input/update data in the Landed cost module, other than manually doing this via the D365 interface?

Thank you for sharing!

Koen

I have the same question (0)
  • Suggested answer
    Brittany Burke Profile Picture
    Brittany Burke on at
    RE: Landed cost module - How to mass upload/update voyages, po lines, actuals ...etc?

    Hi Koen!!

    There is a feature that is available in D365 that if enabled, allows you to copy and paste from Excel into forms within D365. If you export the form into Excel, you can add the data you need, and then paste it back into D365.  This might be a good solution for you. Lauren Wooll from my team wrote a blog post that may be very helpful to learn the functionality.

    No Data Entity? No Problem! - caf2code.com

    A power automate integration may also be helpful.

    Let me know if the copy/paste functionality helps you!

  • Unknown geen idee Profile Picture
    Unknown geen idee 132 on at
    RE: Landed cost module - How to mass upload/update voyages, po lines, actuals ...etc?

    Dear Brittany,

    Thank you for your suggestion, really appreciate it.

    I have done some testing and it seems that the Landed Cost module is possibly setup a bit differently ... I cannot make the copy-paste work in any of the possible tables there.

    I can make it work in for example an item arrival journal.

    For now it seems that the only way forward would be via the data entities and see if/how these allow for mass update of data (via PowerAutomate).

    Thank you,

    Koen

  • Suggested answer
    Jamesm89 Profile Picture
    Jamesm89 5 on at
    RE: Landed cost module - How to mass upload/update voyages, po lines, actuals ...etc?

    Many of the larger freight forwarding companies have EDI setups that can feed the ASN shipment data such that the voyage can be automatically created, and then updated as desired.  (K&N is one example).  This would be an enhancement, but I have worked with a client in the past that successfully did this.  Check with your freight forwarder on the possibility.  (And at least now many of the Landed Cost data entity tables exist and are open).

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 > Supply chain | Supply Chain Management, Commerce

#1
Siv Sagar Profile Picture

Siv Sagar 303 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Laurens vd Tang Profile Picture

Laurens vd Tang 93 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans