Forum Discussion
In-Transit Material
I am having a pain of a time getting a result that works for In-Transit products when I am viewing my Inventory Snap Shots for Month-Endings. Below are what I believe would be sufficient examples of...
Hello Greg_Deckler
I mocked up a sample of the same scenario I am trying to do. I need to know the Quantity of what Shipped before my slicer's Month-Ending date, but was receipts After that date.
I made an adjustment to the file, but since the link is to the shared file on my GoogleDrive, you should be able to click that same link before.
I removed the Receipt record of Order 99 so this helps with calculating In-Transit to also include Shipped products that have no receipts recorded yet as well and not just what does have a receipt date that is after the Month-Ending date selected in the slicer.