Hi all,

THIS IS PERTAINING TO BAAN IV.

I am required to write a report to fetch details of open orders (Pending purchase orders). for which I have written following condition:

and ((tdpur041.dqua = 0 and tdpur041.bqua = 0) or (tdpur041.bqua > 0))

Still some of the orders lines which are not present in tdinv150 (planned inventory transactions) are also coming.

Can anybody guide me what is the logic of open orders ?

Also, In purchase order session tdpur4101m000, Baan IV displays order status, which is not a table field. Can we determine the order status by calling some standard dll or is there any way to determine purchase order status ?

Please guide.

My best suggestion is to take the orders that you do not expect on the report and look at the tdpur041 record and receipts. See if the receipt is hung or inspection is hung. I have seen the tables get out of sync and I seem to recall something about receipts that are in process causing an issue.