Hi experts, I am trying to create a BAQ for the stock status like system report Stock Status. How i can apply the logic ? I am thinking of subtracting all issued qty from total reciepts by transactions type from partran table. Will it make sense? anybody done this before ? Thanks

Thanks Ken. I’ll occasional go back to this, just for the challenge. Even if I don’t need to do it, I find doing these types of things are the best learning tools. And I was aware of the TranType affecting the sign of the TranQty. But I’m sure there are even more demons around every corner.

guys, i tried for BAQ, half done…but as @ckrusen said…there are even more demons around every corner…there are so many difficulties and confusions with summerizing total inward and total issues. Need to rectify all transaction types…

Forgive me if I have the wrong end of the stick but: Partbin - you can get partbin, onhandqty, warehouse code, Part - you can get part description, Partcost - you can get the STD costs. Join all 3 together and you’ll get a mirror of the stock status. I built the above in Excel through SQL. If …

@Rowley150 : Good idea, but partbin shows the current stock of till date. If i want to retrieve stock from parttran, how we will get the stock on CutOff date like Stock Status ? Now here, tranDate comes into picture. Now assume that on 1st of feb, the part XYZ had null stock, and today it is 200 No…

Yes - PartTrans needed to duplicate the “As Of” feature for the Stock Status report. I think a BAQ filtered by PartTran.InventoryTran = True should get you pretty close to start with. Beyond that I’m pretty sure I ran into a few TranTypes/exceptions the last time I looked at this in E9. But can’t…

Hey guys, Yuhhhhhhhhhhh…finally a BAQ is ready for Stock Status . I have applied a tracker view for cutoff date also. Thank you very much guys for your suggestions. Thanks.

Prakash, Can you share what you did then? We have a BAQ like Mark’s using Part - PartBin - PartCost tables. But would be interested to compare it to yours.

Hey randy, I will be happy to share BAQ with all of you, i just finalizing the ‘Cut Off Date’ functionality. It is not working as as expected, still working on it. I will post the BAQ as soon as i finshed. Thanks

No worries, I’m sure we’ve all had our share of BAQ quirks to hunt down and correct. :slight_smile:

Hello guys, Still fighting with ‘Cut off Date’ . Criteria / parameter in BAQ, Date Range filter in Tracker view not working. Tried all available tricks…but still BAQ is incomplete without ‘Cut off date’… I think , i have used 4 instatnces in BAQ ,screenshot is attached. Is it the problematic ? If…

BAQ for Stock Status

Epicor ERP 9

Topic		Replies	Views
BAQ for Stock Status Report Epicor ERP 10 ssrs	21	9923	January 14, 2021
BAQ to get quantities for all parts on a specific date Epicor ERP 10 e10 , baq	15	10407	June 11, 2024
Create a BAQ similar to Stock status report Epicor ERP 10 inventory , baq , stock-status	19	3426	July 18, 2022
Stock Out BAQ Epicor ERP 10 e10	11	2079	January 30, 2019
Stock Status Report Epicor ERP 10 baq	15	6038	February 16, 2023

BAQ for Stock Status

Related topics