Sage 100

Does anyone know if it is possible to import to GL_DetailPosting? Sage 100 2013. I need to back-populate a UDF we have added. The table is not listed in the VI lookup, is there some backdoor way to get to it?

Problem is knowing what the sequence number of the line detail is which very difficult. How far back does the history flow? You could try creating a test company, export ALL of the GL detailposting table. insert your UDF information, import everything a VI via GL journal entry, update, then copy the GL_detailposting table back to the production company.

Be careful if you do this because more than likely the account keys will be different in the test company so there might be a mismatch after copying the GL detail file.

Good point. The account keys did me in when merging companies last year. I don't think you will have an issue if you copy the GL to the test company, then reinitialize the detail posting table before importing....... The sequence keys will probably be different, but I don't think that will be an issue.

Yeah, I think I am out of luck, there is too much data to do anything like that @JeffSchwenk I thought of using exchange, editing the csv in the middle, but there are hundreds of thousands of postings in their gl detail and it would be too risky, they would never authorize it. I am afraid they are going to have to live with the data missing and just know they are getting it from this point forward. Good point @BillPfahnl Are the account keys the same when a company has been copied to a test? That would mess it up as well.

How many adjustments are there?

There are 3800 postings that need this data. Too many to do manually, and not important enough to write a special program. They were willing to pay me a couple of hours to do the import, but probably won't pop for a custom program to add the data.