What does GTIN quantity mean?
If there's only 1 GTIN on file and the quantity per is greater than 1, then that's the GTIN qty.
If there's more than 1 GTIN on file for an item, and the bigger qty can be fully divided by the smaller quantity, the system will show the quantities in the multiple units of measure.
Let's say we have a qty of 37, the quantity will be presented:
32 + 4 + 1
2 CS, 1 CT, 1 EA
1 CS = 18, 1 CT = 4? In that case, the application will use only use the smaller quantity per of 4
37 = 9 CT, 1 EA
The new Type field allows the user to specify if a user is a warehouse user or an office user. Warehouse users will see the breakdown in multiple applications. The default value is Office user.
A new UOM (unit of measure) field has been added to the GTIN maintenance application. This field must be set up to make the GTIN eligible to be considered for the GTIN quantity display.
This a user-defined field that can be any abbreviation that represents the packaging for the item. This UOM will print or be displayed wherever the GTIN breakdown is shown.
When viewing the list of GTINs on file for an item, the UOM is now displayed in the master list.
GTIN CSV Imprt
The following fields are supported during the import:
A) Item No - Item number the GTIN or UPC represents.
B) Type (8=UCC-8, U=UCC-12, E=UCC-13, G=GTIN) - Type of UPC code.
C) Link to Item Master - Indicate if the GTIN is linked or based off the UPC code found in the Item Master File. This field is required if the type is G.
D) GTIN/UPC - The UPC/GTIN code.
E) Qty Per - The quantity per for the item. THis field will default to 1 if not provided.
F) UOM - A two-character unit of measure.
Import GTIN From - Enter a path and file name for the CSV file. This will default to a new I/M Global Setup option on screen 4 field 5:
Default Path for GTIN CSV Import?
Does CSV File Have a Header Row? Answer Y if the CSV file has a header row. Otherwise answer N.
The application will produce a report the with the results of the import.
1. Item number is longer than 15 characters.
2. Item number is not on file in the item master.
3. An type other than 8, U, E or G was provided.
4. The quantity per exceeded 999,999.
5. The link to item master field size is longer than 1 character. This field should contain a Y, N or space (for non G type codes).
6. The link to item master is not Y or N for a G type code.
7. Type 8 length must be 8.
8. Leading digit is wrong for type 8.
9. Invalid check byte.
10. Type U length must be 12.
11. Type E length must be 13.
12. Type G length must be 14.
13. UOM is longer than 2 characters.
PO Warehouse Receiving Edit List - Summary
When running the PO Warehouse Receiving Edit List in summary, the report will show a breakdown of each item's unit of measure based on the GTIN quantites that are set up.
Inventory Transfer Management
The Transfer ticket now shows a breakdown of quantities for each item based on the item's GTIN units of measure. Recommendations of where to pull stock from or where inventory aready exists are also shown in the GTIN unit of measure.
The Inventory Transfer Management maintenance application shows more information regarding GTIN packaging. Quantities entered in the GTIN unit of measure. GTIN information is shown on the bottom of the screen.
Pressing the F2 key will allow this screen to pop up. Users can enter the appropriate quantities for the transfer.
If the quantity is split between multiple "to bins," the GTIN pop-up screen is used here as well to enter quantities in the GTIN unit of measure.
The appropriate unit of measure is displayed when the application returns to the split screen. The quantity remaining is updated.
The Inventory Transfer Management Dispatch screen allows the user to see the detail information about the transfer batch. This detail screen also shows the breakdown of the different GTIN units of measure.
Cycle Count Worksheet
The Cycle Count Worksheet prints the GTIN unit of measure based upon the current quantity on hand at the item level if using single bin or at the bin inventory level if running the multi-bin enhancement.
Physical Count Processing
When in Quantity mode of Physical Count Processing, the application will allow the user to enter quantities based on the applicable GTIN units of measure for the item.
Viewing the tag in change mode will show quantity counted in the item's stocking unit of measure as well as the GTIN units of measure.
Stock Status Inquiry
The Stock Status Inquiry application shows the quantities based on the GTIN units of measure.
Drilling down to the Multi-Bin Information will show the item total qty, item quantity on hand and item quantity available in the stocking and GTIN units of measure. The F5 toggle supports the option of displaying the bin quantities in the GTIN unit of measure.
The Bin Inquiry supports a unit of measure column. The data shown on this base screen is representative of what resides in the bin. For example, if multiple items reside in bin and they all have the same stocking unit of measure, the stocking unit of measure is shown. If they have various units of measure, "VA" is shown in the unit of measure field.
"From Bin" Search
The "From Bin" search supports a new F5 toggle option to show the GTIN unit of measure quantities.
Warehouse Management Support (Release Date 7/24/18)
Programs Added: IMGINTIS, IMGTINIP, GTINQTYP.WS, GTINQTYP.PL
Programs Changed: NSCTLFIL.FD, NSCTLFIL.W33, NSCTLINI, NSCTLMN3, NSCTLUT3, IMGTINFI.FD, IMGTINMN, SYUSERS.FD, SYSPASS, POWHRSCN, POWHSLST, POWHRLSS, IMGINTMN, IMGTINMN.WS, TRANTICK.WS, TRANTICK.WS, IMBTTSCN, IMBTTRPT, IMBRRWPT, IMBATCON, BM19S1, BM19S2, BM19S3, BM20S1, BM20S2, BM20S3, CP02S1, CP03S2, IM2400, PO2000, POWHRPSS, IMBINTSF, IMBINTRN, IMTSFDTL, IM0500, IM1000, IM1001, BINLIST, IMBINDTL, IM1904B, BINWMGEN, CPBATVEB, IMTSFREC, IMTSFVEB