Search results
2. Just in case someone get to this question, here goes my solution: I decided to create a table transfer_stocks to register all the transfers between venues. This table is also used to solve any discrepancy when stock is counted (when recipient_id is nil, it means wastage or stock missing in the venue - sender_id ).
Jan 10, 2018 · 1. It is likely a bad idea to use two separate tables. You will have to perform a join which is unnecessary. Simply have one table with an 'ordered' column and a 'used' column. In your query you can very efficiently calculate the net value e.g. : SELECT ordered, used, (ordered - used) as net FROM inventory. answered Jan 10, 2018 at 19:56.
Closed 6 years ago. I'm upgrading an inventory system for a jewllery store that was originally built with MS Access. The application stores items, customers, vendors, and displays data about items stored. Reporting tool should be considered to generate reports for items in a printable format. The system should be built in C#, but I've not made ...
Apr 5, 2017 · I suppose you have a single database which serves all warehouses. Create another table. warehouses. warehouseid (PK) name. other details. And then add the field - warehouseid to table stock_balance as a FK (Foreign Key) - this way you will bind each stock of an item to a warehouse.
Sep 21, 2013 · You will probably have to implement different logic in your front end program for each company. Better you should develop one schema for the entire database; each table would have a field called 'CompanyID' which naturally would define to which company each row belongs. This field would be a foreign key to the Companies table.
Aug 2, 2011 · Essentially, I want to be able to create sales invoices and record payments received. The reports, I generate are. statement with balance outstanding. invoice. receipt. To create a statement, I was thinking of doing a union of receipts and invoices ordered by date. I also need to cater for refunds/credits, which i am doing by refund = receipts ...
Jun 27, 2013 · I need help with designing database for following data. Time1 : x,y,z. Time2 : x,x,y,z. Time3 : x,y,W. I need to store the above in database. How should I design my table. the list of inventory (x,y,z..) can be in hundreds. mostly I will be using this to get quick history change between 2 time stamps. and inserting new inventory into table ...
