Claim creation through lockbox and receipt level validation
Hi,
In the remittance file, the customer is fully paying the invoice but the remitted amount is less than the invoice amount,
So the requirement is to mimic that in oracle by creating a receipt with the remitted amount and fully pay the invoice and create a claim for the difference:
Invoice: $100
Receipt: $80
Amount to be applied: $100
(In certain sources, we receive only the above lines, and in other source we receive an additional line for claim creation)
In oracle :
Receipt: $80
Invoice application: $100
Unmatched Claim: $20 (We will populate the Original invoice number in Notes field for reference)
This is doable through the from-end, we have tried it through lockbox and it is not working and I believe that because one the validation lock box is doing is "Sum of all of the Amount Applied columns for a receipt should not exceed the remittance amount",
In the remittance file, the customer is fully paying the invoice but the remitted amount is less than the invoice amount,
So the requirement is to mimic that in oracle by creating a receipt with the remitted amount and fully pay the invoice and create a claim for the difference:
Invoice: $100
Receipt: $80
Amount to be applied: $100
(In certain sources, we receive only the above lines, and in other source we receive an additional line for claim creation)
In oracle :
Receipt: $80
Invoice application: $100
Unmatched Claim: $20 (We will populate the Original invoice number in Notes field for reference)
This is doable through the from-end, we have tried it through lockbox and it is not working and I believe that because one the validation lock box is doing is "Sum of all of the Amount Applied columns for a receipt should not exceed the remittance amount",
0