Dynamics Community Forum Thread Details

Sales order & invoice data link export

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.

Categories:

Customization / Solutions / SDK and API

Quick Links

Leaderboard