{"id":31577,"date":"2025-12-11T11:01:35","date_gmt":"2025-12-11T11:01:35","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=31577"},"modified":"2025-12-11T11:01:35","modified_gmt":"2025-12-11T11:01:35","slug":"how-to-display-ap-ar-customer-bp-invoice-records-on-sales-invoice-inquiry-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2025\/12\/11\/how-to-display-ap-ar-customer-bp-invoice-records-on-sales-invoice-inquiry-in-sage-x3\/","title":{"rendered":"How to Display AP\/AR (Customer BP Invoice) Records on Sales Invoice Inquiry in Sage X3"},"content":{"rendered":"\n

In Sage X3, the Sales Invoice Inquiry function is widely used to review sales invoices and related transactions. By default, this inquiry only displays records coming from the Sales module. However, there may be scenarios where you also need to view AP\/AR (Customer BP Invoice) records alongside your sales invoices.

This document will walk you through the steps to include AP\/AR records in your Sales Invoice Inquiry results.<\/p>\n\n\n\n

Navigation Path<\/h2>\n\n\n\n

To access the Invoice Inquiry screen:

– Go to Sales Module
– Navigate to Inquiries
– Click on List of Invoices<\/p>\n\n\n\n

Steps to Display AP\/AR Records<\/h2>\n\n\n\n

1. Enter Filter Criteria<\/p>\n\n\n\n

– On the Invoice Inquiry screen, provide the required header details (such as customer, date range, or invoice number) to filter the records.
– Click on Search.
– At this point, Sage X3 will only return results from the Sales module.<\/p>\n\n\n\n

2. Add Criteria for AP\/AR Module<\/p>\n\n\n\n

– To include AP\/AR (Customer BP Invoice) records, click the Criteria button on the inquiry screen.<\/p>\n\n\n\n

\"Sales
Fig:01 Sales Invoice Screen<\/strong><\/figcaption><\/figure>\n\n\n\n

– In the Criteria window, navigate to the Module tab.
– Select the AP\/AR Module from the list.<\/p>\n\n\n\n

\"Criteria
Fig:02 Criteria_Screen<\/strong><\/figcaption><\/figure>\n\n\n\n

– Click OK to confirm.<\/p>\n\n\n\n

3. View Combined Records<\/p>\n\n\n\n

– Once the AP\/AR module is added to the criteria, the system will display both Sales module invoices and AP\/AR invoices in the same grid.
– This allows you to review all relevant invoices in one consolidated view.<\/p>\n\n\n\n

By default, the Sales Invoice Inquiry in Sage X3 only shows Sales module records. With a simple adjustment in the criteria, you can also display AP\/AR (Customer BP Invoice) records alongside them. This approach gives you a consolidated invoice view that improves efficiency and reduces the need to navigate across multiple modules.<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage X3, the Sales Invoice Inquiry function is widely used to review sales invoices and related transactions. By default, this inquiry only displays records coming from the Sales module. However, there may be scenarios where you also need to view AP\/AR (Customer BP Invoice) records alongside your sales invoices. This document will walk you\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,5,3162,8,3642,10],"tags":[4491,4492,4235,4489,4490,1762,1780,1822,1839,2871,1945,1977,2538,4488],"class_list":["post-31577","post","type-post","status-publish","format-standard","hentry","category-configuration","category-features","category-greytrix","category-sage-erp-x3","category-sage-x3","category-standard","tag-ap-ar-modules","tag-combined-records","tag-inquiries","tag-invoice-inquiry","tag-posted-sales-invoices","tag-sage-enterprise-management","tag-sage-erp-x3","tag-sage-x3","tag-sage-x3-blogs","tag-sage-x3-functional-blogs","tag-sage-x3-technical-blogs","tag-sales","tag-sales-invoice","tag-sales-invoice-screen"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/31577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=31577"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/31577\/revisions"}],"predecessor-version":[{"id":31581,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/31577\/revisions\/31581"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=31577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=31577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=31577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}