Managing Customer Risk through Doubtful Receipt

By | September 24, 2013

Sage X3 provides the ways to manage the customer risks, the doubtful receipts is one of the important function which is used to record the doubtful receipts for customers. The account type used during the posting of the entries varies according to whether the customer is defined as doubtful or not. It is also possible to define if there are any unpaid charges to be carried, if these charges generate a journal entry that is different to the doubtful receipt entry, and if necessary, whether they must be the object of customer re-invoicing.

To Create the Doubtful receipt against follow the below mentioned steps:

Navigate through  A/P – A/R Accounting > Payments > Doubtful Receipt Entry

New Stuff: Implementing Parent and Child Company in X3


1. Fill the header details:

Bank: This is the bank assigned to the payments to be processed and thus the bank where the doubtful entries    are posted.

Accounting Date: This is the accounting date that is given to journal entries created by the process.

Select the payment for doubtful receipt: It is possible to manually enter a payment number. A selection screen (called by the contextual menu/right click) is used however to propose a group of payments corresponding to defined criteria. Refer to the below screen shot of selection window.


2.  Fill the other detailed line fields :

Reason: This field is used to define the doubtful receipt entry reason. The user can choose any valid reason from the drop down list.

Doubtful: This field is used to define whether the customer is doubtful or not.  This information has an impact on the account types that will be used at the time of posting the doubtful receipt entry. If the customer is “doubtful”, the doubtful receipt entry is generated in a “doubtful customer” control account. If the customer is not considered to be doubtful, the doubtful receipt entry is generated in the same control account as the one settled.

Charges: This field is used to enter the amount of charges caused by the doubtful receipt entry. The amount is expressed in the currency displayed in the header (bank currency).

VAT/VAT: The doubtful receipt entry charges are subject to VAT. It is therefore necessary to define the appropriate tax code. The VAT amount is automatically calculated.

Analytical Posting: If the charges are tracked analytically then it is necessary to define the analytical posting for the charge that arises.

Due Date: It is possible to define the due date for the journal entries generated by the process.

3. After entering the all the details click on save the doubtful receipt will get create and payment status will changed to “Unpaid” and it will the generate the log file wherein it will show the Doubtful receipt number created against the payment as shown in below screen shot.


You can check the doubtful receipt created for the payment’s on clicking the “Milestone” button present on payment screen. When we click this button it will show the details in trace log file as shown in below screen shot.


About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized 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 expertise.

Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage and Magento eCommerce along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3). Currently we are Sage Enterprise Management Implementation Partner in East Africa, Middles East, Australia, Asia. 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 for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage Enterprise Management – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at We will be glad to assist you.