This is a notification from the Help Desk.

On Mar 07, 2014 @ 03:26 pm, mark@... wrote:
No Comment.


==Ticket History==

On Mar 07, 2014 @ 03:26 pm, venussoftop@... wrote:
Hi all

I know a qty. for a particular item purchased. This item though has been purchased over a long period only the last few purchase bills are now of concern (FIFO method). I have the following tables

tPurchaseBill
iID PK
iNo Bill No.
etc.

sPurchaseBillItems
iID PK
iPID FK to tPurchaseBill table
iItemID FK to mItems table
bQty qty. in this purchase
etc.

so if I am to provide an iItemID and a bStock qty. can I bring out only those last few tPurchaseBill records. Is there any way I can do this in pure SQL?

Please advise

Thanks and regards
Bhavbhuti

------
This is an automated response. Your issue has been noted. We'll be in touch soon.



Please reply to this email or visit the URL below with any additional details.

http://DANTOIN:9675/portal/view-help-request/111




[Non-text portions of this message have been removed]