x Want to participate? Join the group to interact

Sage 500

Welcome to the Sage 500 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.

Financials, Projects, and Administration ap trial balance query

Options

State Not Answered
Replies 2 replies
Subscribers 45 subscribers
Views 1647 views
Users 0 members are here

Browse Forums

Announcements

Customization and Integration

262

822

Financials, Projects, and Administration

382

843

General Discussion

327

836

Installation and Technical Issues

335

Manufacturing, Distribution, and Applications

341

696

Reporting and Analytics

123

480

ap trial balance query

Posted By kevans over 8 years ago

does anyone have a query that returns the value of the AP trial balance? We want to extend that functionality to show line dist level detail of vouchers

0 dbcoles over 8 years ago

I do believe this is built with several queries in a procedure. If you care to look at that, it's called spAPTrialBal. Be aware that the reports rely on that structure, so you should copy this and modify your own version.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kevans over 8 years ago in reply to dbcoles

Thank you very much!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 500

ap trial balance query

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING