Im on IVc2, NT, SQL 7

I'm having a lot of problems running Process delivered purchase order. I ran with Process

Order DAta = Yes, Delete Order Data = Yes, Delete Up to 12-31-00. It ran fine on some orders

but very slow on some - sometimes taking up to half an hour for one order. ive already

changed the table def of tdpur046, tdpur046.cmba to No check on delete and update mode,

re-org table tdpur041 and tdpur045.

I am very much inclined to just run this session now with Process Order data=No but I'm

worried that I will have problems with archiving later on, especially on finance.

Anybody has experience on this? Comments?thanks a lot.

Hi Benito,

what is the setting in the PUR Order Parameter? Delete 'By Order' or 'By Order Line'? How often do you run this session without deleting? Is it part of your daily jobs? How many records are in the tables tdpur045 and 041?
What about running the session in two steps? First: Process order data. Second: delete processed orders.

Regards,

Martin

Hi Martin,
Thanks for your reply. I found out that we have lots of bad data last year. Some have the status Print Purchase Invoice instead of Deleting Line. In fact the program skipped the bad data.
After confirming with my finance and purchasing guys that I can delete the bad data, I made changes to the records so Baan thinks that the record has been processed properly:

tdpur045.date = 729724
tdpur045.stsd = tcstsd.all.approved
tdpur045.stsc = tcstsc.updated
tdpur045.spur = 9
tdpur045.pmsk = "eeennnneennnnnnnnnnn"
tdpur045.invn = 911
tdpur045.invd = 729724
tdpur045.bqua = 0

I only made the changes on tdpur045.srnb <> 0

Thanks
benito