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.
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by kvvaradha
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.
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.
There is no cost estimation module available. But you can use the sales quote as estimation.
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') . "'";
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 .
I think the pdf will work better to show the informations.
@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.
@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.
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.
FrontAccounting forum → Posts by kvvaradha
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.