Skip to main content
Question

Export inventory from stock item menu

  • September 8, 2023
  • 5 replies
  • 149 views

AndrewBGL
Pro I
Forum|alt.badge.img

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

AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • September 8, 2023

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


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • September 8, 2023

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?


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • September 9, 2023

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

 


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

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


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • September 15, 2023

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!