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
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
Table | Description |
F03B11 | Customer Ledger |
F03B112 | Invoice Revisions |
F03B13 | Receipts Header |
F03B14 | Receipts Detail |