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
@joe, While adding new purchase invoice, we are calling the add_supp_invoice function, Which actually called get_stock_gl_code twice inside the entered_grns foreach, remove the second one.
$stock_id = $entered_grn->item_code;
$stock_gl_code = get_stock_gl_code($stock_id);And the previous one already exist. to handle further gl codes.
possibly your GL close date might be changed. check the Banking and General ledger -> GL Close transaction.
If the date is greater than the transaction date, it wont allow you to do this. We cant consider its just php version issue, it can be code changed to make it fail or make it complex.
Seems like you didnt read the system requirement, now a days all servers are updated to new php versions. So go with new one and try install there. May of us using php 8 for FA.
If you still get issues. Bring us the issues. Will try to help you on it .
From company setup. We have an option to choose no of days transaction list in the reports drop down. Setup->Company setup.
Max day range in documents
Check and change it. But remember showing all transactions will make the browser freeze if you have huge in the list. May be customize to choose days level to filter and get list of transactions in between the date range.
Its good try for promotion. Kindly don't make fake promotions here.
You can refer the module shipment tracking and get it connected for you.
There are two logics that i understand.
We normally sell the product to end customers along with tax. Example when we buy a shampoo it will be added the tax inside price and charged us.
In othercase if we are buying a box of 100 shampoo battles as wholesaler, the distributor must say the product price and than tax. Because both operates in the B2B. So tax is there in the middle of both.
Thats how retail and wholesale types created i guess.
There should be some calculation level decimal value comes during the time of tax applied with it. So it can be either positive or negative balance comes like that. This balance we used foreign exchange gain or loss account to compensate the GL balance.
There is a option tax include and exclude in the system. If its included tax its 305 for 18% of 2000. If its excluded tax its 360.
Kindly check the sales type and the tax inclusion and exclusion there.
Not like that dude.
Some Italian users available in the community too. Most of them are accountants i guess. But its good to have the italian coa in FA. Joe update it to repository for future users
Hello All,
Thanks for your reponses so far.
@ Apmuthu, you suggested I do a new Installation and see if this Standard Cost Alteration still persist. I have installed version 2.4.11 and it still persist.
Please this might sound stupid. How do I enter cost of Good so that when I do Inventory Valuation Report, It uses the standard cost to calculate and not average cost.
Cost when I got value different from my Standard cost which I know is average cost, I updated the Standard Cost but its not reflected in the Report.
Please help out.Thanks
Popsicles12
While creating inventory or its from category the COGS account set to use it and also inventory account..
From that it will make the entry.
May be we have to provide this feature company level like the allow negative inventory.
May be you have checked included sales type from price list. Which makes the price included tax, which makes the amount of calculated tax vary. And it makes you to feel like the tax is less than actual.
Or you have adding shipping cost, but while checking the tax calculation you might missed to calculate shipping tax.
May be you can void and recreate it.
kvvaradha wrote:Bank payment and deposit automatically makes journal entry. You can simply input the respective GL account with amount.
But how does it know to use a credit or debit in the respective accounts?
Its actually depends on payment or deposit. Each and every bank account connected with a GL code. So if you make bank payment , the credit debit performs automatically based on the fields.
Normally our sales invoice handles the shipping expense, along with its tax , right. ?
Receivables 50
Sales 40
Shipping 10
Here it connects the shipping expense inputted here 10.
Am i wrong ?.
Bank payment and deposit automatically makes journal entry. You can simply input the respective GL account with amount.
Suppose if i have only one location for my business. how do i add fixed assets location. ?
I need to create separate location for fixed assets. but actually its not original, As i need to use the same location that i have.
And also the category.
you are right. but we can do this partially and run the remaining stocks depreciation after sales.
is it not ok. ?
From fixed assets inquiry page, we have a purchased column with link, thats giving wrong trans_no.
get_fixed_asset_purchase function get invoice now, how do we link the invoice trans no in place of GRN trans no.
function purchase_link($row)
{
if ($row['purchase_date'] === NULL)
return "";
return get_supplier_trans_view_str(ST_SUPPRECEIVE, $row["purchase_no"], sql2date($row["purchase_date"]));
}Here the $row['purchase_no'] has not exist.
function purchase_link($row)
{
if ($row['purchase_date'] === NULL)
return "";
//my suggestion would be something like this to get GRN now.
$sql ="SELECT trans_no FROM ".TB_PREF."stock_moves WHERE 1=1 AND type =".ST_SUPPRECEIVE." AND stock_id =".db_escape($row['stock_id'])." AND qty > '0' ";
$res = db_query($sql, "Can't get grn no");
$row2=db_fetch($res);
return get_supplier_trans_view_str(ST_SUPPRECEIVE, $rows["trans_no"], sql2date($row["purchase_date"]));
}@Joe, check it. otherwise we need to connect the invoice, instead of the GRN in purchase link.
and also i see, we can try the depreciation start with the date given from fixed assets input date. i dont know the reason why we are using every month start date.
this is perfect example dude. looks good to have it for drop down purpose.
During Customer payment, as you can see a textbox stated charges, just input the 10 usd there. the system will put that 10 usd in the Interest and bank charges account.
So your journal entry will be like this.
AR 350
interest and bank charges 10
Bank 360
Hope this helps you.
i feel, we can allow quantity as well as perform the depreciation based on per unit. so we can calculate the depreciation for one item and multiply with quantity.
and also for your existing fixed assets. we need to make the purchase invoice in its appropriate date. after that you can input the depreciation start date in that date. and than you can process depreciation from the date of purchase to till. in a journal entry. Hope that will help you to perform the material cost updated and cost variance also updated. later you can process the future value,
for future value also we need cron based automatic depreciation. so that we can avoid missing of making depreciation in time.
you are right. but the parent has no use here i guess. it was simply kept there. but never used anywhere in the system.,
Suppose if i buy 20 laptops or computers in a same brand and same config. How do i add it in fixed assets?
each time should i need to create separate fixed asset and do the purchase and make the depreciation?
How about buying of 50 computers. or 100 Computers. ?
FrontAccounting forum → Posts by kvvaradha
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.