Customized AP Purchase Register for Taxes Bifurcation

By | November 24, 2022

In Sage300 ERP, GST taxes are applicable to all items present in the detail lines of an Invoice. Some items are exempt from taxes or the tax amounts are reversible in later quarter. Some bifurcations are to be seen on the report level for such items. Hence to easily identify such items and invoices, we have customized the AP Invoice Register report, where user will define an Optional field in the header that will be used as a filter in report level. If the Optional field value is set to ‘Yes’, any taxes applied will be assigned to a different column in the Register.

New Stuff: Detail Sales Order Report in Sage 300 ERP

Working of INGST (Optional field) for SCGST/IGST Vendor in AP Invoice:

  • User needs to configure an optional field named as ‘INGST’ for AP Invoice detail line.
  • Depending on the items that the user needs to filter, the value of the optional field should be set to YES or NO.
  • If the optional field value is set to YES, then the tax details will be displayed in the additional columns added in Purchase Register report.
  • Below is the sample output when Optional Field value is Yes:
Sample Report field value:YES
Sample Report for Optional field value: ‘YES’

  • If the optional field value is set to NO, then the tax details will be displayed under Standard Tax columns
  • Below is the sample output when Optional Field value is NO:
Sample Report for Optional field value: 'NO'
Sample Report for Optional field value: ‘NO’

Optional fields can be customized as per requirement and appropriateness.
So this customization is very useful for Users that need to bifurcate items that are not applicable for taxes.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM, (listed on Salesforce Appexchange), Dynamics 365 CRM and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using sData and web services  to Sage business partners, end users and Sage PSG worldwide.

Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more details on Sage 300 and Sage 300c Services, please contact us at, We will like to hear from you.