Difference between revisions of "Lockbox Batch Details"
| Line 1: | Line 1: | ||
This screen is a grid showing the details of a [[Payments Lockbox|lockbox batch]]. It would display each payment item from a lockbox batch, including the amount, amounts applied, and status. Below each payment item are the payment item details, which are the applications of the payment to customers and invoices. These lines would show the customer and invoice IDs, the amount of the corresponding invoice in opentaps, the amount to apply, a cash discount if there is one, and the status of the line. It will also show the customer name, if the customer ID entered by the bank matches a party ID of a customer in opentaps. | This screen is a grid showing the details of a [[Payments Lockbox|lockbox batch]]. It would display each payment item from a lockbox batch, including the amount, amounts applied, and status. Below each payment item are the payment item details, which are the applications of the payment to customers and invoices. These lines would show the customer and invoice IDs, the amount of the corresponding invoice in opentaps, the amount to apply, a cash discount if there is one, and the status of the line. It will also show the customer name, if the customer ID entered by the bank matches a party ID of a customer in opentaps. | ||
| − | On the screen, you can do one of | + | On the screen, you can do one of three things: |
| − | # Enter an amount to apply to an invoice shown on the lockbox payment item detail, if you wish to apply the lockbox payment to an invoice already created. | + | # Enter an amount to apply and cash discount to an invoice shown on the lockbox payment item detail (marked AL), if you wish to apply the lockbox payment to an invoice already created. |
| − | # | + | # Add a new detail line, so that you can: |
| + | #* apply an amount and cash discount to an existing invoice. | ||
| + | #* apply an amount to a customer account. | ||
| + | # Process the items that are marked as Ready | ||
You are not allowed to modify any data supplied to you from the original bank lockbox file, including the amounts of the payments or the invoices and customers. Therefore, if the original bank customer ID does not match an opentaps party ID, simply skip it by not applying any of it to that line and add a new line with the correct invoice ID and party ID. | You are not allowed to modify any data supplied to you from the original bank lockbox file, including the amounts of the payments or the invoices and customers. Therefore, if the original bank customer ID does not match an opentaps party ID, simply skip it by not applying any of it to that line and add a new line with the correct invoice ID and party ID. | ||
| Line 9: | Line 12: | ||
Finally, if you wish to apply a discount to reconcile the difference between the invoice amount and payment amount, enter it in the "Discount" column. | Finally, if you wish to apply a discount to reconcile the difference between the invoice amount and payment amount, enter it in the "Discount" column. | ||
| − | When you are finished | + | When you are finished applying details, click on the Process Items, this will create payments and payment applications accordingly. Only the lockbox items marked as Ready will be processed this way, and the amount processed will be subtracted from the outstanding amount of the batch. |
| + | |||
| + | Items applied to an invoice will create a Payment, and if a cash discount should be applied an invoice Adjustment will be made. | ||
| + | |||
| + | Items that are applied to a customer account only will only create a Payment from this customer. | ||
Revision as of 13:45, 15 December 2008
This screen is a grid showing the details of a lockbox batch. It would display each payment item from a lockbox batch, including the amount, amounts applied, and status. Below each payment item are the payment item details, which are the applications of the payment to customers and invoices. These lines would show the customer and invoice IDs, the amount of the corresponding invoice in opentaps, the amount to apply, a cash discount if there is one, and the status of the line. It will also show the customer name, if the customer ID entered by the bank matches a party ID of a customer in opentaps.
On the screen, you can do one of three things:
- Enter an amount to apply and cash discount to an invoice shown on the lockbox payment item detail (marked AL), if you wish to apply the lockbox payment to an invoice already created.
- Add a new detail line, so that you can:
- apply an amount and cash discount to an existing invoice.
- apply an amount to a customer account.
- Process the items that are marked as Ready
You are not allowed to modify any data supplied to you from the original bank lockbox file, including the amounts of the payments or the invoices and customers. Therefore, if the original bank customer ID does not match an opentaps party ID, simply skip it by not applying any of it to that line and add a new line with the correct invoice ID and party ID.
Finally, if you wish to apply a discount to reconcile the difference between the invoice amount and payment amount, enter it in the "Discount" column.
When you are finished applying details, click on the Process Items, this will create payments and payment applications accordingly. Only the lockbox items marked as Ready will be processed this way, and the amount processed will be subtracted from the outstanding amount of the batch.
Items applied to an invoice will create a Payment, and if a cash discount should be applied an invoice Adjustment will be made.
Items that are applied to a customer account only will only create a Payment from this customer.
