POS System ( Sales,Income,Expenses,Stock,Supply)
Hello,
I have been working on a POS System all created in Ninox,
What I'm trying is that when the sale of 1 product happens (Sales Table) the product is deducted from the Stock table and money added to the Income table.
When I buy from the Supplier the number of products is added to the Stock Table and the money is discounted in the Expense table
Would appreciate the help a lot!
30 replies
-
Looking at your DB, it seems like you have done a good job with the stock part. Your 'Inventory Herne', 'Inventory Bergkamen', and 'Inventory Beckum' all do what you want. It shows you the current stock of articles based on each where you bought them from and subtracts the number of articles sold. So I'm not sure what you need done here. In fact you are using the power of the reference fields to gather the data and NOT doing select statements. Good Job!
I'm not sure what you want to do with your Income tables. You have a date field and a yearmonth field. Can you expand on what you are thinking here?
-
Hey Bruno,
Could you finalise your POS Project successfully?
Michael
Content aside
- 5 mths agoLast active
- 30Replies
- 710Views
-
7
Following