Please contact me, my Elance profile : http://bharata_kalbuaji.elance.com

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.

Solved, the javascript file must be edited too.

Hello, anyone know why this happened? Please. I already tried with the lates version and it still have the problem.

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?

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.

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

(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

(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

(7 replies, posted in Accounts Payable)

Is it set to inactive?

136

(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

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.

I can modify this, but I want to make sure if this problem occur because the function hasn't been imlemented yet

139

(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?

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.

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.

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

(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

(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

(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

(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

(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

(21 replies, posted in Items and Inventory)

What is the different between procured and purchased?

I agree. I just don't understand with reference in FA. So I just hide it and generate my own formatted number.

150

(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.