Sage 100

 View Only
  • 1.  Client working on ACA. If you try to put in the P

    Posted 02-07-2017 09:42
    Client working on ACA. If you try to put in the Plan Start Month you get ""Column not in IOList"". If I try to import it I get the same thing. On my machine I could enter the field on ABC files, but can't after copying over HIS files. File looks the same in DFDM. Help!


  • 2.  RE: Client working on ACA. If you try to put in the P

    Posted 02-07-2017 10:31
    If the rebuild customized options don't work, I've used this to fix a similar error. Sorry if this posts weird, doing this mobile. Select File, Run. enter SYZCON as the program name, and click OK. At the prompt, type the following, and press Enter:O = NEW(""SY_ACTIVATION_BUS"",%SYS_SS) At next prompt type the following and press Enter:PRINT O'ACTIVATE(""I/M"",""xxx"") (where xxx = company code) The number 1 is returned if the last command was successful. Type BYE and press ENTER.


  • 3.  RE: Client working on ACA. If you try to put in the P

    Posted 02-07-2017 11:37
    @KateKrueger - Well, I got a ""1"", but it didn't help. :-(


  • 4.  RE: Client working on ACA. If you try to put in the P

    Posted 02-07-2017 12:29
    Can you reinstall the last Product Update? Sounds like the the definition is askew.


  • 5.  RE: Client working on ACA. If you try to put in the P

    Posted 02-07-2017 13:38
    OK, so since i had to get this done while people were on the system... I went through DFDM of the PR_ACAEmployee file and created a 2016 record for each employee who had a 2015 record. THEN, if you brought up their 2016 record in the screen, you did not get the ""Column not in IOList"" error. So, if someone else gets this error and has too many employees to DFDM (I only had about 150), I can't tell you how to fix it. :-(


  • 6.  RE: Client working on ACA. If you try to put in the P

    Posted 02-07-2017 19:00
    Unrelated to ACA, or Payroll, I had the same error recently. In my case it was a UDF. I went to User Defined Fields and Table Maintenance and did an Update on the table containing the UDF. It fixed my errors. Worth a try.


  • 7.  RE: Client working on ACA. If you try to put in the P

    Posted 02-08-2017 05:51
    I thought of that and checked Custom Office, but Employee Maintenance was still the only file you can UDF in Payroll. Although I SUPPOSE it might actually be the Employee file rather than the ACA file....