Subject: | Tax calculation changes to cater for tax setup by value | Summary: | The following changes are required to change tax calculation by value: - Changed tax calculation formula to multiply tax value by quantity for value-based tax codes.
Areas Affected: - Backoffice - replenishment to create a purchase order
- Backoffice - purchase order entry
- Backoffice - receive purchase
- POS - Prescription Entry, Load prescription
- POS Screen - Load prescription
- POS Screen - Items having different combinations of tax setup. E.g Tax Inclusive/Percent, Inclusive/Value, Exclusive/Percent, Exclusive/Value.
- POS Screen - Quantity Change
- POS Screen - Price Change
- POS Screen - Discount by line
- POS Screen - Discount by Total (Utility)
- POS Screen - Minimum Profit % calculations for different item types in 6. above
- POS Screen - Changed rounding to correctly round away from zero to 2dp for values such as 0.045 = 0.05.
| Audit Notes: | | 27 Jun 2018 | 05:40PM Comment 1 by Alvis (Link Technologies) Case 9375 added to project 09.4 | 27 Jun 2018 | 07:22PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 27-06-2018 07:22 PM Time Taken: 40.00 | | Below are details of how Discount By Totals work. Note that in simple cases, the total discounts will match exactly to the discount percent, however in complex scenarios (explained below), the discount amount may not be able to achieve the full percentage amount. Discount algorithm notes: - When there are multiple line items on the order lines, discounts are applied to the items of least "Profit Margin" first. This is to ensure that as we pro-rate discounts down the line, and therefore, we are able to allocate discount most accurately.
- Items can have "min Profit Percent" that prohibits the amount of discount you can apply. If you try and enforce a 50% discount, however, the "Min Profit Percent" is > 50%, the algorithm will "floor" at the "Min Profit Percent"
- The algorithm calculates the most viable route to apply discounts so the customer achieves the most benefit, without exploiting the "providers" inventory pricing setup parameters
- Link to the Calculation sheet
In this example, we are using every possible TAX scenario to explain how discounts work. Figure 1 - Line items before discounts applied
Figure 2 - Line items after discounts applied
|
| 29 Jun 2018 | 03:29PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 29-06-2018 03:29 PM Time Taken: 2.00 | | System test completed, Tested the following: - Setup test products as follows:
TI001 Test product. Tax: PI10 Price: $10 Cost: $5 MinProfit: 0% MinUnitPrice: 0 TI002 Test product. Tax: PI10 Price: $10 Cost: $5 MinProfit: 20% MinUnitPrice: $6.60 TI003 Test product. Tax: PE10 Price: $10 Cost: $5 MinProfit: 0% MinUnitPrice: 0 TI004 Test product. Tax: PE10 Price: $10 Cost: $5 MinProfit: 20% MinUnitPrice: $6.60 TI005 Test product. Tax: VI10 Price: $10 Cost: $5 MinProfit: 0% MinUnitPrice: $10 TI006 Test product. Tax: VI10 Price: $10 Cost: $5 MinProfit: 20% MinUnitPrice: $16 TI007 Test product. Tax: VE10 Price: $10 Cost: $5 MinProfit: 0% MinUnitPrice: $10 TI008 Test product. Tax: VE10 Price: $10 Cost: $5 MinProfit: 20% MinUnitPrice: $16
- Backoffice - replenishment to create a purchase order
- Created replenishment for above 8 items
- Created Purchase order from replenishment and verified values, tax and total.
- Backoffice - purchase order entry
- Created Purchase order for above 8 items
- Changed Tax code on the purchase order to match items tax code setup above.
- Verified Quantity change, price change and verified tax values.
- Checked Approved Purchase order screen and verified values.
- Checked purchase order report and verified reports
- Backoffice - receive purchase
- Verified purchase order receive screen values for above 8 items.
- Received purchase order and checked database values are stored correctly.
- POS - Prescription Entry, Load prescription
- Created prescription for above 8 items
- Loaded prescription on POS and verified values
- Gave various discounts by line and by total and checked values are computed correctly.
- Completed sale and verified database values.
- POS Screen - Items having different combinations of tax setup. E.g Tax Inclusive/Percent, Inclusive/Value, Exclusive/Percent, Exclusive/Value.
- Loaded above 8 items in POS
- Changed quantity for all items to 10.
- Changed price for above items
- Verified discount by line
- Verified discount by total
- Verified Min Profit % calculations
- Verified rounding is done correctly for values such as 0.045.
|
| 03 Jul 2018 | 02:23PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 04-07-2018 12:00 AM Time Taken: 8.00 | | Hi Sanjay, This case has been tested successfully. Test Environment - Version 9.48 Beta 3
- LINKSOFT on QA1
Test Plan. - Created Below products
Purchase Order - Create a Purchase on 573 and PO from Replenishment.
- Product: VALEX, Quantity - 2,Cost - 15.Tax should be 18 and total as 30- Pass
- Product: VALIN,Quantity - 2,Cost - 15.Tax should be 18 and total as 48- Pass
- Product: PERIN,Quantity - 2,Cost - 15.Tax should be 2.48and total as 30- Pass
- Product: PEREX, Quantity - 2,Cost - 15.Tax should be 2.70 and total as 32.7- Pass.
- Above tax amounts should be the same on the Purchase Order Approve Screen, Purchase Order Report and Purchase Order Receive Screen.
- Change the cost to 20 for the products on the receiving screen.
- Product: VALEX, Quantity - 2,Cost - 20.Tax should be 18 and total as 40- Pass
- Product: VALIN,Quantity - 2,Cost - 20.Tax should be 18 and total as 58- Pass
- Product: PERIN,Quantity - 2,Cost - 20.Tax should be 3.30 and total as 40- Pass
- Product: PEREX, Quantity - 2,Cost - 20.Tax should be 3.60 and total as 43.60 Pass.
Prescription - Create a prescription with items
- Product: VALEX, Quantity - 2,Price- 10.Tax should be 18 and total as 38- Pass
- Product: VALIN,Quantity - 1,Price- 10.Tax should be 9 and total as 10- Pass
- Product: PERIN,Quantity - 4,Price- 10.Tax should be 3.30 and total as 40- Pass
- Product: PEREX, Quantity - 3,Price- 10.Tax should be 2.7 and total as 32.70 Pass.
- The above was successfully output in the prescription labels and receipts.
- Tested Line Discount, % Discount, Discount by vale and on totals - Pass
POS Transactions - Tested tax portions for all price setup, Promotional Price, Cost Plus Markup, Price Break and Minimum Profit. See Attachment document.
- The following was verified
- Change in Quantity
- Change in Price
- Discount - Tested Line Discount, % Discount, Discount by vale and on totals
- Load and Copy Transactions
Rounding was verified on all screens. Thanks Rashna
|
| 03 Jul 2018 | 02:40PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 03-07-2018 02:40 PM | | Thanks Rashna |
| 09 Oct 2019 | 08:14AM Comment 6 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |
|