Standard Template Modification (Print Stock Label) - Query
Creation date: 20/12/2021 09:12
Updated: 20/12/2021 09:12
Question:
Answer:
[FAST] - Standard Template Modification (Print Stock Label)
Affected Environment:
PROD
Affected warehouse:
ALL WAREHOUSES
Screenshots of error messages:
Time when the issue occurred:
N/A
Affected module:
Data Export Rule, Inventory Balance
Detailed description of the issue:
Just want to ask how to modify or change SQL script(Change the Alias for WarehouseID and CustomerID) in the Data export rule with "Standard Template Flag" set to "YES".
The purpose of this is to create a different printable form per Warehouse.
FYI, The SQL query field is disabled.
First level investigation/troubleshooting taken:
N/A
Case replication in the original warehouse:
N/A
Answer:
Solution:
For
standard data export rule, user cannot modify the existing query but can add on
to the query in the section highlighted below.
Remember to click on “Test SQL”
to ensure the modified query is correct and make it available on the report
template.
User can use this add on selection in the report template.