We are using ACCPAC ERP 5.4 in all modules in SQL. The day end didn't process correctly and we now have OE documents that have not transfered through to IC and AR. We are trying to see if there is a way to have the day end process these documants and transfer them accordingly. Has anyone had success in doing this and if so how did you accomplish this? We also have problems on the PO side as well and need to do these documents as well.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Day End processing problem
- Thread starter dbant101
- Start date
The OE day end errors most probably relate to missing records in some of the tables, you can rebuild the data from the OE tables for the missing records and OE will continue with the day end processing. The tables to fix depends on the error.
PO is a different stories, I have no success rebuilding PO data, all I do is remove the reference for the offending records from the day end tables.
It may be best to send your data in for repair.
PO is a different stories, I have no success rebuilding PO data, all I do is remove the reference for the offending records from the day end tables.
It may be best to send your data in for repair.
- Thread starter
- #3
We are getting ready to send the data for repair but we were hoping that we could transfer these through correctly.
The missing OE documents are in their order, shipment, and invoice tables. They have the complete/Dayend number as 5 but are not in the posting journal. I have also created a crystal report that compares the invoice to the AR invoice batches and found the ones that havenot transfered to AR. I have not done the IC report but will later on today. Ihave tested changing the complete number in the table but can not get day end to transfer the document through. Still trying different scenarios. My suoervisor was hoping that by putting it here ettienne might have some insight on how to do this.
The missing OE documents are in their order, shipment, and invoice tables. They have the complete/Dayend number as 5 but are not in the posting journal. I have also created a crystal report that compares the invoice to the AR invoice batches and found the ones that havenot transfered to AR. I have not done the IC report but will later on today. Ihave tested changing the complete number in the table but can not get day end to transfer the document through. Still trying different scenarios. My suoervisor was hoping that by putting it here ettienne might have some insight on how to do this.
- Thread starter
- #5
I have done a query to find the missing records and have used the data to reconstruct the data tables. I have added the records in the posting journal header and detail tables. When I print the posting journal only some of the shipments and invoices are printed. I have checked the database tables and all records are there just won't print some of the records. Anyone have any ideas why all records wouldn't print.
- Thread starter
- #8
The records are not in the posting journals tables because they were not processed by IC day end processing - because records are missing from OE and PO tables. You need to recreate the missing records in the correct tables, you cannot just populate the posting journal tables and think that will fix the problem.
- Thread starter
- #10
We have stopped trying to populate the posting journals and have moved to the ic area. Would it be correct to import the missing records in location details and in the item valuation tables. It appears the location details and trans history are correct but when we run the item valuation report it does not have the correct average costs. Is this something that can be corrected by adding corerect amounts either through an import or by database changes. I also thought I should mention we are doing all of this on a temp company as the live version will be sent out for data repair in the near future.
- Status