Macsys
Member
Every week we run the batch integrities report P007021(Transactions w/o batch header). The report lists a number of batches with 'Header rec is posted/detail rec is not' errors.
It appears that the header record and the majority of the detail records have posted but a number of detail records do not have the status field set to posted.
I have been told that I need to SQL the posted flag in the F0414 back to unposted and then reset the header using batch header revisions before reposting the batch.
The only problem is that the batch number is stored in the F0413 and links to the f0414 by the payment id which is unique to each record. I also assume that I should be updating/removing the f0911 records before running the repost.
Does anyone know of a simpler solution or perhaps a procedure which lists the required actions to correctly fix this problem.
It appears that the header record and the majority of the detail records have posted but a number of detail records do not have the status field set to posted.
I have been told that I need to SQL the posted flag in the F0414 back to unposted and then reset the header using batch header revisions before reposting the batch.
The only problem is that the batch number is stored in the F0413 and links to the f0414 by the payment id which is unique to each record. I also assume that I should be updating/removing the f0911 records before running the repost.
Does anyone know of a simpler solution or perhaps a procedure which lists the required actions to correctly fix this problem.