x Want to participate? Join the group to interact

Sage 50 US

Reporting and Analytics Quotes/Orders Tables

Options

State Suggested Answer
Replies 1 reply
Answers 1 answer
Subscribers 19 subscribers
Users 0 members are here
Views 683 views

Browse Forums

121

topics

111

replies

General Discussion

5k

topics

12k

replies

506

topics

688

replies

Reporting and Analytics

518

topics

1k

replies

1

topics

0

replies

Software Development Kit (SDK)

413

topics

645

replies

68

topics

170

replies

Quotes/Orders Tables

SUGGESTED

Posted By Gavriel over 1 year ago

Hi,

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

thanks

0 termerins 7 months ago

SUGGESTED

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.
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Reject Answer

Cancel