The file is composed by three tabs. Only the last tab has to be updated thanks to a BW query.
Status colour Blue title Step 1
Step 1 Open I open a data source or a workbook.
| Expand | ||
|---|---|---|
|
|
Status colour Blue title Step 2
Step 2 Select I select the query
BW - Critical Material Movements (core query)
Comment: the technical name of the query is BW_QRY_ODS_IC01_0003
Status colour Blue title Step 3
Step 3 Run I run the query
1. Enter the mandatory information that is to say at least the calendar day.
2. Enter detail information like the company code, the plant code to obtain the information that you are interested in.
I obtain the report and I justify the highlighted amount in the appropriate column
Comment: There is an automatic filter to obtain only the amount to be justify but it can be removed (see next step)
Status colour Blue title Step 6
Step 6 Description
I remove the filter in the amount criteria
| Viewtracker | ||
|---|---|---|
|
Status colour Blue title Step 7
Step 7 Description
Status colour Blue title Step 8
Step 8 Description
Status colour Blue title Step 9
Step 9 Description
Show If
| user | crollier,alepercq,bfoisell |
|---|