I am new with jet report, I need to create a movement report base on Entry type .
Report should look like :
Opening Stock Qty Sales Shipment Purchase Receipt Production Adjustment Stock Balance
I have no idea how to get the opening from the filtered date.
Any idea?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello Brian,
I assume you are using NAV since you referenced Entry Type. If so, you might want to try to use the Net Change FlowField from the Item table. This field will allow you to get the quantity on hand at a point in time (unlike the QOH/Inventory field). Try using a function like this:
=NL("First","Item","Net Change","Date Filter","..4/1/15","No.","1000")
Date Filter is a FlowFilter that will allow you to find the QOH as of 4/1/15. I also added a filter for the item no to be 1000.
I hope this helps!
Please sign in to leave a comment.