Automatic Credit memo receivable in Sage Enterprise Management

By | July 29, 2015

Have you ever come across in circumstances where the Credit Memos Receivable (CMRs) from the supplier return lines, either not invoiced or partially invoiced, and pending a credit memo.

New stuff:How to populate and save data in grid using TABLEAUX

Sage X3 provides a feature to generate Credit Memo Receivable. A credit Memo Receivable function is used to generate recurrent CMRs and it runs at the end of the month.

If a return has been posted at the end of month N and it has still not been the object of a credit memo in the month N+1, a new CMR will then be generated at the end of month N+1 for this return line. In effect, this process takes into account the non posted (not having been the object of a CMR), not invoiced returns, or the posted and not invoiced returns whose associated CMR reversal date is less than the new generation date.

It should be noted that the CMRs generated from the non-invoiced returns do not take into account possible order footers.

Based on the PNH automatic journal setup, it is possible to generate a credit memo receivable by return or by Company-Site-Supplier-Currency combination.

This depends on the Grouping option chosen in the automatic journal header:

  • Document by line: used to generate a CMR by return
  • Grouped document: used to generate a CMR by Company-Site-Supplier-Currency combination.

Two automatic journals are delivered with the application. One is used to generate the credit memos receivable with taxes, the other is used to generate the credit memos receivable without taxes. The CMR generation process always uses the PNH automatic journal.

If the automatic journal PNH1 should be used instead, it will be necessary to delete or rename the PNH automatic journal and to rename the PNH1 automatic journal as PNH.

To successfully bring this functionality follow below steps.

Navigate to: Financials > Closing Process > Credit to receive

  1. Enter the Company name and Site.
  2. Select the supplier range.
  3. Enter the date till credit memo receivable require.
  4. Checkmark the generation type
  5. Check to mark the distribution status
  6. Checkmark product to be processed
  7. Select Document Type.
  8. Select Journal Type.
  9. Click on OK Button1b

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.