Validation of the Credit Amount of a Direct Credit Memo
When a full or a line level credit is issued for an option which is a part of a bundle product, the Billing application, ensures that credit amount for an option or component of a bundle can never exceed the bundle's roll up price for the first time or subsequent credit memo. Also, the overall credit for that credit memo should never exceed the source invoice's total. It also ensures that the subsequent credit memos show the real time available credit based on the total amount of the bundle.
Use Case: Validation for Line Level Credit
If there is a bundle product with a lower roll-up price compared to the invoice amount of some of the components, when a finance analyst creates a line level credit memo against an invoice, the Billing application validates the actual credit amount of such bundles.
Consider an invoice with the following bundle product:
| Invoice Line Item | Product | Bundle | Amount |
|---|---|---|---|
| ILI-1 | Option-1 | Graphic Package | USD 100.00 |
| ILI-2 | Option-2 | Graphic Package | (USD 20.00) |
| ILI-3 | Option-3 | Graphic Package | USD 30.00 |
| ILI-4 | Option-4 | Graphic Package | (USD 40.00) |
| ILI-5 | Option-5 | Graphic Package | USD 0.00 |
| Group Total Available Credit | USD 70.00 | ||
- Line items with negative and USD 0.00 fee amount (Option-2, Option-4, and Option-5) are rendered non-selectable.
- Line items with positive fee amount (Option-1 and Option-3), the validation is done to show that credit amount can not be greater than Bundle Total or Line Level Total or (Bundle Total - Credit given to other lines in that bundle), whichever is lower.The validations are summarized as follows:
When option-1 is given a credit before option-3 When option-3 is given a credit before option-1 No message is displayed if the credit amount is less than or equal to USD 70.00. No message is displayed if the credit amount is less than or equal to USD 30.00. When the credit amount is more than USD 70.00 and you clicked the Next button, you see a message that the maximum credit amount that can be given is USD 70.00. When the credit amount is more than USD 30.00 and you clicked the Next button, you see a message that the maximum credit amount that can be given is USD 30.00. If you enter USD 70.00 or lower, then credit amount for Option-3 will be either USD 0.00 or (USD 70.00 - credit given for Option-1). If you enter USD 30.00 or lower, then credit amount for Option-1 will be either USD 40.00 or (USD 70.00 - credit given for Option-3).
Use Case: Validation for Subsequent Line Level Credit
If there is a bundle product with a lower roll-up price compared to the invoice amount of some of the components and subsequent credit memo is created against that invoice, the Billing application validates the actual credit amount of such bundles.
Consider an invoice with the following bundle product. Assume a credit of USD 45.00 and USD 20.00 are given to Option-1 and Option-3, respectively during the creation and approval of first direct credit memo.
| Invoice Line Item | Product | Bundle | Amount | Applied Credit |
|---|---|---|---|---|
| ILI-1 | Option-1 | Graphic Package | USD 100.00 | USD 45.00 |
| ILI-2 | Option-2 | Graphic Package | (USD 20.00) | |
| ILI-3 | Option-3 | Graphic Package | USD 30.00 | USD 20.00 |
| ILI-4 | Option-4 | Graphic Package | (USD 40.00) | |
| ILI-5 | Option-5 | Graphic Package | USD 0.00 | |
| Group Total Available Credit | USD 5.00 | |||
- Line items with negative and USD 0.00 fee amount (Option-2, Option-4, and Option-5) are rendered non-selectable.
- Line items with positive fee amount (Option-1 and Option-3), the validation is done to show that credit amount can not be greater than Bundle Total or Line Level Total or (Bundle Total - Credit given to other lines in that bundle), whichever is lower.The validations are summarized as follows:
When option-1 is given a credit before option-3 When option-3 is given a credit before option-1 No message is displayed if the credit amount is less than or equal to USD 5.00. No message is displayed if the credit amount is less than or equal to USD 5.00. When the credit amount is more than USD 5.00 and you clicked the Next button, you see a message that the maximum credit amount that can be given is USD 5.00. When the credit amount is more than USD 5.00 and you clicked the Next button, you see a message that the maximum credit amount that can be given is USD 5.00. If you enter USD 5.00 or lower, then credit amount for Option-3 will be either USD 0.00 or (USD 5.00 - credit given for Option-1). If you enter USD 5.00 or lower, then credit amount for Option-1 will be either USD 0.00 or (USD 5.00 - credit given for Option-3).
Validation when the Asset Value has Changed
Consider that the prices of the options are revised as follows:
| Invoice Line Item | Product | Bundle | Amount | Applied Credit |
|---|---|---|---|---|
| ILI-1 | Option-1 | Graphic Package | USD 150.00 | USD 45.00 |
| ILI-2 | Option-2 | Graphic Package | (USD 20.00) | |
| ILI-3 | Option-3 | Graphic Package | USD 50.00 | USD 20.00 |
| ILI-4 | Option-4 | Graphic Package | (USD 40.00) | |
| ILI-5 | Option-5 | Graphic Package | USD 0.00 | |
| Group Total Available Credit | USD 75.00 | |||
- Line items with negative fee amount (Option-2 and Option-4) are rendered non-selectable.
- Line items with USD 0.00 fee amount (Option-5) are selectable, but can only be given a credit of USD 0.00. Any other amount is not allowed.
- Line items with positive fee amount (Option-1 and Option-3), the validation is done to show that credit amount can not be greater than Bundle Total or Line Level Total or (Bundle Total - Credit given to other lines in that bundle), whichever is lower.The validations are summarized as follows:
When option-1 is given a credit before option-3 When option-3 is given a credit before option-1 No message is displayed if the credit amount is less than or equal to USD 75.00. No message is displayed if the credit amount is less than or equal to USD 30.00. When the credit amount is more than USD 75.00 and you clicked the Next button, you see a message that the maximum credit amount that can be given is USD 75.00. When the credit amount is more than USD 30.00 and you clicked the Next button, you see a message that the maximum credit amount that can be given is USD 30.00. If you enter USD 75.00 or lower, then credit amount for Option-3 will be either USD 0.00 or (USD 75.00 - credit given for Option-1). If you enter USD 30.00 or lower, then credit amount for Option-1 will be either USD 45.00 or (USD 75.00 - credit given for Option-3).
Use Case: Validation for Full Credit
If there is a bundle product with a lower roll-up price compared to the invoice amount of some of the components, when a finance analyst creates a full credit memo against an invoice, the Billing application validates the actual credit amount of such bundles.
For the Full Credit memo, the entire available credit amount of all the invoice line items are set as the credit amount.
Consider an invoice with the following bundle product:
| Invoice Line Item | Product | Bundle | Amount | Group Total |
|---|---|---|---|---|
| ILI-1 | Option-1 | Graphic Package | USD 100.00 | USD 70.00 |
| ILI-2 | Option-2 | Graphic Package | (USD 20.00) | |
| ILI-3 | Option-3 | Graphic Package | USD 30.00 | |
| ILI-4 | Option-4 | Graphic Package | (USD 40.00) | |
| ILI-5 | Option-5 | Graphic Package | USD 0.00 | |
| ILI-6 | Option-11 | Designer-002 | USD 100.00 | USD 70.00 |
| ILI-7 | Option-12 | Designer-002 | (USD 20.00) | |
| ILI-8 | Option-13 | Designer-002 | USD 30.00 | |
| ILI-9 | Option-14 | Designer-002 | (USD 40.00) | |
| ILI-10 | Option-15 | Designer-002 | USD 0.00 | |
| ILI-11 | Support | USD 160.00 | USD 200 | |
| ILI-12 | One-time charges | USD 50.00 | ||
| ILI-13 | Discount | (USD 50.00) | ||
| ILI-14 | Miscellaneous charges | USD 40.00 |
While creating a full credit memo, the application validates that the overall credit memo(s) total amount does not exceed the total amount of the source invoice. Within this invoice, the application validates that the credit amount for individual bundle does not exceed the total amount of the bundle. The same validation is done for the standalone lines that are not a part of the bundle.
For the above bundle, if you want to create a full credit memo, the lines may look like:
| Invoice Line Item | Product | Available Credit | Credit Amount |
|---|---|---|---|
| ILI-1 | Option-1 | USD 100.00 | USD 70.00 |
| ILI-2 | Option-2 | (USD 20.00) | 0 |
| ILI-3 | Option-3 | USD 30.00 | 0 |
| ILI-4 | Option-4 | (USD 40.00) | 0 |
| ILI-5 | Option-5 | USD 0.00 | 0 |
| Group Total Available Credit | USD 70.00 | ||
| ILI-6 | Option-11 | USD 100.0 | USD 70.00 |
| ILI-7 | Option-12 | (USD 20.00) | 0 |
| ILI-8 | Option-13 | USD 30.00 | 0 |
| ILI-9 | Option-14 | (USD 40.00) | 0 |
| ILI-10 | Option-15 | USD 0.00 | 0 |
| Group Total Available Credit | USD 70.00 | ||
| ILI-11 | Support | USD 160.00 | USD 160.00 |
| ILI-12 | One-time charges | USD 50.00 | 0 |
| ILI-13 | Discount | (USD 50.00) | 0 |
| ILI-14 | Miscellaneous charges | USD 40.00 | USD 40.00 |
| Group Total Available Credit | USD 200.00 | ||
