x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 47 subscribers
  • Views 1948 views
  • Users 0 members are here
Browse Forums
Announcements
51
topics
34
replies
General Discussion
1k
topics
2k
replies
Billy Welsh

Need Report/Export for Open AP Invoices by Account

SUGGESTED
Posted By

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.

  • 0
    SUGGESTED
    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
  • 0 in reply to Coleen Graber
    Thank you. I am familiar with ODBC links. I will pull that KB so I know where to link to the data.

*Community Hub is the new name for Sage City