Wait till April 1st, 2017. Excise will be merged into GST (if the parliament is allowed to function)....

In the meanwhile, Arrange for an invoice type that bills a dummy client.... and gets return of goods when transferred to another client / location. Sometimes, Excise can be treated as a commission agent (Sales Person) as well.....

Alternatively treat it as warehouse transfers and keep the excise offline.

Treating the goods as a manufactured item and the final destination as the real client, Excise can become a Manufacturing service cost with reversibility on manufacture and return to warehouse.

Treat Fuel as an Inventory Item. Enter a large stock quantity as Opening Balance. Reset to large stock quantity when it nears exhaustion.

Alternatively, use Tags / Dimensions for Fuel purchases.

3,228

(1 replies, posted in Report Bugs here)

@joe: Thanks for the commit.

3,229

(12 replies, posted in Report Bugs here)

Quickfix @joe. Thanks.

Line 53 in the new file:

        AND (line.debtor_trans_type = ".ST_SALESINVOICE." OR line.debtor_trans_type = ".ST_CUSTCREDIT.")";

may also be

        AND (line.debtor_trans_type IN (".ST_SALESINVOICE.", ".ST_CUSTCREDIT."))";

This way, when more transaction types needs to be added, it would be easily readable.

Please commit it.

3,230

(1 replies, posted in Report Bugs here)

FA 2.4RC1 bug 3667 has been fixed here.
It has been backported to FA 2.3.25+ in my repo's FAMods.

@joe: Kindly backport this to the official stable repo as well.

3,231

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

SMS gateways are commercial devices and / or service URLs from your mobile service provider or bulk SMS provider. Most such services 'have' / 'allow to format' a mobile number like an email address for sending SMS. Use such email ids in FrontAccounting for the customer / supplier.

No change is needed to FrontAccounting.

3,232

(12 replies, posted in Report Bugs here)

@joe: Boxygen's claim needs to be checked for reporting consistency.

The Wiki states:

Purpose

Generate a credit note for customer reimbursement.

Procedure

Enter each line item as if a Sales Order were being entered. If the material is to be returned to stock, select the correct option from the Credit Note Type combo-box and location/warehouse it is being be returned to. Otherwise (Items Written Off), if material is NOT going to be returned to stock (credit only) select the GL Account to be adjusted.

If there is no material involved and a mere credit note is desired to be passed on to a customer by way of say discount amount in settlement after the invoice was raised, there is no place to enter the amount other than in Shipping. It is possible to create a dummy service item assigned with negative amount during Customer Credit Note creation to accommodate this situation.

Tips and Tricks

If some material will be returned to stock, but others won't, they will need to be on separate credit notes.

The actual screenshot is attached, where there is no list of GL Accounts to select from for Credit Note Type.

When the Credit Note Type "Items Written Off" is selected, then the GL Accounts list comes up and if the default sales account was chosen for the customer branch then choose the Sales Account (4010) in the Standard US CoA.

3,234

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

Look in the modules folder's sub-folder of the extension used. The name of the extension's folder path is listed in the installed_extensions.php file.

3,235

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

It is possible that the module's files are accepting only integers as account numbers.

The es_MX translation is available in my repo - fill in / update the missing translations and forward to the forum and to the official repo.

Journal Voucher can be passed for this.

3,238

(0 replies, posted in Announcements)

There has been a growing interest in FA since July 2016 as the attachment shows.

3,239

(6 replies, posted in Report Bugs here)

@itronics: committed in the official repo.

3,240

(6 replies, posted in Report Bugs here)

There is a need to investigate / discuss the matter at hand and also look at it in the light of another issue in the bug tracker that @itronics is looking at.

My unofficial repo has the core folder in synch with the main FA repo's master branch only and my modifications are in another folder - FAMods. Yet another folder has the expanded out extensions as well. Hence it is not possible to provide a pull request from my GitHub Repo to the upstream one's master branch.

3,241

(6 replies, posted in Report Bugs here)

@joe: In FA 2.3 please change lines 179-180 in sales/includes/db/sales_invoice_db.inc:

            update_debtor_trans_allocation(ST_SALESINVOICE, $invoice_no, $amount);
            update_debtor_trans_allocation(ST_CUSTPAYMENT, $pmtno, $amount);

to

            update_debtor_trans_allocation(ST_SALESINVOICE, $invoice_no);
            update_debtor_trans_allocation(ST_CUSTPAYMENT, $pmtno);

It is pertinent to note that the third parameter in the function update_debtor_trans_allocation in sales/includes/db/custalloc_db.inc is only available in FA 2.4.x and that too it is a person_id and not an amount.

Fixed inmy unofficial repo's FAMods. Fixed in the core now (2016-11-14).

Going forward, if there are any changes in the parameters of functions, a global search and replace as needed should be done and it should fulfill all such usages.

3,242

(6 replies, posted in Report Bugs here)

Yes, the mantis is used for all except simple bugs.

Checkout: http://mantis.frontaccounting.com/view.php?id=3697
Your Bug report http://mantis.frontaccounting.com/view.php?id=3696 has been fixed on 28th May 2014 itself and it is possible you are using a very old version of FA.

3,243

(1 replies, posted in Setup)

On a fresh install now everything appears okay!

3,244

(1 replies, posted in Setup)

Testing out the FA 2.3.25+ master on GitHub as a fresh install with demo data has the auto_update field in the currencies table as checked (1).

1. Navigate to Banking & General Ledger => Currencies
2. Choose to edit any non-default currency.
    Error 1: The inactive flag gets enabled wrongly
3. Try to uncheck the auto_update field in the UI.
    It will return as successful.
    Error 2: The currencies table auto_update field and the table display do not get updated!

Check if it is made into a "Bank Account" whether it would work.

http://www.anterp.com gets redirected to https://acoffeeshops.com/ which uses OpenCart.

See if the SOAP Service of ANTerp is what you need in:
https://frontaccounting.com/wbt/pages/download/download-release-2.3.php

3,247

(18 replies, posted in Report Bugs here)

State which version of FA you are using and what what versions of PHP/MySQL/OS for the server.
Test with the latest version of the stable FA Release.

3,248

(0 replies, posted in FA Modifications)

When the default currency is chosen on the exchange rates page, we can choose to have the list of last exchange rates displayed as per my FA v2.3.25 mod committed in my FAMods folder.

@joe: can integrate it with the standard paged table constructs and port to FA 2.4 as well.

1. Create and assign a role (with or without FA core editions) to a user with such restrictions. Quick Entries may be used as well.
2. Sub Ledgers are currently available and reporting can be summary or detailed (need to hack the repXXX.php files). Account tags may be useful here as they are already available as filters in the reports.
3. Need an extension with a separate field that lists those that need approval.

3,250

(3 replies, posted in FA Modifications)

DNS poisoning, blacklisting and simply it's temporary non availability have made us use this choice and order. Timeouts are not because of IP but some setting - php.ini, httpd.conf, etc.