| 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;- Yees Cold Storage
- 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;- The Upload template will go through the Validation process to check;
- Stocktake Number exists
- Products Codes match
- Negative SOH Upload is Not Allowed
- The Upload will Update the Count Quantities
- The second Upload with same Stocktake Number will override the first Quantities Uploaded
- User will manually verify the variances via Stocktake Variance Report
- User will manually Post the Stocktake
Note: This upload should also go through Replication as the Client is using Replication.
Regards
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 2020 | 03:01PM Comment 1 by Rashna (Edge Business Solutions) Case L12020 added to project 12.0 |
| 13 Aug 2020 | 06:02PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 14-08-2020 06:01 PM |
| Allocated to development |
|
| 20 Aug 2020 | 04: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): - Added "InventoryStockTakeCount" file format for "stocktake" count upload to "Dropdowns -> Integration FileImport Type
- Added code for validating and importing stock take count.
2. Affected Areas: - File Import - Inventory Stock Take Count - system tested.
3. The issue was caused by: - New feature
4. Notes:
5. Next Step: Documentation ---------------------- Development Reference: |
|
| 26 Aug 2020 | 03:59PM Comment 4 by Rashna (Edge Business Solutions) ETC was changed from 31/08/2020 to 31/08/2020 |
| 10 Sep 2020 | 09: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: - Tested stock take count updated using the "InventoryStockTakeCount.csv" file.
- Updated the "File Import" page (Framework\Integration\File_Import.htm) stating users can import stock take counts.
This case is now closed |
|