The corresponding purchase lines are done when the delivery is done. The same dimension as the one belonging to the sales invoice is used.
Joe
1,252 02/22/2015 11:46:25 am
Re: Achieved 999% (error?) in Profit and Loss statement (4 replies, posted in Reporting)
I don't know Apmuthu. We have had this all the time. Maybe you can find somewhere suitable in the Wiki to put this. Isn't it mostly used in the balance Sheet and Profit and Loss Statements?
I my opinion, I Think we can continue with this.
/Joe
1,253 02/22/2015 05:50:39 am
Re: Achieved 999% (error?) in Profit and Loss statement (4 replies, posted in Reporting)
This is not an error, but a constant for out of range value.
Joe
1,254 02/20/2015 06:47:27 am
Re: Work Orders (7 replies, posted in Manufactoring)
Just press the '#' label.
/Joe
1,255 02/19/2015 04:42:53 pm
Re: Bug in customer aging (2 replies, posted in Report Bugs here)
Yes, there were a 1 day failure in the aging routines. These errors have been here for 8 years 
.
Well, not a serious bug perhaps, but as you say Mark, quite annoying.
The HG repo for 2.3.23 will be updated asap. If you can't wait you can download:
/reporting/rep.102.php1 and /reporting/rep202.php1. Rename the files to .php.
/sales/includes/db/customers_db.inc and /purchasing/includes/db/suppliers_db.inc.
And replace the files.
/Joe
1,256 02/19/2015 09:23:56 am
Re: Sorting the Outstanding work order screen...or any option for filters (19 replies, posted in Manufactoring)
This issue has now been implemented in 2.3.23 release.
If you can't wait you can download the files /manufacturing/search_work_orders.php1 (rename to .php) and /manufacturing/includes/db/work_orders_db.inc. Please replace the files in your setup.
/Joe
1,257 02/19/2015 08:42:45 am
Re: Sorting the Outstanding work order screen...or any option for filters (19 replies, posted in Manufactoring)
Hold your horses . I didn't realize this as that important.
I will have a look again.
Joe
1,258 02/19/2015 07:41:14 am
Re: Costed Inventory Movement Report (10 replies, posted in Report Bugs here)
@MarkAndrew,
I now see the problem.
When you void a supplier invoice, the underlying Delivery is NOT voided. This has to do with when using the supplier invoice in the right panel, you can select which deliveries is going to be included in the supp invoice.
Therefore voiding a complete direct supp invoice ( and a built up supp invoice from the right panel) will not be done and it will Always require a 2 step operation.
1. First void the supplier invoice.
2. And now void the PO delivery.
Although most of the time it could be done to void both the supp invoice and the receive, it would be dangerous to do this and in several cases it qould not be desirable.
So I will leave the operation as is.
The wiki has been update here.
/Joe
1,259 02/18/2015 03:42:46 pm
Re: Costed Inventory Movement Report (10 replies, posted in Report Bugs here)
Ok, I will give it another go, but be prepared to help testing.
Joe
1,260 02/18/2015 01:04:36 pm
Re: Sorting the Outstanding work order screen...or any option for filters (19 replies, posted in Manufactoring)
Oh, I see. Sorry we do not consider this as needed. As you say you can search by reference.
Joe
1,261 02/18/2015 11:34:54 am
Re: Sorting the Outstanding work order screen...or any option for filters (19 replies, posted in Manufactoring)
Just press the # label.
Joe
1,262 02/17/2015 07:57:11 pm
Re: Backporting rep107 fix in reporting.inc (2 replies, posted in Reporting)
@apmuthu
This is not necessary, because the value in the sixth parameter is 0 (for default orientation). This parameter should have been used for Customers and setting this value as 0 doesn't do any harm. The seventh parameter is used for default orientation and is per default set to 0.
So all in all it is not necessary to back port this issue.
Joe
1,263 02/17/2015 03:00:37 pm
Re: Costed Inventory Movement Report (10 replies, posted in Report Bugs here)
@MarkAndrew
Mark, this is an extremely complicated routine: function void_supp_invoice in file /purchasing/includes/db/invoice_db.inc.
The function starts on line 487 and the handling of the received items is done from line 505 and forward.
As you can see several users have been editing these routines and some lines have been commented out.
I am not sure what we should do here to fix your issues.
Will you have a look, and maybe give me som hints. Thanks in advance.
/Joe
1,264 02/17/2015 02:13:19 pm
Re: Costed Inventory Movement Report (10 replies, posted in Report Bugs here)
I will have a look into this, Mark.
Joe
1,265 02/16/2015 10:16:20 pm
Re: exchange rates not updating automatically (9 replies, posted in Banking and General Ledger)
Please go into Banking and General Ledger -> Exchange Rates and select the USD and press the button 'Get'.
If this works, then you should get an automatic update when saving foreign documents.
If it doens't work, you could try to change Exchange Rate Provider in the file config.php.
/Joe
1,266 02/15/2015 07:25:36 pm
Re: bank accounts (16 replies, posted in Banking and General Ledger)
@apmuthu.
The key_in_foreign_table checks that there are no transactions on the GL account.
Just to ensure that the transactions on he bank account are mirrored on the GL account without having other transactions.
Joe.
1,267 02/15/2015 11:32:28 am
Re: Sales invoice with VAT Rate column for UK (8 replies, posted in Accounts Receivable)
Take it easy. The Polish version that Janusz has been working on is somewhat different than the open source version. He will reveale the line Vat solution in a while, just give him some time.
Joe
1,268 02/15/2015 11:28:27 am
Re: bank accounts (16 replies, posted in Banking and General Ledger)
It is more clean if the account is empty. Much easier to check the bank account against the GL account.
Joe
1,269 02/15/2015 07:10:51 am
Re: Sorting the Outstanding work order screen...or any option for filters (19 replies, posted in Manufactoring)
This is already implemented in release 2.3.22.
/Joe
1,270 02/15/2015 07:08:33 am
Re: Sales invoice with VAT Rate column for UK (8 replies, posted in Accounts Receivable)
Hello guys,
Janusz has already a similar variant ready for his Polish Version. He will incorporate this in release 2.4.
/Joe
1,271 02/15/2015 06:58:17 am
Re: bank accounts (16 replies, posted in Banking and General Ledger)
I guess we can make a better eror string like 'The GL account selected is already in use or has transactions. Select another empty GL account.'
Joe
1,272 02/13/2015 09:55:44 pm
Re: Print a large number of invoices at once (21 replies, posted in Reporting)
A new update of the file rep107.php has been done. please make a reload of the file from HG repository.
/Joe
1,273 02/12/2015 08:58:45 pm
Re: Print a large number of invoices at once (21 replies, posted in Reporting)
The currency filter didn't work for most documents, so these have been fixed and the 2.3 HG repo has been updated.
The fixed Invoice Document kan be downloaded here.
/Joe
1,274 02/12/2015 04:44:30 pm
Re: Print a large number of invoices at once (21 replies, posted in Reporting)
The currency filter do not work in rep107.php. This will be fixed for 2.3 later this evening.
The Sales Group filter will require more work elsewhere, so this will have to wait and be included during 2.4.
Joe
1,275 02/12/2015 04:16:00 pm
Re: Print a large number of invoices at once (21 replies, posted in Reporting)
I wil have a look into this.
Joe