Our company went live on Business One 3 weeks ago. We will be doing a physical inventory at the end of this week. Our physical inventory process has always included controlled, pre-numbered inventory tags that are filled in with Item Code, Item Name, Batch #, Bin Location, Quantity. These tags were then input into our legacy system and used for reporting, tracking and reconciling the physical inventory. There does not appear to be a method for using tags in Business One. Are there other companies using Business One who use tags to perform a physical inventory? How/where do they record the tag number? I could add a user-defined field, but don't know where to add one (don't see a Physical Inventory section under UDF management).
Keith Taylor replied
not sure adding a UDF is really the correct answer here as if you do you are really going to "hard code" a tag number to an item/warehouse combination since SAP does not permit direct access to the database you would not be able to clear the field.
A better solution or thought might be using the SDK or to export the items out to Excel and assign tag numbers in Excel and then you could use Excel to print labels or tags.
Your tag control could then be in Excel