AR information

[rkatyal]

Hello All,

I am using Great Plains Dynamics Version 5.5. I had a question, if anyone knew

which tables contain your AR information? We are trying to migrate from Great Plains to another software and would hate digging into each table.

thanks in advance for your help

 

[Luvsql]

There many AR tables. What ones in particular?

 

[rkatyal]

could you give me the main ones or all of them if possible.

Thanks

 

[Luvsql]

If you just need a list of tables, open Great Plains and go to Tools > Resources > Tables and choose sales.

 

[rkatyal]

I am looking for these in particular

I can't find invoices and adjustments (credits, debits, write-offs, etc).

 

[Luvsql]

Debits, credits and writeoffs are all in the same RM tables as invoices and returns. The RMDTYPAL changes to reflect what document type it is (for example, a 1 represents an invoice).