105
Hi Community,
I am looking for a report or maybe a module that can help me detail what is in inventory in-transit as of 12/31/2021.
For example, I've submitted a purchase order to the supplier and the supplier shipped the inventory on 12/31/2021. The inventory is then received on 01/05/2022. Where in Dynamics 365 Business Central would I go if I want to view all inventory that was shipped from the supplier but not yet received?
Thank you in advance!
The two step process can work. Receive the inventory into an in-transit location when you take ownership. Then create a transfer order to the final location and receive that when the goods arrive. Make sure the in-transit location is a non-pickable location.
However, the landed cost module offers a one step alternative. The shipment is invoiced before it is received, thus automatically creating in-transit inventory (paid not received). Then the goods are received against the original PO when they arrive. It is worth investigating so you don't have to duplicate every PO as a TO.
Also, if your PO does not have multiple lines or if all lines ship at the same time, then you can use fields date in PO header (see article in my previous comment) then this way you can go to PO list and filter based on those dates. You will not see the line but you will see PO
Hi
Just to add to other experts here.
You can add a new field then design a report for it. Or as Kim suggested utilize one of 3 fields that are available. See this article for explanation of each field
https://archerpoint.com/microsoft-dynamics-nav-how-use-purchase-order-dates/
if you decided to use one of already existing fields then you can look into this free app to get the info you need.
If development is not an option then maybe you can utilize container concept (which is a little over killed) in the following app. or use the app
Be careful with the locations that Josh recommended, Depending upon your costing method, when you transfer inventory, cost layers are closed for the transfer from location and new cost layers created for the to location. All this really means is that you cannot apply item charges to the PO receipt, you must apply to the transfer receipt.
Inge's suggestion for a date is the best. There are three dates already, you might try using one of these.
Adding to Josh reply.
In some scenarios where this has been asked for i have added a date field to the purchase lines where so when a shipping advice is received from the vendor this date field can be updated and used for reporting.
It also come downs to shipping terms. Some regulators may prohibit you from taking the goods into your inventory until you are the legal owner of the good according to the shipping and delivery terms.
In standard a workaround for this would be to have a step in between. Have another 2 locations setup. On is an in-transit, so just tick the applicable field for that. And send another which is similar to the vendors name. Your PO will need to use the vendors location. Receipt into that when they ship. Then setup a transfer order between the vendors location and the final stocking location. Ship so it places the stock “in transit”. You can then use inventory reports filtered on the “in transit” location.
If you don’t like this then check out appsource for cargo or container management type solutions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
