51 Reply by erwindebruin

(44 replies, posted in Announcements)

elax wrote:
AlastairR wrote:

I've added a project for the module and theme at code.google.com. It's called fa-dashboard-module. I regret it uses SVN for source control as that is what I know best.
A couple of issues identified by Elax have been fixed.
I've added Janusz as a joint project owner. If anyone else would like to be able to commit code changes, let me know and I'll add you.

Hi Alastair

Could you provide a link ? I search for it but couldn't find it.

/Elax

https://code.google.com/p/fa-dashboard-module/

Go to forum: Announcements

52 Reply by erwindebruin

(7 replies, posted in Setup)

you can copy the default theme, located in the themes folder. Copy the folder and rename it to something like "training". In the  copied folder changes in the css file the color you like. Upload the "training" folder to the themes folder.

Now for users in the training company, set as theme "training". In other companies the default view is displayed with a normal background. In the training company the training theme is displayed with your adjusted background.

Go to forum: Setup

53 Reply by erwindebruin

(7 replies, posted in Installation)

MyotOwner wrote:

is there a for "idiots" directions on how to do this...

A complete reinstallation

Go to forum: Installation

54 Reply by erwindebruin

(7 replies, posted in Installation)

Try using phpmyadmin run the following query, password will be set to default (admin /   password).

If your administration hasn't the prefix 0_, please change it first in the query.

If this doesn't works, maybe you have experienced a installation/rights problem.


DROP TABLE IF EXISTS `0_users`;
CREATE TABLE IF NOT EXISTS `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 '',
  `inactive` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM  AUTO_INCREMENT=2 ;

--
-- Dumping data for table `0_users`
--

INSERT INTO `0_users` VALUES(1, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', 2, '', 'adm@adm.com', 'en_US', 0, 0, 0, 0, 'default', 'Letter', 2, 2, 4, 1, 1, 0, 0, '2008-04-04 12:34:29', 10, 1, 1, '1', 1, 0, 'orders', 0);

Go to forum: Installation

55 Reply by erwindebruin

(7 replies, posted in Installation)

try the default login:    user:   admin     / password:   password

Go to forum: Installation

56 Reply by erwindebruin

(6 replies, posted in Accounts Receivable)

Maybe you can use the "statements report" for this or change this report a bit..... see /reporting/reports_main.php?Class=0&REP_ID=108

Go to forum: Accounts Receivable

57 Reply by erwindebruin

(7 replies, posted in Accounts Receivable)

joe wrote:

Yes another minor bug here. It was the wrong column that was replaces. It should have been the Cust Order Ref that should have been replaced instead of the Branch.
The Cust Order Ref should be Description when showing delivery and invoice templates. So the content is ok.

Download search_orders_view.php1 and rename it to search_orders_view.php. Then replace it in /sales/inquiry folder.

/Joe

Thnx Joe, this works!

Go to forum: Accounts Receivable

58 Reply by erwindebruin

(7 replies, posted in Accounts Receivable)

Thnx Joe, that works perfectly ou!

But now I see another possible error:


In the view [sales/inquiry/sales_orders_view.php?InvoiceTemplates=Yes] all orders with the "template" function marked, are displayed. In the "Cust Order Ref" column the "Comments text" is displayed. I think the "Cust Order Ref" must be displayed here like in [sales/inquiry/sales_orders_view.php].

Seems to be when using the invoice template function (also when using the delivery template function) the COMMENTS field is displayed in the CUST ORDER REF field instead of the CUST ORDER REF.

Please can you check this?

Thnx,
Erwin

Go to forum: Accounts Receivable

59 Topic by erwindebruin

(0 replies, posted in Accounts Receivable)

Possible code change wish:   is it possible to set/select a sales area as default?

Go to forum: Accounts Receivable

60 Topic by erwindebruin

(7 replies, posted in Accounts Receivable)

When using the template invoice function, the text entered in the template order's comment field is not entered automatically in the comment field of the invoice. In a previous version of FA (now using 2.3.15) it did work ( i think something near version 2.3.10 ??)

Please can this be setup again?

Go to forum: Accounts Receivable

61 Reply by erwindebruin

(2 replies, posted in Banking and General Ledger)

attaching documents can be done by the setup-attach documents screen (also after creating the journal entry). select "journal entry" from the dropdown list, enter the JE transaction reference, document description and select the attachment you would like to attach.

if the setup-attach documents screen is not accessible, please check if the current user is authorized for this operation in the setp-access setup screen.

Go to forum: Banking and General Ledger

62 Reply by erwindebruin

(2 replies, posted in Setup)

Maybe cardbooks is suitable for you? See: http://www.cartbooks.com/frontaccounting-point-of-sale/     for a pos/terminal demo site.

Go to forum: Setup

63 Reply by erwindebruin

(4 replies, posted in Setup)

Looking in the translation file for the word INVOICE returns it it used twice in the reporting/rep107.php file (line 67 & 84). You can change the word INVOICE into TAX INVOICE in this file.

Or you can choose the less hard coded way to change is, in the translation file using poedit. Search for INVOICE and change it into TAX INVOICE.

Go to forum: Setup

64 Reply by erwindebruin

(2 replies, posted in Setup)

During the install you can choose between a chart of accounts (english, default) of chart of accounts with demo data. I think you have selected the one with demo data. If you reïnstall the COA again, without demo data your question is solved.

Go to forum: Setup

65 Topic by erwindebruin

(1 replies, posted in Reporting)

Hi,

How does the price in words function works? I see this function is used in several reports but onlye can display the price in words in English. I don't see where I can translate the words used.

I see this function goes back to ui_view.inc but don't understand where it get its words from. Can anybody explain this please?  thnx.

Go to forum: Reporting

66 Reply by erwindebruin

(30 replies, posted in Wish List)

This is pefect Joe, thnx

Go to forum: Wish List

67 Reply by erwindebruin

(30 replies, posted in Wish List)

Thanks Joe, sound good.

How can I download the adjusted files like this manually from the repo? I tried to download the adjusted PHP files from https://frontaccounting.hg.sourceforge. … ccounting/ but I didn't succees.

Go to forum: Wish List

68 Reply by erwindebruin

(30 replies, posted in Wish List)

Hi,

i have two questions related to the supplier detail listing report:

1) The report shows also suppliers which are marked as "inactive". I think the report should ignore the "inactive suppliers" and so doesn't list it...

2) Is it possible to include the "remark" field in the supplier detail listing report? So it would be possible to identify the source of services provided by the suppliers in the report, like: housecleaning, plumber, etc

Go to forum: Wish List

69 Reply by erwindebruin

(17 replies, posted in Misc. Charts of Accounts)

thnx janusz for checking the COA file and uploading in the repository.

@rein: COA is updated, income accounts must be working now.
@chrison: Also the Dutch can make income now smile

Go to forum: Misc. Charts of Accounts

70 Reply by erwindebruin

(17 replies, posted in Misc. Charts of Accounts)

janusz has identified 2 errors in my updated COA:
- duplicate account code 7000
- leading zeros in account groups are stripped.

I have updated the COA: removed duplicated number and renumbered account groep 01-0X to 11-1X, 11-1X to 21-2X and so on. I have send the updated file to Janusz for review.

Seems to be COA will be working hereinafter...

Go to forum: Misc. Charts of Accounts

71 Reply by erwindebruin

(17 replies, posted in Misc. Charts of Accounts)

Hi Janusz,
I have made an export from the clean installed database with dutch coa installed, and by vlookup checked this export with my original file. I have identified 2 problems:

1. in total 27 accountnumbers are missing in the Dutch COA (starting from nr 7010 to 9699). PLease check my original file and the difference with the COA file.
2. a lot of account number are correctly available in the COA but does not appear in the listings. It seems to be this happend to all the accountnumbers which are assigned to an account group starting with a 0-ID, like:  01 or 02 or 04. By exemple account group 04 (Voorraden, = dutch for inventory) seems to be correctly available in the account groups and if you check the backup file there are account numbers which reference to this account group, by example 3000 or 3100.

In my orgiginal FA setup where i designed the Dutch COA, everything seems to be working ok. I just send a copy of this COA to the contribution mailbox. Maybe can you check this issues, it would be very helpful for the Ducth users.

thnx

Go to forum: Misc. Charts of Accounts

72 Reply by erwindebruin

(17 replies, posted in Misc. Charts of Accounts)

Hi Rein,

I have installed a clean FA install with Dutch COA and it seems to be a lot of account groups are not included (turnover (30), tangible fixed assets, etc). This groups and accounts are included in the COA file which I send in to the contributions mailbox. Looks like the conversion from my file to the COA included in repository didn't succeed 100%.

maybe can one of the core developers check this?

rein, i will send the correct coa to you by forum e-mail.

Go to forum: Misc. Charts of Accounts

73 Reply by erwindebruin

(7 replies, posted in Translations)

latest version 2.3.14....

But i see now the original text for this item is not in the default PO file and therefore it's unable to translate it

Go to forum: Translations

74 Reply by erwindebruin

(7 replies, posted in Translations)

Another line, unable to translate.....

when changing a bank deposit entry after submitting appears:


Deposit XXX has been modified

Go to forum: Translations

75 Topic by erwindebruin

(1 replies, posted in Accounts Receivable)

I have searched the forum, but can't find an answer....

I like to use recurring invoicing on an advanced basis, example:

- Start 1 February 2013
- Invoice recurring every 1st of the month
- Invoicing period is related to the current month

So: invoice created on the 1st of February is related to the period February 2013. I have tried a lot, but only gets as a result an invoice for the period 1 january 2013 - 31 january 2013 (1 month before). How to invoice 1 month after invoicing date?

Go to forum: Accounts Receivable