How to set up alternate item numbers in GP (for UPC's, Vendor Item Numbers, etc.)

How to set up alternate item numbers in GP (for UPC's, Vendor Item Numbers, etc.)

Dynamics GP allows you to set up alternate item numbers (cross-references) that PanatrackerGP can use for barcode scanning and data entry.

Set Up in Dynamics GP

  1. In Dynamics GP, navigate to Inventory > Cards > Item Purchasing Option.
  2. Enter your GP item number.
  3. Tap the gear icon to the right of the item lookup to open the Manufacturer's Item Number Maintenance window.
  4. Add the alternate item numbers you want to use.

Any item numbers added here can be scanned or entered in the PanatrackerGP application.

PanatrackerGP Features for Alternate Items

On-the-Fly Association at Receiving

Enable the AllowMfgCodeAssignments configuration setting and set it to true. When receiving against a purchase order, if an item number not found in GP is scanned, the user is prompted to associate it with an item on the PO. This association is then saved for future use.

Associate Mfg Item # Transaction

Use the Associate Mfg Item # transaction under Tools to create cross-references for any GP item number.

Audit Trail

All associations created through receiving or the Associate transaction are logged in the PanatrackerGP portal for auditing.

Handling Duplicate Associations

If the same alternate item number is associated with multiple GP item numbers, PanatrackerGP displays a selection list when that number is scanned.

Recommendations

  • If vendor item numbers are barcoded, set them up as cross-references to fully leverage barcode scanning.
  • For bulk imports of cross-reference data, contact your Dynamics GP partner to populate the GP table (IV00115) via SQL script.