andatabase
New member
- Local time
- Today, 08:27
- Joined
- Jul 23, 2015
- Messages
- 14
Hi All,
I need some assistance building a stock database.
Premise: To monitor movements in stock on a period by period basis. The movements are then used to create journals to ‘revalue the stock’ in our accounting system.
• Users use the previous valuations to review and update the stock
• Once reviewed, they are submitted to management for approval
• Once approved, the accountants will process the journals.
Problem areas
Monitoring previous and current data side by side ( Site A, Stock B, Date, Unit Price, Total Value)
Unit Prices (if I update the prices in a table, all records will be retrospectively updated). I would like for prices to remain fixed for previous periods.
Thanks
I need some assistance building a stock database.
Premise: To monitor movements in stock on a period by period basis. The movements are then used to create journals to ‘revalue the stock’ in our accounting system.
• Users use the previous valuations to review and update the stock
• Once reviewed, they are submitted to management for approval
• Once approved, the accountants will process the journals.
Problem areas
Monitoring previous and current data side by side ( Site A, Stock B, Date, Unit Price, Total Value)
Unit Prices (if I update the prices in a table, all records will be retrospectively updated). I would like for prices to remain fixed for previous periods.
Thanks