x Want to participate? Join the group to interact

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.

Reporting and Analytics In what table is the Customer YTD Sales value stored?

State Verified Answer
Replies 3 replies
Subscribers 118 subscribers
Views 813 views
Users 0 members are here

Browse Forums

268

topics

260

replies

Databases and Operating Systems

755

topics

2k

replies

Financials Suite

1k

topics

3k

replies

General Discussion

2k

topics

10k

replies

Operational Suite

850

topics

2k

replies

Reporting and Analytics

1k

topics

3k

replies

Reports, Macros, and Customizations

876

topics

3k

replies

Sage CRM for Sage 300

182

topics

408

replies

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

Sign in to reply

Verify Answer

Cancel

Reply

0 Jay Converse Acumen over 1 year ago

ARCSM
Cancel
Vote Up 0 Vote Down

Sign in to 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

Sign in to 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

Sign in to reply

Reject Answer

Cancel