Hello everyone, We manage inventory on a bin basis. So, it is necessary to manage the change in the daily bin stock quantity. I created Bin’s on-hand Qty. But, I want to make it so that the quantity by day can be managed like the picture below. Is there any way to do it? I need the help of BAQ ex…

@pilio.lee try this BAQ, will give you what you want but per entered parameter day, see if you can modify it to a pivot one instead [image] Stock Status Report - Zero Value on Part ERP 10 Bev_StockStatus.baq (41.8 KB) My Stock Status BAQ to calculate Running Total On han…

Are you wanting to see what HAS been in the bins in the past, day by day? Or are you embarking on an ambitious “Plan for every part” project, where you want to add some UD fields to the DB to say, “this is what you people SHOULD be stocking each day”? I see dates in the past in your mockup, so I a…

Yes. I just want to see how much stock was in the bin by date in the past (by part). From what you said, it seems like a fairly difficult function for me as a beginner in BAQ.

That’s a good way to look at it. If @pilio.lee only needs the last 5 days or a specific day, that seems doable (speaking from my own moderate skill level).

I needed a specific date and your sharing has been a big help to me. That’s a good way.

I’m sorry to bother you, but may I ask you two questions? I made a BAQ from the query you advised. And then I imported PartBin to add Warehouse/Bin to column. This is because even the same part is distributed across multiple bins. However, they appear as duplicates in multiple bins. What should I …

if you want it to be Bin specific, then yes you need to add this to each one of the three subqueries as a field to group in by, then added it as a dynamic filter same as the cutoff date, (i.e. remove it from the top level), however this will only count the stock within each Bin not as total, e.g. yo…

[image] A.Baeisa: then added it as a dynamic filter same as the cutoff date, (i.e. remove it from the top level), What is the work you said “added it as a dynamic filter same as the cutoff date(i.e. remove it from the top level)”? [image]

[image] [image] and you need to add the warehouse the same way as i see you added it to the group by fields

I followed your advice. And one more question arose. I want to add Warehouse/Bin field in Query Results. What should I do? sorry to bother you [image]

no problem at all mate, very easy to do, just add it on the top level query from any subquery, all of them have them [image] [image]

Bin Inventory Report by Day

Kinetic ERP

A.Baeisa (Al) February 14, 2022, 8:15am 4

@pilio.lee
try this BAQ, will give you what you want but per entered parameter day, see if you can modify it to a pivot one instead

Topic		Replies	Views
Parts by customer - BAQ preferred Kinetic ERP baq	34	405	June 10, 2025
Pivot BAQ Kinetic ERP baq	3	1772	February 5, 2024
BAQ for Stock Status Epicor ERP 9	22	9164	March 9, 2017
BAQ Grouping Epicor ERP 10 e10 , epicor10_0	32	7261	May 10, 2024
Stock Status Report Epicor ERP 10 baq	15	6125	February 16, 2023

Bin Inventory Report by Day

Related topics