Build IC Financial Reporting File (IC131)

Run Build IC Financial Reporting File (IC131) to provide adjustment/difference postings for the Stock Ledger/Purchase Journal Interface. Run this program after you have run IC130, which sets the PULL-FOR-FR-FL (UNIX/Windows) or PLFRFL (IBM i) field to Y in the MMDIST (UNIX/Windows) or DBPOMMD (IBM i) database table.

Processing effect

This program reads the MMDIST (UNIX/Windows) or DBPOMMD (IBM i) table and pulls the records with PULL-FOR-FR-FL (UNIX/Windows) or PLFRFL (IBM i) = Y and inserts them into the ICFRREXP (UNIX/Windows) or DBICIFX (IBM i) table. At the same time, the program sets the PULL-FOR-FR-FL (UNIX/Windows) or PLFRFL (IBM i) field to N in MMDIST (UNIX/Windows) or DBPOMMD (IBM i).

You will need to write an extract program to use this data to update your non-Lawson retail system.