Dayend processing. Internal error. Cannot read OESHCD (7851 OEPOSTI1.C)

[jonsen63]

Hi everyone

I has a problem with the IC Dayend processing error.
Found the error relating to a OE Shipment # SH/2014/050358.
I had done a SQL statement to add the missing fields from OE Invoice to OESHCD.
IC Dayend processing completed with generated AR Invoice entry with the correct sales and cost.
But I found that there was no shipment posting journal in O/E and I/C has no record of the O/E Shipment in Item valuation/Inventory Movement/Stock Transaction reports.

Is there any program update or hot fixes for the missing transactions.

Thanks

Jonsen

 

[Boris10]

Do not use direct SQL to change Accpac tables. Instead use the Accpac views as they help to populate all the fields in all the required tables. These views help to keep your DB insync. So what i would addvise is to restore your DB to the last working state (try it in a test DB). if you performing any custom operations use an Accpac view instead of direct SQL and try run your day process