Receipt Application-Unapplied Amount
This is the business scenario. We are using Receipt Spreadsheet Upload feature(we do not have Lockbox).
Receipt Amount: $ 100
Invoice A: $ 20 , Invoice B: $ 50, Invoice C: $ 70
Is there any way to load the spreadsheet so that the following is achieved?
Receipt Amount: Fully Applied
Invoice A: $ 20 fully applied, Invoice B: $ 50 fully applied and Invoice C: Partially Applied for $ 30
But currently, this is what is happening:
Receipt Amount: Applied $ 70, Unapplied: $ 30
Invoice A: $ 20 fully applied, Invoice B: $ 50 fully applied and Invoice C: Nothing applied