Please contact me, my Elance profile : http://bharata_kalbuaji.elance.com
126 08/08/2014 02:46:29 am
Re: FA customization in Singapore (9 replies, posted in Jobs wanted/offered, non-free offers)
127 08/06/2014 01:18:27 am
Re: TIPS. How to Update existing translations after new releases ... (3 replies, posted in Translations)
Hello,
I've used POEdit to edit the PO and click update. I already set the root directory to my Front Accounting project. I've seen the updated label which added by me. I've set the translation and save it. After I reload, I don't see any change in the Front Accounting. I think the po file is alreay updated. Is there any wrong with this method?
Thank you for your attention.
128 07/15/2014 12:47:11 pm
Re: Amount cell bug in customer_payments.php (3 replies, posted in Report Bugs here)
Solved, the javascript file must be edited too.
129 07/10/2014 06:30:34 am
Re: Amount cell bug in customer_payments.php (3 replies, posted in Report Bugs here)
Hello, anyone know why this happened? Please. I already tried with the lates version and it still have the problem.
130 07/02/2014 10:28:54 pm
Topic: Amount cell bug in customer_payments.php (3 replies, posted in Report Bugs here)
I've tried to add an amount cell in this file. Usually, the inputted number will be automatically formatted. Instead of automatically formatted, it do nothing and I get this error in firebug :
TypeError: document.getElementById(...) is null
var val = document.getElementById(doc).innerHTML;
utils.js (line 250)
In this file, I already modified it and guess maybe my modification caused it. So I changed back to original version, but nothing had changed.
I use 2.3.20 and only half of it updated to 2.3.21 because I've heavily modified it. Anyone can help?
131 06/16/2014 03:41:06 pm
Re: Asset register extension doesn't add the fixed asset journal (2 replies, posted in Items and Inventory)
I've tried it in localhost and I've been inspecting the SQL function and trigger. The function for adding value to general ledger is not existed. It's only function to generate the depreciation value of the item.
132 05/29/2014 03:44:53 am
Re: Navigation : Sorting by ( ASC / DESC ) (21 replies, posted in Report Bugs here)
Sorry, I just can't answer because your code is looking good. Even in your local is working. Maybe it's because the different version of MySQL in the server or anything. You must test in another machine.
133 05/28/2014 05:27:20 am
Re: Rowspan in table (3 replies, posted in Reporting)
Please see my code below "
$rep->TextCol($x, 1+$x++, _($no++),0,0,1);
$rep->TextCol($x, 1+$x++, $row['so_number'],0,0,1);
$rep->TextCol($x, 1+$x++, $row['branch'],0,0,1);
$rep->TextCol($x, 1+$x++, $row['cust_ref'],0,0,1);
$rep->TextCol($x, 1+$x++, $row['curr_code'],0,0,1);
$rep->AmountCol($x, 1+$x++, $row['totval'],0,0,0,1);
$rep->TextCol($x, 1+$x++, sql2date($row['ord_date']),0,0,1);
$rep->NewLine();
I try to list sales order in a table. The newline work to create new row. But I want to create 2 cell that merge vertically. For example in the column of customer. For all the same customer, I want to rowspan the name of the customer. If I use newline, it's like creating some new row. I can merge cell horizontally using number in text col like above. The $x control the from an to cell. In above, each cell just have 1 width cell. Is there any function work like this for rowspan?
134 05/28/2014 02:29:17 am
Re: SUPPLIERS (7 replies, posted in Accounts Payable)
Hmm, I think you must try to debug the query to see if there is something wrong with the sql. Get the sql string and try to run it directly in phpmyadmin or anything else
135 05/28/2014 12:43:40 am
Re: SUPPLIERS (7 replies, posted in Accounts Payable)
Is it set to inactive?
136 05/28/2014 12:41:17 am
Topic: Rowspan in table (3 replies, posted in Reporting)
Hello,
I can create a colspan cell in Front Accounting report, but how can I create a rowspan cell with it? Thank you
137 05/22/2014 11:16:57 pm
Re: Navigation : Sorting by ( ASC / DESC ) (21 replies, posted in Report Bugs here)
It's strange the same code won't work if it's work on your local. Is there any information you can give about the server? Maybe you can give me you snippet code to check if it has any error.
138 05/19/2014 05:07:08 pm
Re: Asset Module Entries don't show up on Balance Sheet (6 replies, posted in Modules Add-on's)
I can modify this, but I want to make sure if this problem occur because the function hasn't been imlemented yet
139 05/06/2014 07:32:17 am
Topic: Editable WO Requirement (1 replies, posted in Manufactoring)
Hello,
Now, FA can not modify WO Requirement and I have a case where I need to change some material with another material as a substitute. It would be annoying if we must create a new item which have different BOM even only one material. So, I plan to add a feature to edit the WO requirement. Does some problem will occur (in accounting process) if I add this feature? I already have some idea about accounting logic in FA but for this WO, I still don't get it, especially in cost or issue while we have 0 quantity. So, to add another material, I will hide this menu and create one myself. What are your opinion to this?
140 04/30/2014 12:06:24 am
Re: Asset Module Entries don't show up on Balance Sheet (6 replies, posted in Modules Add-on's)
Btw, I already inspect the code for this module and I think there is no function to create a journal where we entry a new asset. The trigger and function in mysql only works for amortisation and I already confirm that.
141 04/29/2014 11:26:10 pm
Re: Asset Module Entries don't show up on Balance Sheet (6 replies, posted in Modules Add-on's)
I already create a trigger and it does nothing. I use root privilege in my localhost. But I remember it used to create a journal entry before.
142 04/29/2014 11:05:57 pm
Topic: Asset register extension doesn't add the fixed asset journal (2 replies, posted in Items and Inventory)
Hello, is there someone who use asset register extension? Is it doesn't do a journal entry when we create new asset? I remember when I first use it, it creates an entry in journal. But now, it doesn't. Is something wrong?
143 04/12/2014 12:15:29 am
Re: Strangest bug I've ever since (3 replies, posted in Report Bugs here)
Yes, it's the rounding issue. But, I already print the $x which is exactly same as 0.84.
144 04/11/2014 12:55:56 pm
Topic: Strangest bug I've ever since (3 replies, posted in Report Bugs here)
I don't know how to explain this. I'm still confused with this bug. I have some strange bug and I'm trying to debugging until I found the root problem. I've just try some simple substraction but it gives me strange result. Here is my code:
$x = 0.56*1.5;
logger($x-0.84);
What I expection is 0, but the result is : 1.1102230246252E-16
If you want to know what is logger function, it's some function that I create to echo the parameter. The stranger thing is, this bug only happen to 2 decimal place operation. If I try with
$x = 0.5*1.5;
logger($x-0.75);
It works fine. I already check the variable type. Both show me they are double. Can anyone hlep me?
145 04/05/2014 03:10:13 pm
Re: Best practice to modify reporting (2 replies, posted in Reporting)
Hello,
If I want to create my own formatted report (for example like creating custom table for item in sales order), where do I start modifying the report? Can anyone explain the structure for reporting class? And how can I display the company logo inside my report? Thank you
146 03/29/2014 11:11:13 am
Re: how can i add new Item Type (21 replies, posted in Items and Inventory)
Hello, Asaha
1. You can modify this easily
2. Fa does support this
3. If the number is so huge, what kind of process do you want?
4. My case is same, the payment is every friday. But I think it's not an issue or do you have some issue with this?
I think the solution to add some flag in supplier is the best because it's the least modification but have some impact rather than you modify the core of FA.
147 03/28/2014 04:02:51 pm
Re: how can i add new Item Type (21 replies, posted in Items and Inventory)
Hello asaha,
Can you give me some example or such case study? I still don't understand the correlation between huge transaction and item type. I think the purpose of item type is to differentiate between service, which needn't GRN, purchased, which normally excluded from sale, and manufactured, which need manufacturing process to re-supply and we must define the BoM for it. The purpose of this type is not related to another process and if you add a new type, I think you must modify FA hugely. My advice is just classify your process and I think the purchased type is sufficient for this type and modify the other part which wouldn't make you to modify hugely. So, if you tell me what you need, maybe I can give some advice for modifying. I myself already modify FA hugely so I know how hard to modify some part which is the core of FA.
148 03/28/2014 02:14:09 am
Re: how can i add new Item Type (21 replies, posted in Items and Inventory)
What is the different between procured and purchased?
149 03/21/2014 09:23:52 am
Re: Invoice Number has already being user - when multiple users... (6 replies, posted in Report Bugs here)
I agree. I just don't understand with reference in FA. So I just hide it and generate my own formatted number.
150 03/21/2014 09:19:28 am
Re: Default Purchase Price (2 replies, posted in Items and Inventory)
The default FA doesn't support this. I think you can modify it youself. Just add an input text for standard purchase price in general setting form, add a column in stock master, and save to it. In purchase price form, just add some auto generate button which is generate entry data to table purch_data. The data entry is the pair of supplier id and the standard price that you set. I think it's not that hard. Maybe 2-3 hours of coding will do the trick.