Sage 100

Hi there VI fans; I have a field that contains an Invoice Number that I am trying to import into AP Invoice Header. Unfortunately the string also contains a lot of stuff that is not invoice numbers. For example, here are 3 of the values in that field…

Hi All, I want to setup a calculated field in explore that takes a package quantity UDF and divides the on-hand quantity by that to show the number of cases they have on hand. The hitch is that not all of the items have a pack size and some items have…

Hello, After I run a job it shows that all the inserts and updates were failed. Almost all the error message (which I could see in 'Transaction Errors') say that 'Input string was not in a correct format'. I want to know how can I get to know…

I'm importing invoice records from MS Sql server and one of the fields has line feed characters, but they get stripped out during the import. The sql field contains something like "Line one text" + char(13) + char(10) + "Line two text". In MS Access…