Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Qty In Hand


moj6054
 Share

Recommended Posts

Hi,

I want to know qty in hand after sold qty according with my database.

I have this tables:

Board:Board_ID,Board_Name,FirstQty,Price,cStockLevel

Invoice:INV_ID,INV_Date,cTotalInvoice

InvoiceLineItem:INL_ID,INV_ID,Board_Name,Qty,Price,cLineTotal

 

 

cLineTotal=sum(FirstQty*Price) cTotalInvoice=sum(InvoiceLineItem::cLineTotal) cStockLevel=FirstQty-Sum(InvoiceLineItem::Qty)

 

 

 

I need to know after sold, qty in hand =?

 

thank you.

Link to comment
Share on other sites

Please do not duplicate post. You only need to post once since those that take the time to respond are able to see your post regardless of category you post it in and do not want to give a second answer if an adequate answer has already been given.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share



×
×
  • Create New...

Important Information

Terms of Use