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 boxygen
Hello,
In customer_invoice.php the following code is ineffective I think or may be I am not able to find the way how it works.
if (isset($_POST['_InvoiceDate_changed'])) {
$_POST['due_date'] = get_invoice_duedate($_SESSION['Items']->payment, $_POST['InvoiceDate']);
$Ajax->activate('due_date');
}Reason of checking this code is that I am facing problem that when I am changing the Invoice Date then It is not changing the Due date. How shall I expect this to work?
You don't need to add a field rather you can define a new account in Chart of Accounts name Cash
Hello all,
I was able to integrate this.
Download gridphp.com and add it to the root folder of FA.
Copy the following code in the page where you want to show the Grid and set the $path_to_root with respect to the location of file.
<?php
/**
* PHP Grid Component
*
* @author Abu Ghufran <gridphp@gmail.com> - http://www.phpgrid.org
* @version 2.0.0
* @license: see license.txt included in package
*/
$page_security = 'SA_OPEN';
$path_to_root="../..";
include($path_to_root . "/includes/session.inc");
add_css_file($path_to_root."/gridphp/lib/js/themes/redmond/jquery-ui.custom.css");
add_css_file($path_to_root."/gridphp/lib/js/jqgrid/css/ui.jqgrid.css");
add_js_ufile($path_to_root."/gridphp/lib/js/jquery.min.js");
add_js_ufile($path_to_root."/gridphp/lib/js/jqgrid/js/i18n/grid.locale-en.js");
add_js_ufile($path_to_root."/gridphp/lib/js/jqgrid/js/jquery.jqGrid.min.js");
add_js_ufile($path_to_root."/gridphp/lib/js/themes/jquery-ui.custom.min.js");
// include and create object
include_once ($path_to_root."/gridphp/lib/inc/jqgrid_dist.php");
$server = $db_connections[user_company()]['host'];
$user = $db_connections[user_company()]['dbuser'];
$password = $db_connections[user_company()]['dbpassword'];
$database = $db_connections[user_company()]['dbname'];
$db_conf = array(
"type" => 'mysqli',
"server" => $server,
"user" => $user,
"password" => $password,
"database" => $database
);
$g = new jqgrid($db_conf);
$grid["rowNum"] = 10; // by default 20
$grid["sortname"] = 'id'; // by default sort grid by this field
$grid["caption"] = "Invoice Data"; // caption of grid
$grid["autowidth"] = false; // expand grid to screen width
$grid["multiselect"] = true; // allow you to multi-select through checkboxes
$grid["form"]["position"] = "center";
$grid["shrinkToFit"] = false;
$g->set_options($grid);
$g->set_actions(array(
"add"=>true, // allow/disallow add
"edit"=>true, // allow/disallow edit
"delete"=>true, // allow/disallow delete
"view"=>true, // allow/disallow delete
"rowactions"=>true, // show/hide row wise edit/del/save option
"search" => "advance", // show single/multi field search condition (e.g. simple or advance)
"showhidecolumns" => false
)
);
$g->select_command = "SELECT * FROM dimensions where id < 85";
$g->table = "dimensions";
// this db table will be used for add,edit,delete
$g->table = "invheader";
// pass the cooked columns to grid
$g->set_columns($cols);
// generate grid output, with unique grid name as 'list1'
$out = $g->render("list1");
page(_($help_context = "Dimensions"), false);
echo '<div style="margin:10px">';
echo $out;
div_end();
end_page();
?>Hello
I was trying to integrate gridphp.com in FA.
Facing this error. May be some JS is conflicting. Can anyone help?
I am using the references as {0001}/{MM}{YY}
It works perfectly but sometimes (not always) the reference is auto updated to Legacy values. For e.g at times I see that the new month is started but it is continuing the sequence of old month. Upon checking the transaction references I found that the pattern was auto set to Legacy.
I tried to debug the issue but since it is not doing all the time I could not catch it.
Any idea how to catch and fix the bug?
I wanted to use the translation function for some quick translations. For e.g. some clients they want to see the word dimensions as cost centers. So instead of changing the text in code or adding a translation file I just want to add some quick translations using the translation function.
Any help is appreciated?
Hello, just curious to know what is the use of these two functions? Can we change the functionality using any module using this hook?
Hello,
In includes/lang/languages.inc at the bottom the conditional definition of function _($text) is there.
I was wondering where is the actual definition of this function.
PHP gettext extension works with php_extension in php.ini.
Create a Direct Delivery as below
Create Partial Invoice of the Delivery as Below
Now void this newly created invoice and then again create a Invoice for the delivery. You will find the wrong updated qty_done as below
Hello, Recently due to some changes in output of EXCHANGE-RATES.ORG the current code is not retrieving Exchange Rate.
Following fix is needed.
/gl/includes/db/gl_db_rates.inc
Line # 240 Replace
$val = getInnerStr($contents, '<span id="ctl00_M_lblToAmount">', '<');
$val = str_replace (',', '', $val);with
$val = getInnerStr($contents, "1 $curr_b = ",$curr_a);Thanks @Braath and @Varadha for your suggestions.
Inventory Valuation Report Served the subject for me. Now my Trial Balance is giving exactly the same value of Inventory as that of Inventory Valuation Report. I had to set $use_costed_values = 1 in config.php. This I tested for any Date.
But now I am facing a very strange issue that I had to dig out after hours.
Here is the Screen shot of the Database.
This is one item's records in stock_moves table which is fetch by Inventory Valuation Report to calculate average cost in the function getAverageCost
Now the below condition is calculating wrong average cost because in one record the standard_cost is ZERO as highlighted in above image.
What is the purpose of this condition? And I don't know why the standard_cost is set to ZERO for that line in first image?
If I remove this condition my Inventory Valuation is perfect. But I am unable to understand why this condition was applied earlier.
Here is the Screen Shot of Inventory Valuation Report
Any idea?
I am facing a challenge.
In one FA installation with many inventory items, the opening inventory was recorded at a cost and that was averaged out with purchases, voiding of transactions, inventory adjustments etc and current inventory is at average cost.
Now If I see the inventory valuation report of the first day of the fiscal year it is not giving the actual value of the inventory rather the averaged out value. Now auditor want's to see the actual value of the opening inventory.
Is there any way out to give him report.
We have a function handle_negative_inventory() in includes/db/inventory_db.inc.
This function performs action when inventory of an stock is going to be negative or ZERO with following condition.
if ($qoh + $quantity <= 0 && $qoh > 0) //Positive inventory turning zero/negative
But I think this should only check if Inventory is going to be negative. Zero Inventory is not an issue while Negative inventory is an issue.
I may be wrong in a broader scenarios but in one recent scenario I found the condition to be as below.
if ($qoh + $quantity < 0 && $qoh > 0) //Positive inventory turning negative
Just putting it here so that may get some expert advices.
Regards.
While voiding work order the following error comes
The possible fix could be following.
@@ -161,7 +161,7 @@ function void_work_order_produce($type_no)
return;
// deduct the quantity of this production from the parent work order
- work_order_update_finished_quantity($prod["workorder_id"], -$prod["quantity"], false);
+ work_order_update_finished_quantity($prod["workorder_id"], -$prod["quantity"], 0);
Sometimes the Users mouse is speedy and single click causes double click on Place Invoice button.
FA takes it as double input and creates 2 invoices of same value.
This is very irritating and sometimes not caught instantly.
Is there any workaround to prevent this? To disable the button after First click?
Hello,
I found one bug in purchasing/includes/db/invoice_db.inc Line # 500.
This should be
$details_row['quantity_inv'],instead of this
$details_row['quantity_inv']-$details_row["quantity"],Otherwise it is not showing Quantity Invoiced on Supplier Credit page as shown in image below. While the Quantity Invoiced should be 10
I tried to figure out if this option is useful any other way. But I couldn't. May be I have overlooked something. But as far as Supplier Credit is concerned this should be fixed.
I am sorry to bother you. Actually I was trying on my custom theme and in that theme I am using Select2 for drop down. In that theme the COGS dropdown is not retaining focus when I hit tab from Price before Tax. While it is working fine on default theme on the same installation with same data. I will try to fix it.
One thing I need to ask is that while we are importing goods from foreign supplier hence different currency. But the Local Expenses are in Local currency. Is this also handled in this Modification?
Anyway this is a very useful modification and very beautifully placed in the current UI.
Bundle of thanks.
No, not the Ajax is running on COGS menu rather it is running on the Price Before Tax as shown in image . When the focus shifts from Price Box to COGS menu the Ajax runs and bring the focus back to Price box.
One idea, but I haven't tried it out yet.
https://github.com/apmuthu/frontac24/pull/7 allows service costs to be wrapped into purchased item costs on a single P/O or direct invoice and offers three methods for the calculation.
Thus, using the example offered, each computer is $100 and 10 computers are ordered. A Freight service item for $100 is added to the P/O, and using the Quantity method, the price of the computer is automatically recalculated to $110 and the service item is zeroed.
While this does not directly address the issue of wrapping in P/Os from multiple vendors, such as DHL, it may be possible to do this by leaving the P/O open until the DHL bill arrives:
1. When the DHL bill comes in, add the freight to the original P/O, which is then incorporated into the item pricing as described above.
2. Because now this overstates the amount payable to the vendor of the original P/O, when the P/O is invoiced, the Freight account must be added as a G/L item to the invoice using the negative amount of the DHL payment.
3. The amount invoiced should now be correct for the original vendor.
4. DHL is paid in the usual manner against the G/L Freight account.
5. The net Freight expense is zero, because the negative amount on the invoice offsets the positive amount of the DHL payment.
Result: the cost of the DHL freight is captured in the item price and will be reflected in COGS when the item is sold.
The disadvantage of this approach is that the P/O had to remain open to wait for the DHL freight billing, which delays deliveries, and therefore may not be acceptable.
I wrote the pull request to operate on the P/O, but perhaps it would preferable for it to operate when the invoice is created, which should work because item prices are not firmed up in FA until then. That would allow the delivery to go forward before the DHL freight bill was received.
@braathwate, I was trying your fork to test this feature. I am facing one problem. When I select a Service Item on PO or Invoice I can see a Drop Down under COGS column with 3 options. By Line Total, By Quantity, By Line Item.
Unfortunately I am not able to select any of these three options as the Ajax is taking back focus from this dropdown list.
I am trying to use API in a project where API call is from within FA for the currently logged in user and company.
In this case how the session will be handled in the current FA API plugin.
Session Handling
I don't want to create a new session. Instead want to use the same session.
API Call
I created a test page and called the absolute url using file_get_contents as below and I got response.
$result = file_get_contents('https://pakerp.net/modules/api-bx/category');
But I am not sure what is the right way to call API using relative path within FA.
Hello, amputhu I am trying to use your api in a project. The api call is within the FA so I don't want to recreate session instead use the same Logged In Session. How to do this?
This is such a great input. I highly recommend to include this in Core
I have tried to use Jquery to validate some form fields based on input value.
It works fine but when the default FA Ajax is called on the page the jquery doesn't load and hence no validations are done.
I have added this in themes renderer.php menu_header() function.
add_js_ufile("$theme_path/libraries/jquery-1.10.2.min.js");
send_scripts();Where else I shall add this to ensure that it works even after default Ajax Call on the page?
Please guide.
In FA we can activate Ajax on Combo fields by setting Submit_on_Change to true.
Is there any way we can activate Ajax on Input Text Field if the value is changed then Ajax is called?
FrontAccounting forum → Posts by boxygen
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.