There should be a matched invoice document for a credit memo quantity and the corresponding invoice quantity for the following reasons:
The invoice quantities will show as unmatched in window Matching PO-Receipt-Invoice for as long as there is no matched invoice between the credit memo qty and corresponding invoice.
If a foreign currency invoice was recorded in a different period and with a different conversion rate than the credit memo, GL account “Inventory Clearing” will not be zero in schema currency and the difference has to be dealt with.
The preferred solution is to generate the matched invoice document automatically where any difference is written off directly to Realized gain/loss because when offsetting Invoice AP and Credit memo AP, it will also go to realized gain/loss.
Thanks Heng Sin and Elaine, please I have successfully tested the latest patch.
Please deploy solution in public repo.
Heng Sin Low
October 8, 2019 at 5:45 AM
Hi Michael,
Please verify the latest patch. Elaine believe with the latest changes, it is inline with your comment above. Please clarify here if that's not the case.
This ticket is related to JIRA https://idempiere.atlassian.net/browse/IDEMPIERE-4006 - Wrong matched PO quantity for vendor credit memo.
There should be a matched invoice document for a credit memo quantity and the corresponding invoice quantity for the following reasons:
The invoice quantities will show as unmatched in window Matching PO-Receipt-Invoice for as long as there is no matched invoice between the credit memo qty and corresponding invoice.
If a foreign currency invoice was recorded in a different period and with a different conversion rate than the credit memo, GL account “Inventory Clearing” will not be zero in schema currency and the difference has to be dealt with.
The preferred solution is to generate the matched invoice document automatically where any difference is written off directly to Realized gain/loss because when offsetting Invoice AP and Credit memo AP, it will also go to realized gain/loss.