We have a GL dataset that has the following message for 1 detail in the detail listing. "P1 Supporting details Missing". We have ran a data integrity check, which does not help the problem.

What would be the best way to correct this issue? I thought of attempting to un-post the batch of the original entry and re-post to see what this might do.

Thanks, David

For "1 detail" or 1 account?

Hi David,

The problem is that the sum of the posted transaction details for this account in period 1 does not equal the Net Changes in Period 1 amount. I doubt that un-post will address the problem because it will simultaneously change posted transactions and the net changes (if posted transactions are removed) or do nothing (if posted transactions are maintained). You could try it on a copy of the data, but this likely isn't the solution.

This message usually appears on the detail listing report if Import Account Net Changes was performed and the imported amount doesn't match the details. It could also occur due to integrity errors that were re-built - is it clean? If not then a database repair or restore from backup may be necessary.

You will need to somehow determine whether the Net Changes or the Posted Transactions are correct, and which value is incorrect. This could take a bit of work.