Company: Link Technologies
Case No: L10533. Project: 11.40: LinkSOFT Version 11.4
Logged By: Rashna (Edge Business Solutions) on 02 Aug 2019 11:03AM
Priority: Medium
Product: Point of Sale
Group: Enhancement
Time Taken: 8.50 (Weight: 11.50)
Version: 11.3.0902
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Friday, 09 August 2019 12:00 AM [1723 days since logged date]
Status: Closed
Subject: Review the implication of "Freight" and "Retail Value" in transfers
Summary:    

Steps to Replicate

  1. Set the last cost for item 01068 as $55.00 in the demo database.
  2. Create a transfer for the item of quantity 20 from "Retail" to "Main". Enter freight as $16.50.
  3. Create, Submit and Receive the transfer. The freight entered in 2 above is not reflected in the total cost in the screen nor in the "Transfer Delivery" report.
  4. Generate the "Transfer Delivery" report.
    1. The includes the retail price and retail value. What is the significance of this? 
Audit Notes:Edited by sanjay on 05/08/19 15:59. Edited by rashna on 02/08/19 11:03. 
02 Aug 201910:59AM Comment 1 by Rashna (Edge Business Solutions) Case 10533 added to project 11.0
05 Aug 201903:59PM Comment 2 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 05-08-2019 03:59 PM Time Taken: 2.50

Hi Rashna, the current design is used for reporting purposes only.

We will change this as follows:

  1. Add a configuration name "Transfer Cost Distribution Method (None, Quantity, LineTotal, Weight)" where the user can select a Freight Cost distribution method:  Default is "LineTotal"
    1. None
    2. Prorate by Quantity
    3. Prorate by LineTotal
    4. Prorate by Weight
  2. When the Transfer is saved, the cost is updated in the destination location

06 Aug 201909:19AM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 06-08-2019 09:19 AM Time Taken: 3.50

Development work for this case has been completed.

The change will be available in version: 11.0.0806

1. The following changes were made(Include Database object names, Program classes and any other relevant information):|

  1. Added configuration Transfer Cost Distribution Method (N=None, Q=Quantity, L=LineTotal, W=Weight). The default value is "L"
  2. Changed the transfer receive process to include the Freight in the cost based on the distribution method.

2. The issue was caused by:

  1. Improvement

3. Next Step:

  1. UAT

4. Notes:


16 Aug 201903:23PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-08-2019 03:23 PM Time Taken: 1.50
For UAT 

19 Sep 201908:46AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 19-09-2019 08:46 AM Notes: Edited by rashna on 19/09/19 09:08. 
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1

Set the "Transfer Cost" distribution to None.

Create a transfer for items "TR001" and "TR002" from Retail of Main

  • Transfer Quantity = 5
  • Cost = 2
  • Freight = $5.00

Verify when the transfer has been received the cost remains $2.00.

Pass
2

Set the "Transfer Cost" distribution to "Line Total".

Create a transfer for items "TR001" and "TR002" from Retail of Main

TR001

  • Transfer Quantity = 3
  • Cost = 2

TR002

  • Transfer Quantity = 2
  • Cost = 2

Freight - 5

Verify when the transfer the cost should be as below

  1. TR001 = $5.00 (2+ (6/12)*5)
  2. TR002 = $4.00 (2+ (4/12)*5)

Computation = "Current Cost" + (Line Total of the item/Total Cost of Transfer)x Freight)

Pass
3

Set the "Transfer Cost" distribution to "Line Total".

Create a second transfer for items "TR001" and "TR002" from Retail of Main

TR001

  • Transfer Quantity = 3
  • Cost = 2

TR002

  • Transfer Quantity = 4
  • Cost = 2

Freight - 4.50

Verify when the transfer the cost should be as below

  1. TR001 = $1.93 ( (6/14)*4.5)
  2. TR002 = $2.57 ((8/14)*4.5)

Computation = Line Total of the item/Total Cost of Transfer)x Freight)


Pass
4

Set the "Transfer Cost" distribution to "Quantity".

Create a transfer for items "TR003" and "TR004" from Retail of Main

TR001

  • Transfer Quantity = 2
  • Cost = 2

TR002

  • Transfer Quantity = 5
  • Cost = 2

Freight - 4

Verify when the transfer the cost should be as below

  1. TR001 = $3.14 (2+ (2/7) *4)
  2. TR002 = $4.85 (2+ (5/7)*4)

Computation = "Current Cost" + (Quantity for a line/Total Quantity on the Transfer)x Freight)


Pass
5

Set the "Transfer Cost" distribution to "Weight".

Create a transfer for items "TR005" and "TR006" from Retail of Main

TR001

  • Transfer Quantity = 3
  • Cost = 2
  • Weight = 10

TR002

  • Transfer Quantity = 2
  • Cost = 2
  • Weight = 5 

Freight - 5.5

Verify when the transfer the cost should be as below

  1. TR001 = $3.30((30/50)*5.5)
  2. TR002 = $2.20((20/50)*5.5) 

Computation = "Current Cost" + (Weight of items in a line /Total Weighton the Transfer)x Freight)


Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.3.916
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-11-RASHNA

Next Step: 

  1. Documentation

19 Sep 201909:09AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 19-09-2019 09:09 AM
This case is added to documentation

04 Dec 201908:43AM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 05-12-2019 08:24 AM Time Taken: 1.00

Hi Sanjay, 

Documentation has been updated at "Linkweb application - Company Administration- configuration - Point of Sale"

Thanks
Rashna


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

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