Sage 100

So, I am editing the AP_InvoiceHistoryDetail for Job Information. I know the dangers... Well some genius has setup validation to return the job number failed because the customer does not match the job. Yes, this is accounts payable and there is no customer number to validate against. I was told when I called into Sage this is only when amending records, so I fleshed out the import, reinitialized the file and brought back all fields with the same result. How do I convince VI they match or edit the validation?

Oh yeah, I tried to temporarily turn off the JC to AR integration as well (to no avail).

Can you import into AP data entry in a test company, update, then copy the AP_InvoiceHistoryDetail to the live company?

Or possibly import to AP data entry as an adjustment, then update to facilitate the change to AP_InvoiceHistoryDetail.

Hack the library?? Maybe @AlnoorCassim has some insight.

@LarryBradford in the File Layouts for that table I see that for JobNo field under Class column is found JOBNO. This is dictionary validation. It's possible removing that will work out for you but be careful with this too and make a backup of the files below: 1. DFDM providex.ddf 2. Change Key No to ByName 3. Type in AP_INVOICE then arrow to the right (Ctrl-F7) until you find AP_InvoiceHistoryDetail 4. Change Key No to Primary Key 5. Note the Key= in the top left. Copy that into clipboard. For me it's 000335 6. DFDM providex.dde 7. In the Key paste in from the clipboard and Enter. This takes me to record 000335 8. Arrow over to the right (Ctrl-F7) until you find JobNo$ - for me it's 000335000005 9. Field 14 shows JOBNO this is the dict validation reference. Blank out field 14 Now try V/I importing.

Did the trick! Thank you so much @AlnoorCassim

@AlnoorCassim - I think I know the answer, but want to throw it out there again. The data dictionary will reset when Sage is reinstalled??? How about during a PU install??

Yes on reinstall I'm pretty sure. PU involving conversion almost always do a dictionary update on tables that have expanded and new tables