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 108 subscribers
Views 1084 views
Users 0 members are here

Browse Forums

310

topics

279

replies

Databases and Operating Systems

775

topics

3k

replies

Financials Suite

1k

topics

3k

replies

General Discussion

2k

topics

10k

replies

Operational Suite

771

topics

2k

replies

Reporting and Analytics

1k

topics

4k

replies

Reports, Macros, and Customizations

817

topics

3k

replies

Sage CRM for Sage 300

198

topics

434

replies

In what table is the Customer YTD Sales value stored?

SOLVED

Posted By Nathan Kahn over 2 years 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 2 years 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.

0 Jay Converse Acumen over 2 years ago

ARCSM
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Nathan Kahn over 2 years 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 2 years 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