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

Change Stock


moj6054
 Share

Recommended Posts

I have more product.

I have this tables(categories:For Sub Product Product:Details of Product and link to categories

Order:Order Information OrderItems:Link to product(Duplicated this table and rename ItemPurchased) and a filed cLineTotal=Qty(product)* price

Invoices:Invoices information InvoiceItem:Link to product(duplicated this table and rename ItemSold) and a field clinetotal=Qty*Price

)

and in the order(TO) a field cTotalOrder=Sum(cLineTotal)

and in the Invoice(TO) a field cTotalInvoice=Sum(cLineTotal)

 

in product: a field cStockLevel=Qty+Sum(Qty::ItmePurchased)-Sum(Qty::ItemSold)

 

I need to replace cStockLevel value with Product Qty for next progress.

How I can do this?

 

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use