Hi All,
I need advice on the following topic, see table descriptions below.
The idea is to be able to select a date (from the mastercalendar) and an article, so that te application shows the corresponding costprice and numbers in stock.
In the COSTPRICE table the date is defined as a range. The STOCK table however contains only the mutation-dates, with the number_in_stock being the actual number.
Because the tables COSTPRICES and STOCKS both contain the column ART_ID, I got a circular reference in my datamodel.
In the end, I would like to be able to do an ABC analysis based on costprice and number_in_stock.
What is best practice in a situation like this?
Thanks in advance!
Marco
-------------------------------------------------------------------------------------------------------------------------------------------------
MasterCalendar:
date
Articles:
art_id
description
CostPrices:
art_id
start_date
end_date
price
Stocks:
art_id
date
number_in_stock
