On Time In Full BAQ

Kinetic ERP
1

Hi, I really need some help if possible.

I’m trying to do a BAQ to see when the deliveries are being booked in.

I’ve got a feeling its the below function, but not 100%

CASEWHEN(OrderDtl_OrderQty=QTYSHIP)AND(DATEDIFF(DAY,OrderHed_OrderDate,ShipHead_ShipDate)<=0)THEN’ONTIMEINFULL ELSE’NOT ON TIME IN FULL’

Any help would be appreciated…

many thanks

Yasmine

2

You have the ELSE inside the quote.

1 Like
3

I would do your logic on the order release ship by date, not the header.

1 Like
4

Also you should only be analyzing releases with a ship by date in the past.

5

Thanks you for for the help. but now released that the report is needed for the shipments coming in. not going out as I thought.

not sure how i can create a report for that… if anyone had any ideas?

would appreciate it.

start with PO, due and promise date and look at the arrival date i suppose.

6

Yeah it’s the same concept but looking at PO releases and receipts instead of order releases and shipments.

1 Like