Refresh PO Status

How to Refresh the PO Status Going Back X Number of Days

1) Retrieve source.

RTVCLSRC PGM(TS_LTMAPOR) SRCFILE(K3S_5MOD/QCLLESRC) RTVINCSRC(*YES)

Note: The type of the source will be blank so we must change it to CLLE.

2) Edit program to have the proper parameters (LIBRARY, COMPANY CODE, etc.) The user can by your system user ID (K3S_DEV, USER, etc.).

3) Compile rpg program TS_LTMAPOR.

4) Change the API tablecode which controls how many days back to update POs.

Table Code Value: AR_LTMAPOR
Table Code Description 1: Analyze K_PRODLTM records up to this many days old
Table Code Description 2: Values is in number 1 field
Table Flag 1: 0
Table Number 1 (5.0): 7

5) SBMJOB to call rpg program TS_LTMAPOR.

6) If you changed the API tablecode to run TS_LTMAPOR, change the Number 1 value back to 7 so the night job is only looking back 1 week.