Skip to main content
Answer

Inventory import with warehouse and location

  • April 1, 2023
  • 8 replies
  • 530 views

AndrewBGL
Pro I
Forum|alt.badge.img

Hello,

I am trying to use an import scenario to import our initial inventory test tenant.

Does someone have a .xlm import I could use as a template.

Thanks

Best answer by AndrewBGL

Hello Everyone,

Thanks for all your replies. I was able to use an import scenario to import our inventory into 2 warehouses. I then checked the receipts that was created and released them. In total we received 15,353,545 items and it worked perfectly.

 

8 replies

Forum|alt.badge.img+12
  • Acumatica Support Team
  • April 3, 2023

Hi @AndrewBGL 

What document are you using to bring in Initial inventory quantities? You can use a Physical inventory document or just an Inventory receipt document. 

Regards,


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

Hi @AndrewBGL 

Using receipts screens you can import the Inventory with out Import scenario.

Please use load file from Excel option.

Map the excel columns

 


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • April 3, 2023

Hi @AndrewBGL 

Using receipts screens you can import the Inventory with out Import scenario.

Please use load file from Excel option.

Map the excel columns

 

Thanks for the reply. For adding a few items this would work great but we are loading 976,194.00 items.


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • April 3, 2023

Hi @AndrewBGL 

What document are you using to bring in Initial inventory quantities? You can use a Physical inventory document or just an Inventory receipt document. 

Regards,

I wanted to use an import.


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • Answer
  • April 3, 2023

Hello Everyone,

Thanks for all your replies. I was able to use an import scenario to import our inventory into 2 warehouses. I then checked the receipts that was created and released them. In total we received 15,353,545 items and it worked perfectly.

 


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • April 3, 2023

If anyone needs help with inventory imports let me know.


Forum|alt.badge.img
  • Freshman I
  • June 23, 2023

If anyone needs help with inventory imports let me know.

Hi Andrew, can you share how you solved the problem, did you create a new import scenario or there is an existing import scenario can serve the purpose.

Thank you 


  • Freshman II
  • July 30, 2024

I’m struggling to receive in about the same number of items. I tried a receipt and it errored out. Can you provide an import scenario to the Receipt screen? Thanks!