Dear All,

Due to wrong receipt of Raw material against purchase order, i correct in all tables related to the Purchase receipt. The stock for that material is Ok but when i Printing the GRN the delivered quantity is wrong.

i correct the data in the following tables tdpur45, tdinv700, tiitm001

Please help me to sortout this problem.

thanks

dksharma

You didnt mention the status of the Purchase Order line. How come you missed out tdpur051 table? Was it a partial receipt?

Doing a GTM to rectify mistakes is a risky thing and you could have avoided it by using the re-execute option in Maintain Order Steps {tcmcs0139m000} and rectified the received quantity. There are other ways too.. If this purchase order is invoiced and processed, then the value in the financial tables would be wrong. Supplier Balance would be wrong... not a pretty sight...

sk

Dear SK,

The Purchase order was made for 1000kgs, but delivered value was entered in the system 10000 kgs. The status of that line on PDPO. how we correct the records in system.

Please help

thanks

Dksharma

Ok now the picture is clear. Undo all the manual changes you did in the tables(that you mentioned in your post) and process this PO(with 10000kg). Create a Purchase Return of 9000kg and process that PO too.

This is what you should have done. Since the status is Process Delivered Purchase Order, the re-execute becomes too late.. Therefore this is the best method to update all the tables automatically without doing any GTM..

Any reservation in doing it this way?

sk

But all changes have been made. the problem is only, when we printing the GRN the delivered quantity shows 10000 kgs. While all related transactions give results 1000kg. We are already GTM in all related tables, perhapes we miss any single table which are related to the GRN printing session. Please help what to be done.

Dk

I see that you havent done any modification on tdpur046 & tdpur051..
Apart from that, are you printing the Storage List or Goods Received Notes(Baan terminology is different from local use)?

Do you use Location Control?



sk

No, we are not using LOT CONTROL

Sir,

we are only print the GRN, after that we take the receipt.

dk

Did you correct dqua field in the tdpur41 table?

sk

Thanks a lot, sir.

the problem is solved

Dksharma....closed