Hi All,

I am a new to Sage X3 ERP.  I also have extensive experience of SAP (FI/CO, SD, MM, PP, PM, HCM, modules) and have good understanding of how ERP systems work.

As I mentioned earlier I am new to X3 with almost no training and struggle in pulling right information from the system.  I'll keep utilizing this great forum to enhance my understanding of the system and keep posting random questions.  For the time being I need to pull standard costs for the materials that are valid as of now, but can't find a report that pulls/provides this information.  A co-worker pulled it directly from the database but it gives complete history of standard costs (all cost runs since the beginning) with every item repeated multiple times.  Is there a way to pull just the most recent standard cost for each item without repetitions.

Thanks

Tariq