1) Data Monitoring - Report 50328

Report develop for support purpose.  End user will not use this report.  

Job Queue for run the report at 1:00am every date for data monitoring.


The report to be show on "Report Inbox" for the user "Bizspoke"

Clik the report to see if there has different qty between VWA and ILE>


2) Data Checking

Export Table for VWA, ILE, VWLE for the item has different QTY at the date.

Put the 3 table into the same excel file (separate worksheet)

Use excel formula "Match" to check if any document and entry is missing between the tables

a) VWA vs ILE / ILE vs VW Entry

(example as below.  The sample excel file can find in Jira UICL-764

b) Then patch the missing data to resolve the problem

c) run the job queue for generate the report to check the result.  (DONT run the report from object coz it will print to printer and the printer is located in client's end)












  • No labels