0

Automatic cutting stock item when creating invoice

Hello. I would like to know if the below scenario is technically doable in Ninox. 

I have a table for 

- Invoices

- Stock

 

Invoices and Stock do both have a subtable for Line Items.

When creating an invoice,  I would like to be able to lookup the stock items, find the product we sell and add it to the invoice (all from within the Invoice form). And when the item is added to the invoice, it should update the remaining stock quantity accordingly and add a reference to the invoice.

Can this be done in Ninox?

 

Thanks everyone.

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Mel Charles
    • Mel_Charles
    • 5 mths ago
    • Official response
    • Reported - view

    Bernd - short answer is absolutely it can!

    and there as been several topics on this on past posts.

    so search on stock or inventory

    this one might get you started

    https://forum.ninox.com/t/83hr63m

    but otherwise I sure we can all help you out

    Like 1
    • Alan Cooke
    • Alan_Cooke
    • 5 mths ago
    • Reported - view

    Way back when I was learning Access in an effort to build a sales/inventory system.....  The first golden rule is NEVER EVER enter a stock value/quantity.  What you have in stock is solely based  on the difference between incoming and outgoing stock.  Stock Balance is in effect Stock in minus Stock out.  In this scenario and very basically defined.  Your would have a table for Orders and another for Sales.  The difference between "Qty Item Sold" and "Qty Item Ordered" would = "Item Stock Balance"

    Like
Like Follow
  • Status Answered
  • 5 mths agoLast active
  • 2Replies
  • 52Views
  • 2 Following