|
|||||
|
|||||
|
Grid Population Logic:
Invoice Total = merchant Subtotal multiplied by (Tax Rate (linked to the merchant per Tax Group) as a number, plus 1).
For example:
9. Add Plan, Merchant, Currency, and Invoice Total to grid.
10. Is there another sub merchant account to be invoiced individually?
11. Is there another merchant in the database?
a. If yes, select next merchant, repeat steps 1 to 10.
b. If no, grid is populated. Run is complete.
c. If there are any sub merchant accounts without an Active Primary Contact, display a popup with an OK button and the following message: "An invoice for <<Account Name(s)>> cannot be generated because the Primary Contact is not active. Please contact the merchant and ask them to update their Primary Contact." Please replace <<Account Name(s)>> with account names added in step 10 a) ii.
| ||||||||||||||||||
| ||||||||||||||||||
| ||||||||||||||||||
4. Create "Invoice Summary" portion of invoice by doing the following:
a. Add Row and enter the following:
I. Add Tier Number to first row details (starting at "Tier 1" and incrementing for each row)
II. For this merchant, retrieve the Transaction Count from memory that was used in populating the grid.
III. Is Transaction Count greater than Plan "Quantity To" for Tier-Level row?
If Yes, do the following:
a. Number of Transactions = "Quantity To" - "Quantity From" + 1
b. Is Frequency = Month?
i. If Yes, enter "Rate" as Rate and Total for the row
ii. If No:
- enter "Rate" as Rate
- multiply "Rate" X "Quantity To"
- then enter result as Total for the row
c. Update Transaction Count by subtracting "Quantity To" from Transaction Count to get an updated Transaction Count for the next Tier-Level row.
d. Repeat step 4a part (III) for the next Tier-Level row.
If No, do the following:
a. Number of Transactions = Transaction Count
b. Is Frequency = Month?
If Yes, enter "Rate" as Rate and Total for the row
If No:
- enter "Rate" as Rate
- multiply "Rate" X difference
- then enter result as Total for the row.
c. Proceed to step 5.
5. Calculate Invoice Summary Subtotal and add as an invoice line.
6. Display "Tax <<Tax Rate>>" as a line below Subtotal line, calculate tax and display below Subtotal.
7. Calculate Invoice Total by adding Subtotal and Tax, display Total below Tax.
8. Add "Preview" as a watermark on the invoice to show this is not an actual invoice.
| ||||||||||||||||||
Invoice Creation Logic:
For each Merchant selected, do the following:
4. Create "Invoice Summary" portion of invoice by doing the following:
a. Add Row and enter the following:
I. Add Tier Number to first row details (starting at "Tier 1" and incrementing for each row)
II. For this merchant, retrieve the Transaction Count from memory that was used in populating the grid.
III. Is Transaction Count greater than Plan "Quantity To" for Tier-Level row?
If Yes, do the following:
a. Number of Transactions = "Quantity To" - "Quantity From" + 1
b. Is Frequency = Month?
i. If Yes, enter "Rate" as Rate and Total for the row
ii. If No:
- enter "Rate" as Rate
- multiply "Rate" X "Quantity To"
- then enter result as Total for the row
c. Update Transaction Count by subtracting "Quantity To" from Transaction Count to get an updated Transaction Count for the next Tier-Level row.
d. Repeat step 4a part (III) for the next Tier-Level row.
If No, do the following:
a. Number of Transactions = Transaction Count
b. Is Frequency = Month?
If Yes, enter "Rate" as Rate and Total for the row
If No:
- enter "Rate" as Rate
- multiply "Rate" X difference
- then enter result as Total for the row.
c. Proceed to step 5.
5. Calculate Invoice Summary Subtotal and add as an invoice line.
6. Display "Tax <<Tax Rate>>" as a line below Subtotal line, calculate tax and display below Subtotal.
7. Calculate Invoice Total by adding Subtotal and Tax, display Total below Tax.
8. Is there another Merchant selected in the grid?
If Yes, repeat steps 1 to 7.
If not, return to the table above and complete remaining steps for the Accept button starting with step 2f.
| ||||||||||||||||||
