We have a situation where the material is transferred from main warehouse to another warehouse (read Plant to Plant tarnsfers). For the audit purposes, we need to generate a report that could provide the information on stocks transferred during a particular period, quantity trfd, value and rate at which the stock transfers took place. The aforesaid information is required in the form of a consolidated report for a group of articles as it is quite time consuming to go into each inventory ledger and extract the details. Can anyone advise as to how can we generate this report or is there a table that would store the required information ?
Thanks in advance.