Error 500  will occur, when your directory doesnot have permission to access the files.

You better check godaddy to resolve 500 error. Check with godaddy call center and update us.

Yes, When i tried to delete the fiscal year, it encountered an error

Undefined variable: total in file: /var/www/FrontAccounting/admin/db/fiscalyears_db.inc at line 377

I think it has the solution from the previous versions.

803

(8 replies, posted in FA Modifications)

Time functionalities are not programmed in existing FA. If you wish to use date and time picker you need to find a JavaScript or jQuery plugin to use and then you need to disable the FA date picker and use the new one. But you have to change some programs to maintain FA date formats into the new plugin formats.

i guess it would be like this

For VAT Payment
                                        Debit            Credit
VAT account COA               XXXXXX
Bank Account                                        XXXXXXX

For VAT Repayment

                                          Debit            Credit
VAT account COA                                     XXXXXX
Bank Account                      XXXXXXX

I hope it helps.

Also i forget to write it. Even if we void the supplier invoice and we can able to void the GRN.

Yes,  I found an issue with Voiding Transaction. Let me explain the case.   I am just placing an direct GRN to receive 10 quantity of an item.  And I didn't make supplier invoice yet.

Than i made a sales of 5 quantity for the same item and now the stock balance is 5 quantity.  Now I am voiding the Direct GRN.

Actually the system has to stop me from voiding this Direct GRN. But it allows me to void the GRN. and stock goes to negative.

Also I found solution for this problem.

if (!exist_transaction($_POST['filterType'],$_POST['trans_no']))
        {
            display_error(_("The entered transaction does not exist or cannot be voided."));
            unset($_POST['trans_no']);
            unset($_POST['memo_']);
            unset($_POST['date_']);
            submit_center('ProcessVoiding', _("Void Transaction"), true, '', 'default');
        }
        else
        {
            display_warning(_("Are you sure you want to void this transaction ? This action cannot be undone."), 0, 1);
            br();
            submit_center_first('ConfirmVoiding', _("Proceed"), '', true);
            submit_center_last('CancelVoiding', _("Cancel"), '', 'cancel');
        }

This is default code. If we change it to be like this.

 if (!exist_transaction($_POST['filterType'],$_POST['trans_no']))
        {
            display_error(_("The entered transaction does not exist or cannot be voided."));
            unset($_POST['trans_no']);
            unset($_POST['memo_']);
            unset($_POST['date_']);
            submit_center('ProcessVoiding', _("Void Transaction"), true, '', 'default');
        }   else     {
            if($_POST['filterType'] == ST_SUPPRECEIVE){ 
                $result = get_grn_items($_POST['trans_no']);
                 if (db_num_rows($result) > 0)   {
                    while ($myrow = db_fetch($result))        {
                        if (is_inventory_item($myrow["item_code"]))    {
                            if (check_negative_stock($myrow["item_code"], -$myrow["qty_recd"], null, $_POST['date_']))    {
                                $stock = get_item($myrow["item_code"]);
                                display_error(_("The void cannot be processed because there is an insufficient quantity for item:") .
                                    " " . $stock['stock_id'] . " - " . $stock['description'] . " - " .
                                    _("Quantity On Hand") . " = " . number_format2(get_qoh_on_date($stock['stock_id'], null, 
                                    $_POST['date_']), get_qty_dec($stock['stock_id'])));
                                return false;
                            }
                        }
                    }
                }
            }
            display_warning(_("Are you sure you want to void this transaction ? This action cannot be undone."), 0, 1);
            br();
            submit_center_first('ConfirmVoiding', _("Proceed"), '', true);
            submit_center_last('CancelVoiding', _("Cancel"), '', 'cancel');
        }

I think it has only unit price.  Its not showing the total sales cost to get tax informations there.   If you wish to bring tax means, you need to change the unit price and total sales cost with tax rate.

808

(9 replies, posted in Manufactoring)

There is no cost estimation  module available. But you can use the sales quote as estimation.

809

(5 replies, posted in Setup)

This is good to use when the customers has more categories and each one has more items.

But the feature has to be used in reports page mainly. 

Rep306 - Inventory Purchasing Report    has the items category, when the user select a category, we can shortlist the items in the list on the next drop down.  So its good to use this feature.

And i have one more suggestion, if possible we can use the "get_post()" within the list function like this.

if (get_post('category') )
        $sql .= " AND s.category_id='" . get_post('category') . "'";

810

(3 replies, posted in Setup)

You can connect it by using the hostname of remote database.  If you are using Cpanel. you can configure the remote Server IP to make it work on.

If you are using plain VPS without cpanels. try with the server ip address instead of the "localhost".

You have to do it like this.

1. First install a new copy of FA 2.3.26
2. Get backup from 2.3.24
3. Import it to the database to freshly installed FA 2.3.26
4. Now, goto the exports page and export it from FA2.3.26
5. Download a fresh stable FA 2.4.4 and install it without demo data.
6.  Goto backup and restore, and import the file you exported from Fa 2.3.26
7. Now goto upgrade and upgrade it.

It will upgrade your database to newer version. 

This procedure i followed it for FA 2.4.1 upgrade from 2.3.19 So it might work If you have problem with 2.4.4.than go with 2.4.1 and than again one more upgrade to 2.4.4

Hope this helps.

1. Create sales invoice with delayed payment.
2. After creating sales invoice you have an option for payment, just enter 300 payment first time.
3. Goto Banking and GL ledger -> Bank Deposits
  Here from -> customers and below a drop down appears with customers list , just select the customer and select the bank account. And put 600 payment there and process it.
4. For debit, goto -> journal entry under the same menu and debit the money with journal entries .

813

(3 replies, posted in Installation)

I think the pdf will work better to show the  informations.

FrontAccountingWiki-Main-installation.

814

(10 replies, posted in Items and Inventory)

@apmuthu,  nayaspp is right, the issue is the core javascript tries to create option to textbox,  Its a core bug, i will try to fix it, when its drop down it works fine.  But when the drop down changed to textbox, its not possible to add the item here.

For now items based discount is available to use.  But you can program to make it work

From the debtor_trans table, you can see a column  ov_discount,  and use that field and make the customized program on sales_order_ui.inc as well as its related view pages and pdf files.  you need to change in several places to take efffect.

@poncho, You dont need to get confused much with this.  Because the extension hook will replace the existing functionality.  The Perfect example is Access security roles. When you define a custom one but it uses the existing system access role numbers, it will override the access permission with new one.

Last, Yes the Wiki talks about the security roles and access permissions.

@notrinos,  I tested it with the above code before I post here.  Otherwise I will further add a sentence to "test it on your own". It should work.  Because while I was programming some other module I did it by mistake and it replaced inventory module that time.

@poncho, I think you are complicating yourself for a simple thing.  You wanted to replace the Tabs for example Purchase with your custom module of Purchase, right,   

Anyhow you have a hook.php file which will inherit the application and create new constructor to create tab for your custom modules. Just use the exiting Slug,it will replace the existing with your module.

Here is my example code for you to understand it .

 
class Kvcodes_app extends application{
    var $apps;
    function __construct()  {
      parent::__construct("AP", _($this->help_context = "&Kvcodes"));
    }
}

This will simply replace your purchase module with Kvcodes and here you have to add the further functions. to replace the links under the menu,

Enable Debugging mode, to know the issues.

You can see the error_log afterwards. If you still stuck with issue PM or Email me to check the details from your server.

Batch number system will be open source, but the Batch number and Expiry Date together will be Commercial one, because I have put much more effort in it.

I think, there is one more thing, we need to fix in void transactions.

When we try to void a GRN, and with that GRN void, if the inventory goes negative But the user didnt check the "Allow Negative Inventory". we have to prevent it by showing a warning, the inventory may goes negative.

822

(2 replies, posted in Reporting)

@Prabha,  You can't set different headers with help of SetHeaderType. 

But i can advice you to check the "Tax Reports" rep709.php. Here first layout will be for the list of taxes and its details. the last page will be the summary of the Tax as per the tax types.  you can check the functionality of providing different  page headers here.

Good luck

@dhanakumar,  I have already developed expiry date with the batch number.  you can demo it here. 

http://demo.kvcodes.com/BATCH  and the same username and password to login and check it

The  auto entries created, when the stock goes negative.   If you disable the Allow Negative Inventory, the stock may go negative. the entries created to balance the GL entries

When you have 10 items from Purchase GRN and which has not placed Invoice and you made sales for 5 items and after that,if you void the GRN, the stock will go 5 items negative. When this situation comes the entries are created automatically.

825

(29 replies, posted in Installation)

You need to provide page permission to your login.   

Here is the procedure to provide it.

Goto Setup ->Access setup

Here select " Your role (System Administrator as main login access).  and scroll to end and there are some checkboxes, check them all. Each main checkbox will show some more by extending the list.

check them all and click "Save Role" 

Than logout and login again. You can able to access those pages.