Skip to main content

Serial/Lot Attributes - Knowledgebase / Inventory Manager (fka DataCollection) / Miscellaneous - Cavallo Technical Support

Serial/Lot Attributes

Authors list
Overview

The Serial/Lot Attributes screen allows users to assign attributes to their serial or lot tracked items. Users can see manufactured dates, expiration dates, and many other characteristics for a specific serial/lot number. In addition, users can create as many attributes as needed with DataCollection user defined fields. Existing serial/lot attributes defined in Dynamics GP can also be viewed and edited in this screen.


Usage

Users can search for serial or lot tracked items, then filter and sort the results. Attributes can be edited as necessary within the grid.

When editing the attributes of a serial number tracked item, the attributes apply only to that serial number. However, when editing the attributes of a lot number tracked item, the attributes apply to all items that share the lot number in the same warehouse. Users may add as many serial/lot attributes as needed by using the SalesPad DataCollection User Field Editor (User Field Editor must be enabled in the Security Editor).

To enter new serial lot attribute user fields:

  1. Open the User Field Editor. NevHo9xNrZdb0ERiYveD4jkR1mqLPOC8.png?access_token=snx3td-ljfuybakhs-3f1a7b455470ba63a17241cf8657d2fe2d7cd92b
  2. In the User Field Tables pane, select ItemSerialLotAttribute_x, then click New to create a new user field.UrNLXSe4KaMkpOvcL2mYfegIHo3HEYxg.png?access_token=snx3ta-ubvzlachfj-9ef787e569f510bfdea0e3bcfb63ed8535f4db7f
  3. Enter the properties of the new user field in the User Field Editor Window.52APJqf177W5lRjw0LX7je11L0bV0BJu.png?access_token=snx3td-odpasdfdkl-871974665f5ff92a8074074c9dd9041b46719fc6
  4. Click OK to close the User Field Editor.
  5. Click Save to keep the user field, and click Update Database Table to create the column in the SQL database.AerAHbnUJYNzlJjHdiS57AU6MY7ajlJt.png?access_token=snx3t6-zjwrpyhknz-6c5b254d895cd8acae4b8a39e4cce0a5b97cf5de
  6. User field columns are automatically added to the Results grid the next time the Serial/Lot Attribute screen is loaded. This layout can be further customized using the Column Chooser.
  7. In the Serial Lot Attributes module, the user fields can be edited in the Grid view simply by modifying the values in each lot’s cell. Tabbing off the field will instantly save any changes.6wX8pAlfm8FG2P9apR0Z3jAEGldG9rKF.png?access_token=snx3t5-prkvgqicjw-410d0d8c2726e88498e8219cf3d8701e5d63840a
Editing GP Lot Attributes

DataCollection supports entering and editing of Dynamics GP lot attributes. You may add, edit, and manage GP lot attributes by selecting an item on the SalesPad DataCollection Serial/Lot Attributes screen and then clicking the GP Lot Attribute Editor button. This button is disabled when a non-lot tracked item is selected.

BveLbPRCGVP4sm4ENRgST2VbHypvwI0A.png?access_token=snx3t9-ufewrublur-2afec55ba65c7f05a644144070c510caa6f4e851

Dynamics GP supports 3 text-based and 2 date-based user defined fields. The GP Lot Attribute Editor screen in DataCollection allows users to edit those user fields. All changes made on this screen will reflect on the selected lot tracked item in Dynamics GP.

eOaYlGsXonwAGsGPcJ7QeAarqP1PeAST.png?access_token=snx3te-yslomvykwy-ab8ee584aebc1d5d31a8acba03ca6b041e08b076


Security

Serial Lot Attributes - Grants access to the Serial Lot Attributes module.

Helpful Unhelpful