Supply chain | Supply Chain Management, Commerce

How to reconcile inventory transactions without a running balance?

(0) Share

Report

Posted on by Community Member

Hi Experts

I've been through all of the previous posts around this subject but none seem to have a real answer that I can work with.

We use 3PL providers so often need to reconcile their WMS systems with D365. I can't seem to find a way to see all the physical transactions in a date order to see if either the 3PL has missed a transaction or if it's D365 not updated.

HELP PLEASE!

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Allen Dejoux on at

Like (0)

Report

Hi, are you able to use the Inventory Management>Inquiries and reports>Transactions to view all inventory transaction report and sort by physical date?

Was this reply helpful? Yes No
Chris Segurado 612 on at

Like (0)

Report

Hello Donna,

I hope you are doing well.

In the past, I designed an integration pattern for 3PL - between 3PL inventory system of record and D365FO. I leveraged a SO for inventory that you send from your warehouse to the 3PL warehouse (deducts inventory in your warehouse in D365FO). We had a separate warehouse representing the inventory in 3PL in D365FO. As soon as the 3PL receives the inventory that you sent in their WMS system (not D365FO), an item arrival journal was created for the 3PL warehouse in D365FO. I set up a batch job to post the ASN and the ASN PO Receipt (custom) - was needed as of some batch number requirements/could also be just a PO that will be created (not custom). The 3PL warehouse inventory is now increased and accurate. When there was a SO to fulfil by the 3PL warehouse, the SO pulled from the 3PL warehouse in D365FO inventory - inventory was tracked in D365FO and again accurate. If there was any scrap when the 3PL received initially your inventory in their WMS system - an inventory movement journal was created in D365FO scrapping the damaged quantity.

Not sure if that scenario addresses your need - but feel free to provide more input.

Thank you!

Best Wishes,

Chris Segurado

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Chris

Thanks for your response. Do you use AWMS with the 3PL? We use it to load plan. We don't have batches so that's not an issue. It's the outbound that tales so much time to reconcile and we do have it all in a default location. Did you receive a feed of the 3PL's transactions to build this?

Thanks
Donna

Was this reply helpful? Yes No
Suggested answer

AXSHAH 528 on at

Like (0)

Report

Hi, recently I had chance to Integrate 3PL with 365FO. However the in 3PL we cannot pushed the date so instead design was one way (D365<-3PL), that is reading inventory transactions on daily basis configured by batch job.

Step 1: Read the item codes periodically from 3PL and dump the data in D365FO, so that item codes are reconciled.

Step 2: Read transactions of inventory periodically "receipts"(+) and "sold"(-)

Step 3: Based on financial requirement for "receipts" you can generate purchase orders with product receipts posted , and based on "sold"(-) generate either sales orders with packing slip posted or inventory adjustment.

Note: allow negative posting, eventually it will be reconciled and keep these item codes unique by using different Item model group or procurement category.

Was this reply helpful? Yes No