Search results for query: *

Thanks for the response. SQLServer - yes. All tables you mentioned - yes. I havn't used these tables in the report I am struggling with - this really only involves the supply and demand references and the table that links these references together. All the tables you list do obviously...

I am tying to write a report that connects overdue purchase orders (PO) to any sales orders (SO) that they relate to. The MRP system creates 2 tables of supply and demand references (PSAD.ID's and ID Links) that can link through up to five levels of components in the manufacturing process. My...

Many thanks for the reply. I'm using CR11. SQL query is: SELECT "SO_Header"."SO_No", "SO_Items"."SO_Line_No", "SO_Items"."Part_No", "SO_Cancellations"."SO_Line_No", "SO_Cancellations"."Part_No" FROM ("Javelin"."sales"."SO_Header" "SO_Header" INNER JOIN "Javelin"."sales"."SO_Items"...

Line items from sales orders that get deleted disappear from the sales_order.items database and get placed in a sales_order.cancelled_items database. If its a missing line in items it will be in cancelled. The two db's are tied together by the sales_order.header db. I need a report that can...

Many thanks lbass. It looks like I havn't been using running totals to their full potential. I need to read up to understand more about them. The key learn being that running totals don't include the non-displayed records like summations do. AB

I have a report that checks the costing run of manufactured parts. Each part is manufactured against a works order number. The costing runs are done on an arbitrary time basis by part, there is no common correlation between time of costing between parts nor works orders. I wish to pick the last...