Company: Link Technologies
Case No: L12322. Project: 13.40: LinkSOFT Version 13.40
Logged By: Vineet (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 14 Jul 2021 10:41AM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 74.25 (Weight: 74.25)
Version: 13.40
Assigned To: Development
Circulation: Development, Sanjay, Vineet
Resolve By: Wednesday, 30 March 2022 11:59 PM [1009 days since logged date]
Status: Closed
Subject: Credit note automation for invoices based on Price Level and RRP
Summary:    
Section A: Description of requirement:
Mobil and OTGL have requested a feature where the system can automatically create CREDIT NOTES and APPLY this to invoices created in POS.

The reason for this feature is to allow OTGL to bill customers at RETAIL PRICES and pay MOBIL at a Specific price defined in the Price level.  This will allow OTGL to have a consistent invoice to all customers and get a Rebate for servicing Mobil Customers.

Section B: Cost - TBA

Section C: Test Plans

Audit Notes:Edited by sanjay on 24/03/22 14:27. Edited by sanjay on 24/03/22 14:26. Edited by sanjay on 24/03/22 14:10. Edited by sanjay on 24/03/22 14:10. Edited by sanjay on 24/03/22 14:10. Edited by sanjay on 17/03/22 10:40. Edited by sanjay on 17/02/22 14:07. Edited by sanjay on 17/02/22 14:05. Edited by sanjay on 17/02/22 14:02. Edited by sanjay on 27/01/22 08:02. Edited by sanjay on 25/01/22 14:30. Edited by sanjay on 04/12/21 11:16. Edited by sanjay on 23/11/21 08:50. Edited by sanjay on 23/11/21 08:49. Edited by sanjay on 16/11/21 14:16. Edited by sanjay on 16/11/21 14:07. Edited by sanjay on 16/07/21 10:53. Edited by vineet on 14/07/21 10:41. 
16 Jul 202110:53AM Comment 1 by Sanjay (Link Technologies) This comment has been removed
06 Sep 202110:13AM Comment 2 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 10-09-2021 10:00 AM Time Taken: 2.00

Hi Guys

OTGL and Mobil have confirmed this design is suitable for their needs. Please review and provide a costing.

Regards
Vineet Ram


06 Sep 202110:27AM Comment 3 by Sanjay (Link Technologies) This comment has been removed
16 Nov 202110:03AM Comment 4 by Vineet (Link Business Solutions) This comment has been removed
16 Nov 202102:07PM Comment 5 by Sanjay (Link Technologies) This comment has been removed
16 Nov 202102:07PM Comment 6 by Sanjay (Link Technologies) Case L12322 added to project 13.30
23 Nov 202108:49AM Comment 7 by Sanjay (Link Technologies) ETC was changed from 30/11/2021 to 28/02/2022
23 Nov 202108:50AM Comment 8 by Sanjay (Link Technologies) ETC was changed from 28/02/2022 to 28/02/2022
23 Jan 202209:55AM Comment 9 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 24-01-2022 11:54 AM Time Taken: 1.00
Hi Vineet, as stated in Section C of the case header, can you add in the test plans?

27 Jan 202208:02AM Comment 10 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-01-2022 12:02 PM
Added numbering tags to case header to easily reference paragraphs

27 Jan 202208:05AM Comment 11 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-01-2022 12:02 PM
Skype conversation: 27/01/2022

Sanjay

Morning Vineet, when can you add the test plans to case L12322?

Vineet, 8:04 AM
I have a tight schedule today. I'll let you know when am a bit free and can do then

31 Jan 202202:07PM Comment 12 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-01-2022 06:05 PM Time Taken: 1.00
Hi Vineet, can you update this case please? This is the only case left before we go into release preparation. Thanks.

03 Feb 202201:41PM Comment 13 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 03-02-2022 05:37 PM Time Taken: 1.00

Hi Vineet, please update this case with your Test plans so I can complete this work. This is the only case left in the release.

As discussed, please use the Standard Demo Database for your test plans (DEMO-LinkSOFT). Thanks


08 Feb 202210:28AM Comment 14 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 08-02-2022 02:27 PM Time Taken: 1.00
Hi Vineet, can you attend to this urgently please? we have passed our deadline for release testing. 

15 Feb 202211:49AM Comment 15 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 15-02-2022 03:48 PM
Hi Vineet, please update this case with your Test plans so I can complete this work. This is the only case left in the release.

As discussed, please use the Standard Demo Database for your test plans (DEMO-LinkSOFT). Thanks

17 Feb 202201:29PM Comment 16 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-02-2022 01:39 PM Time Taken: 1.00

Bula Sanjay

Find below simple test plan:

 

 

 AmountBilledtoCustomer

 AmountPaidByMobil

 Credit on the Docket

 

1

Set Plevel 1 at location Retail for item FUEL01 AS $2.58. Retail Price for this item is set as $2.61

 

 

 

 

2

Setup Customer as Link Business Solutions with Customer Category as 'Mobil'

 

 

 

 

3

Make a sale for item 'FUEL01'. Quantity 20 Liters. Fleet Card Number 1988, Pin 1234.  Vehicle IU838

 $                                       52.20

 $                             51.60

 $                                  0.60

Credit to be applied at the end of the month

4

Make a sale for item 'FUEL01'. Quantity 10 Liters. Fleet Card Number 1988, Pin 1234.  Vehicle IU838

 $                                       26.10

 $                             25.80

 $                                  0.30

Credit to be applied at the end of the month

5

Make a sales to customer CU000002 for item FUEL01 for 10 liter

 $                                       26.10

 $                             25.80

 $                                  0.30

Credit to be applied at the end of the month

6

Assuming sales made in (5) above was pressed incorrectly under the wrong customer, make a sales returns

-$                                       26.10

-$                            25.80

-$                                 0.30

Credit to be applied at the end of the month

7

Set Plevel 1 at location Retail for item FUEL05 AS $2.31. The retail Price for this item is set as $2.34

 

 

 

 

8

Setup Customer as 'Customer ABC' with Customer Category  as 'On the Go Limited'

 

 

 

 

9

Make a sale for item 'FUEL05'. Quantity 15 Liters. Fleet Card Number 1990, Pin 1234.  Vehicle KI972

 $                                       35.10

 

 

 

10

Make a sale for item 'FUEL05'. Quantity 20 Liters. Fleet Card Number 1990, Pin 1234.  Vehicle KI972

 $                                       46.80

 

 

 

 

Rules: SAP Report to show the Retail VEP unit prices.

Environment:

URL: https://linktechnologies.com.au/DEMO-LinkSOFT-LBS/
Server: LINKAD
Database: DEMO-LinkSOFT-LBS



17 Feb 202202:02PM Comment 17 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 17-02-2022 06:00 PM Time Taken: 1.00 Notes: Edited by sanjay on 21/02/22 17:28. 

Hi Vineet, this test case comes too late for version 13.30 as Release testing is in progress. I will move this to version 13.40

We can do this as a Patch update soon after as we release 13.30 at the end of this month.


17 Feb 202202:02PM Comment 18 by Sanjay (Link Technologies) Case L12322 added to project 13.40
17 Mar 202211:26AM Comment 19 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 30-03-2022 02:40 PM Time Taken: 12.00 Notes: ETC extended from: 28/02/2022 to 30/03/2022
Development Journal:
  1. Created process named: Credit Note Automation.
  2. Added the following rules:
    1. Start date for the automation of credit notes
    2. Restrict Credits to customers with this Customer Category. Menu: Point of Sale ~> Customer Profile ~> Category
    3. Restrict Credits to customers with this Customer Group. Menu: Point of Sale ~> Customer Profile ~> Group
    4. Restrict Credits to Products with this Product Category. Menu: Inventory ~> Product Master ~> Category
    5. Apply credit based on this percentage of the line amount
    6. Apply credit based on the difference between Sell Price and Price Level. Use numeric numbers between 1 and 9
  3. Created procedure shell to implement automation

17 Mar 202202:44PM Comment 20 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 17-03-2022 03:26 PM Time Taken: 6.00

Development Journal:

  1. Added logging and process counters
  2. Extracted rules to implement Credit Note automation
  3. Created shell to implement credit note Implementation by Transaction ID

18 Mar 202204:22PM Comment 21 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 18-03-2022 08:21 PM Time Taken: 12.00

Development Journal:

  1. Created Function to Extract transactions to Credit
  2. Created procedure to implement Credit Note
  3. Created procedure to implement Credit Note Allocation

21 Mar 202203:24PM Comment 22 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-03-2022 07:20 PM Time Taken: 6.00
Development Journal:
  1. Amended Extraction for a Credit note to implement the following rules:
    1. Priority 1 - Process Rule "Credit Percentage". When enabled, Credits will be based on this percentage
    2. Priority 2 - Process Rule "Use Price Level". When enabled, Credits will be based on the difference between UNIT PRICE and Price Level as a percentage of the line total
    3. Credit notes are applied based on:
      1. Invoice Outstanding Amount
      2. Only when the Outstanding amount is > Credit amount
      3. Customer, Product filters applied
  2. Added code to shell procedure to implement credit notes

Next Step: UAT


22 Mar 202210:01AM Comment 23 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 22-03-2022 01:59 PM Time Taken: 6.00

Development Journal:

  1. Completed procedure to extract and create credit memos
  2. Completed Credit memo allocation
Next step:
  1. System Test and UAT
  2. Add view to see the status of Automation and view orders and order credits

22 Mar 202203:23PM Comment 24 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 22-03-2022 02:01 PM
Completed System Test

23 Mar 202210:42AM Comment 25 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-03-2022 01:16 PM Time Taken: 9.00 Notes: Edited by sanjay on 23/03/22 10:44. 
The following tests were performed for SYSTEM TESTING

Setup Notes:

  1. Create customer SS001, Assign Category = RETAIL, Group = MOBIL, Credit Limit 1000
  2. Setup Process POS030. Customer Category Like: RETAIL, Customer Group Like: MOBIL, Product Category Like: PETROL
  3. Product A001 TAX IN, Price Level 1 = 10, Category PETROL
  4. Product A002 TAX EX, Price Lebel 1 = 10, Category PETROL


Table 1 - Test Results. 

NoTest CaseExpected ResultPass/FailComments
1Create Invoice for customer SS001, Product A001, Qty 1, Price 10
No Credit as the invoice is not posted
Pass

2Post invoice in 1 above 
No Credit as Price is same as Price 1
Pass

3Create Invoice for customer SS001, Product A001, Qty 1, Price 12
No Credit as the invoice is not posted
Pass

4Post invoice in 3 above
A credit of $2 applied to the invoice as Sell Price was 12, Price Level is 10
Pass

5Create and Post invoice to SS001. A001, Qty 2, Unit Price 12. A002, Qty 2, Price 13
Credit total of 10.54 made up of $4 for A001 and 6.54 for A002
Pass

6
Change Customer Category and Repeat 5. above
No Credit as customer category is not part of automation
Pass

7
Change Customer Group and repeat 5. 
No Credit as customer group is not part of automation
Pass

8
Change product Category and Repeat the test in 5. 
No Credit as the product category is not part of the automation
Pass

9
Change POS030 to credit based on percentage. Repeat steps above
Credit based on Line balance as a percentage and applied to invoice
Pass

Table 2 - Calculation of Credits based on testing performed

IDInvoiceLineCustomerProductInvoiceBalanceInvoiceLineBalanceUnitPricePriceLevelPriceCreditAmountNotes
TX000109RC0001051SS001A001447.0020.0020.0010.0010.00Credit based on: Invoice Line Balance: 20.00, Unit Price: 20.0000, Price Level Price: 10.0000, Price Level: 1, Product Category: PETROL, Customer Group/Category: MOBIL/RETAIL
TX000109RC0001052SS001A002447.00327.0030.0010.00218.00Credit based on: Invoice Line Balance: 327.00, Unit Price: 30.0000, Price Level Price: 10.0000, Price Level: 1, Product Category: PETROL, Customer Group/Category: MOBIL/RETAIL
TX000110RC0001061SS001A00126.1712.0012.0010.002.00Credit based on: Invoice Line Balance: 12.00, Unit Price: 12.0000, Price Level Price: 10.0000, Price Level: 1, Product Category: PETROL, Customer Group/Category: MOBIL/RETAIL
TX000110RC0001062SS001A00226.1714.1713.0010.003.27Credit based on: Invoice Line Balance: 14.17, Unit Price: 13.0000, Price Level Price: 10.0000, Price Level: 1, Product Category: PETROL, Customer Group/Category: MOBIL/RETAIL
TX000111RC0001071SS001A00162.3424.0012.0010.004.00Credit based on: Invoice Line Balance: 24.00, Unit Price: 12.0000, Price Level Price: 10.0000, Price Level: 1, Product Category: PETROL, Customer Group/Category: MOBIL/RETAIL
TX000111RC0001072SS001A00262.3428.3413.0010.006.54Credit based on: Invoice Line Balance: 28.34, Unit Price: 13.0000, Price Level Price: 10.0000, Price Level: 1, Product Category: PETROL, Customer Group/Category: MOBIL/RETAIL

Environment Details

  1. OS version: Win10
  2. Application version: 13.40
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Since this is a customisation, the reseller will perform UAT and provide feedback. Build 13.40 RC1 available at https://www.linktechnologies.com.au/ftp/Misc/

Case assigned to Development until RC1 is available.


24 Mar 202202:27PM Comment 26 by Sanjay (Link Technologies) ETC was changed from 30/03/2022 to 30/03/2022
05 Apr 202201:28PM Comment 27 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 05-04-2022 05:27 PM Time Taken: 8.00
Repeated tests in comment 25 and achieved the same results.

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12322 in the subject line of all emails regarding this issue.

Document size: 45.3 KB
For call complaints, please contact the Managing Director of the company using this form