Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gabe17
  • Content: Threads
  • Order by date
  1. gabe17

    ARIBD.TEXTDESC - List all lines of invoice description in 1 excel cell

    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...
  2. gabe17

    Take out all non numeric characters out of a text string.

    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...
  3. gabe17

    Auto Apply receipt batch list automatically

    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...
  4. gabe17

    Need to add outstanding balance to invoice template

    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...

Part and Inventory Search

Back
Top