I think No
I have re bundled module to fetch price of each item upon scan and few other improvements and unnecessary code removed.
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
I think No
I have re bundled module to fetch price of each item upon scan and few other improvements and unnecessary code removed.
Here is a small module that adds items in the Cart using Bar Code Scan
Can you manually approve this account
Nothing in spam
https://imgur.com/a/WaU5452
I advised my junior to join forum.
But he is not receiving confirmation link email.
https://imgur.com/a/9r7dDJr
Requested email is
huzaziz1@gmail.com
Average Cost Calculation at FA
1. 10 pcs of Item A purchased at $15
2. 6 pcs are sold
3. 15 pcs of Item A purchased at $18
avg cost = ((15*18)+(4*15)) / 19 = 17.36
This is the formula of Avg Cost
However the problem at FA is that if you even Stock IN it calculates the Avg Cost. Even if you do Stock Transfer it calculates Avg Cost. Even the Voding Stock Moves affects the Average Cost
I have some modifications and conditions applied in
function void_stock_move()
if (!in_array ($type ,array(ST_LOCTRANSFER))) //condition added by faisal
if(!get_company_pref ('controlled_avg_cost') || in_array ($type, array(ST_WORKORDER, ST_MANURECEIVE, ST_SUPPRECEIVE)))
update_average_material_cost($row["supplier_id"], $row["stock_id"],
$unit_cost, -$row["qty"], sql2date($row["tran_date"]), false, "Void Stock Move # $type_no and type = ".$systypes_array[$type]);
This function also is modified but the idea is to limit it on all Transaction Types
@tom this extension will access the wordpress database directly hence needed to be on the same server. Right?
Great work
In session.inc comment out following lines
function preventHijacking()
{
if (!isset($_SESSION['IPaddress']) || !isset($_SESSION['userAgent']))
return false;
// if ($_SESSION['IPaddress'] != $_SERVER['REMOTE_ADDR'])
// return false;
// if ( $_SESSION['userAgent'] != @$_SERVER['HTTP_USER_AGENT'])
// return false;
return true;
}
Yes you can use Foreign Keys.
FA uses Foreign Keys but not at DB Level.
The referential Integrity is maintained through Code
https://github.com/FrontAccountingERP/FA/commit/6c40a3be4a79826087d7abbdd11b483f19decc2a
This latest commit is returning Ajax Failure on Add Item.
I tested this on one of my installations where some clients have more that 1000 sales orders.
This updated query is taking too long to return stk_code and hence the Ajax is failing and Add Items not working.
Hello brothers,
Does anyone else face same issue?
The Ajax call reloads the page and all data is lost.
One of my client he transfers stock in bulk to another store. May be 50 plus items.
After 10-15 items the page reloads due to Ajax call when we add item
At one of my installations I am facing a severe issue.
My client's Purchase Invoice contains a lot of Line Items.
Its happening that sometimes maybe (1 out of 10) when he enter any line item or when he press Process Invoice upon Ajax Call the Page gets refresh without saving the data. Hence the whole cart vanishes and it creates a lot of frustration with users.
Has anyone else faced this issue.
How to rescue this?
Actually modules are not the part of core releases. They are maintained in non official repos. Just check BraathWate repo on Github
Thanks
Why are you not using multiple deliveries against sales order and then merge deliveries on sales invoice?
Thanks
Keep sharing
I think it is built on react technology so the guy needs to access the API through browser. The CORS error is specific with browser and not with POSTMAN.
Your second point I couln't get. The above mentioned gihub link for module for API is on SLIM3 or SLIM4 I couldn't ge this?
purchasing/includes/db/invoice_db.inc
Line # 276
The 3rd arugment is 0 but it should be $supp_trans->tax_group_id. Therefore it should be look like
$line_tax = get_full_price_for_item($entered_grn->item_code,
$entered_grn->this_quantity_inv * $entered_grn->chg_price, $supp_trans->tax_group_id, $supp_trans->tax_included) - $taxfree_line;
Otherwise the unit_tax is not calcuated correctly because
finally the function get_tax_group_rates is not reurning the rates to calculated the full_price_of_item() on above mentioned line.
I have done some thing similar in Pakistan
You need to check the access rights. However some access rights may be overlapping. So that may need customization
Is this done without any core changes?
That may need customization.
You may need to create sys pref in company setup like std_cost.
Once check you can apply condition to not call update_average_material_costs function defined in purchasing/includes/db/grn_db.inc.
One more controlled average costing can be just to call this function when a new item is purchased.
Hi
I have done similar thing for Pakistan.
I thing this is related to report VAT charged on each invoice to government.
Is this a fatal error or the page is still working? This may be warning for PHP 8 and may need to be fix
FrontAccounting forum → Posts by boxygen
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.