3,126

(2 replies, posted in Wish List)

The discount on the Customer/supplier is in percent. When entering the discount during payment it should be in amount.
The percent discount is only there to indicate that there is a discount. Depending on the size of the payment amount the discount amount may differ, right?

/Joe

I just tried the operations a couple of times without problems. Any specific operations during creation/updating?
Maybe Janusz can throw a light on this.

BTW. The line numbers are not the same in my code, release 2.3.4. Which version?

/Joe

3,128

(6 replies, posted in Report Bugs here)

I would recommend the url http://infotechaccountants/fatraining for training or you should place this in the jobs wanted/offered forum.

/Joe

Hello,

You can void a payment in Setup tab, Void transactions.

/Joe

The positive or negative selections on Item Adjustments are here for safety. o you will need two Journals to operate this.

/Joe

Your SOAP API has now been placed on our Download Release 2.3 page. We have reorganized our downloads quite a bit now, so it should be more user friendly.

Please don't forget to send me a company logo and short description of your company for publishing on our partner page.

/Joe

3,132

(18 replies, posted in Setup)

It doesn't seem to be uploaded to the repository. I can't find any COA for Italy. If you have any, please tell me.

/Joe

Very good tclim. Thank you so much for your decision. We appreciate. Please send your logo and text to our partner site smile

/Joe

3,134

(3 replies, posted in Accounts Receivable)

When you create a direct invoice, a delivery is created in the background. These background documents get the reference 'auto'. As you don't use them, just let them be.

/Joe

Instructions from Janusz
--------------------------------

If you want use the module only locally, there is no need for _init directory at all. If extension is of type theme, chart, language, or it contains only additional reports there is even no need for hooks.php file. For any more complex extension module you have to create hooks.php file containing class definition 'hooks_name_of_the_package' derived from hooks class found in includes/hooks.php. Methods of this class (if defined) are used for module integration with various FrontAccounting parts. Most important hooks are:
* install_tabs() - adds new tabs in FA menu;
* install_options() - adds option to various FA menus;
* install_access() - allow additional permission levels to be defined for module's pages;
* install_extension() - called on extension installation;
* activate_extension() - called when extension is activated for selected company.

All the available hook methods are described in includes/hooks.inc file, and the hook files bundled with extensions in FA central repo can be used as examples.

If you create extension which you want to be placed in central FrontAccounting repository, you should create only single additional _init/config file containing following information used during install/preview:

Package: single_word_package_name
Version: 2.3.4
Name: One line description  of the package
Description: Longer description of the package content. Can be 
 continued on following lines providing the first char in line is space.
Author: name and <email of the author>
Maintenance: name and email of current maintainer (or the author)
Homepage: address of related www page
Type: extension or chart or language or theme
InstallPath: modules/folder_name

That's all. Before the package is placed in repository we make some rough code audit and create all the other needed auxiliary files, so you can don't care about them.

Janusz

3,136

(9 replies, posted in Wish List)

These attachment links have now been added after Sales Invoice, Sales Credit, Inventory Adjustments, Work Order entry (assemble), Bank Payments and Journal Entry. These should be the most popular places.
Before it was already added for Supplier Invoice and Supplier Credit.

Tell me if you need more places.

The HG repository has been updated and the changes will go to minor release 2.3.5.

/Joe

3,137

(9 replies, posted in Wish List)

I guess you mean attaching documents from all input forms like Sales Invoice, Journal entry etc. just like after Supplier Invoice, right?

/Joe

Cool,
Are there any chance that you will let the REST Webservice API as GPL in some version (LGPL or so).

This would even inspire others to make bridges.

Best regards

/Joe

I cannot reproduce this. ST_SUPPCREDIT (21) types are included correctly here.

Please try this SQL statement directly in your phpMyAdmin.

SELECT 
    IF(trans_type=11 || trans_type=20 || trans_type=0,-1,1)*
    IF(trans_type=2 || trans_type=10 || (trans_type=0 AND amount<0)
         || trans_type=11, net_amount*ex_rate,0) net_output,

    IF(trans_type=11 || trans_type=20 || trans_type=0,-1,1)*
    IF(trans_type=2 || trans_type=10 || (trans_type=0 AND amount<0)
         || trans_type=11, amount*ex_rate,0) payable,

    IF(trans_type=11 || trans_type=20,-1,1)*
    IF(trans_type=2 || trans_type=10 || (trans_type=0 AND amount<0)
         || trans_type=11, 0, net_amount*ex_rate) net_input,

    IF(trans_type=11 || trans_type=20,-1,1)*
    IF(trans_type=2 || trans_type=10 || (trans_type=0 AND amount<0)
         || trans_type=11, 0, amount*ex_rate) collectible,
    taxrec.trans_type,
    taxrec.trans_no,
    taxrec.tran_date,
    taxrec.rate,
    ttype.id,
    ttype.name
        FROM 0_tax_types ttype,
             0_trans_tax_details taxrec
        WHERE taxrec.tax_type_id=ttype.id
            AND taxrec.trans_type != 13
            AND taxrec.tran_date >= '2011-05-01'
            AND taxrec.tran_date <= '2011-05-31'

You may need to change the tran_date period. Here you should see the trans_type 21 (ST_SUPPCREDIT).

/Joe

This is highly interesting, tclim. I have looked at both the Portal with vtiger etc. and the Accounting Mobile Edition. Both look promissing.

Tell me if you want us to place a link on the Partner page at our Website, with a logo and description. You can address me directly with this.

/Joe

3,141

(1 replies, posted in Accounts Receivable)

There is only a minimal POS feature, under Setup tab, in FA.

If you need further options, you may search the forum for ideas about this.

/Joe

Sorry, by simple assembly I meant Assembly.
Yes you should create new unit of measures and use these.

The Assembly is not the quite the same as the Advances Manufacturing. Just like is says, assembles some items.

Yes, you need to create a BOM for them, but you only have to do that once.

/Joe

3,143

(1 replies, posted in FA Modifications)

No, we are using Mercurier (HG) now:

https://frontaccounting.hg.sourceforge.net/hgweb/frontaccounting/frontaccounting

/Joe

3,144

(5 replies, posted in Dimensions)

Oh, there is a bug in the calculation of balance for dimensions. There was a double db_escape in /dimensions/includes/dimensions_db.inc. Fixed in HG repository.
There was also a bug in /dimensions/view/view_dimension.php. Changing the dates here didn't process a new query. Fixed in HG repository.

Thanks for reporting this.

/Joe

3,145

(2 replies, posted in Reporting)

I guess this has been fixed, or at least it is fixed in the HG repository and will come in next minor release 2.3.5.

/Joe

Hello,

You should create an Item, pens, and use the Inventory adjustment (or POs) to add your stock of pens.

You can use manufacturing simple assembly to create your various boxes. And for every box you create a bom. Then create work orders as you need them.

Every time you create a work order, the pens are reduced from stock and the new box is increased.

If you have a Training Co. you can experiment with this until you are satisfied.

/Joe

3,147

(14 replies, posted in Accounts Receivable)

You are using the 'Search Customer List' that is enabled in Company Setup, Setup tab.
If you don't have that many customers you can unmark this Search and everything works 'normally'.

/Joe

No it is not. The delivery phase is called with reference 'auto' . During the delivery the GL transactions for inventory and COGS are done as well as the stock moves outwards.
You don't have to use the deliveries to anything further. They occupy a transaction record in debtor_trans table.

/Joe

Under the Salesman, in Sales tab, you can set the salesman to 0%. Breakpoint 1000 and then 1%. Further operations are not possible.

If you want more sophisticated sales reports you can select the Excel as destination and use columns for further calculations.

/Joe

The script file en_US-new.sql is empty for transactions. Only the Chart of Accounts and a couple of managed records, that are easily changed.

I don't know why your script-file is filled with transactions. Are you sure you didn't use the en_US-demo.sql, whitch is meant as a training script?

/Joe