Solved

Physical Inventory Upload Counts

  • 26 September 2023
  • 4 replies
  • 26 views
S
Rank
Userlevel 2
Badge

We are trying to import the PI inventory counts from excel and receiving an error.  Steps taken

  1. Export the list with the Excel button.
  2. 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.

 

icon

Best answer by sspencer 26 September 2023, 17:31

View original

4 replies

S
Rank
Userlevel 2
Badge

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.

kandybeatty49
Rank
Userlevel 7
Badge +15

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. 

 

Kandy ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
S
Rank
Userlevel 2
Badge

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.

 

kandybeatty49
Rank
Userlevel 7
Badge +15

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. 

 

Kandy ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2023  Acumatica, Inc. All rights reserved