PODetail.ExtCost missing on old POs

While scrubbing some of our data, I came across an oddity where all PO lines 2016 and prior now have “Zero” for the PODetail ExtCost. And it propigates to the POHeader in the PO screen, which also show zero now. The database has zeros for those fields; this isn’t a customization or reporting glitch. The UnitCost field is still good.

Anyone else seeing this for old POs? Any idea what could have happened?

I’m thinking about getting a datafix, but might just leave it alone due to age…

Line:

Header:

This is for ALL POs prior, ~20,000 of them.

Another example, with old scan archive of the PO form vs now when it generates:
image

image

It isn’t a reporting issue, the cost data is not in the database…!

Have you tried running the “Set PO Total and Tax Defaults” process? I was told to do this as part of our upgrade, though I never actually saw PO totals getting zeroed out as you have.

1 Like