Hi, I did this in an excel spreadsheet years ago. Initially followed the instructions on the ATO website but found they were slightly wrong.
So after a little mucking around and validations against known ABN's I came up with a formula that works. (Which is only slightly different to what the ATO said anyway). Rather than explaining it here I would say just look at the spreadsheet. The top 1/2 shows how to generate an ABN from an ACN and the 2nd 1/2 validates an ABN. The only things that I ask is that you create a CFC that is open source and credits me with doing the initial ground work. Oh and make the CFC available to everyone as I am sure there are ppl out there with the same problems. The other good thing is that it would be easy to implelement into Javascript too. Cheers, Simon Haddon [EMAIL PROTECTED] http://www.sibern.com.au On 09/04/07, Stephen M <[EMAIL PROTECTED]> wrote: > > > So, has anyone got a Cold Fusion ABN validator they can throw me? > > I've found a PHP one, but no luck so far searching for one in CF. > > So far, what I've come up with is > > Len(ABN) eq 11 > > which is a bit like Blackadder and Baldrick's s rewrite of Dr. > Johnson's dictionary, stuck on Aardvark > > > > > -- Cheers Simon Haddon --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
ABN.xls
Description: MS-Excel spreadsheet
