Hi there!
What is the best approach to merging a GP company db into another system when the account formats do not match.
The GL00100 table in the target system as 7 account number segments ACTNUMBE_1 through ACTNUMBE_7.
the one we want to put in only has 5 segments setup.
Should we buy the Re-formatter product (https://crgroup.com/re-formatter/) or is there a set of tables we can update manually? I identified large number of them and started that way - but the smartlists give me errors.
Thanks!
Mark