Company: Link Technologies
Case No: L08473. Project: 08.20: LinkSOFT Version 8.2
Logged By: Rashna (Edge Business Solutions) on 18 Apr 2017 10:12AM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 2.00 (Weight: 2.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna
Resolve By: Wednesday, 19 April 2017 12:00 AM [2559 days since logged date]
Status: Closed
Subject: Incorrect date on Inventory Movement when items are uploaded by excel
Summary:    

Hi Sanjay, 

I have uploaded inventory via excel. I uploaded product FW001 from "Inventory" Sheet and updated the stock to 20 from "Inv List" sheet.

When we validate the entry, the current date is depicted from the machine date. I have validated and upload the item with date 18/04/2017. Refer to Figure 1.

However, the date on the inventory movement report is 01/01/1900

Figure 1.

Figure 2


Audit Notes:
04 May 201704:05PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 04-05-2017 04:05 PM Time Taken: 1.00
Development work for this case has been completed.
The change will be available in version: 8.12
Documentation update required(Yes/No. Add change details below): 
QA required(Yes/No.Include areas that require testing): Yes

The following changes were made(Include Database object names, Program classes and any other relevant information): 
 1. Changed inventory upload template to update DatePosted, WhoPosted and LastSavedDateTime fields in LBS_PART_ADJ_HD table.


Documentation details:
  

17 May 201708:55AM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 17-05-2017 08:55 AM Time Taken: 1.00
1. Was this test completed using Demo / New / Other database? Demo
2. Did the test pass or fail? Pass
3. Tab order, spelling, alignment, font size consistency, screen size etc checked? N/A
4. Data verified, saved, edit, delete/void? Pass
5. Documentation update required? No
Additional Details (Risks, issues, special conditions required for this test to pass etc):
  • Tested Inventory and Inv_List upload via excel.
  • Inventory header and details were successfully uploaded.
  • Date on the Inventory Movement report was correctly updated with the date on the excel upload template.



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

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