{"id":36393,"date":"2025-09-30T05:08:31","date_gmt":"2025-09-30T05:08:31","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=36393"},"modified":"2025-09-30T05:08:33","modified_gmt":"2025-09-30T05:08:33","slug":"adding-bank-details-vat-details-dynamically-in-oe-invoice-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2025\/09\/30\/adding-bank-details-vat-details-dynamically-in-oe-invoice-report\/","title":{"rendered":"Adding Bank Details & VAT Details Dynamically in OE Invoice Report"},"content":{"rendered":"\n

In any business, invoices are not just transactional documents\u2014they serve as official records that must be accurate, compliant, and easy for customers to understand. To improve the efficiency and transparency of our invoicing process, we have enhanced the Crystal Reports layout in Sage 300 ERP<\/a> . With this update, OE Invoices will now dynamically display the correct VAT registration number<\/strong> and bank account details<\/strong> based on shipment location and order currency.<\/p>\n\n\n\n

Please refer below screenshot for the \u201cOE Invoice Report<\/strong>\u201d.<\/p>\n\n\n\n

\"\"<\/a><\/center>
Figure 1 : OE Invoice Reports with dyanamic bank and VAT Details<\/center><\/font>\n\n\n\n

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

New Stuff: –<\/strong> <\/em>IC Transfer API for Sage 300 ERP<\/a><\/p>\n\n\n\n

1. VAT Registration Number by Shipment Location<\/strong>
Previously, every invoice displayed the same VAT Registration Number at the bottom of the page: \u201cVAT Registration Number GB89xxxxxxx.\u201d<\/em> While this worked for some locations, it did not cover all business cases. Now, the report has been updated to dynamically display the correct VAT number depending on the shipment location from the invoice header.<\/p>\n\n\n\n

For example:<\/p>\n\n\n\n