{"id":36488,"date":"2025-10-30T12:04:01","date_gmt":"2025-10-30T12:04:01","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=36488"},"modified":"2025-11-03T10:09:19","modified_gmt":"2025-11-03T10:09:19","slug":"branch-wise-ar-invoice-report-in-sage-300","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2025\/10\/30\/branch-wise-ar-invoice-report-in-sage-300\/","title":{"rendered":"Branch-Wise AR Invoice Report in Sage 300"},"content":{"rendered":"\n

In Sage 300 ERP<\/a>, the Accounts Receivable (AR) Invoice Report is one of the most important financial documents for any organization. It provides complete details of customer billing, payment, and transaction information.<\/p>\n\n\n\n

For companies that operate through multiple branches, it becomes essential to print the correct branch address and contact details on each invoice to ensure accuracy.
By default, Sage 300 prints a single company address on all AR invoices. However, when invoices are generated from different branches, there is a need to display the corresponding branch address on the printed invoice. Managing multiple invoice templates for each branch can become time-consuming.To address this requirement, we implemented a Branch selection mechanism within the AR Invoice entry screen using Optional Fields in Common Services.<\/p>\n\n\n\n

Please refer below screenshot of the user interfaces for the \u201cBranch-Wise AR Invoice Report<\/strong>\u201d. <\/p>\n\n\n\n

New Stuff : –<\/strong> Enhancing Terms & Conditions for SEZ Customers in Crystal Reports<\/a><\/p>\n\n\n\n

\"\"<\/a><\/center>
Figure 1\u00a0:\u00a0AR Invoice Branch Report – Optional Field 1<\/center><\/font>\n\n\n\n

According to the above screenshot, the BRANCH01 optional fields were defined in Common Services \u2192 Optional Fields, where the Value<\/em> field stores the address label (such as Address 1, District, ZIP\/PIN Code), and the Description<\/em> field holds the actual branch address.<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a><\/center>
Figure 2 : AR Invoice Entry Branch Report – Setting Optional Field<\/center><\/font>\n\n\n\n

The BILLINGBRN field was then assigned at the header level in Accounts Receivable \u2192 A\/R Setup \u2192 Optional Fields, allowing the user to select the required branch name while entering the invoice. Based on this selection, the report automatically identifies which branch details to print. As shown above<\/p>\n\n\n\n

Below is the screenshot ofBranch-Wise AR Invoice Reportoutput:<\/strong>\u00a0<\/p>\n\n\n\n

\"\"<\/a><\/center>
Figure 3 : AR Invoice Report Output<\/center><\/font>\n\n\n\n

As shown in the above report, once the configuration is done, the selected branch details are automatically displayed on the invoice printout without any manual updates. This ensures branch-wise billing accuracy and allows businesses to maintain a consistent report format across all locations.<\/p>\n\n\n\n

This report includes following <\/strong>Optional <\/strong>fields and can be modified according to the requirement.<\/strong> <\/p>\n\n\n\n