Difference between revisions of "Lockbox Tests"

From Opentaps Wiki
Jump to navigationJump to search
(→‎Testing Lockbox File Validation)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
=== Prerequisites ===
+
__TOC__
 +
 
 +
== Prerequisites ==
 
You need a fresh database installed with seed and demo data.  Or, you should load the file hot-deploy/financials/data/DemoLockbox.xml
 
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 ===
+
 
 +
== Testing Lockbox Batch Management ==
 +
 
 
# go to /financials/control/manageLockboxBatches
 
# go to /financials/control/manageLockboxBatches
 
# upload hot-deploy/financials/data/TestLockbox.mbx
 
# upload hot-deploy/financials/data/TestLockbox.mbx
 +
 +
=== Testing the First Lockbox Batch ===
 +
 
# open the first batch ''TestLockbox030''
 
# open the first batch ''TestLockbox030''
 
# the first check has one application with error (Error - No Customer # - Bad Invoice #)
 
# the first check has one application with error (Error - No Customer # - Bad Invoice #)
−
#* create an application of the remaining 900.75$ to any customer  
+
#* create an application of the remaining $900.75 to any customer  
 
#* the check is then marked as Ready
 
#* the check is then marked as Ready
 
#* the created application displays the note ''No Invoice #''
 
#* the created application displays the note ''No Invoice #''
Line 13: Line 20:
 
# the third check has two application lines
 
# 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)
 
#* 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
+
#* change application to DemoLBCust/LB0003 to $500 and cash discount of $100 to completely apply the invoice
−
#* create an application of 500$ to ''LB0002''
+
#* create an application of $500 to ''LB0002''
−
#* create an application of the remaining 500$ to customer DemoLBAcct
+
#* create an application of the remaining $500 to customer DemoLBAcct
 
#* the check and applications are Ready  
 
#* the check and applications are Ready  
 
# the last check is applied to ''DemoLBCust'' / ''LB0004''
 
# the last check is applied to ''DemoLBCust'' / ''LB0004''
−
#* 1250$ should already be applied
+
#* $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
 
#* the check is Ready  and the application displays a note ''Partial Payment'' meaning that the invoice still has an outstanding amount
 
# click Process Items
 
# click Process Items
 
# all checks are now applied and
 
# all checks are now applied and
−
#* the batch pending amount is now 0$
+
#* the batch pending amount is now $0
 
#* there should be no more form input available
 
#* there should be no more form input available
 
#* trying to click on Process Items results in error No line ready to process found.
 
#* 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
 
#* since we fully applied all the invoices concerned except ''LB0004'', the open amount listed in ERP Invoice Amount should be 0$ for them
 
# check invoice ''LB0003'' for example
 
# check invoice ''LB0003'' for example
−
#* invoice items total is 600$
+
#* invoice items total is $600
−
#* payment applied is 500$
+
#* payment applied is $500
 
#* invoice is now Paid
 
#* invoice is now Paid
 
# check invoice ''LB0004''
 
# check invoice ''LB0004''
−
#* invoice items total is 1550$
+
#* invoice items total is $1550
−
#* payment applied is 1250$
+
#* payment applied is $1250
 
#* invoice is still Pending
 
#* invoice is still Pending
 
# go back to the ''Manage lockbox'' screen
 
# go back to the ''Manage lockbox'' screen
−
#* ''TestLockbox030'' should be listed anymore  
+
#* ''TestLockbox030'' should not be listed anymore
 +
 
 +
=== Testing the Second Lockbox Batch ===
  
−
=== Testing the Second Lockbox File ===
 
 
# select the batch ''TestLockbox032''
 
# select the batch ''TestLockbox032''
−
# the first check has 302.15$ applied but only 300$ remains for the invoice ''LB0004''
+
# the first check has $302.15 applied but only $300 remains for the invoice ''LB0004''
−
#* set the cash discount to -2.15$
+
#* set the cash discount to -$2.15
 
#* the check and applications are now marked Ready
 
#* the check and applications are now marked Ready
 +
# the third check is already marked ready
 
# click Process Items
 
# click Process Items
−
#* the check is applied
+
#* the first and third checks are applied
 +
# the batch pending amount is now $302.15 which is the amount of the second check
 
# check invoice ''LB0004''
 
# check invoice ''LB0004''
−
#* invoice items total is 1550$
+
#* invoice items total is $1550
−
#* two payments are applied: 1250$ (from the first batch) and 300$ applied from a 302.15$ payment
+
#* two payments are applied: $1250 (from the first batch) and $300 applied from a $302.15 payment  
 
#* invoice is now Paid
 
#* invoice is now Paid
 
# the second check has $302.15 but only $300 is outstanding for the invoice ''LB0005''
 
# the second check has $302.15 but only $300 is outstanding for the invoice ''LB0005''
−
## create a new AL line with amount of 302.15 and cash discount of -2.15.  Now this line should be ready.
+
## create a new AL line with amount of $302.15 and cash discount of -$2.15 to the invoice LB0002.  Now this line should be ready.
 
## Click on [Process Items]
 
## Click on [Process Items]
 
## Verify the invoice ''LB0005'':
 
## Verify the invoice ''LB0005'':
 
##* Has a status of paid
 
##* 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.
+
##* Has a payment of $300 applied to it and no invoice adjustment
 +
## Verify the payment application has $300 applied to the invoice LB0005 and $2.15 applied to the GL Account 511000 (PROMPT PAYMENT DISCOUNTS)
 +
 
 +
== Testing Lockbox File Validation ==
 +
 
 +
# go to Financials > Receivables >> Manage Lockbox Batches
 +
# upload hot-deploy/financials/data/TestLockboxInvalid-bad-batch-amount.mbx
 +
#* verify that the following error appears: Mismatch between batch total [5350.75] and actual checks total [4350.75] for batch ID [TestLockboxInvalid-bad-batch-amount030]
 +
# upload hot-deploy/financials/data/TestLockboxInvalid-duplicate-application-id.mbx
 +
#* verify that the following error appears: Check number [3012345678] has payment applications with the same sequence id.
 +
# upload hot-deploy/financials/data/TestLockboxInvalid-duplicate-check-id.mbx
 +
#* verify that the following error appears: Check ID [001] occurs in batch more than once
 +
# upload hot-deploy/financials/data/TestLockboxInvalid-duplicate-check-num.mbx
 +
#* verify that the following error appears: Check number [5012345678] occurs in batch more than once.
 +
# upload hot-deploy/financials/data/TestLockboxInvalid-duplicate-batch-id.mbx
 +
#* verify that the following error appears: Unexpected new batch, has same batch number [030] as an already parsed batch.

Latest revision as of 00:31, 24 February 2009

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 Lockbox Batch Management

  1. go to /financials/control/manageLockboxBatches
  2. upload hot-deploy/financials/data/TestLockbox.mbx

Testing the First Lockbox Batch

  1. open the first batch TestLockbox030
  2. 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 #
  3. the second check should already be fully applied and marked as Ready
  4. 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)
    • change application to DemoLBCust/LB0003 to $500 and cash discount of $100 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
  5. 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
  6. click Process Items
  7. 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
  8. check invoice LB0003 for example
    • invoice items total is $600
    • payment applied is $500
    • invoice is now Paid
  9. check invoice LB0004
    • invoice items total is $1550
    • payment applied is $1250
    • invoice is still Pending
  10. go back to the Manage lockbox screen
    • TestLockbox030 should not be listed anymore

Testing the Second Lockbox Batch

  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. the third check is already marked ready
  4. click Process Items
    • the first and third checks are applied
  5. the batch pending amount is now $302.15 which is the amount of the second check
  6. 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
  7. 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 to the invoice LB0002. 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 $300 applied to it and no invoice adjustment
    4. Verify the payment application has $300 applied to the invoice LB0005 and $2.15 applied to the GL Account 511000 (PROMPT PAYMENT DISCOUNTS)

Testing Lockbox File Validation

  1. go to Financials > Receivables >> Manage Lockbox Batches
  2. upload hot-deploy/financials/data/TestLockboxInvalid-bad-batch-amount.mbx
    • verify that the following error appears: Mismatch between batch total [5350.75] and actual checks total [4350.75] for batch ID [TestLockboxInvalid-bad-batch-amount030]
  3. upload hot-deploy/financials/data/TestLockboxInvalid-duplicate-application-id.mbx
    • verify that the following error appears: Check number [3012345678] has payment applications with the same sequence id.
  4. upload hot-deploy/financials/data/TestLockboxInvalid-duplicate-check-id.mbx
    • verify that the following error appears: Check ID [001] occurs in batch more than once
  5. upload hot-deploy/financials/data/TestLockboxInvalid-duplicate-check-num.mbx
    • verify that the following error appears: Check number [5012345678] occurs in batch more than once.
  6. upload hot-deploy/financials/data/TestLockboxInvalid-duplicate-batch-id.mbx
    • verify that the following error appears: Unexpected new batch, has same batch number [030] as an already parsed batch.
Retrieved from "https://docs.opentaps.org/docs/index.php?title=Lockbox_Tests&oldid=3735"