Quotes/Orders Tables

Question

Hi, 
 Can anyone help to identify where the quotes and orders data is via the odbc please. 
 
 thanks

termerins · Answer

For any transaction in Sage 50, the header record is stored in the JRNLHDR.DAT file, and the rows records are stored in the JRNLROW.DAT file. The two are linked together via the Post Order field, and the Journal for Quotes is 12, while the Journal for Sales Orders is 11. For additional assistance, please reach out to us at https://pcosupport.com or 800-780-0700 or 954-961-0600.

Sage 50 US

Quotes/Orders Tables

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING