Search results for query: *

thread631-1438436 Hello, I would like to make the batch listing report in ACCPAC only 1 line per invoice to make it easier to to vlookups, etc in excel. I have one column that is aribd.textdesc , this will show the first line of the invoice description, but exclude the other lines. Ideally I...

Worked like a charm! I can't begin to thank you lbass. You're a lifesaver. Cheers, Gabe

Hi LBass, Thanks again for all your help with this, greatly appreciated. Okay your above formula works if it's a number, but not if it's an email address, it gives "error" instead of the email address. Also, it seems to give an error if the fax number starts with a 1 (11 digits). Thanks...

Hi lbass, So it may just be where I put this in, but it's not doing the required action. If there's an email address instead of a fax number. It will take out all letters and there will only be @myfax.com in the output. This is the formula currently: whileprintingrecords; If Not...

Hi, Sorry me again. Some of our clients prefer to get sent email instead of a fax. I need the above formula to not do anything to the value if there's an "@" in the string already. So basically if the value is something@email.com it will just leave something@email.com, but if it says...

I noticed my field added up all fax numbers together if I had a batch of invoices, so I've added the following line to briangriffin's formula to take only the data from each page in case someone else needs it. whileprintingrecords; If Not InRepeatedGroupHeader then stringvar x:=""; numbervar...

Thanks to both of you for the very quick response! fisheromacse, that worked great, but briangriffin, this is exactly what I was looking for, just in case there are some characters I was missing from my replace formula. Thank you very much for taking the time to write back. Gabe

Hello, I am trying to take a database of fax numbers and turn it into ##########@myfax.com so I can batch email the invoices to myfax.com to fax out. the issue is some fax numbers are formatted ###-###-#### or (###) ###-####, and some ##########@myfax.com already. So far I've got this...

thank you ettienne, I figured as much. Seems like this feature should have been built into ACCPAC, but hey, what can you do?

Hello, I am importing large receipt batches, but I would like to use the auto apply feature automatically for the whole batch, instead of pressing five buttons over and over. Does anyone have any ideas about the easiest way to do this? I'm guessing it will need to be a macro, but I have no...

Thank you very much for your help they're all in there.

Hello, I need to add 2 line items to our invoice template. 1 First Previous balance. 2 Invoice amount 3 Current Balance. Basically most importantly I need the invoice to show the customer's outstanding balance. I can't seem to find the right database in the invoice template for this figure...