Stock move history

Stock moves report workaround: Normally among the current SAP reports, there is a stock balance that Shows the user, in detail, the opening Qty Increasing Qty, Decreasing Qty, Effective Qty, and ending balance of inventory at a given location and logistics area over a defined period.

Buy referring to Increasing Qty, Decreasing Qty, or Effective Qty, and conf.ID and filtering the data in which the Inventory Change Reason is Transfer, the user can tell from the exported Inventory balance report, the source and destination logistic area after adding some formulas, like INDEX/Match or VLOOK UP in the said exported file.

How to Stock moves report by a workaround

First, pull the stock balance report:

Go to

1. -> Physical Inventory

2. -> Reports.

3. ->from reports list select inventory Balance.

4. ->fill filter fields [called selection] (by the period that you need to check, e.g.: Current year, Precise product, Logistic area, etc. (if you need all the products leave product field empty)

5. -> Do Apply.

6. ->Enable full balance details.

7. ->Turn on repeated text and apply again,

8. -> Export in excel for further analysis.

9. -> Filter and remain with rows in which Inventory Change Reason is Transfer

10. -> Add two columns at the end of the table and name them Destination logistic

area and Source logistic area respectively.

11 -> Generate destination logistic area: Filter rows which, Increasing Qty

or Effective Qty is greater than zero. In the destination Logistic area Colum,

add a formula that pulls the Logistic area and populates it as the destination

logistic area; that means, the logistic area for these rows filtered, on stage

11, is considered a destination logistic area.

i.e.: [Destination logistic area = Logistic area]

12. -> Copy and paste the data into a new tab and rename the tab

Destination.

13. -> Generate source logistic area: Filter rows which, decreasing Qty or

Effective Qty is Less than.

zero[negatives], In Source Logistic area Colum, add a formula that

pulls the Logistic area and populates it as the source logistic area; that means,

the logistic area for these rows filtered on stage 13, is considered as the source

logistic area. [Source logistic area = Logistic area]

14. -> Copy and paste the data into a new tab and rename the tab.

Source.

15. -> Generate source and destination logistic areas that were not possible to generate on stages 11 & 13: Go back to the initial tab, filter empty destination, and source logistic

areas, and add formulas that pull destination logistic area and source logistic area from source and destination tabs. Referring to conf.ID as look-up the value. (Use INDEX/Match or VLOOK UP]

1-2. Physical Inventory-> Reports

3. Select Inventory Balance

4. Fill in selection fields and supply

5. Keep filling in whatever selection You need to add and the do Apply

6. Enable full balance details

7. Turn on the repeated text and apply again, to have well-organized columns.

8. Export to excel for further analysis If you need to. Or check or look at SAP Screen.

9-10. Filter rows which Inventory Change Reason is Transfer, Adding two columns at

the end of the table and name them Destination Logistic area and Source

logistics are respectively.

11. Generating destination logistic area

12. Copy and paste the data in a new tab and rename the tab Destination

13. Generate source logistic area

14. Copy and paste the data in a new tab and rename the tab Destination

15. Copy and paste the data in a new tab and rename the tab Destination