Yesterday, we created new item records and did cost price roll up. The data in ticpr300 table was dated yesterday. Then we created sales order with order date equal to yesterday. Error message "Cost Price Structure not present for this date" pops up and the sales line cannot be saved.

The record in ticpr300 table was copied and saved with a date equal to 11/6/2015, last Friday. With this, the sales line can be saved.

Today, we have the same issue. All new items have to be saved with cost price roll up in ticpr300 table dated 11/6/2015 before sales line can be saved.

I have checked company calendar and there are records for this week.

Any other ideas of what to check?

joy, there is a field last calculation date in ticpr007. i'm looking at LN but i believe it's the same as baanIV.

Thanks benito for responding.

ticpr007 does not exist in IVc4.

Idea: Check References to that item in ttaad4229m000 to see there isn't another date reference somewhere. Seems unlikely as ticpr200 "Cost Prices by item" doesn't have a date but ticpr300 does.
Has planned delivery or receipt date been backdated on tdsls040/041?

Are they phantoms and the sales order line is set to "issue components"? If so you need to have a cost present for each of the components, not just the top item.

To GaryEd - Items are purchased Items. Phantom is set to No.

To EdHubbard - I checked references to item and table, ticpr300 is the only table with date field. Also, the planned delivery date & planned receipt date are set to a future date.

Thanks for replying.

What shows in item data for a last cost price transaction date? Does it match what is in ticpr300?

Order Date is equal to 11/10/2015. Cost price roll up is 11/10/2015 and is displayed as such on item master.