Reporting on Tote Inventories

Hello, I’m not sure I understand what you mean by “in totes” and “list all totes active in the system “, can you provide an example screen shot of an Acumatica screen or report where you see the totes? I hope seeing examples will help us to answer your question. Thank you.

In the automated Pick/Pack/Ship module, you can items into totes. When you scan an item it will say something like Item A, qty 1, Scanned to tote 01A. I want to find that tote and all it’s contents.

This came up because on the very LAST item you scan, the tote is not given, so no one knows what tote it is in. I want to display all the totes and their contents since the system won’t tell me on the screen when I’m scanning.

I dumped that whole table to an inquiry and none of fields have a Tote ID. Did you bind to another table by chance? Here is an export of every field I have for that table.

I feel like you’re on the right path though, I’m going to fumble around with this some more and see if I can find where the TOTE ID lives :D

NVM, you just need to bind it to SOPickerToShipmentLink

I bound on PickerNbr, ShipmentNbr, and SiteID. I don’t think I needed SiteID, but it isn’t hurting anything. I ran left joins so I could also capture toteless single picks as well.

Glad you figured it out. In my system, I only had to grab the one table. I am using 2023 R1 Beta.

For the readers following along, the version that required two tables was: 

Acumatica 2022 R1
Build 22.107.0022

Your may have different results, good luck my friends!

@Doug Johnson - Thanks for the push in the right direction, once you got me there, I was able to DAC Browser myself to victory!!!!

I think this would be a great native GI. Especially if people are scanning multiple shipments at once, a  lot of times they do not know what Totes are free as they may already be assigned to other shipments/orders.

But I will try and create this GI on 2023R2 for a client