How to define multiple Taxes in line level of Customer BP invoice screen in Sage X3

By | April 14, 2021

The customer BP invoice entry function is used to manage the customer invoicing out of the “typical” sales cycle. In this context, the user does not manage the order, the delivery note with the stock issue etc. When issuing the invoice, the data necessary to the accounting are saved.

We may need a basic important points to make a sales invoice such as:

  1. Customer
  2. Account
  3. Site
  4. Tax

Customer: In sales, commerce and economics, a customer which sometimes are a clients, buyer or purchaser or is  the recipient of a good, service , product or an idea obtained from a seller, vendor or supplier via a financial transaction or exchange for money or some other valuable consideration.

Account: A general ledger, also known as a nominal ledger, is a bookkeeping ledger that serves as a central repository for accounting data transferred from all sub ledgers like accounts payable, accounts receivable, cash management, fixed assets, purchasing and projects. Each account maintained by an organization is known as a ledger account, and the collection of all these accounts is known as the general ledger. The general ledger is the backbone of any accounting system which holds financial and non-financial data for an organization.

Tax: A tax is a compulsory financial charge or some other type of levy imposed on a taxpayer (an individual or legel entity by a governmental organization in order to fund government spending and various public expenditures.

Now sometimes in Sage X3, we may find difficulties in entering multiple taxes on  line level of Customer BP invoice as X3 doesn’t allow user to enter multiple taxes on line level, so to overcome this, in X3 there is a setup for this. Kindly follow below steps for set up to define multiple taxes in the Customer BP invoice screen.

Navigate to: A/P-A/R accounting -> Invoicing -> Customer BP Invoices

Fig01: Customer BP Invoice screen

As we can see in the above screen shot only one Tax field is present on the screen. Now follow below steps for the multiple tax setup:

Step1:

Navigate to : Common Data ->  G/L Accounting Tables -> General.

Select that account which we used in the Customer BP Invoice

Fig02: Accounts screen

Then, navigate  to the General tab.
Set ‘Tax Management’ field as ‘Tax account’ and Tax as ‘ANSTD’ or any tax code we can set here. Refer below screenshot:

Fig03: Accounts Tax Management screen

Then save it.
Now, Navigate to:

AP / AR accounting code → Invoicing → Customer BP Invoice
Enter all the mandatory fields and then go to line level tax field select the action button of the tax field , click on tax entry button. Refer below screen shot:

Fig04: Tax Entry Field
Fig05: Tax Entry screen

Now as you can see in the above screen shot, user can define the multiple taxes in the Customer BP invoice screen.

In this way, we can define multiple taxes in the line level of customer BP invoice screen.

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 caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide. Greytrix Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

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.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We would like to hear from you.