Company: Link Technologies
Case No: L12020. Project: 12.10: LinkSOFT version 12.1
Logged By: Rashna (Edge Business Solutions) on 07 Aug 2020 03:01PM
Priority: Medium
Product: Point of Sale
Group: Enhancement
Time Taken: 3.00 (Weight: 3.00)
Version: 12.10.1020
Assigned To: Rashna (Edge Business Solutions)
Circulation: Alvis, Development, Rashna, Sanjay, Vineshwar Prasad
Resolve By: Monday, 31 August 2020 11:59 PM [1349 days since logged date]
Status: Closed
Subject: New Feature - Stocktake (Count) Upload/Import template
Summary:    Bula Team,

We have received the request after discussing with the POS Clients to Include Stocktake Upload Template;
  1. Yees Cold Storage
  2. Kundan Singh
Feature: Stocktake (Count) Upload/Import template

Justification: After the introduction of version 12, the excel upload templates have been removed with the inclusion of Stocktake Upload. Users need an option of Uploading 1000+ stock counts at once on a regular basis. The system currently doesn't allow this as they have to manually fill in the count quantities which is time-consuming and affects there Business Operating Hours.

Rules of Upload;
  1. The Upload template will go through the Validation process to check;
    • Stocktake Number exists
    • Products Codes match
    • Negative SOH Upload is Not Allowed
  2. The Upload will Update the Count Quantities
  3. The second Upload with same Stocktake Number will override the first Quantities Uploaded
  4. User will manually verify the variances via Stocktake Variance Report
  5. User will manually Post the Stocktake
Note: This upload should also go through Replication as the Client is using Replication.

Vineshwar Prasad
Audit Notes:Edited by rashna on 26/08/20 16:00. Edited by rashna on 26/08/20 15:59. Edited by rashna on 07/08/20 15:01. 
07 Aug 202003:01PM Comment 1 by Rashna (Edge Business Solutions) Case L12020 added to project 12.0
13 Aug 202006:02PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 14-08-2020 06:01 PM
Allocated to development

20 Aug 202004:04PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 21-08-2020 03:38 PM Time Taken: 2.00

Development work for this case has been completed.

The change will be available in version:12.0.0820

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

  1. Added "InventoryStockTakeCount" file format for "stocktake" count upload to "Dropdowns -> Integration FileImport Type 
  2. Added code for validating and importing stock take count.

2. Affected Areas:

  1. File Import - Inventory Stock Take Count - system tested.

3. The issue was caused by:

  1. New feature

4. Notes
5. Next Step
: Documentation


Development Reference:

26 Aug 202003:59PM Comment 4 by Rashna (Edge Business Solutions) ETC was changed from 31/08/2020 to 31/08/2020
10 Sep 202009:58AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 11-09-2020 09:33 AM Time Taken: 1.00

The following has been done:

  1. Tested stock take count updated using the "InventoryStockTakeCount.csv" file.
  2. Updated the "File Import" page (Framework\Integration\File_Import.htm) stating users can import stock take counts.
This case is now closed

If you have any queries regarding this support incident, please email and include the Case No: L12020 in the subject line of all emails regarding this issue.

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