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.
It's not one-to-one mapping. One order may be invoiced by several partial invoices or there may be a combination of invoices and credit notes. And a summary invoice can cover several orders. At table-level, you can find this relation in CustSalesInvoiceLink table. I don't know which entity exposes this table; use Find references should give you the answer.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.