In the Price List Report the inactive items are removed.
In other Item related reports the inactive Items are stamped (Inactive) after the description.
CVS Main updated. Affected files: /reporting/...rep104.php, rep301.php to rep305.php.
/Joe
3,751 04/06/2010 07:47:44 am
Re: Inactive Items in reports (5 replies, posted in Reporting)
3,752 04/01/2010 12:27:38 am
Re: Creating delivery service item posts Inventory and COGS Automaticly. (9 replies, posted in Accounts Receivable)
I am sorry, I can't reproduce this. Will you give me a detailed situation.
/Joe
3,753 04/01/2010 12:22:20 am
Re: Removing "demouser" from login screen (1 replies, posted in Setup)
Hello,
This is a config.php problem. A global variable, $allow_demo_mode, is set to true. You should try to empty the internet cache.
/Joe
3,754 03/31/2010 07:11:45 am
Re: Creating delivery service item posts Inventory and COGS Automaticly. (9 replies, posted in Accounts Receivable)
Check that you have set the correct accounts on the service item. For service there should be only 2 accounts, Sales and CoGS.
/Joe
3,755 03/30/2010 10:10:57 am
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
1. Recursivity is not available in all version of MySQL (3.23). We may, however, skip 3.23 in 2.3 if this is not used anymore according to our polls.
2. It is not adviseable to handle the grouping as strings and numeric as per se.
/Joe
3,756 03/30/2010 08:02:14 am
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
All the group ids and subgroup ids are strings, so 13 is between 1 and 2. So you will have to rearrange your ids to fit into your hierarchy.
It is quite obvious why we sort by class_id first. The balance sheets and PL statements are created by using this class_id.
/Joe
3,757 03/29/2010 11:34:43 pm
Re: Client delivery indication - packing slip (15 replies, posted in Manufactoring)
Please use the Training Co, to make some test run to ses how it works.
/Joe
3,758 03/29/2010 11:27:16 pm
Re: How to do tax on a tax - sales taxes (1 replies, posted in Accounts Receivable)
Hello,
If this is the fact, then you would set it up as follow:
In Tax type, setup a fed tax 5%, value 5
Provincial tax 7.5%, value 7.88
Then combine them into a group, and you are done.
Maybe there are some Canadians that can help me further here?
/Joe
3,759 03/29/2010 10:20:05 am
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
The groups are sorted by class_id, group id. And inside the group_id it is sorted per subgroup. When running the reports it is doing the right way.
This is the way it works. You can rearrange the group_id. The update routine will adjust the subgroups and accounts groups in the accounts table accordingly.
/Joe
3,760 03/27/2010 11:30:16 pm
Re: Fragmented Unit of Measurement (1 replies, posted in Items and Inventory)
Please look into our wiki,
under Working with FA, Items and Inventory, Purchase pricing. Here you can read all about conversion factors and cartons, boxes etc.
/Joe
3,761 03/26/2010 04:35:19 pm
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
You should also download the following file from CVS unstable
Otherwhise some of the reports will not print.
/Joe
3,762 03/26/2010 03:19:11 pm
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
This has now been fixed in CVS unstable. Affected file /includes/ui/ui_lists.inc.
You can download it here:
/Joe
3,763 03/26/2010 03:07:39 pm
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
Yes, I understand.
The Account Group table above is ordered correctly, but the combobox list is sorted in a strange way. It should have been sorted just as the Account Group table.
Janusz will have a second look at the function gl_account_types_list.
/Joe
3,764 03/26/2010 12:01:45 pm
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
You could send me a backup (sql script) from your test client. You can use the email address on the 'Contact Us' page for sending attachments to us.
/Joe
3,765 03/25/2010 03:20:53 pm
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
There must be something wrong with your setup. It is sorted correctly in my environment.
Did you remember to download the latest /includes/ui/ui_lists.inc from the CVS unstable?
You can download it here:
This types_list has been updated.
/Joe
3,766 03/25/2010 10:42:58 am
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
Hello, I think your list should be sorted just as you typed it (with None in front). All these types are belonging to the same class type, right?
The sort order is class type, type id.
I will have a look at it.
/Joe
3,767 03/24/2010 09:40:39 am
Re: Bank Account Payment Entry modification (4 replies, posted in Banking and General Ledger)
No, it is not possible to modyfy a payment at present.
You will have to void the transaction (Setup - Void a transaction), and re-enter it again.
/Joe
3,768 03/24/2010 09:38:26 am
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
Janusz has how fixed the combox group order. I have tested further on the subject and fixed a couple of other minor errors. Now the types is working as intended.
Please update your CVS unstable. The files affected are:
/includes/ui/ui_lists.inc
/gl/includes/db/gl_db_account_types.inc
/gl/manage/gl_account_types.php
/Joe
3,769 03/23/2010 03:22:04 pm
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
This was related to the following expressing in php:
if ("00" == "0")
This will return true in php. I have now used strcmp instead for comparing the strings in the file /gl/manage/gl_account_types.php, but there is still a problem when setting the correct type in the listbox (for parent). I will have to discuss this with Janusz.
In the meantime you can pick up the latest revision in the CVS unstable.
/Joe
3,770 03/23/2010 08:53:26 am
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
It is the zeros that are causing the problems. You can either change your groups one by one by editing them and select None for parent and save again. Or you can use phpMyAdmin and change all the 0 in parents to an empty string.
Or you can use this SQL for fixing this.
UPDATE `0_chart_types` SET parent='' WHERE parent='0' OR parent='-1';After that, you can again use 0 as a parent if there is such a group.
This SQL is going to be part of alter2.3.sql when upgrading in a while.
/Joe
3,771 03/23/2010 12:23:49 am
Re: Direct Invoice Question (2 replies, posted in Accounts Receivable)
Please look at the underlying delivery (dispatch) note. It is referenced as 'auto'.
Here you will see the inventory and COGS GL postings.
/Joe
3,772 03/22/2010 04:29:23 pm
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
CVS unstable (2.3 CVS) is updated. Affected files:
/gl/includes/db/gl_db_account_types.inc
/gl/manage/gl_account_classes.php
/gl/manage/gl_account_types.php
/includes/ui/ui_lists.inc
Thanks for reporting this.
/Joe
3,773 03/22/2010 04:24:28 pm
Re: Error editing (updating) Account Groups in 2.3 CVS (27 replies, posted in Report Bugs here)
Yes, will be fixed asap.
/Joe
3,774 03/10/2010 10:36:58 pm
Re: PO Number is not right (3 replies, posted in Report Bugs here)
Ok, Fixed. CVS Main updated. Affected file /reporting/rep209.php
You can download it here:
/Joe
3,775 03/10/2010 11:39:41 am
Re: Report, stock check sheets (1 replies, posted in FA Modifications)
Yes good idea.
CVS Main trunk updated. Affected files: /reporting/rep105.php, /reporting/rep301.php, /reporting/rep302.php and /reporting/rep303.php.
/Joe