FIFO,QtyOnHand on Historical Stock Status Report

[dhv919401]

Does anyone know how the FIFO value, Qty on hand on the Historical Stock Status is calculated? This is very important for me to know.
I appreciate if anybody could share their knowledge.

Thank you for your help in advance,


dhv919401

 

[barbola]

I'm not 100% sure but I think it would calculate the same way as the regular Stock Status report, only taking into consideration any invoice/matching transactions with a cost variance from the original receiving. Possibly also recalculating the layer of inventory used for inventory transactions entered with older dates?

You can check Tools > Utilities > Inventory > Adjust costs to see what is happening. Did you run the HSS detail? That would help too although would be slow to run.

 

[swabunn]

I am also strugging to know this?

 

[dhv919401]

I am looking for the code that the Historical Stock Status is using to calculate ON HAND QTY (At a certain point in time) and FIFO Cost (At a certain point in time).

I made my query based on the invoice transactions (IV30300) and docdate. But they are not matching with the Historical Stock Status report numbers.

Could anyone please help us by providing the code?

I am sure it is done by somebody somewhere.

As this is very urgent for me and I do not have that much time with me to play around with this, I request any of the users to share their info.

Thank you all for your help,

dhv919401

 

[barbola]

Could you maybe turn the SQL tracing on in your dex.ini file to track what is happening? Or is that what isn't working.

 

[dhv919401]

I am trying to create a report using Crystal which gives me the Qty on hand and FIFO values at a certain point of time. In other words I need to replicate Historical Stock Status report.
Can anyone please post the code which gets these two values?

I really appreciate your help,

Thank you,

 

[UserofGP]

I am looking for that code too. If anyone has it, please post here.

 

[dhv919401]

Help please... I am sure somebody already banged their head against this already.

Any help is appreciated.