Payment Reverse/Correct with C_Project_ID generating wrong GL postings

Description

GL facts are posted wrongly in the following situation:

1. Invoice (Vendor) assigned to a project (c_project_id)
2. AP Payment for invoice created in step 1.
2.1 The system creates the following GL postings:
DR Payment Selection 10=>OK
CR BIT 10=>OK
3. Payment>Reverse/Correct
3.1 The system incorrectly marks the prepayment indicator in payment and payment reversal document.
3.2. Because of the incorrectly set prepayment indicator, the system creates these 2 wrong fact postings:

  • Payment reversal document:
    DR BIT
    CR GL Prepayment=>NOT OK, should be GL Payment Selection

  • Allocation document:
    DR GL Prepayment=>NOT OK, should be GL Payment Selection
    CR GL Prepayment=>NOT OK, should be GL Payment Selection

Environment

None

Activity

Show:
Michael Powacht
February 10, 2020, 1:10 PM

@Heng Sin,
started testing but get the following error message when performing Reverse/Correct on the payment document.
My test environment is still on 6.2, could this be the reason?

org.adempiere.exceptions.AdempiereException: Validation Error Invoice Paid
at org.compiere.model.MAllocationHdr.prepareIt(MAllocationHdr.java:425)
at org.compiere.process.DocumentEngine.prepareIt(DocumentEngine.java:436)
at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:315)
at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:283)
at org.compiere.model.MAllocationHdr.processIt(MAllocationHdr.java:361)

Heng Sin Low
February 10, 2020, 1:39 PM

Hi ,

Sorry, the previous patch is bad, please revert that. I’ve uploaded a new patch, please re-test.

Regards,

Low

Michael Powacht
February 10, 2020, 2:12 PM

no worries, will do.

Michael Powacht
February 11, 2020, 12:38 AM

@Heng Sin, did some testing this morning and works as expected.

Heng Sin Low
February 11, 2020, 5:32 AM
Edited

thanks , changes pushed to 7.1 branch.

Assignee

Heng Sin Low

Reporter

Michael Powacht

Labels

None

Tested By

None

Components

Fix versions

Affects versions

Priority

Minor
Configure