Bad debt management in Sage X3

By | April 21, 2021

Sage X3 provides a feature in which you can manage the entire bad debts process, which includes defining the types of bad debts managed like impairment, doubtful receivables, and write-offs and the automatic journals and analytical dimensions applied for journal entries.

There is a setup screen Bad debt term’s function (GESBDT) to create the terms to apply in calculating bad debt values.

Fig: Bad debt terms

Path: All > Setup > Financials

In Bad debts management (BADBTGEN), you can define which company and which bad debt management rule is used, select which open items are used to create new bad debts, and select the accounting date. The Generation type is always Debit/Credit.

Fig: Bad debt management

Path: All > Setup > Financial>Closing processes

This new functions is protected by the BADBT – Bad debt management activity code.

Use this function to create journal entries based on late charges calculated according to the terms defined in the Bad debt terms function (GESBDT).

Bad debt is an account receivable due to a business when the repayment of credit previously extended to a customer is estimated to be potentially uncollectible. Bad debt is a contingency that must be accounted for by all businesses that extend credit to customers because there is always a risk that payments will not be received.

To generate a list of open items to consider, select criteria such as company, bad debt rule, reference date, number of days, site, etc.

The Bad debt selection screen opens to display open items that are eligible for bad debts, grouped by company. If a bad debt has already been issued for an open item, the already processed column displays a value. On the click of OK button below selection screen is displayed in which you can select transaction.

Fig: Bad debt selection

Path: Financials > Utilities > Miscellaneous > Control account transfer

This screen displays open items eligible for bad debt management based on your search criteria. Open items are grouped by customer, site and currency and the data displayed in the grid cannot be modified except for the Percentage column, which is always a percentage of the Item balance.

From the Action icon on each line, you can view the original invoice, the original journal entry or the analytical dimensions. By default, the analytical dimensions for the company display. You can change these for the open item, but you must create the bad debt before closing the Analytical allocations screen to apply you changes.

Open items with a temporary balance are highlighted in pink.

You can select all open items or individual items by selecting Yes or No from the Select column.

When you click Create, a journal entry is created for each selected open item. A new screen opens where you can select the Accounting date. The Generation type is always Debit/Credit and cannot be modified

Using Bad debts management you can track and record your bad debts in X3 system. Hope this blog helps you in accounting your Bad debts more efficiently!

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.