Alphabetise my invo...
 

  You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] Alphabetise my invoice.

14 Posts
8 Users
0 Reactions
55 Views
Posts: 17106
Full Member
Topic starter
 

The people that send us our invoices say that they can't put them into alphabetical order.

I reckon just they can't be bothered. If I can sound intelligent and tell them how to do it , I reckon they just might.

Alternatively is there a magic gubbins that can put printed invoices in order?

Wading through 6 pages of trying to find a BASS6MK is doing my head in.


 
Posted : 23/05/2018 12:30 pm
Posts: 0
Free Member
 

printed invoices?


 
Posted : 23/05/2018 12:42 pm
Posts: 0
Free Member
 

btw, If it's a pdf, can you not just search the pdf for the code you are looking for?


 
Posted : 23/05/2018 12:44 pm
Posts: 16346
Free Member
 

Shouldn't be too tricky to put it into excel. Very easy if its a pdf, a bit trickier from an image but not that hard these days with ocr


 
Posted : 23/05/2018 12:51 pm
Posts: 22922
Full Member
 

Are you selling sex toys?


 
Posted : 23/05/2018 12:54 pm
Posts: 17106
Full Member
Topic starter
 

OCR?

What's that?


 
Posted : 23/05/2018 12:58 pm
Posts: 25815
Full Member
 

Oversize Chrome Rabbit ?


 
Posted : 23/05/2018 1:38 pm
Posts: 453
Free Member
 

Are you a JC distributor?


 
Posted : 23/05/2018 1:50 pm
Posts: 17106
Full Member
Topic starter
 

JC.? Yes we are.


 
Posted : 23/05/2018 1:51 pm
Posts: 16346
Free Member
 

OCR?

What’s that?

Optical character recognition. Turning a picture of words into actual words (and numbers)


 
Posted : 23/05/2018 1:59 pm
Posts: 17106
Full Member
Topic starter
 

Have downloaded Text Scanner OCR.

Taken picture and it shows all the words. How do I get it in order?


 
Posted : 23/05/2018 2:06 pm
Posts: 16346
Free Member
 

It might just paste into excel as a list of separate items. If not excel has import options to use spaces, carriage returns, etc as delimiters for each item.It depends how the OCR has made the document


 
Posted : 23/05/2018 2:29 pm
Posts: 8613
Full Member
 

Do you actually need it in order once you've converted it to searchable words?


 
Posted : 23/05/2018 2:32 pm
Posts: 17106
Full Member
Topic starter
 

Yep we want to be able to print out the delivery note in order so we can check that all the stock arrives.

Have managed to get it to Dropbox.


 
Posted : 23/05/2018 2:45 pm
Posts: 1294
Free Member
 

Can't they email you a copy?


 
Posted : 23/05/2018 4:13 pm

6 DAYS LEFT
We are currently at 95% of our target!