Consolidating files logic
Caution: If you perform a consolidation without proper preparation, it can result in serious data integrity issues.
Top Tip: Because the CSV file format cannot support multiple tabs all of your data will be copied into one worksheet within the CSV workbook.
You prefer to maintain all data for this customer (invoices, address book records, sales orders, etc.) using one address book number.
You can now consolidate the two address book records into the 1001 address book record number.
You can correct this by removing the From Address as a parent using either Address Book Information (P01051) or Organizational Structure Revisions (P0150).
You must then run the Update A/R from Address Book (F0311 from F0101) (P03802) and the Global Update A/P Records w/AB Information (P04802) to ensure that the parent in the Accounts Receivable Ledger (F0311) and Accounts Payable Ledger (F0411) files changes.
For example if your cmd window opens with “C:\Users\Your Name Top Tip – if you navigate to your desired folder in Windows Explorer (e.g.