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!
29 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?
-
Paul Chappell Bruno Skëndaj Hi Bruno. Paul is right. I wouldn't take this as any form of criticism, embrace your newly found knowledge. Much of the pain you are feeling with your development will disappear once you move to a single Transactions table.
All the best John
-
John Halls Bruno Skëndaj We have all done it when creating systems like this. There is a tendency to over-think the problem and to try and ‘build’ a solution rather then using the built-in database functions and reporting options. You’re getting there Bruno!
-
Paul Chappell I really didn't thought about this, I think I got confused from working on it a lot
-
John Halls Paul Chappell Fred I want to thank all of you guys for replying and helping, You definitely helped me and I really appreciate your time and feedback
p.s If I will need help in the future things I know where to find good people to help me
-
Content aside
- 1 yr agoLast active
- 29Replies
- 524Views
-
6
Following