CLOSE
CLOSE
https://www.sikich.com

D365 FSCM Enhancement: Monthly Service Invoice Processing for Landed Cost Transfer Orders

If your company uses the Landed Cost module in Microsoft Dynamics 365 Finance and Supply Chain Management (D365 FSCM) to add Transfer Order service costs to the transferred items, a new Sikich enhancement might be of interest. 

One of the main frustrations around using Landed Cost is the application and payment of the service invoices from the carrier. In one of my previous posts, we discussed how a different Sikich enhancement streamlines the cost entry and application of the transfer order service costs. This next improvement streamlines the invoice payment process. 

How to Use the New Landed Cost Transfer Orders Enhancement for D365 FSCM

We added a new field to the Transfer Order page called Vendor. This is linked to the Accounts Payable/Vendor/All Vendors data table. In addition, we linked the Functions section of the accounts payable screen to the Transfer order fields of Tag (new) and BOL (existing). These can also be used to locate Transfer Order Voyages without needing to know the associated Voyage. (Helpful, as accounting staff are not normally familiar with nor have access to the Landed Cost Voyages section of the module.) 

locate Transfer Order Voyages

The user selects the freight company that will be moving the transfer order. We then added the same field to the Accounts payable invoice journal Function page. When the user selects the vendor account they have received a service vendor invoice from and does a search, the new code will display all Landed Cost Voyages that have open invoice payable amounts for the associated vendor. Selecting OK will then open the payable page and display all open invoice lines for the associated resulting voyages. The displayed lines can be sorted and filtered as desired. At this point, normal functionality of the Voyage invoice posting resumes and allows all the associated voyage invoices to post to their respective Landed Cost Voyage records. 

associated voyage invoices to post to their respective Landed Cost Voyage records

You can see in this example that there are three voyages associated with the vendor. There is no limit to the number of returned voyages. When the user selects OK, the open invoice lines for each voyage are then displayed for processing. 

select voyage costs

After posting the records that match the vendor invoice, creating a new AP invoice journal and filtering to the same carrier vendor ID the payable screen will only show the invoice lines that are still open. 

showing the invoice lines that are still open

Turning on the “Show previously invoiced” selector to Yes will bring back up the cost area lines that have been previously allocated if there are additional charges that appear later. 

select voyage costs

Have any questions about how to use the enhancement for invoice processing for Landed Cost Transfer Orders in Microsoft Dynamics 365 Finance and Supply Chain Management? Please reach out to our experts at any time!

This publication contains general information only and Sikich is not, by means of this publication, rendering accounting, business, financial, investment, legal, tax, or any other professional advice or services. This publication is not a substitute for such professional advice or services, nor should you use it as a basis for any decision, action or omission that may affect you or your business. Before making any decision, taking any action or omitting an action that may affect you or your business, you should consult a qualified professional advisor. In addition, this publication may contain certain content generated by an artificial intelligence (AI) language model. You acknowledge that Sikich shall not be responsible for any loss sustained by you or any person who relies on this publication.

About the Author