Tables from GP 8 1

[akalinowski]

i have a backup of a Great Plains DB and i restored it to my SQL server, i do not need to use great plains but i need to extract sales data from the DB. the tables are not named in a manner that makes sense, does anyone have a link to some docs explain what tables contain what data.

akalinowski

http://www.nofear.com

MCSE 2000, A+, N+, LCP, CNE

 

[winthropdc]

It really depends on how much details you need. Here are the main ones:

RM_OPEN (RM20101) - Posted Sales
RM_HISTORY (RM30101) - Fully paid Sales

SOP_HDR_HIST (SOP30200) - Posted SOP transactions
SOP_LINE_HIST (SOP30300) - Posted SOP transaction lines

If you need distributions, tax, commissions, serial/lot numners, comments, user defined fields etc. these are in other tables.

PS: There is a naming convention which does give hints to what table is what.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[akalinowski]

awsome!
thanks!

akalinowski

http://www.nofear.com

MCSE 2000, A+, N+, LCP, CNE

 

[realstandman]

anyone know where I can find the old Great Plains DOS version? I have the data but can't find the installion disks from way back. This was at my company and discontinued now they need some data out of if.

Don't think and the solution will come.