Accpac Day end error

[paopaozero]

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

Description: Shipment Cost-To-Clear Detail. Record already exists.Internal error. Cannot insert OESHCD (4064 OEPOSTS1.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]

Hi tuba2007
We had use you'r query to find out the missing records already,but don't have record.How to next step?

 

[Jay Converse]

Run RVSPY, I think you'll find more missing records.

 

[ettienne]

There are 4 shipment tables OESHCH, OESHCD, OESHIH & OESHID that can have missing records. You need to check for missing records in each table. Run RVSpy to figure out what is missing from which table.