We are trying to import the PI inventory counts from excel and receiving an error. Steps taken
Export the list with the Excel button.
Enter the Physical Quantities in the the column for Physical Quantities in the excel. Save excel and click upload. There is only the one column to update. Expected this to be “easy”
Dont know how to find the Trace in the error message to try to identify the error.
Page 1 / 1
it seems the issue was Physical Quantity has to be defined as Numeric in the excel spreadsheet not as general and we also changed this to 2 decimal places. Then it worked. Weird.
HI @sspencer
I know you got the answer to this, but I was just going to suggest when you upload, make sure that the Physical Quantity Column is defined when you re-import the counts.
I would still like to know where to find this trace information. I am now trying to upload more information and ADD records not just update existing records. What do i need to do to Add New Rows.
HI @sspencer
You can find the trace by going to the Top Right of the Screen and selecting Tools> Trace:
To Add items, click the + sign, however depending on the settings of the Physical Inventory Type, you may not be able to add items. You may get an error that those combos don’t work.