Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

In what table is the Customer YTD Sales value stored?

SOLVED

Posted By Nathan Kahn over 1 year ago

I really thought I just exported the customer file to excel from within Sage but I don't see that column anywhere. Or in the SQL tables.

Top Replies

Mike Cook over 1 year ago in reply to Nathan Kahn +1 verified

you would have to sum the periods. The statistics tab would be doing that in the background.

Parents

0 Jay Converse Acumen over 1 year ago

ARCSM
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel

Reply

0 Jay Converse Acumen over 1 year ago

ARCSM
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel

Children

0 Nathan Kahn over 1 year ago in reply to Jay Converse Acumen

Thanks for that Jay, but it seems to only have the Period amounts. I'm looking for the figures I see for YTD Amount when I look at the Statistics tab for a customer. Is that built on the fly or is that figure stored some place?
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel
+1 Mike Cook over 1 year ago in reply to Nathan Kahn

verified answer

you would have to sum the periods. The statistics tab would be doing that in the background.
Cancel
Vote Up +1 Vote Down

Reply

Reject Answer

Cancel

Sage 300

In what table is the Customer YTD Sales value stored?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING