MunirObeidat
New Member
- Joined
- Mar 28, 2019
- Messages
- 1
Hello everyone,
I'm creating an accounting system that includes invoice recording and an inventory system. And I need help finding an automatic way to calculate the inventory stock.
Example:
Page 1: Contains Invoices
Product X | 35$ | 5
Name.....Cash Paid....Quantity Purcahsed.
Page 2: Contains Inventory and Product Details
Product X | 500 | 15$
Name...Quantity in Storage Unit...Price Per Piece
What I want to happen is that everytime I enter an order for Product X, the quantity purchased gets automatically subtracted from the quantity in stoarge unit. Keep in mind that they are both on different sheets.
Thank you.
I'm creating an accounting system that includes invoice recording and an inventory system. And I need help finding an automatic way to calculate the inventory stock.
Example:
Page 1: Contains Invoices
Product X | 35$ | 5
Name.....Cash Paid....Quantity Purcahsed.
Page 2: Contains Inventory and Product Details
Product X | 500 | 15$
Name...Quantity in Storage Unit...Price Per Piece
What I want to happen is that everytime I enter an order for Product X, the quantity purchased gets automatically subtracted from the quantity in stoarge unit. Keep in mind that they are both on different sheets.
Thank you.
