Sage 100

Ok stumped on this, I have an import to AR invoice header using misc codes. My challenge is the invoice number. In the source file I have say T036, I created a temp file and extracted the 36 (know I am going from a string to a number), in temp 2 is the 5 digit number (say 98765) and I need to bring the 2 together for the complete invoice number of 3698765. Everything I have tried wants to just add them together. Is this possible? v5.2std Also it is possible that my temp 1 numbers will change, so I can't assign it.

They have to both be strings. I can't tell from the above if you have your first temp as string or not, but assuming temp1 is string and temp2 is numeric, then calc field would be Temp001$+str(Temp002). If temp1 is also numeric, then str(Temp001)+str(Temp002)

Thanks @BethBowers that got me further than I was. Now I put that in temp 3 and tried to make invoice no be temp 3 and invoice number is all zeros

or let me clarify if I use the same formula that I use in temp 3 for invoice no I get the 0000000 for inv no.

I believe the temp fields have to be before the field you are assigning it to.

Do you actually have the TEMP fields on the list of fields lower than the invoice number? I seem to remember that somewhere along the line, VI seems to have started to ignore the order of fields when it comes to the KEY field. But I might be wrong, so check first that the Temp fields are first.

I was afraid of that. I've run into that - VI ignores the order when it comes to the key field. If you put the invoice number field on the import TWICE (getting desperate)

I'll try changing the order

I was thinking I would have to get to that

Seems like I ran into this on an AP import and had no way around it. I finally had to have the client put a macro in their spreadsheet and create the invoice number we needed.

Yeah. I would swear the older versions of VI did not do this.

doesn't matter order,I get 0000000 as invoice number. If I assign temp 3 or str(temp3) to invoice # I get failed, need valid invoice #

Bummer :( But thanks for being the guinea pig for us all on this one and verifying our fears. I would be willing to be perform logic could fix this... but that is a whole other can of worms!

My pleasure, at least I don't feel like I totally did not know what I was doing. Wish I could get that time back I spent on it though. lol

Hey I'm late to the conversation, but I didn't see any reference to the ""Assign Temp on"" field in the temp variables. Since you are using these temp variables in the key field (invoiceno$) then you have to make sure that you set all 3 of those temp variables to ""Key Assigns Only"" see screen shot

@DavidOverholt that is exactly what I needed. I got it working!! Thanks all for the info and David you get the prize.

I am always puzzled on how to assign a temp on. Is there a primer somewhere that explains this?

There may be one somewhere, but conceptually if you need to use the temp variable as part of the key field the you set it to key assigns only. Key field being defined in the file layouts. if you are importing into a master file type table the default is ""standard record"" and you can leave the temp variable at that setting as long as you are not using it to assign part of the key field. If your importing into a header/detail type of table such as Sales Order data entry tables then you have three option for the temp variable. Key assigns only Header Record Line Record Same concept applies here; set this based on what part of the import you need to use the temp variable on. I hope this is helpful to some.