2,751

(4 replies, posted in Setup)

No, this is too complex. You will have to do another correct cost update.

/Joe

This is the sales_type from the Price List.

/Joe

Yes this sounds reasonable. We will establish a global variable in config.php file for this to work in the next minor release.
In the meantime you can do the following change in /reporting/rep107.php at line 121

                if ($Net != 0.0)
                {
                    $rep->TextCol(2, 3,    $DisplayQty, -2);
                    $rep->TextCol(3, 4,    $myrow2['units'], -2);
                    $rep->TextCol(4, 5,    $DisplayPrice, -2);
                    $rep->TextCol(5, 6,    $DisplayDiscount, -2);
                    $rep->TextCol(6, 7,    $DisplayNet, -2);
                }    

If you also want to do this in the deliveries please change adequate in /reporting/rep110.php line 130.

/Joe

Please go into Company Setup, Setup tab, and unmark the Search Customer List.

/Joe

Hello Fred,

You go into Access Setup in Setup tab. Select the set of role and lookup the new extension and mark it.

/Joe

2,756

(4 replies, posted in Reporting)

I hope some of the implementors will contribute to this topic. It is easy to be totally confused when trying to follow the algorithms. The only thing is that I know it works. Nobody else have complained.

/Joe

2,757

(35 replies, posted in Translations)

Thanks, hopefully Janusz will update the repository asap.

/Joe

2,758

(5 replies, posted in Manufactoring)

Because the BOM is always 'issued' to the work order. Issuing items here is additional.

/Joe

2,759

(4 replies, posted in Reporting)

This is a very complex calculation and has been implemented by several using this fascility. Please be patient. this should work.

/Joe

2,760

(2 replies, posted in Setup)

Please enter Company Setup in Setup tab. Unmark 'Search Supplier List'. That should do it.

/Joe

Yes, you need to enter Access Level setup and mark the new extension.

/Joe

2,762

(8 replies, posted in Accounts Receivable)

1. I am not sure how to fix this. Maybe some of the users out there can help us.

2-3-4-5. The fill of the fields depends on which type of document it is. Due Date is the last date for paying the invoices.

If you want to change the text, then re-edit the line after it has been added.

Please also read the Wiki, http;//frontaccounting.com/fawiki for more details.

/Joe

2,763

(1 replies, posted in Banking and General Ledger)

I guess you should consult an accountant. However I think you should create tow tax types, 21 and 23 %.
Also create 2 tax groups (f.i. tax 2011 and tax 2012).
Then when creating documents you should swap the tax group on your customers/suppliers depending on which year you are working on.

I guess this will be the best solution.

/Joe

When we fixed it a couple of months ago, it was only fixed in the customer transactions. I forgot to fix it correctly in Journal Inquiry.
It should only be allowed to edit the sales invoices when there are no allocations. The complexity is too huge for fixing this.

/Joe

I see that you have used the Journal Inquiry for editing the sales invoice. The Journal Inquiry shouldn't have allowed you to edit allocated invoices. This is a bug.
In Customer Transactions you are not allowed to edit allocated invoices.
This bug is fixed in HG repository and come in the next minor release.

You can also replace this function on line 106 in /gl/inquiry/journal_inquiry.php.

function edit_link($row)
{
    global $editors;

    $ok = true;
    if ($row['type'] == ST_SALESINVOICE)
    {
        $myrow = get_customer_trans($row["type_no"], $row["type"]);
        if ($myrow['alloc'] != 0 || get_voided_entry(ST_SALESINVOICE, $row["type_no"]) !== false)
            $ok = false;
    }        
    return isset($editors[$row["type"]]) && !is_closed_trans($row["type"], $row["type_no"]) && $ok ? 
        pager_link(_("Edit"), 
            sprintf($editors[$row["type"]], $row["type_no"], $row["type"]),
            ICON_EDIT) : '';
}

/Joe

2,766

(17 replies, posted in FA Modifications)

ok, elax, please continue report files and lines that need the new floatcmp filter.

The following files have been updated in the HG repository:
/reporting/rep101.php
/reporting/rep102.php
/reporting/rep201.php
/reporting/rep202.php
/sales/inquiry/customer_inquiry.php

Other files will be added as we find more.

The theme exclusive has been updated for this about a month ago. Please re-install.

/Joe

2,767

(17 replies, posted in FA Modifications)

elax, please add the following lines in /includes/current_user.inc after the function number_format2

/* price/float comparision helper to be used in any suspicious place for zero values? 
usage:
if (!floatcmp($value1, $value2)) 
    compare value is 0
*/

define('FLOAT_COMP_DELTA', 0.0000001);

function floatcmp($a, $b)
{
    return $a - $b > FLOAT_COMP_DELTA ? 1 : $b - $a > FLOAT_COMP_DELTA ? -1 : 0;
}

and see if it is ok with the floatcmp.
reporting/rep102.php had alreade a filter in the sql used in the file.

/Joe

2,768

(17 replies, posted in FA Modifications)

Thanks elan,

If you have a detailed list of these happenings, I will gladly change the filter.

/Joe

2,769

(2 replies, posted in Wish List)

There are no POS module in FA, however there is a simple POS system in the Setup tab.

/Joe

2,770

(4 replies, posted in Setup)

Maybe there are some UK users here who can give you some tip.

/Joe

2,771

(17 replies, posted in FA Modifications)

It is not the double precission that causes this problem. Consider the following:

When you pay and allocate customers/suppliers in another currency than the customer/supplier there would occasionally be a small leftover, either positive or negative in the AR/AP ledger. FA does not consider the record as fully paid. That is the reason for doing the check for either 0.0001 or 1e-6 to check that the record is 'paid'.

So I guess we can can continue with double precission.

/Joe

You should set the AP account on the supplier to be the same as the account you book the debet value from the payment.
Using this approach as you do you should consult an accountant to do the right things.
We do not have the resources to help you with accountancy problems.

/Joe

In FA it works al follows:
Register the Down Payment (this will also create a GL journal.
Register the Supplier Invoice. After that goto Allocate Supplier Payments or Credit Notes and pickup your Down Payment and allocate your supplier invoice and save it.
This will take care of everything.

/Joe

2,774

(9 replies, posted in Modules Add-on's)

Compare the active extensions (those without the ; in front) with your own.

/Joe

I would rather use the Bank Deposit form in Banking and General Ledger for doing that. here you can select which credit account you want to use.

/Joe