We are trying to import the PI inventory counts from excel and receiving an error. Steps taken
Dont know how to find the Trace in the error message to try to identify the error.
Best answer by sspencer
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.
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.
+17HI
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.
+17HI
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
