Amount is being posted into In-transit account through inter-site transfer and container management, but not able to reconcile. Hence need a report to reconcile the transactions with Goods In-transit A/c.
One simple way might be to run the stock valuation report with 'In transit' ticked, then to run it without it ticked to give you the stock figure. If you're using average cost, you could also get the figure solely from the ITMMVT table as it contains the in transit quantities and the average cost, so they can be summed up.
Hello Steve,
Thank you for your responce,
Transferred check box shows only intersite and Intercompany stock movements. I need stock movement done by container tracking as well. Becuase they are all posted to Goods-In-Transit A/c.
Afraid I have no experience with this second aspect so am not aware of the underlying data / tables off the top of my head. Sounds like a custom report to fuse together though unless X3 has something specific in place.
*Community Hub is the new name for Sage City