I am trying to create an inventory site for sales reps to be able to login and order what they need. I do not have any spreadsheets yet, this is all new for me. I have added some products but can’t see where to give each product a monetary value? Our situation will be giving each item a $$ but we are not doing POS, we want to tally up every month and then be able to send that total to the client. Any help appreciated, thank you.
You should be able to simply add another column (number column) and format it to resemble currency (.00 decimal place, $ unit). Enter your prices for each item in that column.
You’ll want to create an “order items” table that allows sales reps to pick from a list of these products and add quantities, etc. You can use a form screen for this.
2 Likes
Thank you so much Robert!! I’ll give it a shot.