@surreyhills
Thanks for telling us. In certain releases of MySql or MySql setup won't allow the insert of empty value.
Fixed in HG repository. Your fix was used.
No problems in the Direct Sales Invoice.
/Joe
2,326 10/16/2012 03:03:52 pm
Re: DB Error while Placing a Direct Invoice with no customer selected. (7 replies, posted in Report Bugs here)
2,327 10/16/2012 02:49:31 pm
Re: DB Error while Placing a Direct Invoice with no customer selected. (7 replies, posted in Report Bugs here)
The supp_trans table is used by both documents and the payments. It is correct to set the value to 0 here.
Certain setup and versions of MySql accepts this though.
Will be fixed asap.
/Joe
BTW will check the ddebtor_trans also.
2,328 10/16/2012 11:07:04 am
Topic: Private Messages (16 replies, posted in Announcements)
You can now send private messages to a user in the punbb.
You see the link for this up right, New messages.
/Joe
2,329 10/16/2012 10:47:48 am
Topic: Attachments to topics/posts (18 replies, posted in Announcements)
It is now possible to attach files to topics and posts.
Uploading are only allowed by Senior Members, Moderators and Administrators.
Members can only download attachments.
If you want to be a Senior Member and you have about 50 posts, you can ask for an upgrade.
/Joe
2,330 10/16/2012 07:26:05 am
Re: Tax on MRP of a item. (1 replies, posted in Items and Inventory)
You can use the Tax Types/Groups together with the Item Tax Types (where you can exclude some tax types) to setup the correct tax for an item.
You will see the items included in the Manufactured item in the Bill of Material. These included items can be handled by Item Tax Types to get the correct tax.
/Joe
2,331 10/15/2012 07:59:34 pm
Re: how to change the COA for the training co (5 replies, posted in Banking and General Ledger)
You simply do the changes you want, after that you do a company backup. After that you do a rename of the backup to the name you want.
After that you can create new companies with this new COA.
Joe
2,332 10/13/2012 09:28:16 am
Re: Direct Invoice Issue with Branches (1 replies, posted in Accounts Receivable)
Please set the variable $go_debug in config.php file to 1 to trap any errors.
/Joe
2,333 10/12/2012 06:37:58 pm
Re: Norwegian Charts of Accounts (kontoplan) are outdated (by 7 years) (5 replies, posted in Misc. Charts of Accounts)
No problem. If you want me to help you, just send the COA to me. You will find my email by pressing my link to the left of the topic.
Joe
2,334 10/11/2012 01:22:39 pm
Re: Inactive items (5 replies, posted in Accounts Payable)
This has now been fixed. HG repository updated. In the meantime you can change line 401 in /purchasing/includes/ui/po_ui.inc
from:
stock_items_list_cells(null, 'stock_id', null, false, true, true);
to:
stock_items_list_cells(null, 'stock_id', null, false, true, false);Joe
2,335 10/11/2012 09:44:09 am
Re: Inactive items (5 replies, posted in Accounts Payable)
Ok, sorry I misunderstood. Will be fixed asap.
/Joe
2,336 10/11/2012 07:29:32 am
Re: Inactive items (5 replies, posted in Accounts Payable)
I can not reproduce this. Are you sure the supplier is inactive?
/Joe
2,337 10/10/2012 04:58:04 pm
Re: NEW Themes for Front accounting (9 replies, posted in Modules Add-on's)
The theme is fine, allthough I see no links back to FA. Please, while we have done the major work, it would be nice to do that.
Otherwise, nice work.
Joe
2,338 10/10/2012 04:42:22 pm
Re: New Functionalities suggestions (24 replies, posted in FA Modifications)
Hello guys,
The Gl Items in supplier invoice is an extreme fine possibility to enter supplier invoice for phone bills, maintenance, various cost scenarious. Especielly if we use quick entries for this.
I see no way of entering these kind of cost elsewhere.
If we remove this, I guess we loose many users.
Joe
2,339 10/08/2012 06:39:38 pm
Re: Revisit Date Form Field defaults on report requests (2 replies, posted in Reporting)
I think you sould be able to select date in the reports across fiscal years.
This is important for GL transactions belonging to assets accounts.
Also for dimensions over more than one year. If you use the dimensions as projects you will want that.
Remember that the reports do not harm any db fields. And the freedom to select over fiscal years make FA unic.
Joe
2,340 10/07/2012 03:20:23 pm
Re: disabling journal reference (5 replies, posted in Setup)
You can fix that in access setup, setup tab
Joe
2,341 10/07/2012 06:14:06 am
Re: Customizing Templates (6 replies, posted in Reporting)
You can use the legal text field in company setup.
Joe
2,342 10/06/2012 05:33:46 pm
Re: Clock time in Frontaccounting (2 replies, posted in Setup)
I am out of office at present, but if I recall this right, I guess you can set this in config.php. Maybe someone can correct me if I am wrong.
2,343 10/05/2012 04:19:34 pm
Re: New Functionalities suggestions (24 replies, posted in FA Modifications)
Ok, thanks. But bear in mind that FA is open source and mostly for small companies.
2,344 10/05/2012 03:19:40 pm
Re: New Functionalities suggestions (24 replies, posted in FA Modifications)
Well, sorry to hear that you dislike FA's behaviour. Maybe you should stick with some other ERP system.
The general behaviour in FA has been majured during several years, and our users are somewhat satisfied with it. At present we have about 110.000 downloads and we are glad for that.
Joe
2,345 10/05/2012 02:29:45 pm
Re: contact_email in sales_orders table (16 replies, posted in Accounts Receivable)
You can always save a copy of your report with your own name from your pdf viewer.
I have no idea about why it saves to another directory. Maybe Janusz can throw some lights on that.
2,346 10/05/2012 02:25:31 pm
Re: UK VAT Set up (6 replies, posted in Setup)
You have two topics covering the same thing.
Read my answer in the FA Modifications Forum.
Joe
2,347 10/05/2012 02:21:56 pm
Re: New Functionalities suggestions (24 replies, posted in FA Modifications)
When you use the supplier invoice from the right hand side tab in purchase tab, you use the lower GL items for entering direct account booking.
Making quick entries for all your expenses eliminate all the problems for you.
Read about how to use them in the wiki.
In my opinion there are no possible mistakes here if you have created the quick entries correctly.
This has been used over several years, without any kind of problems.
Regarding your post on COA, there is a report, the first one in the banking and general ledger reports. Is you select this report you have the option to show the balances as well
2,348 10/04/2012 04:28:17 pm
Re: UK VAT Set up (6 replies, posted in Setup)
Looks fine. I guess you could have created a quick entry for this too. Quick entries allow negative amounts, so I guess you could do that. You can try for yourself.
There is no harm done until you save the transactions.
Joe
2,349 10/04/2012 12:17:01 pm
Re: VOIDING BANK DEPOSIT (1 replies, posted in Setup)
Simply the bank or underlying gl transaction doesn't exist. Which release of FrontAccounting are you using? If older release of FrontAccounting, you have to be on the correct fiscal year.
Can you see it in X_bank_trans table (X = company no) in the database? You can look with phpMyAdmin.
/Joe
2,350 10/03/2012 06:58:04 pm
Re: Sorting Descending Dimensions (4 replies, posted in Dimensions)
I guess you use one of the external themes.
You can change the renderer.php file inside the theme /themes/name of theme/renderer.php to suite your needs.
Joe