Sage 100

Sage 100 2017.02 setting up VI import for AP Invoices. Error message references ""Job Cost Integration"" but customer has never had Job Cost module and it is not listed in AP Setup Integrations. Any ideas?

Did you look at the AP_Options file in DFDM?

Make sure none of the fields you are importing are job cost related. Header.Jobno Line.Jobno Line.CostCode LineCostType Line.Retention Line.UnitCost etc.

Also Line.Unit of Measure Line.Quantity Distributed They can look like something you might need, but only apply to JC. Confusing, although they are referenced as JC in the File Layouts.

The field ""integrate to Job Cost"" should have a Y or an N in AP_Options when viewed thru DFDM - could be blank (agreeing with Nicole above)

Set to N. Only fields being imported on the line are AccountKey$ and DistributionAmt. and this is BOI not VI. BOI app: retVal = AP_Invoice_bus.oLines.nWrite(): error message: ""The Job Cost module is not integrated.

From ""Left Field"" - is this Sage100 Advanced and do you have Avalara ??

I was going to ask too - are there any third party products installed?

Vanilla standard edition GL/AP/AR

There was a similar issue importing into PR but the resolution was to remove the JC validation for that field which is not an option for AP at v2017.

SO...started developing the BOI app on a VM that had all the Crystal 2011 versions on it. Lee was also on the same server, probably running a different version of Sage 100. this likely confused the code into returning the wrong path from the registry/DSN. I set up another VM with only the right version on it and the BOI app now runs fine. Be careful using code from Sage that does this - better to get the real paths you need from a .ini file.