Page Comparison

5849 System will generate unique barcode for each quantity of each item in the imported Excel

Module:

Ginesys Web - Procurement - Operations - Receipts
Ginesys Web - Inventory - Operations - Miscellaneous Entry

Enhancement Summary:

The system will now provide new unique serialized barcode to each unit quantity of an item. Suppose a red shirt has been created in five (5) different sizes - XS, S, M, L and XL, each with 20 quantities. Now if we import it through Excel, it will create 100 (5 X 20) new barcodes. This will allow the tracking of each item individually through all interactions.

New Import class has been added for 'Serial/Unique Item Creation' and the import class is available in Transaction modules only.

Column mapping changes in Excel file for Serial Item Creation are as follows:

1. Quantity column mapping is now mandatory.
2. OEM Barcode and Short Name column are not provided for mapping.
3. If status of Allow creation of new item /barcode  profile is Not allowed in User profile then import Excel from this class is not allowed and the following message is displayed: Item creation is not allowed from transaction module.

Scenario:

N.A.

5832 Items can now be created while receiving Miscellaneous stock by importing Excel

Module:

Inventory - Operations - Miscellaneous Entry > Receive tab

Enhancement Summary:

Users can now create items while importing Excel for Miscellaneous Entry > Receive tab. 

If Barcode or OEM Barcode, provided in the Excel file, is already found in the item master, then the values specified in the columns mapped with Excel file will be updated.

Role permission, for such modification, will be checked in User Profile for Inventory tab: Allow item editing from transaction entries and will work accordingly as below -

If the value is Not Allowed: On click of Edit item in item grid, modification is not allowed.

The following message is displayed - Edit Item is not allowed. Please contact administrator.

If the value is Allowed (All item properties): On click of Edit item in item grid, the window for item modification opens, with selected item information getting populated.

Modification of fields values for Barcode, and Inventory item are not allowed.

Rest all field modification is allowed, validating item master working checks.

If the value is Allowed (Price change restricted): On click of Edit item in item grid, open the window for item modification, with selected item information getting populated.

Modification of Pricing information is not allowed, i.e. Standard Rate, RSP, WSP, MRP

Modification of field values for Barcode, and Inventory item are not allowed.

All other field modification is allowed within checks provided in Item master.

If Barcode is not provided and specified OEM Barcode does not exist in Item master, then new item will be created (as per User Profile option of Allow creation of New item/Barcode). 

Note: App-operation assigned to connected user role with relation to Item master will not be validated for modification of item. User not having permission in Inventory module, can modify item from transactional modules in Procurement if permission is available in the User Profile assigned to that user.