Company: Link Technologies
Case No: L11978. Project: 12.10: LinkSOFT version 12.1
Logged By: Rashna (Edge Business Solutions) on 15 May 2020 02:44PM
Priority: Medium
Product: Point of Sale
Group: New Feature
Time Taken: 5.00 (Weight: 5.00)
Version: 12.10.1020
Assigned To: Rashna (Edge Business Solutions)
Circulation: Alvis, Rashna, Sanjay, Sitla, Vineshwar Prasad
Resolve By: Sunday, 31 May 2020 12:00 AM [1651 days since logged date]
Status: Closed
Subject: New Feature - Separate Access for Inventory Adjustment In and Adjustment Out
Summary:    Bula Team,

We have received the below request from Laucala Bay Pharmacy as a New Feature.

Feature: Separate Access for Inventory Adjustment In and Adjustment Out

Business Scenario 1
Company A is a Bakery Retail outlet. Their operating hours are from 9.00 am to 4.00 pm. Baking is done in the outlet between 12.00 am to 6.00 am daily. They do not stock the Ingredients in the POS system and also don't use the Kit feature due to the conversion factor not being accurate in the Bakery industry as;
  1. There is a lot of wastage of ingredients
  2. Ingredients are measured in grams which is hard to maintain
  3. Ingredients usage may not be exact to grams mentioned in the formula (kit setup)
Once baking is completed, the Supervisor arrives at 8.00 am, does the Stocktake to balance all the ingredients, and uses the Production sheets to do Inventory Adjustment In of the finished Goods. The shop operates normal as they are able to process sales of all finished goods in the system.

After 4.00 pm once the Bakery is closed. The Accountant does the Stocktake, balances the Daily sales, and does Inventory Adjustment Out for the leftover of the Products from the system as this cannot be used the next day. The Roles are separated by 2 staff to control theft.

Business Scenario 2
Company A and Company B are registered businesses and are sister companies as the owners are family members. Both companies are using the same system however it is not linked as they are registered with separate TIN numbers and Company Names.

Both companies borrow stock from each other when they fall short or the delivery from the supplier is late. Since they are family members they trust the person will return the stock once they get the supply. They use Inventory Adjustment In and Out so that a document can be generated for what is borrowed.

At both Companies, the Stock Clerk's responsibility is only related to stock dispatch (Inventory Adjustment Out). Once the stock is returned from the other Company, the Store Manager verifies the stock and does the Inventory Adjustment In. This way there is a separation of duties and theft is prevented.

Regards
Vineshwar Prasad
Audit Notes:Edited by alvis on 25/05/20 15:21. Edited by alvis on 25/05/20 15:21. Edited by sanjay on 25/05/20 14:07. 
15 May 202002:46PM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 19-05-2020 02:45 PM Time Taken: 1.00

Hi Sanjay, 

Case assigned for development as per "Go To Meeting" with Sanjay, Sitla and Vinesh.


25 May 202002:06PM Comment 2 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 26-05-2020 02:05 PM
Approved to proceed

25 May 202002:07PM Comment 3 by Sanjay (Link Technologies) Case L11978 added to project 11.5
25 May 202003:21PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 26-05-2020 02:54 PM Time Taken: 2.00

Development work for this case has been completed.

The change will be available in version:11.5.0525

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

  1. Added security access for "Adjustment IN" and "Adjustment OUT"
  2. Implemented security when entering an adjustment

2. Affected Areas:

  1. Inventory Stock Adjustment

3. The issue was caused by:

  1. Improvement

4. Notes
5. Next Step
: UAT


29 May 202001:17PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 02-06-2020 01:06 PM Time Taken: 1.00
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

User admin has access to below securities

  1. Can create items for "Adjustment IN" in menu Inventory Stock Adjustment
  2. Can create items for "Adjustment OUT" in menu Inventory Stock Adjustment
  • On the stock adjustment menu, add an adjustment for location  "Retails" as below
    • Product = PNT01 , Direction = In, Quantity = 10
    • Product = PNT02 , Direction = Out, Quantity = 10
  • This should be allowed for the user
Pass
2

Disable access for "Can create items for "Adjustment IN" in menu Inventory Stock Adjustment"On the stock adjustment menu, add an adjustment for location  "Retails" as below

  • Product = PNT01 , Direction = In, Quantity = 10
  • This should NOT be allowed for the user


Pass
3

Disable access for "Can create items for "Adjustment OUT" in menu Inventory Stock Adjustment"On the stock adjustment menu, add an adjustment for location  "Retails" as below

  • Product = PNT02 , Direction = Out, Quantity = 10
  • This should NOT be allowed for the user

Pass

Environment Details

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

Next Step

  1. Documentation

    01 Jun 202010:18AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 02-06-2020 10:14 AM Time Taken: 1.00

    Hi Sanjay, 

    Documentation has been updated at LinkSOFT\LinkWebApplicationsPortal\Global Administration\Security_Controls.htm

    Thanks
    Rashna


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

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