Purchase Order Last Status/Next Status Messed Up

[jdemike]

I have a purchase order that has been receipted (twice!!) and the actual PO lines (F4311) are showing the last status as 999 and the next status as blank.

How can I manually set the last status and next status fields to what they should be?

Appreciate any suggestions you may have

 

[Oliver]

Hi,

Have you tried looking at the F43199 - PO Detail Ledger File? The records can be traced for each activity made on that particular transaction. However, in order to have this logged on the F43199 table, you need to have Ledger (Y/N) - alias WRTH in the PO activity rules enabled to "Y" for the specific order type and line type.

Resetting the record back to a certain status involves touching multiple tables e.g. F43121, F4311 and requires a better understanding of the issue as it might have already crossed the A/P process.

Hope this helps.

 

[janicej]

All you have to do is make yourself a version of P4310 where the processing options allow you to update the last status/next status fields. You'll find this option on the Display tab. No need to SQL tables for this.

 

[aidy]

Hi jdemike

You can always try using P43025 (use with caution though!)

Hope this helps
Aidy