Allocate Payment to Charge
Description
Environment
relates to
Activity
Carlos Ruiz August 23, 2012 at 10:24 AM
Carlos Ruiz June 24, 2012 at 11:22 AM
Hi Edwin, your tests and report looks thorough, I guess is OK to integrate it.
Regards,
Carlos Ruiz
Edwin Ang June 13, 2012 at 3:02 PM
Any comment on this?
Edwin Ang May 30, 2012 at 12:13 PM
Hi Carlos,
Reporting my test result on Payment Allocation form in Adaxa branch.
Changes made:
Add Charge dropdown list on Payment Allocation form
Add column C_Charge_ID on table C_AllocationLine
Modify the posting logic for Allocation document
Scenario Tested:
1. Fully Allocate one AR payment to charge --> payment isallocated, allocation ok, posting ok
2. Partially Allocate one AR payment to charge --> allocation ok, posting ok
3. Fully Allocate one AP payment to charge --> payment isallocated, allocation ok, posting Payment Selection has negative value
4. Partially Allocate one AP payment to charge --> allocation ok, posting Payment Selection has negative value.
5. Fully Allocate one AR payment to Invoice --> payment isallocated, allocation ok, posting ok
6. Partially Allocate one AR payment to Invoice --> allocation ok, posting ok
7. Fully Allocate one AP payment to Invoice --> payment isallocated, allocation ok, posting ok
8. Partially Allocate one AP payment to Invoice --> allocation ok, posting ok
9. Fully Allocate one AR payment to one AP Payment --> payment isallocated, allocation ok, posting Payment Selection has negative value
10. Partially Allocate one AR payment to one AP Payment --> allocation ok, posting Payment Selection has negative value
Not Tested:
Payment Allocation WebUI form
Conclusion:
I personally think it is very well designed and a must have for iDempiere. It is flexible, you can allocate Payment or Invoice to Charge. Just need to tweak the posting code for AP Payment posting when not allocated to Invoice.
Suggestion:
A process similar to Invoice Write Off but for payments. It is a frequent case in retail industry to have this "small overpaid" payment due to rounding. Using this payment we can auto allocate all open payment - with max open amount smaller than a certain threshold amount - to a charge.
What do you think? I can do the integration work if required.
Regards,
Edwin Ang
It is a very common scenario that the payment amount differs from invoice grand total due to reasons like currency difference, rounding, etc.
If the invoice grand total is greater than the payment amount, we can write them off and the invoice will be marked as allocated.
However when the payment amount is greater than the invoice amount, we cannot write the payment off. Overtime we can have hundreds of these remaining payments on our Unallocated Payment reports.