Hello wise and knowledgeable users,
In 2018 we converted from Dynamics GP to Dynamics F&O. At which time we did not set up many sales features. Currently it was decided to move all sales from one of our divisions to industry specific (cemetery) sales program (Cemsites). We are only migrating Dynamics F& O activity from 2018 forward.
For this conversion we created a SQL database to export the 5+ years of customer history.
I exported these entities from data management to the database.
Customer V3
Sales order headers V2
Sales order lines V2
Inventory adjustment journal headers and lines
Released products V2
Sizes
Styles
Sites
Item serial numbers
Product master colors
Product master sizes
Product master styles
Warehouses
My issue is with Customer sales order and customer invoices. In the current tables there is no common field to connect sales order number and invoice number.
Is there an entity I can export that includes both sales order number and invoice number on the same line? Or is there another method to capture this information?
I'm not an I.T. person, just an accountant with the system administration role. Any help or direction will be much appreciated.