Converting Customers from Single to Headquarter/Branch relationship
"Richard De Rocco" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <009701cce819$de709b90$9b51d2b0$@com> |
Hi Folks, I've been researching a conversion of existing single customers to a headquarters branch relationship with AR Consolidation. (There are about 580 with open AR data that should be treated as one AR with invoices to the branches) My observations so far. 1. There appears to be no changes in the open orders files that are affected by the consolidated AR. 2. I can create a new headquarter customer with headquarter = 'Y' and Is consolidation? = 'Y'. The CONID field is therefore '1' and CONCS is the same as CUSNO. 3. If I convert all the other MBBFREP records that are branches to this customer I would place: a. '3' in CONID b. The headquarters customer number in CONCS 4. Convert all OPENAR records from the individual branch customer numbers in CUSNO to the new headquarters number and leave CONCS alone. 5. This will cause a message to appear (details don't match) during inquiry and cash app but that should be corrected in the next month-end during the Unload/Reload. So any thoughts on how I'm going to shoot myself in the foot? Thank you in advance. Rich DeRocco _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.