Skip to main content
Answer

Mass Inventory Receipts with Serial Numbers

  • January 12, 2024
  • 2 replies
  • 161 views

Forum|alt.badge.img

Hello!

I want to enter inventory items with serial numbers through the receipts form. 

I created an import scenario for that but it gives me the below error message. 

Field: Quantity, Value: 1, Warning: One or more lines have unassigned Location and/or Lot/Serial Number
Does anyone have a scenario created or any idea on how to map?

Amanda 

Best answer by jharris

Hello!

I want to enter inventory items with serial numbers through the receipts form. 

I created an import scenario for that but it gives me the below error message. 

Field: Quantity, Value: 1, Warning: One or more lines have unassigned Location and/or Lot/Serial Number
Does anyone have a scenario created or any idea on how to map?

Amanda 

Looks like your items are lot controlled and it wants to know the lot/serial numbers because your lot class is configured to store the lot number on receipt rather than at issue. So you’ll either need to adjust your import to include the lot numbers, or change the lot class to at issue so it won’t require this.

 

Thanks,
James

2 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • January 12, 2024

Hello,

For fastest answer, please export your scenario to XML using Clipboard action at top of Import Scenarios screen, then attach the XML file here.  Members of this community often prefer to download your XML - this allows them to see your import scenario configurations and see your Excel file… leading to an answer for you, I hope!

 

Laura


jharris
Semi-Pro I
Forum|alt.badge.img+7
  • Semi-Pro I
  • Answer
  • February 14, 2024

Hello!

I want to enter inventory items with serial numbers through the receipts form. 

I created an import scenario for that but it gives me the below error message. 

Field: Quantity, Value: 1, Warning: One or more lines have unassigned Location and/or Lot/Serial Number
Does anyone have a scenario created or any idea on how to map?

Amanda 

Looks like your items are lot controlled and it wants to know the lot/serial numbers because your lot class is configured to store the lot number on receipt rather than at issue. So you’ll either need to adjust your import to include the lot numbers, or change the lot class to at issue so it won’t require this.

 

Thanks,
James