Can you store daily purchase prices in Business Central Navision ?
Can you create items with weekly or monthly prices based on the averages week/month of these daily price items?
Can you create items with a purchase price at a supplier where the purchase price is based on the purchase price of another item and add a calculation formula?
item “Daily” - price - price valid from day(date) to day(date) at supplier X
Weekly-Monthly average price:
item “Weekly” - price = average price “Daily” (eg average of recorded prices in week 2021W37) at supplier X
Calculated purchase price:
item “Product1” - price at supplier Y = price “Weekly” from supplier X + transport cost from supplier Z + fee from supplier AA
For more information, please do not hesitate to contact me.