I will have a look at it today.
/Joe
3,252 04/10/2011 08:54:18 pm
Re: tax group not calculating correctly (5 replies, posted in Accounts Receivable)
Yes please. You can see the contribution email at the website, Contact Us.
/Joe
3,253 04/10/2011 08:51:31 pm
Re: Report in Excel does not start (6 replies, posted in Reporting)
Hello again. This has now been fixed. HG repository updated. Will be included in 2.3.4.
You can change the following in /reporting/includes/excel_report.inc:
Add Line 698
function End($email=0, $subject=null, $myrow=null, $doctype = 0)
{
Line 698-> global $path_to_root;
++$this->y;
for ($i = 0; $i < $this->numcols; $i++)
$this->sheet->writeBlank($this->y, $i, $this->formatFooter);
---
}
closedir($d);
}
Delete line 718
Line 718-> meta_forward($_SERVER['PHP_SELF'], "xls=1&filename=$this->filename&unique=$this->unique_name");
And add instead line 718
Line 718-> meta_forward($path_to_root.'/reporting/prn_redirect.php', "xls=1&filename=$this->filename&unique=$this->unique_name");
exit();
}
}/Joe
3,254 04/10/2011 02:20:21 pm
Re: Manufactured Item cost (10 replies, posted in Manufactoring)
I guess the Inventory Valuation Report. Maybe you can select a category if you have categoriced it.
/Joe
3,255 04/10/2011 12:41:08 pm
Re: Report in Excel does not start (6 replies, posted in Reporting)
Yes you are right. We will have a look into this.
/Joe
3,256 04/10/2011 12:31:36 pm
Re: Manufactured Item cost (10 replies, posted in Manufactoring)
Can't you just export the reports to Excel (Destination)?
/Joe
3,257 04/10/2011 12:29:19 pm
Re: Backup file not showing (6 replies, posted in Setup)
It should work allright. Maybe you should upgrade to 2.3.3.
/Joe
3,258 04/10/2011 12:26:43 pm
Re: tax group not calculating correctly (5 replies, posted in Accounts Receivable)
Yes, it should. I can not reproduce this. Which release are you running?
/Joe
3,259 04/09/2011 06:53:03 am
Re: Display reporting on Screen (4 replies, posted in Reporting)
This would have been the easiest way for us to display the reports, but in accordance to inaccuracy in the html formatting, we have decided to use PDF for our reports. It is also easier to make uniformed hard copies of the reports this way.
/Joe
3,260 04/08/2011 10:23:17 pm
Re: Instructions (23 replies, posted in Misc. Charts of Accounts)
I have answered you directly. We should try to convert this into a SQL script file. If you have the opportunity you should make a backup of the client that is using this COA and send me this backup SQL script.
I will then send it to the global repository.
/Joe
3,261 04/08/2011 10:18:50 pm
Re: How can I modify/customize the invoice form? (11 replies, posted in Accounts Receivable)
Please, do that. I would be grateful for this.
/Joe
3,262 04/08/2011 02:41:26 pm
Re: Display reporting on Screen (4 replies, posted in Reporting)
By unchecking the 'Popup Window' in Preference (Display setup), the PDF reports are display in another tab.
/Joe
3,263 04/06/2011 01:52:35 pm
Re: Changing Item Type (3 replies, posted in Items and Inventory)
If you haven't done any operations on the items, you can use phpMyAdmin and load your database and go into X_stock_master (where X_ is the company table prefix, if any).
Find the items you want to change. Click the pencil in front and change the letter B to M in the field mb_flag.
After you have done that enter FA and check that the GL accounts for the changed items are correctly set.
You should now be able to create BOM and work orders for the items.
/Joe
3,264 04/06/2011 11:26:55 am
Re: UK VAT returns (2 replies, posted in Reporting)
Hello Hocus,
This seems to be a very valuable report. I will include a report in the Sales tab and call it Sales Summary Report. The selection dates will follow the tax period and the headers will be 'Customer' 'Tax Id', 'Total ex. Tax' 'Tax', 'Tax Group'.
This report will be good for other purposes too, I guess.
I will prepare it, and send you the 2 files needed for testing.
/Joe
3,265 04/06/2011 07:59:51 am
Re: Vertical menu?? (1 replies, posted in FA Modifications)
You can install theme exclusive. This theme has vertical submenus. The problem with the vertical menus is that it will take space from many of the larger forms and inquiries.
/Joe
3,266 04/05/2011 01:39:24 pm
Topic: TIPS. How to Update existing translations after new releases ... (3 replies, posted in Translations)
You can merge your existing .po file with the empty.po (from the new release) file with msgmerge.
Or, if you are using poEdit, you can load your .po file and select 'Catalog', 'Update from pot-file'. Select All files as filter and navigate to the empty.po file and select this one.
Now the merge will take place and you see all your new strings. Translate the new strings and save your work. The .mo file is created when you save.
That is all there is 
/Joe
BTW. Please share the new files with us.
3,267 04/05/2011 12:24:18 pm
Re: Uploading .PDF File Purchase Order (1 replies, posted in FA Modifications)
You have put this item in dual places. See the answer under Accounts Payable.
/Joe
3,268 04/05/2011 12:22:36 pm
Re: Uploading .PDF File Purchase Order (4 replies, posted in Accounts Payable)
When creating the PO you will have a link to email the order.
If you want to do this later you will have to go to the Supplier Reports and select the PO and select Email.
In both cases you must have a valid email set on the supplier.
The pdf file is scrambled when normal printing, but you can save it as a file and in the pdf reader you can possible also email it. But you don't have the automatic interphase then.
/Joe
3,269 04/04/2011 01:50:54 pm
Re: Errors after logout when $show_users_online is set in version 2.3.3 (2 replies, posted in Report Bugs here)
Thanks. The HG repository is updated in a while.
You can change the following in /admin/users_db.inc, line 148, show_users_online:
Add $db as global.
Add || !isset($db) in the first long line of restrictions. This eliminates the problem.
/Joe
3,270 04/04/2011 07:48:42 am
Re: Beginning work on database abstraction / Postgres support (3 replies, posted in FA Modifications)
Hello Brendan,
We have an ambition to make the SQL compatible with mysql, postgres and MS Sql Server. We have a project planning to go into release 2.4 (next major release). This work is in final progress but stalled a bit due to heavy work with release 2.3.3.
The test runs fine on all these DBs, but some minor fixes are to be done.
So either stay put, or make your own approach. You do as you please.
/Joe
3,271 04/04/2011 06:57:27 am
Re: Volunteer translators for installaion wizard messages needed (48 replies, posted in Translations)
You can merge your existing .po file with the empty.po (from 2.3.3) file with msgmerge.
Or, if you are using poEdit, you can load your .po file and select 'Catalog', 'Update from pot-file'. Select All files as filter and navigate to the empty.po file and select this one.
Now the merge will take place and you see all your new strings.
/Joe
BTW. Please share the new files with us.
3,272 04/03/2011 10:06:16 pm
Re: Display balances on payment/transfers forms (2 replies, posted in Banking and General Ledger)
Implemented and going to release 2.3.4. HG repository updated.
/Joe
3,273 04/03/2011 09:47:20 am
Re: Display balances on payment/transfers forms (2 replies, posted in Banking and General Ledger)
Yes, sure it might be a good idea. I will have a look at it.
/Joe
3,274 04/01/2011 11:14:22 pm
Re: Void a invoice if payment has been done (1 replies, posted in Accounts Receivable)
Jujuk, please try for yourself on the Training Co. I have not heard of problems here. I am busy with the release of 2.3.3.
/Joe
3,275 04/01/2011 11:12:21 pm
Re: GL on the sale of "Average Price/Standar Costs" (3 replies, posted in Banking and General Ledger)
Jujuk, I cannot reproduce this. I cannot find the value $320 anywhere in my listing.
I started with B $100, C $100 and D $20. That gives a total value of A $220.
The first production gives a value of $220, the second production gives a value of $220 and after delivering a GL of $220 credit.
So everything is right. There must be something else influensing this.
/Joe