Auto Allocate AR Credit Memo to AR Invoice of a Business Partner

[Suman Kharel]

It seems that Idempiere doesn't auto allocate an AR Credit Note to AR invoice. For example:

For business partner A, 

AR Invoice-------------10,000

AR Credit Memo--------------5,000

BP Open balance----------5,000 (which is correctly shown in the system)

Run::Auto allocate---> Created 0/0

Both invoices remain unallocated and are shown in Aging.

Is there a way where Credit notes are allocated to the sales invoice first? 

Scenario: AR Invoice------->10,000 (2021/06/20)

                  AR Credit Memo------>5000 (2021/06/18)

                  Receipt --------------------->5000 (2021/06/16)

In this case, Auto allocate:: Allocate Oldest first----> the receipt gets allocated to the credit memo thus giving it an allocation of -10,000. 

It seems that if AP Invoice is present instead of AR Credit Memo, then system allocates correctly using above parameters.

How can we solve this problem? Its difficult to allocate all the invoice manually since my client gets a lot of invoices/payment and credit memo in a single day.

[Ayaz Ahmed]

I am also facing the mentioned issue. Is there any way to allocate  AR Credit Memo with AR Invoices. 

[Carlos Antonio Ruiz Gomez]

You can use Allocation for that purpose.  Also the button to create a credit note can allocate automatically.

I think the issue reported is with the automatic allocation process.

Regards,

Carlos Ruiz

El 4/10/21 a las 8:58, Ayaz Ahmed escribió:

--

[Ayaz Ahmed]

Yes  the issue reported is with the automatic allocation process.