Maybe you can help…
I have a Menu with a POS. The Basics are this..
Receiving “Table”
Receive a product (Randbetween) Item number, Category (enum), Description (text), Pack Size, Cost Per Pack, Total Packs, Total Price, Date and Time.
I want it to auto create the received item for the Menu “Table” like a “to-do”. Then I will insert sale price.
Then from the Menu, I’d like select the product to purchase (Item,Qty) to be added to a cart for “checkout”. From there, I will complete the sale with any discounts and Total Price. I will have a Show_if to say that if “Credit” is selected, show the Account Name list. After the account has been selected, the sale details save too that account name and number.
In the Accounts “Table”.
When the account is selected, I want all related orders listed. With a Total Due and Paid row. I need to be able to insert payment on said account.
Orders “Table”
Just a list of all sales orders done. Essentially a transaction list.
And lastly, Inventory “Table”
Receiving Cost and quantities and Sales qty and price. For all items with current on hands. (I’d like the O/H to be visible in the menu item detail.
That all being said, I am new to all of this and some of it is probably simple stuff I have yet to master. I have watched different videos and read different community pages. I have created a few different apps. One I am currently using, but it’s bare bones right now. I’m having to do everything on the spreadsheet. I didn’t want to lay out what I have already because I could be irrelevant LOL!
Thank you for your Time and help.
B.D.O.T
