Sage 100

version 4.4.5 Advanced - Trying to import primary vendor to ci_item. Source (text) file missing a leading 0 so: assign 40 to primary vendor division, assign 0 to temp01 field, replace temp02 with vendor number field (max 6 chars) and calculate temp01+temp02 for primary vendor number. primary vendor fails although it exists in ap_vendor.

Are you clicking test -- or is this a live import? I've had several instances where the ""test"" reports errors but works in live import.

Why does the vendor number have the item tacked onto the end of it?

Not sure Wayne but I believe I just figured this out... need to import to the im_itemvendor file first.... doesn't just file verify the im_vendor ... also im_itemvendor. Thanks for the prompt reply!

btw... I tried test and liuve imports with the exact same result... I thought the same... somewtimes test gives a different result than a live import.

I was just about to say that. Ok - not really. Too bad the error codes aren't a little more descriptive.

Sorry just back from watching the fireworks on the National Mall. Need to get this active on my cell phone so I can be more attentive to my reseller brethren.....

For sure Jeff... I am a little disappointed in you... Enough screwing around..... You need to be engaging in tech support more frequently.

I think the item number was displaying in the vendor number field because of the Temp02 length exceeded the vendor # field length.

This still isn't working... I have created a substring of 1,6 in temp02 and still no go. @MarkKotyla Is there a way to create a field Mask of ""0000000"" on the vendor number? For example if my source field is 1002000 then leave as is, however, if the source field is 101250 then format it to 0101250?

Syntax of the PAD function?

Try PAD(Temp02$,7,L,0). Also, set the length of temp02 to 7.

Sorry I'm late to the party too. Try PAD(temp02$,7,0,""0"") if Mark's doesn't do it

Thanks guys. I already tried your formula earlier David and was getting an error 41. I know an error 41 is a data type error but double checked and I believe my data types were OK. Will try Mark's in a bit. Considering asking the client to modify the vendor field format in the data file.

Don't do it. It's possible, as I just did this earlier this week for a client, but their PC is off for the weekend, so I can't remote in and verify. Worst case, I can get the info Monday.

Never mind..... I just got a revised data extract from the client with 7 character vendor numbers... much easier... and it works! Thanks for all of the help!