151

(5 replies, posted in Banking and General Ledger)

asgare wrote:

Dear barbarian;
Thank for your prompt reply.

I read Opening Balance thoroughly in WIKI but the issues that I couldn't understand is that, how to handle my need via this. Let me give you an example:
Consider I have a customer/supplier X and it is my first time to work with FA. I defined every thing possible in FA such as banks accounts, fiscal years, customers, suppliers and etc... Now, for some defined customers/suppliers I have some previous payments that not settled yet and I just wanted to enter an opening balance sheet for that.
FA has a very nice option, Payments and Deposit. Via this part I can directly point on customer and supplier but in FA journal entry I can't point on specific customer/supplier.
The question is how to enter an opening balance sheet in by which whenever I check out customer/supplier transaction it show's me all invoice plus opening balance.

I do hope could clearly explain what I want smile


Your need is the complicated one. I will have the same problem. I think the Wiki has explained it. Read below : If you have AR/AP records (not settled yet), this is more complicated. It's not a beautiful way to do this, but I think this is easier than you enter manually to database via DBMS.

152

(5 replies, posted in Banking and General Ledger)

asgare wrote:

Dear apmuthu
I didn't understand what you mean! can you explain more in detail?!

You can just manually enter your opening balance sheet to FA via journal entry. But, I think for on going transaction, it would be more complicated. For example if you still have some DO which not yet be invoiced or some unpaid invoice. Although the procedure seems complicated, you can follow FA Wiki guide : here

153

(10 replies, posted in Manufactoring)

But what is the reason for that? I have 0 product and enough material to produce that. I think in the balance sheet, it's enough to convert the total raw material asset to finished goods asset and add some expense in profit/loss report. Why must it reduce the finished goods asset?

joe wrote:

The else part is for use when you have accepted negative stock in system and general GL setup and the current stock is below 0.

Joe

154

(10 replies, posted in Manufactoring)

victoredwards wrote:

The standard cost for manufactured item depends on these cost elements are :
Material Cost – This is the purchased cost. This is set as the standard material unit cost on the cost master file.
Material Overhead Cost – This is the material burden which is calculated using a “Material Overhead Rate’ and applied to the material cost at the time of purchase order receipt.
Direct labor and labor overheaded cost.
Machine Overhead Cost – There is a Machine Overhead Rate associated with each machine and the machine can be specified on each operation of the routing where appropriate.

Thank you for your reply. When I use item adjustment, this works fine. If I set the material cost 70.000 and labour cost 75.000,
the adjustment seems right. My stock account value in balance sheet become 75.000.

The problem occur when I use work order to produce it. I use raw material which total 70.000 and add a labour cost 5.000. But, something happen because my initial qoh is 0. It's in work_orders_db.inc (function add_overhead_cost) that cause this.

if ($qoh > 0){
            $overhead_cost = ($qoh * $overhead_cost + $costs) / $qoh;
        }else { // Journal Entry if QOH is 0/negative 
            global $Refs;

            $id = get_next_trans_no(ST_JOURNAL);
            $ref = $Refs->get_next(ST_JOURNAL);

            $stock_gl_code = get_stock_gl_code($stock_id);
            $memo = "WO Overhead cost settlement JV for zero/negative respository of " . $stock_id;
            //Reverse the inventory effect if $qoh <=0
            add_gl_trans_std_cost(ST_JOURNAL, $id, $date_, $stock_gl_code["inventory_account"], $stock_gl_code['dimension_id'], $stock_gl_code['dimension2_id'], $memo, -$costs);
            //GL Posting to inventory adjustment account
            add_gl_trans_std_cost(ST_JOURNAL, $id, $date_, $stock_gl_code["adjustment_account"], $stock_gl_code['dimension_id'], $stock_gl_code['dimension2_id'], $memo, $costs);

            add_audit_trail(ST_JOURNAL, $id, $date_);
            add_comments(ST_JOURNAL, $id, $date_, $memo);
            $Refs->save(ST_JOURNAL, $id, $ref);
        }

I don't get the else part. Because that, the value of finished goods become 70.000 and the material cost change into 65.000. The labor cost still 5.000.

155

(9 replies, posted in Announcements)

Thank you. I have hugely modified FA 2.3.19. Is it possible to upgrade to this version? Or I must check manually from diff file and replace it? thank you

156

(3 replies, posted in Banking and General Ledger)

I haven't check the tax report. But it seems this is a special case because there is only applied for service item. PPH is income tax for the technician.

157

(4 replies, posted in Manufactoring)

I'm also confused with this problem because I don't know what  purpose of the labor cost and overhead cost in Items. Another thing that I'm still have some doubt is whether the labor cost is added to the finished goods value. For the example like above, the total amount to manufacturing C is 75.000. But I don't know if it should write 75.000 in balance sheet and -5000 from another account in cash/bank or +5000 in liability account or it still 70.000 but the 5.000 will add to COGS account and -5000 from cash/bank account.

Balance sheet before ->

                                Asset                                          Liability
bank                                0
raw material           70.000                      payable      70.000
finished goods                0

For case 1 :

After ->
bank                        -5000
raw material                   0                       payable      70.000
finished goods        75.000

or (labor cost is claimed as payable)

raw material                   0                       payable      75.000
finished goods        75.000

case 2:
balance sheet:
bank                        -5000
raw material                   0                       payable      70.000
finished goods        70.000                      revenue       -5000

P/L:
Income                           0
COGS                        5000
Calculated return    -5000
                         

I must consult my accountant for this. If anyone can help, please share your opinion.

158

(3 replies, posted in Accounts Payable)

apmuthu wrote:

Create a Goods in Transit account and use a journal voucher to move it to the customer when it reaches the destination.

I agree with you. My plan is to modify some database in stock master.  I will add an account for delivery on the way and use this account instead of COGS while creating delivery. In delivery list, instead of directly create invoice, I will add a button to move the delivery on the way to COGS. After that, invoice can be created. So it's like adding 1 step after delivery order. But it will take time to do this sad

159

(3 replies, posted in Banking and General Ledger)

In Indonesia, that is a tax that reduce the total amount of invoice (it's called PPH 21). For example the total invoice is 10.000. The VAT for this order is 1.000 and the tax for PPH 21 (2%) is 200. But the 200 is not like VAT which add the total amount, it reduces the total amount. SO the calculation is like this : 10.000+1.000-200=10.800. Is it possible to do this? Yesterday, I modify the code in tax entry so that negative value to be allowed and it works fine (I deleted the >0 check in can_process function). It solve the problem but is it the right thing to do?

160

(3 replies, posted in Accounts Payable)

If the delivery took some time (i.e. 2 weeks) and we must create monthly report for finance depertment, how I can handle the goos that still on the delivery? Practically, this goods doesn't create COGS account i profit and loss because the customer hasn't received it yet. In my company, the delivered goods that still on the way have it's account in journal. So, the CoA pair for delivery is not finished goods stock and COGS, but finished goods stok and on the way goods. After it has received, a ournal that pair on the way goos with COGS account will created. Is it possible to do this in FA?

161

(1 replies, posted in Manufactoring)

How I handle work in progress in front accounting? It seems after I produce my work order, the jounal entry for finished good is already inserted but usually in practical, we must create a journal for work in progress item.

162

(4 replies, posted in Manufactoring)

I have raw material A 1 kg and B 1 kg. I want to create finished goods C 1kg using 1 kg A and 1 kg B. I don't have any stock for C. A is costed 20.000 and B is 50.000 (set in standard cost and purchase pricing). For C, I set 0 for all cost (raw material cost, labour cost, and overhead cost). I create a work order and add labour cost 5.000. When I enter this labour cost, an automated journal entry occur which contains the memo like this : "WO labour cost settlement JV for zero/negative respository of C".

What does it mean? What is the logic behind this process? After I produce this work order, I get 1 kg C and the raw material cost become 70.000 and another cost is 0. Shouldn't the labour cost become 5000 as well?

My background is not from accounting but when I asked an accountant, he also confused with this process. FYI, I set my balance with raw material asset 70.000 and payable account 70.000 with no entry in profit and loss statement.

Hello all,

I just want to ask your advice because I'm stuck with my problem. The case is (simple but hard to modify) one supplier can change the currency for the item's price. For example, for the first PO they use USD and the next PO they use GBP. I had the same case with creating sales order but that is much simpler because the basic price for item is based on company currency. I just change the rate in sales order entry. But for purchase order, I wonder the same approach can solve the problem. I've my hypothesis to solve the problem, like following:
1. When I enter the purchase pricing in the item, I add currency selector and update the supplier's currency according to the selected currency. For this solution, I wonder if there will be problem because in the default FA system supplier's currency cannot be changed in the supplier maintenance. I'm sure there are reason for this. So, for this solution, the problem to update supplier currency is my big concern. Can someone tell me why default FA not allowing currency change?
2. The purchase price is entered in company currency and I add some currency selector in PO entry. The problem for this solution is when I fill the price in company currency, I must manually convert from supplier currency to company currency.

So, what will you suggest to me? Any idea will help. Thank you.

And I want to ask some advice. While creating work order, I need to create some form that named Request for Material. This form is basically a form that used to ask purchasing to buy raw material that lacked for production that stated in work order. Where is the best place to add this menu? Is it before releasing the work order or after releasing the work order? I don't know where is the best place because I don't understand the meaning of releasing work order in practical.

Hello,

I just need some advice in modifying FA. Currently, I must create a work order that stated all material and cost that will be needed in the production. The material includes packaging material, like plastic bag ord anything else, which is different in every production. So, I think the packaging material is not needed in Bill of Material and must added while creating work order. I already tried the work order entry and see the issue and cost. Can I use this two menus for this kind of requirement that I need? And how do I handle some failed production? Thank you.

166

(2 replies, posted in Reporting)

Hello,

I just want to ask, what is the best method to create my own pdf/excel reporting? Honestly, I have some trouble with original FA reporting method because my report is very different than the current format. If I modified the original format, it will need much work and I'm afraid that it will affect another feature. So, can you give me some suggestion regarding this problem? Thank you.

167

(5 replies, posted in Wish List)

I wouldn't mind to share it, but I don't know how because my modification is very heavily change the current FA. This is my bitbucket project : https://bitbucket.org/18209018/starborn-erp

For sql, use the very recent in backup folder in company.

Oh yeah, btw it's still on going project and my modification is specific for my client request. Just grab some feature that you need and modify it as your wish. If you need to know anything, just ask me in this forum. I'm always watching.

ps.
I'm still working for general feature that not very confidential. After I'm working on confidential part, I will close this repository for public. I'm planning to become a contributor for Front Accounting but I don't know how. Can anyone tell me how? My proposed feature is sales project (create, inquiry, and report) plus modifying SQ/SO entry to have a project reference if needed. It will become good additional feature for FA.

168

(5 replies, posted in Wish List)

Hello,

Currently I am developing ERP using FA. I have added some feature that comes from my client. I think it would be great if it can become default feature for FA. The feature that I alread add is:
- Sales project, the feature is to create a project/contract for sales and then we assign the sales order/quotation to the project. I've already implemented it and it is easy
- Sales packaging, teh feature is to add some packaging option in sales order/quotation. At first, I think this feature already covered in sales kit, but I implemented it for easy usage for deliveries order.
- Unit conversion, it's possible that the order from customer is came with different company unit of measure, for example litre to kg or etc. I haven't implemented it but I think it will become great improvement.
- Planning for Multiple delivery, I think this is the must have feature for FA. Currently, a sales order already support for multiple deliveries. But, I think it would be great if we can add some deliveries planning for a sales order. This feature become very useful when a customer already ordered for multiple deliveries when creaing the order. I'm still adding this feature. But, I imagine that we can have a list for delivery screen and we can crate delivery order based on that.


I wouldn't mind giving my code, but I already heavily modified FA from database to existing code. Maybe in the future I can give some help to add these feature. Thank you.

169

(5 replies, posted in Accounts Receivable)

elax wrote:

Probably because FA developers prefer to spend their time to add new features to FA (or fix bug or answer question on the forum)  instead of fixing something which is not broken ... And if they were, they'll probably start by something else ;-)

/Elax

You are right. It's better to focus on fixing the bug. By the way I want to ask abou ajax again. Honsetly, the previous code is working but I don't know how it's working. When I tried to implement it in another page, it's not working. basically, I just want to do some simple change like in sales order UI. I want to create selector for customer, selector branch, info about currency, and info about sales group. When I change customer, the branch and currency is changed according the customer even though I don't add another code at all and I've been wondering why this code works. But, when I want to change the sales group according to branch, it's not working and I still have no idea why. So, i just want to ask a very simple and below is my code:

customer_list_row(_("Customer:"), 'customer_id', null, false, true, false, true);
customer_branches_list_row(_("Branch").':', $_POST['customer_id'], 'branch_id', null, false, true, true, true);
label_row(_("Currency:"), get_customer_currency($_POST['customer_id']));
amount_row(_("Project Value").':', 'value');
$branch = get_cust_branch($_POST['customer_id'], $_POST['branch_id']);
label_row(_("Business unit:"), get_sales_group_name($branch['group_no']));

When I read the sales order ui header function, I understand the flow of the logic. But I don't know which part is affecting the change because it's so may if there. So, from code above, can you help me to explain why customer branch and currency changed when I change customer but sales group name won't change even though I change branch? I really than you if you could help me with this. The code or customer and branch is copied form sales order ui.

Here is my full code:

<?php

$path_to_root = "../..";
$page_security = 'SA_SALESPROJECTS';

include_once($path_to_root . "/includes/session.inc");
$js = '';
$js .= get_js_date_picker();
page(_($help_context = "Sales Projects"), false, false, "", $js);
include_once($path_to_root . "/includes/ui.inc");
include_once($path_to_root . "/sales/includes/db/sales_projects_db.inc");

simple_page_mode(true);

function can_process() {
    if (strlen($_POST['project_name']) == 0) {
        display_error(_("Project name can not be empty."));
        set_focus('project_name');
        return false;
    }

    if (strlen($_POST['contract_no']) == 0) {
        display_error(_("Contract number can not be empty."));
        set_focus('contract_no');
        return false;
    }
    return true;
}

if ($Mode == 'ADD_ITEM' && can_process()) {
    
}

if ($Mode == 'UPDATE_ITEM' && can_process()) {
    
}

if ($Mode == 'Delete') {
    
}

if ($Mode == 'RESET') {
    
}

$result = get_all_projects(check_value('show_inactive'));

start_form();
start_table(TABLESTYLE, "width=80%");

$th = array(_('Project No'), _('Project Name'), _('Contract No'), _('Customer'), _('Branch'), _('Value'), _('Type'), '', '');
inactive_control_column($th);
table_header($th);
$k = 0;
while ($myrow = db_fetch($result)) {
    alt_table_row_color($k);
    label_cell($myrow["project_no"]);
    label_cell($myrow["project_name"]);
    label_cell($myrow["contract_no"]);
    label_cell($myrow["name"]);
    label_cell($myrow["br_name"]);
    label_cell($myrow["value"]);
    label_cell($myrow["project_type"]);
    inactive_control_cell($myrow["project_no"], $myrow["inactive"], 'sales_projects', 'project_no');
    edit_button_cell("Edit" . $myrow['project_no'], _("Edit"));
    delete_button_cell("Delete" . $myrow['project_no'], _("Delete"));
    end_row();
}
inactive_control_row($th);
end_table();

br();

start_table(TABLESTYLE2);

if ($selected_id != -1) {

    if ($Mode == 'Edit') {
        $comments = $_POST['comments'];
    }
    hidden('selected_id', $selected_id);
} else {
    $comments = '';
}

text_row_ex(_("Project Name") . ':', 'project_name', 25);
text_row_ex(_("Contract No") . ':', 'contract_no', 25);
customer_list_row(_("Customer:"), 'customer_id', null, false, true, false, true);
customer_branches_list_row(_("Branch").':', $_POST['customer_id'], 'branch_id', null, false, true, true, true);
label_row(_("Currency:"), get_customer_currency($_POST['customer_id']));
amount_row(_("Project Value").':', 'value');
$branch = get_cust_branch($_POST['customer_id'], $_POST['branch_id']);
label_row(_("Business unit:"), get_sales_group_name($branch['group_no']));
project_type_row(_("Project Type").':','project_type');
date_row(_("Start").':', 'start_date');
date_row(_("End").':', 'end_date');
project_ref_row(_("Project Ref").':','ref_project');
textarea_row(_("Comments") . ':', 'comments',$comments, 25,3);
end_table(1);

submit_add_or_update_center($selected_id == -1, '', 'both');

end_form();
end_page();
?>

170

(5 replies, posted in Accounts Receivable)

By the way, why FA don't use jquery for ajax? I think it's easier and JsHttpRequest is already old (was made in2006, http://en.dklab.ru/lib/JsHttpRequest/).

171

(5 replies, posted in Accounts Receivable)

joe wrote:

There is no manual on how to use the ajax in FA.

To make it simple please have a look in /sales/includes/ui/sales_order_ui.inc

Look up the function display_order_header, line 258.

First in the function the $Ajax is defined as global.

$Ajax->update($name) can be used either for a single Control (the Control name) or a span of code with div_start($name) and div_end(), where you can declare your own name and use it in $Ajax->update.

Everytime the $Ajax->update is called the specific Control/code is called.

By looking at the code here, I guess you will get a first hint of how to use it.

/Joe



Thank you for your answer. I think this is the code :

       customer_list_row(_("Customer:"), 'customer_id', null, false, true, false, true);

        if ($order->customer_id != get_post('customer_id', -1)) {
            // customer has changed
            $Ajax->activate('branch_id');
        }
        customer_branches_list_row(_("Branch:"), $_POST['customer_id'], 'branch_id', null, false, true, true, true);


I don't know why, but, if I delete the if part, it still working. The code below still works like the code above. Do you know why?
       customer_list_row(_("Customer:"), 'customer_id', null, false, true, false, true);
       customer_branches_list_row(_("Branch:"), $_POST['customer_id'], 'branch_id', null, false, true, true, true);


And by the way, I already successfully created my modification of salesman per sales group. The issue is not the ajax, but the if part that trigger the ajax event.

172

(5 replies, posted in Accounts Receivable)

Hello,

I've been desperate with ajax in Frontaccounting, but my question in another thread is not answered. I don't know if there is no one who understand or no one whol willing to share their knowledge. Anyway, I'm just try to ask agan. I hope someone will give some of their knowledge or I must find another application that easier to modified.

What I want to modify is basically simple. I want to create some dropdown which has another dropdown as the parent. It's exactly like customer and branch dropdown in sales order entry. I want to create this with sales group and salesman. I already modified that a salesman has only one sales group. In customer branch, I want to add this dropdown function. I have already modified the UI for displaying the dropdown in sales group so that it has submit on change. I saw another example that use Ajax->activate. But nothing happen. I don't know what I must do because there is no clue and I cannot debug with my code inspector because the post in header is very difficult to understand. Anyone can help?

173

(2 replies, posted in FA Modifications)

The $Ajax is very mysterious in Frontaccounting

174

(10 replies, posted in Manufactoring)

joe wrote:

According to your last post, you are right. The standard cost is the average material and overhead cost over time.

So I guess this is just a learning process, right?

Joe


It's true for the first work order. But when I create another work order with different labour and overhead cost, I can not get from where the material cost, labour cost, and overhead cost. Another thing is my accountant told me that the price for manufactured item in inventory account is counted only from material. So, I wonder, which is right because in Frontaccounting, the price is calculated from total cost, including labour and overhead. Can you give me some accounting reference for this calculation? And maybe every calculation in Frontaccounting must have some guidelines so that we can crosscheck the calculation.

175

(10 replies, posted in Manufactoring)

I have some guess about this problem. Correct me if I'm wrong.

According to my example, the price for manufactured item in inventory account in general ledger is based from total sum of all cost (material, labour, and overhead).

I have my data like belom for item A (manufactured item)
material cost : 800
labor cost : 500
overhead cost : 200

When I open my balance and do an adjustment, the unit price is 1500 (total of all cost above). So, if I entered 10 items of A, the inventory account will have 15000.

I already confirmed this. Then, I test it with crate a work order that produce 1 A.  I test it wth advance manufactured and I don't enter the cost (I click release and then produce). The GL entry is like what I expected. My inventory account for manufactured item has increased exactly like the total value of material used. But the standard cost is changed so that it have many decimals. Why the value change? I don't know where is this value come from. Is it because I didn't enter any other cost, like overhead and labour cost? Is this value come from total value of manufactured item divided by total quantity?