Skip to main content
Solved

Physical Inventory Import Scenario Help

  • 22 September 2022
  • 9 replies
  • 322 views

Forum|alt.badge.img

We are trying to do our physical inventory from an excel spreadsheet import using an import scenario but for some reason my scenario will not add another line until it gets to a location with a different ID. I’ve tried changing the orders around and playing with the commit option but I’m not having any luck.

 

I need to use the ADD dialog box in the physical inventory review or count screen as many of our inventory lines don’t have a line at the time of PI creation.(Long explanation). 

 

 

Best answer by RohitBhandurge

@jcox43 - Trying to understand the process here. If you are doing a Physical Inventory Count, are the counted quantities recorded on an excel spreadsheet?

If not, are you using the PI Count Sheet to note the Physical Quantities?

If the goal is to load the count details into Physical Inventory Review, then why are you not “uploading” the Excel Spreadsheet on the Physical Inventory Review - see highlighted in red below?

I am assuming you have the Physical Quantities on the Excel Spreadsheet that you are trying to import.

View original
Did this topic help you find an answer to your question?

9 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13
jcox43 wrote:

We are trying to do our physical inventory from an excel spreadsheet import using an import scenario but for some reason my scenario will not add another line until it gets to a location with a different ID. I’ve tried changing the orders around and playing with the commit option but I’m not having any luck.

 

I need to use the ADD dialog box in the physical inventory review or count screen as many of our inventory lines don’t have a line at the time of PI creation.(Long explanation). 

 

 

Hi @jcox43 Could you please share the Import scenario so that we can check and correct it if any changes are needed, this will help us to import and check in the system

Thanks


Forum|alt.badge.img
  • Author
  • Freshman I
  • 26 replies
  • September 22, 2022

Thanks,

Here is the .XML file


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hello

Attached is the import scenario, once check and let me know if it helps.


Forum|alt.badge.img
  • Author
  • Freshman I
  • 26 replies
  • September 22, 2022

No luck, this still only entered the first line


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • September 22, 2022

HI @jcox43 

Have you tried the Add Line?

 


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 63 replies
  • Answer
  • September 22, 2022

@jcox43 - Trying to understand the process here. If you are doing a Physical Inventory Count, are the counted quantities recorded on an excel spreadsheet?

If not, are you using the PI Count Sheet to note the Physical Quantities?

If the goal is to load the count details into Physical Inventory Review, then why are you not “uploading” the Excel Spreadsheet on the Physical Inventory Review - see highlighted in red below?

I am assuming you have the Physical Quantities on the Excel Spreadsheet that you are trying to import.


Forum|alt.badge.img
  • Author
  • Freshman I
  • 26 replies
  • September 25, 2022
kbeatty21 wrote:

HI @jcox43 

Have you tried the Add Line?

 

No I have not tried that yet, our inventory was this weekend so we had to rely on manual input on this. I will try to test this to see if it works.

Thanks


Forum|alt.badge.img
  • Author
  • Freshman I
  • 26 replies
  • September 25, 2022
RohitBhandurge wrote:

@jcox43 - Trying to understand the process here. If you are doing a Physical Inventory Count, are the counted quantities recorded on an excel spreadsheet?

If not, are you using the PI Count Sheet to note the Physical Quantities?

If the goal is to load the count details into Physical Inventory Review, then why are you not “uploading” the Excel Spreadsheet on the Physical Inventory Review - see highlighted in red below?

I am assuming you have the Physical Quantities on the Excel Spreadsheet that you are trying to import.

Our goal this inventory was to record the counts in an excel spread sheet. 

But currently we use both the PI count sheets to record our finished goods but for our raw material we record our measurements or weight (some are just piece counts) on “blank” inventory sheets that then need to be converted into MSI values which can then be input to the PI. 

We’ve never recorded any of our PI in excel before. 

 

I don’t know why I never attempted to use that upload method on this though… it may work and I will try this before our next inventory. For some reason I’m thinking the note field cannot be uploaded… is that correct? We like to record our count sheet/tag number in that field for easier auditing and recounting.

 

Thanks 


AndrewBGL
Pro I
Forum|alt.badge.img
  • Pro I
  • 175 replies
  • April 1, 2023

Hello,

I am looking at the import scenario and wondering why there a was need for the document summary.

I am also doing an import but I think I will only need 4 columns.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings