Lockbox Tests

Prerequisites

You need a fresh database installed with seed and demo data. Or, you should load the file hot-deploy/financials/data/DemoLockbox.xml

Testing the First Lockbox File

1. go to /financials/control/manageLockboxBatches
2. upload hot-deploy/financials/data/TestLockbox.mbx
3. open the first batch TestLockbox030
4. the first check has one application with error (Error - No Customer # - Bad Invoice #)
   • create an application of the remaining 900.75$ to any customer
   • the check is then marked as Ready
   • the created application displays the note No Invoice #
5. the second check should already be fully applied and marked as Ready
6. the third check has two application lines
   • none of the two should have any applied amount since one of them has an error (Lockbox Amount Greater Than Invoice Open Amount)
   • apply 500$ and 100$ of cash discount to invoice LB0003 to completely apply the invoice
   • create an application of 500$ to LB0002
   • create an application of the remaining 500$ to customer DemoLBAcct
   • the check and applications are Ready
7. the last check is applied to DemoLBCust / LB0004
   • 1250$ should already be applied
   • the check is Ready and the application displays a note Partial Payment meaning that the invoice still has an outstanding amount
8. click Process Items
9. all checks are now applied and
   • the batch pending amount is now 0$
   • there should be no more form input available
   • trying to click on Process Items results in error No line ready to process found.
   • since we fully applied all the invoices concerned except LB0004, the open amount listed in ERP Invoice Amount should be 0$ for them
10. check invoice LB0003 for example
    • invoice items total is 600$
    • payment applied is 500$
    • invoice is now Paid
11. check invoice LB0004
    • invoice items total is 1550$
    • payment applied is 1250$
    • invoice is still Pending
12. go back to the Manage lockbox screen
    • TestLockbox030 should be listed anymore

Testing the Second Lockbox File

1. select the batch TestLockbox032
2. the first check has 302.15$ applied but only 300$ remains for the invoice LB0004
   • set the cash discount to -2.15$
   • the check and applications are now marked Ready
3. click Process Items
   • the check is applied
4. check invoice LB0004
   • invoice items total is 1550$
   • two payments are applied: 1250$ (from the first batch) and 300$ applied from a 302.15$ payment
   • invoice is now Paid
5. the second check has $302.15 but only $300 is outstanding for the invoice LB0005
   1. create a new AL line with amount of 302.15 and cash discount of -2.15. Now this line should be ready.
   2. Click on [Process Items]
   3. Verify the invoice LB0005:
      • Has a status of paid
      • Has a payment of $302.15 apply to it and an invoice adjustment of type cash discount and amount $2.15, which increases the value of the invoice by $2.15.