101 Reply by rodw

(5 replies, posted in Installation)

Paul, Did you just download the Aussie Chart of accounts?

Joe made a change in the last day or so in response to a post I made. I had solved my problems before he did this.

I found that the scripts blew away users and securtiy groups and then re made them so you could no longer login. I deleted those parts of the scrpt that altered these two tables.

I have also done some work on an Aussie Translation but have not posted up the code as I am still checking it is complete.

I would also be keen to help with creating an Aussie direct payment module to pay suppliers.

Search for posts I have made and check the threads. PM me your email address if you like. It woud be good to work with another Aussie with this!

Go to forum: Installation

102 Reply by rodw

(4 replies, posted in Translations)

Thanks Joe, After I went to bed last night, I realised that this PO is against a UK based vendor and in GBP which was probably causing it. It works as I expected with a local vendor in AUD. I think I'll leave it as the default for now.

I have purchased from the US as well in which case the references to VAT etc are meaningless. It might be useful to have a global flag that could be set to enable/disable doctext2 translation. I'd probably prefer to have all documents in my language.

Go to forum: Translations

103 Reply by rodw

(4 replies, posted in Translations)

Joe, I restored the default inc files and then started translating away. Invoices, orders and credit notes all work, but Purchase Orders do not change to the translated strings.

This makes me believe there is a bug somewhere that is casusing the strings for the PO to be drawn from doctext2.inc. This would explain why editing the doctext.inc file had no impact on the PO last night until I copied it to overwrite the doctext2.inc file.

Anyway too late here. Let me know what you find.

Go to forum: Translations

104 Topic by rodw

(0 replies, posted in Modules Add-on's)

Hi Guys,

I thought I'd post up this link which outlines how to create a direct entry file which can be uploaded to automatically pay suppliers

http://www.employeebenefitscard.com.au/ … irect.html

Is there any interest in creating a module that would let us Aussies pay our suppliers directly by creating this file for a batch of remittances?

I am happy to help but I am not a PHP coder...

Go to forum: Modules Add-on's

105 Topic by rodw

(4 replies, posted in Translations)

Hi Guys

Seeing Joe asked nicely on another thread smile, I have had a try at creating a translation file for Australia.

So far, everything seems to be fine except that Purchase Orders have not been translated so the PDF files still show all the default UK VAT stuff instead of or GST.

I see a another report of this issue on this forum. Why is this so?

Something just dawned on me. Last night I did some customising of the reports by playing with doctext.inc and doctext2.inc and I was only testing it against the purchase orders. I initially made my changes  to doctext.inc but nothing changed in the PO until I copied the file to doctext2.inc. I suspect therefore that the PO is drawing its strings from this file not doctext.inc and therefore is not getting caught by the .PO language file.

I am not quite ready to share this yet but for one evening's work it is pretty good for a first cut if this problem can be resolved.

Go to forum: Translations

106 Reply by rodw

(6 replies, posted in FA Modifications)

I'd like to echo my thanks here too. I'm a new user of only 24 hours standing. I could not believe how small the distro was and how nicely everything works. User interface speed is great and the support has been great already.

Nolapro is out the door and it looks like I don't have to spend $800 on SAGE which was something my emerging microbusiness could not afford. Sorry Tom, donations might be a while away but I will try and contribute in other ways smile

Go to forum: FA Modifications

107 Reply by rodw

(9 replies, posted in Setup)

Joe, I will try and do this when I get time. For us Aussies, the main thing is to get the text on the invoices correct as there are legal obligations. There is not much text that needs changing. The screen prompts hardly need altering but would mostly be altering references to VAT to GST becasue the chart of accounts covers off most things via tax codes.

The other thing I found last night (finally !!!!)  is the the Australian banking standards  for direct entries. Files in this format allow you to upload payments to your credirtors via online banking systems.

I used to have this years ago in a banking system help file but once gone, it was almost impossible to rediscover. The file format is pretty trivial; fixed length ASCII format with a header and footer row.

Years ago, I created a report in this format using Crystal Reports which worked very well. I am not a PHP coder but it would be great if somebody with more experience could take this on board and create an Aussie Direct Debit Module for FrontAccounting smile I would be happy to assist in this project. I'll post up some details tonight.

Go to forum: Setup

108 Reply by rodw

(9 replies, posted in Setup)

joe wrote:

Hello Rod,

The doctext2.inc is your document text for export and doctext.inc is for domestic use. In your example maybe the same.
You should consider using the empty.po file and copy it to another place and name it en_AU.po. Then translate it with poEdit. Here you can only translate those texts that are different than the default one, en_GB. The en_US is done the same way.
After done, you should use the Install/Update languages to setup your language file and then select and use it.

And after you have done that, please share it with us.

/Joe

I had a quick look at empty.po and googled poedit. Are you saying that by changing the language file, nothing need to be changed in the .inc files I edited so they should be reset to the default files?

Go to forum: Setup

109 Reply by rodw

(9 replies, posted in Setup)

Joe,

Once I got my head around the scripting, I knocked up revised text for the reports by modifying doctec.inc and doctext2.inc to account for GST and ABN numbers. It seems that doc text2.inc is the one that is used in my default installation.

Would it be worth including these files with your chart of accounts? That basically will completly Australianise this software.

Here they are here http://www.vehiclemods.net.au/docs/doctext.zip

Not sure if anything else need altering. I have not tested every document type yet but looks pretty good to me.

Cheers

Rod

Go to forum: Setup

110 Reply by rodw

(59 replies, posted in Modules Add-on's)

Tom, That is what was in your default file and I have not changed it. Fairly steep learning curve for one day for me. I'll have a good look at once I get my head around FA a bit better.

Go to forum: Modules Add-on's

111 Reply by rodw

(59 replies, posted in Modules Add-on's)

rodw wrote:
tom wrote:

How do you check to see if any customers were created?

Tom

I looked in FA but your script says none are added. I just checked the SQL table for 0_debtors_master too!

What table to you store your next numbers to process in?

I found it. The Id's are both 0.

Go to forum: Modules Add-on's

112 Reply by rodw

(59 replies, posted in Modules Add-on's)

tom wrote:

How do you check to see if any customers were created?

Tom

I looked in FA but your script says none are added. I just checked the SQL table for 0_debtors_master too!

What table to you store your next numbers to process in?

Go to forum: Modules Add-on's

113 Reply by rodw

(9 replies, posted in Setup)

joe wrote:

Fixed. New version uploaded with all 10 new security roles and with sys admin role on admin.
Fixed. Default 'password' on admin.
New version uploaded.

/Joe

Thanks Joe, just wondering if it makes sense to overwrite the security settings at all?

Wouldn't most users install the software which creates the user accounts and then run the SQL scripts? That is the path I took.

Also noticed a few of your suppliers remain in the system as well. I did retain OfficeWorks!

Now I just have to work out how to make the GST calculate by default. It did not seem to be doing that when I raised an invoice. First live transaction was a P/O in GBP which worked ok but did my head in for tonight!

Go to forum: Setup

114 Reply by rodw

(59 replies, posted in Modules Add-on's)

Hi guys,

I had a go at using this today and tried to import the customers and it says customers found, but nothing is imported.

Exact steps i took was to install the Australian Chart of accounts which sets up the tax codes and the I went back into osCommerce and set tax codes and classes to agree with FA. Then I made sure the default tax class was set for the customers.

I have the customer categories add on so I have different prices for retail and wholesalers etc. Would this have an impact?

Rod

Go to forum: Modules Add-on's

115 Topic by rodw

(9 replies, posted in Setup)

Hi guys I am very excited that I found FrontAccounting today. I have it up on my website and the Aussie Chart of accounts (version 2) installed. Just a couple of notes with this install script though.

1. The script drops the 0_USERS table and installs the author's encrypted user accounts so you are locked out of the system.

2. the script also drops the 0_SECURITY_ROLES table and replaces it with some non standard data so you are locked out again.

These blocks need to be deleted from the file:

### Structure of table `0_users` ###

DROP TABLE IF EXISTS `0_users`;

CREATE TABLE `0_users` (
  `id` smallint(6) NOT NULL auto_increment,
  `user_id` varchar(60) NOT NULL default '',
  `password` varchar(100) NOT NULL default '',
  `real_name` varchar(100) NOT NULL default '',
  `role_id` int(11) NOT NULL default '1',
  `phone` varchar(30) NOT NULL default '',
  `email` varchar(100) default NULL,
  `language` varchar(20) default NULL,
  `date_format` tinyint(1) NOT NULL default '0',
  `date_sep` tinyint(1) NOT NULL default '0',
  `tho_sep` tinyint(1) NOT NULL default '0',
  `dec_sep` tinyint(1) NOT NULL default '0',
  `theme` varchar(20) NOT NULL default 'default',
  `page_size` varchar(20) NOT NULL default 'A4',
  `prices_dec` smallint(6) NOT NULL default '2',
  `qty_dec` smallint(6) NOT NULL default '2',
  `rates_dec` smallint(6) NOT NULL default '4',
  `percent_dec` smallint(6) NOT NULL default '1',
  `show_gl` tinyint(1) NOT NULL default '1',
  `show_codes` tinyint(1) NOT NULL default '0',
  `show_hints` tinyint(1) NOT NULL default '0',
  `last_visit_date` datetime default NULL,
  `query_size` tinyint(1) default '10',
  `graphic_links` tinyint(1) default '1',
  `pos` smallint(6) default '1',
  `print_profile` varchar(30) NOT NULL default '1',
  `rep_popup` tinyint(1) default '1',
  `sticky_doc_date` tinyint(1) default '0',
  `startup_tab` varchar(20) NOT NULL default 'orders',
  `inactive` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `user_id_2` (`user_id`),
  UNIQUE KEY `user_id_3` (`user_id`),
  UNIQUE KEY `user_id_4` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;


### Data of table `0_users` ###

INSERT INTO `0_users` VALUES ('1', 'demouser', '5f4dcc3b5aa765d61d8327deb882cf99', 'Demo User', '3', '999-999-999', 'demo@demo.nu', 'en_US', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '3', '1', '1', '0', '0', '2008-02-06 19:02:35', '10', '1', '1', '1', '1', '0', 'orders', '0');
INSERT INTO `0_users` VALUES ('2', 'admin', '55f9af63f11ad798e51a8b2fdad65445', 'Administrator', '3', '', 'me@mycompany.au', 'e_US', '1', '0', '0', '0', 'cool', 'A4', '2', '2', '4', '1', '1', '1', '1', '2009-09-02 17:29:20', '10', '1', '1', '', '1', '0', 'orders', '0');
### Structure of table `0_security_roles` ###

DROP TABLE IF EXISTS `0_security_roles`;

CREATE TABLE `0_security_roles` (
  `id` int(11) NOT NULL auto_increment,
  `role` varchar(30) NOT NULL,
  `description` varchar(50) default NULL,
  `sections` text,
  `areas` text,
  `inactive` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `role` (`role`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;


### Data of table `0_security_roles` ###

INSERT INTO `0_security_roles` VALUES ('1', 'FA 2.1 Inquiries', 'Inquiries', '768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15872;16128', '773;774;2818;2822;3073;3073;3075;3076;3077;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5633;5640;5889;5891;8193;8194;8194;8450;8451;10753;11009;11010;11012;13313;13315;15873;15882;16129;16130;16131;16132', '0');
INSERT INTO `0_security_roles` VALUES ('2', 'FA 2.1 Accountant', 'Accountant', '512;768;2816;3072;3328;5376;5632;5888;7936;8192;8448;10496;10752;11008;13312;15616;15872;16128', '513;519;520;521;522;523;524;525;769;771;772;773;774;2817;2818;2819;2820;2821;2822;2823;3073;3073;3074;3075;3076;3077;3078;3079;3080;3081;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5377;5633;5633;5634;5635;5636;5637;5638;5639;5640;5640;5889;5891;7937;7938;7939;7940;8193;8194;8194;8195;8196;8197;8449;8450;8451;10497;10753;10753;10754;10755;10756;10757;11009;11010;11010;11012;13313;13313;13314;13315;15617;15618;15619;15620;15621;15622;15623;15624;15624;15625;15626;15873;15873;15874;15875;15876;15877;15878;15879;15880;15881;15882;16129;16129;16130;16130;16131;16132', '0');
INSERT INTO `0_security_roles` VALUES ('3', 'FA 2.1 System Administrator', 'System Administrator', '256;512;768;2816;3072;3328;5376;5632;5888;7936;8192;8448;10496;10752;11008;13056;13312;15616;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;769;770;771;772;773;774;2817;2818;2819;2820;2821;2822;2823;3073;3073;3074;3075;3076;3077;3078;3079;3080;3081;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5377;5633;5633;5634;5635;5636;5637;5638;5639;5640;5640;5889;5891;7937;7938;7939;7940;8193;8194;8194;8195;8196;8197;8449;8450;8451;10497;10753;10753;10754;10755;10756;10757;11009;11010;11010;11012;13057;13313;13313;13314;13315;15617;15618;15619;15620;15621;15622;15623;15624;15624;15625;15626;15627;15873;15873;15874;15875;15876;15877;15878;15879;15880;15881;15882;16129;16129;16130;16130;16131;16132', '0');
\

Now all I have to do is sort out Tom's osCommerce import script before I enter some data smile

Cheers guys

Rod

Go to forum: Setup