Need Report/Export for Open AP Invoices by Account

Question

The AP Open Invoice report does not provide GL detail. 
 The AP Invoice G/L Distribution Report does not given an option to run for only Open invoices. 
 I have played around with Exports in both AP and GL but don't see where I can get this data. 
 
 I can do this manually using the Open Invoice report but this is very time-consuming given our AP volume.

Coleen Graber · Answer

Billy Welsh- 
Unfortunately, the GL Distribution Report does not have an option to filter on only Open Invoices. The field you are looking for crosses over multiple data tables within A/P and G/L 
 
You would want the ‘GLAccount’ field from the ‘A/P Invoice G/L Distribution (APInvoiceGLDist)’ Table. 
 
This field is not available from our standard Custom Reports or Custom Exports. But the field is accessible using ODBC links outside of the Sage BusinessWorks program – like Excel Queries, Crystal Reports, etc.…. 
 
If you are not familiar with creating reports using ODBC links, we would suggest you work with your local reseller. If you do not have a local reseller we can get you in touch with one that you can consult with to write a report for you. 
 
In addition, for more information regarding our field and table names, please reference KnowledgeBase article ID:19339 "Where do I find the table and field names?" 
Thank you, 
Coleen

Sage BusinessWorks

Need Report/Export for Open AP Invoices by Account

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING