Question

Export inventory from stock item menu

  • 8 September 2023
  • 5 replies
  • 69 views

Userlevel 5
Badge

Hello,

Is there a way to export the current inventory from the stock item menu. I do not see the field from the column configuration.

I guess I would need to create a GI to export the inventory correct?

 


5 replies

Userlevel 5
Badge

I think another option is to run a Inventory Balance report. I was hoping I could accomplish this from the stock item menu.

Userlevel 5
Badge

I was able to use an inventory balance report to get the quantity exported.

I now need to get the location exported also so I can issue out the inventory. How would I get the location exported?

Badge +18

Hello Andrew,

To see inventory quantities on hand by Warehouse Location, have you tried the Storage Summary Inquiry?

Items on Hand by Warehouse, including Location details

 

Userlevel 7
Badge +12

Hi @AndrewBGL 

Please find the attached GI which gives Qty on hand on Avail qty customized to regular stock Item screen,

Please verify in sandbox and plan in production.

Thanks

Userlevel 5
Badge

Hello Andrew,

To see inventory quantities on hand by Warehouse Location, have you tried the Storage Summary Inquiry?

Items on Hand by Warehouse, including Location details

 

Hello @Laura02 ,

I have used storage summary and then exported the list to get all locations. The issue is that there are 1000 items it need to process, so this method would take too long. Thanks for the idea!

Reply


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 — 2024  Acumatica, Inc. All rights reserved