Hello,
Strange, shouldn't IFNULL(move.stock_id, 0) give the same result as you suggest. I will investigate this.
/Joe
801 02/05/2018 10:19:28 pm
Re: Inventory planning report 2.4.3 (2 replies, posted in Report Bugs here)
802 02/03/2018 09:46:03 pm
Re: Fixed Assets (30 replies, posted in Fixed Assets)
This has been committed to 2.4 official repo.
/Joe
803 02/03/2018 04:18:21 pm
Re: Fixed Assets (30 replies, posted in Fixed Assets)
Will fix it later today.
Joe
804 01/29/2018 09:14:36 pm
Re: Sales Orders Overview (13 replies, posted in Accounts Receivable)
Ok, Guys. This has been committed with zero decimals in the amounts. I think it is better not to have too much digits when you shall overview the report.
/Joe
805 01/29/2018 07:27:42 pm
Re: Sales Orders Overview (13 replies, posted in Accounts Receivable)
Hello Guys.
If it is ok with 0 decimals, I could just change the two amount places to AmountCol. Default decimals here is 0.
I think that the decimal values is maybe unneeded in the amounts here, right?
Joe
806 01/29/2018 06:55:14 pm
Re: Sales Orders Overview (13 replies, posted in Accounts Receivable)
You are right, I didn't register that when changing. Thanks for reporting this. Will make a rerun in a while.
Joe
807 01/29/2018 12:45:00 pm
Re: Sales Orders Overview (13 replies, posted in Accounts Receivable)
Hello Again,
I moved the Total Amount for every Sales Order under the Loc column. That gives a little more 'air'.
And of course a Grand Total.
Committed to 2.4 core repo.
I hope it is ok.
Joe
808 01/29/2018 05:50:42 am
Re: Sales Orders Overview (13 replies, posted in Accounts Receivable)
I will have a look into it.
Joe
809 01/19/2018 07:40:09 pm
Re: Bug in report 110 (5 replies, posted in Report Bugs here)
I will look at this in a while.
Joe
810 01/17/2018 10:57:52 am
Re: Print Customer Balance On Invoice (13 replies, posted in Reporting)
No, I guess this should be an extension.
/Joe
811 01/13/2018 01:18:47 pm
Re: Print Customer Balance On Invoice (13 replies, posted in Reporting)
The error in getting sales invoice sequences is fixed and committed.
/Joe
812 01/13/2018 06:59:15 am
Re: Print Sales Orders (5 replies, posted in Report Bugs here)
I have no problems selecting and printing sales orders.
In the first combobox select the lowest ref number you want.
In the second combobox select the highest ref you want.
There might be some problems selecting the auto references created from direct deliveries and direct invoices, however these might not be very interesting.
In the Sales Order Inquiry you can easily print the auto referenced.
Joe
813 01/12/2018 01:33:05 pm
Re: Print Sales Orders (5 replies, posted in Report Bugs here)
You know that the records are presented in falling order. Last first in both combo boxes. Are you sure that you got the sequence right?
Joe
814 01/09/2018 08:57:46 pm
Re: Fixed Assets (30 replies, posted in Fixed Assets)
Yes. Janusz reports that this is of priority.
Joe
815 01/04/2018 10:50:57 pm
Re: Bug in Backups (7 replies, posted in Report Bugs here)
Committed to stable repo.
Joe
816 01/03/2018 02:23:09 pm
Re: Default currency account (5 replies, posted in Report Bugs here)
We are looking into this. Stay put 
/Joe
817 01/02/2018 09:27:27 pm
Re: erorr (14 replies, posted in Setup)
You can reopen the closed Year by pressing the pencil. You should only do this before you have published your accounting. And then you can do your corrections and close it again.
/Joe
818 01/02/2018 08:20:07 pm
Re: Fixed Assets (30 replies, posted in Fixed Assets)
Janusz is looking at this tomorrow.
Joe
819 12/26/2017 10:25:32 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
The pkg repo is dedicated to Janusz. We will have to ask him.
Joe
820 12/24/2017 09:24:54 am
Re: Coding Constructs (2 replies, posted in Report Bugs here)
@cambell
Look into reporting/includes/reporting.inc line 128, function print_link how to make a link to the core report you want.
Also look into manufacturing/workorder_entry.php line 64 how to build a report link.
Joe
821 12/24/2017 07:14:17 am
Re: Auto Fill List of Values in a Text Input Fields (30 replies, posted in Modules Add-on's)
/Joe - the committer
822 12/23/2017 02:54:34 pm
Re: Auto Fill List of Values in a Text Input Fields (30 replies, posted in Modules Add-on's)
I don't know. We must address this to @itronics.
It might have something to do with ajax.
/Joe
824 12/23/2017 08:05:35 am
Re: purchase invoice tax (7 replies, posted in Reporting)
This is only temporary tax info on PO. This info could change when the invoice arrive.
I don't think such a report is interesting. You get the tax report for the info later.
Joe
825 12/23/2017 07:48:30 am
Re: Import Tax. (2 replies, posted in Reporting)
Hello, I guess this is a good approach to enter the Import Tax.
At the same time you get sufficient statistics regarding Import Amounts on the Tax Report. Most tax authorities require this info.
Joe