Thanks for the welcome.
Nice to hear you have done many conversions. I hope you will share your tips and tricks. Below is what I’m migrating (TableID in brackets).
Customers (18) Fairly straight forward here. I have 1.7M postcodes & town so am using this for assigning City. I have someone working on a lookup between the postcode district i.e. LE (Leicester) and the County. Would be nice to start off with valid postcodes and addresses.
Gen. Journal Line (81) SALES Sage AR Open INV,CSH,CRN,JRN. Unallocated amount for partials. Having trouble with this with mapping. I can migrate in but posting complains about Document No. I have mapped slitemm.reference to this but NAV wants GJSAL000001. I’ve splt INV,CSV,CRN & JRN into different Line No sequences. Any help here would be great. Also we can’t import closed items so credit control may have an issue here (no history). Have you a work around?
Item (27) Starting this next week.
Stockkeeping Unit (5700) Starting this next week. I don’t know how to book opening balances in yet for each Location/Item/Bin combination. The data is easy to extract from stquem but I don’t know the table to import it to. Help here would be well received.
Sales Price (7002) Have made a stab at this. My company has thousands of Sage price lists. Some with zero prices! I’m going to use 100% discount in a discount group to handle this.
They are changing the chart of accounts and as such I have to map the old GL account to the new NAV General Ledger Code which has been assigned its dimensions. I have to extract the balances from Sage and then let the accountants break these down as the new opening balances for the NAV General Ledger Code. Not being an accountant I can only try to understand what they want to achieve. I can at least extract the balances from Sage.
Vendor (23) Not started yet.
Gen. Journal Line (81) PURCHASE. Not started yet.
No SOP history. We are starting with just open orders which will be migrated using an order import Codeunit via buffer tables.
We have manufacturing but this may be keyed manually.
One last thing. We have many Customer & Item codes with leading zeroes. What is the best way to stop these being stripped when exporting to Excel. We can change these in the migration so we are going to have to live with them.
Hope we can exchange ideas etc.