Quote Worksheet Custom with Vendor Prices & Price Breaks

Kinetic ERP
, , ,
1

Hi All,

I am after some advice, we are in the process of upgrading from Kinetic 2023.2 to Kinetic 2025.2, reports are now held within the database.

In our 2023.2 version we only used the RDD to output the quote number, we then had a link in the report that went directly to the database using the quote number with a sql query to fetch the details we wanted.

This query included fetching the current Supplier Price & Price Breaks for the supplier of Subcontract Operations & Materials (using the supplier designated on Part Plant of the part)

I am ok with changing the report data definition for the new version to contain all the required fields apart from the ability to get this supplier pricing information - can anyone give me some pointers? I know I can add the Supplier Price Break Table but how to I limit it to just get current/active rather than all?

2

Unfortunately you can’t add server side filters in the rdd. You would have to bring back all the data and then do the filtering in the dataset select statement within the rdl. Depending how much data you have that could be impractical. I usually just create a report form scratch using baqs where you can filter the data properly.

2 Likes
3

Thanks for your reply, I really don’t want to have to create it from scratch with BAQ’s as it’s a really complicated report without even looking at the supplier price breaks, I could create a report directly in SSRS that the user would have to run (I would find this easier to write & maintain) but was hoping to use a modified version of the data definition

1 Like