I need help creating a db and was wondering if anybody was willing to lend a hand. The template for Asset list seems to be a good start. I need to obviously enter in a consignee and what they are consigning. Also Item description an ID number for the Consignee and the item. Also price of the item and date item consigned. I will also need to know how to input daily items sold plus run reports by consignee for items sold. I know I am asking alot and would understand if this is to tall of an order for somedoy to help. Maybe somebody could point me at least in the right direction for free tutorials?? Thanks for any help.
Help creating db for consignment shop
- Thread starter kcranmer
- Start date
georgedwilkinson
AWF VIP
- Local time
- Today, 02:02
- Joined
- Mar 4, 2008
- Messages
- 3,856
There are a ton of free tutorials on the Microsoft Office site. You might want to consider starting out with a template (like the Northwind example, for instance) and modify it to handle consignees.
Once you get to a point where you need to ask a technical question about it, let us know.
Good luck!
Once you get to a point where you need to ask a technical question about it, let us know.
Good luck!
This is what you would consider "goods in free circulation". Too things can happen, the goods are sold or returned.
The consigned goods should be separate to sales as the title of the goods has not as yet been transferred to to the consignee as the consignee has not purchased the the goods.
I would create a Consignment system that records the goods being spent with a location field on the the "asset", a location table with the Client code on the location.
Depending on the arrangements with the consignee and whether or not you are purely wholesale (does your company also sells direct to retail customers?) the prices maybe Retail or purely wholesale. The price on the consignment note should reflect the price the consignee has agreed to pay for the assets / goods.
The consignee is effectively operation a sale and purchase and once this is done an invoice can be raised and the assets / goods affected should now be notes as sold.
Whatever residue assets / goods on consignee unsold should be still under the consignee. The last consideration is who is insuring the assets on consignment. It needs to clear who takes on the responsibility.
Simon
This way you can easilier I dentify where your assets are at
The consigned goods should be separate to sales as the title of the goods has not as yet been transferred to to the consignee as the consignee has not purchased the the goods.
I would create a Consignment system that records the goods being spent with a location field on the the "asset", a location table with the Client code on the location.
Depending on the arrangements with the consignee and whether or not you are purely wholesale (does your company also sells direct to retail customers?) the prices maybe Retail or purely wholesale. The price on the consignment note should reflect the price the consignee has agreed to pay for the assets / goods.
The consignee is effectively operation a sale and purchase and once this is done an invoice can be raised and the assets / goods affected should now be notes as sold.
Whatever residue assets / goods on consignee unsold should be still under the consignee. The last consideration is who is insuring the assets on consignment. It needs to clear who takes on the responsibility.
Simon
This way you can easilier I dentify where your assets are at
statsman
Active member
- Local time
- Today, 03:02
- Joined
- Aug 22, 2004
- Messages
- 2,088
I would begin with two tables.
The first would be for consignees. It would contain the relevant information of the people supplying you with goods, Name address phone etc. I would then create a 3 or 4 digit code assigned by consignee. Example: Joe Smith would be JOSM.
For your inventory table, the inventory number would be connected to the consignee. Joe Smith has assigned 15 items to you in the past. The next inventory number for Joe would be assigned JOSM16.
Using this inventory system, it should be a simple matter to get a specific report on Joe Smith's inventory items (or anyone else's).
The first would be for consignees. It would contain the relevant information of the people supplying you with goods, Name address phone etc. I would then create a 3 or 4 digit code assigned by consignee. Example: Joe Smith would be JOSM.
For your inventory table, the inventory number would be connected to the consignee. Joe Smith has assigned 15 items to you in the past. The next inventory number for Joe would be assigned JOSM16.
Using this inventory system, it should be a simple matter to get a specific report on Joe Smith's inventory items (or anyone else's).
