We need to understand how to get location status, (damaged, frozen, etc), into an inventory report. We haven't been able to find a table in the system that we can filter against thus far.
Best Answer
M
Matt Aussieker
said
over 2 years ago
Hi George,
The Perpetual Inventory Log table is the place where you can view and filter on location status. I would recommend also filtering this table on Current Quantity > 0 as this table does include historical data.
I hope this helps, but let me know if you have any questions.
Matt
1 Comment
Matt Aussieker
said
over 2 years ago
Answer
Hi George,
The Perpetual Inventory Log table is the place where you can view and filter on location status. I would recommend also filtering this table on Current Quantity > 0 as this table does include historical data.
I hope this helps, but let me know if you have any questions.
George Eye
We need to understand how to get location status, (damaged, frozen, etc), into an inventory report. We haven't been able to find a table in the system that we can filter against thus far.
Hi George,
The Perpetual Inventory Log table is the place where you can view and filter on location status. I would recommend also filtering this table on Current Quantity > 0 as this table does include historical data.
I hope this helps, but let me know if you have any questions.
Matt
Matt Aussieker
Hi George,
The Perpetual Inventory Log table is the place where you can view and filter on location status. I would recommend also filtering this table on Current Quantity > 0 as this table does include historical data.
I hope this helps, but let me know if you have any questions.
Matt
-
Add a free bottle opener to all orders that are shipped to California
-
View all unallocatable orders daily
-
Change the parcel carrier for orders shipping to a PO Box
-
Why Do Triggers not apply to certain orders?
-
Return all damaged items to customer
-
Smart Filters for VIP customers
-
Add tags to multiple orders
-
Get Daily Detailed Inventory Reports Automatically Emailed
-
Reporting script
-
Populating custom field on label with customer PO#
See all 24 topics