Help me Day end error

[paopaozero]

We keep recieving the following error message when doing day end processing.

Description: Internal error. Cannot read OESHCD (8281 OEPOSTI1.C). Write down the message, leave ACCPAC for Windows and Windows and return to the system prompt. Reset your computer and try the task again. See Appendix A in the OE User Guide.

Would anyone know what would be causing this error. We are using ACCPAC ERP 5.4 (all Modules) and is in SQL. Thank you.

 

[Jay Converse]

From the other Accpac forum:

You are having missed records. Use the following query to find out the missing records as well to insert into the OESHCD table:

SELECT OESHCH.SHIUNIQ, OESHCH.SHINUMBER
FROM OESHCH
WHERE OESHCH.SHIUNIQ NOT IN (SELECT SHIUNIQ FROM OESHCD)


INSERT INTO OESHCD select ____ AS SHIUNIQ,DETAILNUM,AUDTDATE,AUDTTIME,
AUDTUSER,AUDTORG,SHINUMBER,QTYSHIPPED,PRICEUNIT,UNITCONV,
MOSTREC AS COST,MOSTREC AS ACTUALCOST from OEINVD where SHINUMBER ='____'

 

[paopaozero]

I user query followed below.


SELECT OESHCH.SHIUNIQ, OESHCH.SHINUMBER
FROM OESHCH
WHERE OESHCH.SHIUNIQ NOT IN (SELECT SHIUNIQ FROM OESHCD)


INSERT INTO OESHCD select 256129 AS SHIUNIQ,DETAILNUM,AUDTDATE,AUDTTIME,
AUDTUSER,AUDTORG,SHINUMBER,QTYSHIPPED,PRICEUNIT,UNITCONV,
MOSTREC AS COST,MOSTREC AS ACTUALCOST from OEINVD where SHINUMBER ='SO49/003753'

But qurey result : (0 row(s) affected).Help me please.

 

[Jay Converse]

Run Rvspy during Day-end to find other tables and records.