Yes, I guess so. We will have to address Janusz with this.
Joe
1,126 12/16/2015 06:20:09 pm
Re: Foreign Item Codes Not working to enter item in PO (3 replies, posted in Items and Inventory)
1,127 12/13/2015 05:50:10 pm
Re: Popup Window For Searching Items, Suppliers, Customers, & GL Accounts (8 replies, posted in FA Modifications)
@Bogeyman2007
Your code for popup search has been implemented in 2.4. Is has been modified slightly to work with the existing list searck for customer, suppliers and items. It works well and I thank you for your contribution.
Do you want to get credited with a form of a name, please let me know.
The popup search can be disabled for those wanted that.
Joe
1,128 12/11/2015 07:48:47 am
Re: Query Simplification functions (5 replies, posted in Announcements)
Thanks for sharing this. I have seen similar approaches in various open source db classes.The idea is fine, but I also see some negative effects about this. For seasoned SQL writers, you can loose the overall view of your SQL syntax.
But let this be subject for discussion.
/Joe
1,129 12/09/2015 01:10:08 pm
Re: Supplier Payment Entry(Rounding Problem) (8 replies, posted in Accounts Payable)
This ugly bastard is now fixed in both 2.3.24 and 2.4 Beta.
/Joe
1,130 11/26/2015 06:51:52 pm
Re: Duplicated Invoice Numbers if 2 users generating invoices at same time (23 replies, posted in Accounts Receivable)
Well, i would agree that the numbers should be updated automatically, but we have discussed this internally, and there were other problems involved here. I will let Janusz comment on this.
Joe
1,131 11/26/2015 06:47:47 pm
Re: Sales Quotation/Order/Invoice leading to blank page (2 replies, posted in Installation)
@apmuthu
Yes the error should be enabled. If there are no customers and/or branches in the system, there should be an error reported before you can proceed. Will have a look.
@seend
In the meantime, please set the $go_debug variable first in the file config.php to 1 or 2, to trap any errors.
Joe
1,132 11/23/2015 08:33:02 am
Re: Remove Shipping and Delivery Address from sales invoice (5 replies, posted in FA Modifications)
If no shipping COSTs on sales documents or views, they will not be printed or viewed.
2.3 repo updated and the Changes will go to next minor release.
/Joe
1,133 11/22/2015 11:04:36 am
Re: Remove Shipping and Delivery Address from sales invoice (5 replies, posted in FA Modifications)
If no shipping exists, there is no reason for printing it, I guess.
I will have a look into this later today.
Joe
1,134 11/17/2015 10:58:48 am
Re: REVALUATION OF CURRENCY (1 replies, posted in Banking and General Ledger)
I cannot recall this topic. It is quite old. The routines have been rewritten a year or two ago.
Please update to release 2.3.24 to check if this is working as you want now.
/Joe
1,135 11/14/2015 02:57:15 pm
Re: Purchase Items With Cash (6 replies, posted in Accounts Payable)
Hello,
Use your petty cash account. This should be established as a bank account. Then you can use this at both selling and purchasing.
Even if it is called a bank account, it is your own cash register account.
Joe
1,136 11/14/2015 06:40:29 am
Re: License compatiblity for CoA from other ERP (23 replies, posted in Misc. Charts of Accounts)
We are removing ourselves from the original topic.
What we could discuss in another topic is if we shouldd prevent entering non digits in the so called Numeric accounts.
F.i. Only digits 0-9.
Let us close this topic now.
Joe
1,137 11/14/2015 06:18:43 am
Re: License compatiblity for CoA from other ERP (23 replies, posted in Misc. Charts of Accounts)
Please, think about this as an accountant. The COA is presented as
0200
02001
1000
1001
10010
1002
2000
200011
3000
This is a normal presentation, where 5 or more digits are treated as subaccounts.
Can you see the disaster if we would sort these as integers?
This is the way COAs are setup, despite using digits or a combination of digits and characters.
No accountants are confused about this!
Joe
1,138 11/13/2015 09:27:14 pm
Re: License compatiblity for CoA from other ERP (23 replies, posted in Misc. Charts of Accounts)
In FA there are no cast to integer for accounts. So you can safely use the default account setting
It would be rather inconvenient to treat an account number as an integer.
You are right. The account settings are either Numeric (which mean that only numeric characters are allowed to enter) =0, alphanumeric, where you can enter alpha characters also (Aa to Zz) =1 and last the alpha characters can only be uppercase = 2.
1,139 11/13/2015 08:29:53 pm
Re: License compatiblity for CoA from other ERP (23 replies, posted in Misc. Charts of Accounts)
Sorry, I meant this url.
Joe
1,140 11/13/2015 07:12:17 pm
Re: License compatiblity for CoA from other ERP (23 replies, posted in Misc. Charts of Accounts)
Yes, but they are alphanumeric (varchar in database) only allowing 0-9 numeric character values. It will also allow a point sign.
So therefore they can start with a zero character.
Look at the demo.frontaccounting.com, Banking and General Ledger. There are several accounts starting with zero, and the are presented in the Balance Sheet.
Joe
1,141 11/13/2015 06:56:17 pm
Re: License compatiblity for CoA from other ERP (23 replies, posted in Misc. Charts of Accounts)
The account are per default set to be alphanumeric. So there are absolutely no problem using accounts with leading zeroes.
Certain EU countries uses leading zeroes for alternative reporting. I guess some French COA are using this.
Never mind it is probably not that necessary to use leading zero accounts.
Joe
1,142 11/13/2015 06:23:47 pm
Re: License compatiblity for CoA from other ERP (23 replies, posted in Misc. Charts of Accounts)
@apmuthu
Just curious. Why can't the accounts start with zero, if they are alphanumeric? I see no problems in that.
Joe
1,143 11/01/2015 09:58:48 pm
Re: Annual Balance Breakdown Report -- Net Asset calculation (9 replies, posted in Report Bugs here)
Ok, I will ask Janusz again to update the repo.
Joe
1,144 10/29/2015 05:52:11 am
Re: Cannot call customers data from Sales Menu (2 replies, posted in Accounts Receivable)
Please have a look in Company Setup, Search Customer List. Unmark this if it is marked.
Joe
1,145 10/27/2015 07:27:58 am
Topic: Today we passed 200 000 downloads on Sourceforge. (9 replies, posted in Announcements)
Today we passed 200 000 downloads on Sourceforge. These are the most popular countries:
1. United States 21,616
2. Indonesia 18,699
3. India 15,366
4. Netherlands 7,521
5. Pakistan 5,115
6. United Kingdom 4,272
7. Bangladesh 3,811
8. Canada 3,724
9. Malaysia 3,490
10. Philippines 3,466
11. Germany 3,312
12. Australia 3,150
13. China 3,030
14. Kenya 2,899
15. South Africa 2,896
16. Egypt 2,467
17. Nigeria 2,208
18. United Arab Emirates 1,964
19. Brazil 1,958
20. Saudi Arabia 1,915
21. France 1,905
22. Singapore 1,876
23. Spain 1,790
24. Mexico 1,594
25. Hong Kong 1,544
1,146 10/23/2015 12:47:14 pm
Re: Annual Balance Breakdown Report -- Net Asset calculation (9 replies, posted in Report Bugs here)
Thank you guys for detecting this presentation bug. The file has been fixed and sent to Janusz, that will update the package.
/Joe
1,147 10/18/2015 09:17:14 am
Re: Advanced Manufacturing and My Doghouse (24 replies, posted in Manufactoring)
@Petros
Thank you for your persistent testing 
. Please download and replace from the above links again (they have been updated):
/manufacturing/includes/db/work_order_produce_items_db.inc
/manufacturing/includes/db/work_orders_db.inc.
I guess this is as long as I can go with the fixing. It is very complex routines. It also handles ev. negative stock if set etc. Many things to take care of. Digging deaper will require assistance from a skilled programmer that are also familiar with the Advanced Assembly.
/Joe
1,148 10/17/2015 12:57:07 pm
Re: Advanced Manufacturing and My Doghouse (24 replies, posted in Manufactoring)
Hello,
Here are the new files. They have been committed to repo. replace on your server.
/manufacturing/work_order_costs.php
/manufacturing/includes/db/work_order_produce_items_db.inc
/manufacturing/includes/db/work_orders_db.inc
/manufacturing/includes/db/work_orders_quick_db.inc
@Petros
Remarks to your readme.txt file:
2.a. The issue of 10 'input 1' should NOT be devided by any factor to add the material cost per item price. This is the issue for 1 'Output 1' item.
The Worth of the 10 'input 1' was $41.40 (not $44.10).
/Joe
1,149 10/17/2015 10:17:28 am
Re: Advanced Manufacturing and My Doghouse (24 replies, posted in Manufactoring)
@Petros,
Thanks for the test material. It was nice to make the tests from here.
I have fixed the issues, but want to do some further tests Before releasing the files.
I will be back later.
/Joe
1,150 10/16/2015 03:05:56 pm
Re: Advanced Manufacturing and My Doghouse (24 replies, posted in Manufactoring)
@Petros.
I cannot reproduce your assembly errors.
Will you please give me a detailled example with amounts etc. If there still are errors, I will be extremely glad to fix these,
Joe