A9.4 Understanding the relationship between F03B11, F03B112, F03B13 & F03B14

Pat Clarke

Member
Hello,
I need to understand the relationship between F03B11, F03B112, F03B13 & F03B14 from the point of view of purging these tables by G/L date. For example if a Purge Date of LESS THAN 1st Jan 2018 was selected then I would need to clear down records in these tables that have a G/L date Less than Jan 1st 2018. However I only want to do this if there are no open amounts. Which table would I start processing first and how do I determine whether there are any open elements associated with an order. Any help I can get with this would be appreciated.

regards
Pat


TableDescription
F03B11Customer Ledger
F03B112Invoice Revisions
F03B13Receipts Header
F03B14Receipts Detail
 
Top