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
Recently I found one more report issue, The gl_trans table does not store the supplier id. May be I didn't check the reason much. But from the GL Accounts Transactions report, the supplier name is missing for GRN rows.
So it can be fixed by just changing it commit
@joe look into it.
I didnt check supplier balances. Please test it and apply the fix if necessary.
SELECT SUM(amount), account_name FROM 0_gl_trans, 0_chart_master WHERE 0_gl_trans.account=0_chart_master.account_code GROUP BY account hope this query satisfy your needs.
I have tried both official stable and unstable recent snapshot. Both gives the same error,
For Your understanding i have a screenshot of both journal entry. and the customer payment. What happens is in the screenshot
check the last column(Outstanding) and due to it the grand total is also affecting.
@joe - Review and feedback it.
When we create a journal entry for customer opening balance. and when i open the customer balances report. The outstanding is not added there. And than i made payment to the journal entry through customer payments page. After that i see, that the outstanding balance is increased wth the payment amount. So i had a look into rep101.php
And i found one things, which is showing the wrong data there.
if ( $trans['type'] == ST_SALESINVOICE || $trans['type'] == ST_BANKPAYMENT) which should be like this
if ($trans['type'] == ST_JOURNAL || $trans['type'] == ST_SALESINVOICE || $trans['type'] == ST_BANKPAYMENT) I mean include the journal passing entries to be here.
Hope it fixes the issue
Still we are not clear what you are asking, receivables and payables are just balances of sales and purchase.
You know what, apmuthu already said, the trail balance has what you want. So why dont you check the trail balance queries to program it.
From the image, itself you are giving confusions. I am not sure what you looking.
Check my LTE theme demo dashboard bottom " Class Balances" Table. I have shown such a things i guess.
@emiangel839 - Regarding your comment on my site. here I answered you with the query.
$today = Today();
$begin = begin_fiscalyear();
$begin1 = date2sql($begin);
$today1 = date2sql($today);
$sql = "SELECT SUM(amount) AS total, c.class_name, c.ctype FROM
".TB_PREF."gl_trans,".TB_PREF."chart_master AS a, ".TB_PREF."chart_types AS t,
".TB_PREF."chart_class AS c WHERE
account = a.account_code AND a.account_type = t.id AND t.class_id = c.cid AND c.cid=1
AND IF(c.ctype > 3, tran_date >= '$begin1', tran_date >= '0000-00-00')
AND tran_date <= '$today1' ORDER BY c.cid";
$result = db_query($sql, "Transactions could not be calculated");hope it helps you
@andijani - you are right, the batch allows to oversold 10 from Batch A. Which needs to change the default delivery of FA. Looking to make something different from the default customer delivery,like quantities from different batches,we need to select the product from the drop down.
Sorry its not available to test it locally.
@poncho - If you are really interested to bring the custom fields. We have to make changes in the core to allow it to add additional fields. Instead of making it as extension. Try to make it within core. and get the difference of file with help of git difference. So it would be added to the core in next release of FA2.5.
Hope it sounds good. Also @joe waiting to hear your thoughts before he start working inside core.
we are ready to make this one.
@pratik.kamble - You are not in default company i think. The default first company Administrator has the right to Create companies, install modules, languages. So login to Default first company and get full rights to create companies.
You need to enable debugging mode to see the issues. Not everyone can program without bugs or mistakes. so try with debugging mode and get us the issues, we can help you somehow.
Yes you can change it. Just goto Setup->Install and Activate New Languages.
If you see ur existing language it's ur luck. Than just install it and then go to users. And edit the user with the new language.
That's fine to do it.
All you need to update fields in program and add one ! more field in database.
Sales order details table and
debtor trans details
Add a column for delivery date .
And then go to sales/includes/ui
Here sales_order_ui.inc file is there. Just find below functions
add_to_order. - pass one more parameter and do it.
display_order_summary
sales_order_item_controls
And now open sales/includes/cart_class.inc update the line_details class with one more field and for date and also pass it to add_to_order function here.
With in the read and write functions it calls some more db operational functions. Just update that to complete it
Sales order entry.php
Pass the date parameter to add to cart calling function
@emiangel839- present FA does not have such a feature to use. But you can make it . There is a pop-up search list appears when you click on search button next to customers or suppliers drop down. That opens like this
Customers root/sales/inquiry/customers_list.php
Suppliers root/inquiry/suppliers_list.php
Both files change it to tabbed content view and first tab can be existing content. So you can search if not found than goto second tab and add the customer by linking the add manage customers
I tried to do the same thing, like I created a GL account ( 121110)
And I created an item with same item code.
And i tried to clone it and also it saved with different code. during the clone it worked fine.
Than i placed one PI and checked things. Really sorry, i couldn't understand the abnormal behaivour
It applies to common standard with limitations of FA code structure.
And more over it applies GST . You can use it. And regarding the hsn code and tax report based on hsn was not implemented. Other than that it works fine. The e-way bills also not implemented.
Hope it helps to understand
@cleal - Your solution is ok to use. If you seek other solution,
function count_array($array){
return ($array) ? count($array) : 0;
}I mean without is_array
@king1984 - If you goto "System and General GL Setup" , there are some predefined or used existing COA here. So when you edit the COA, and the code changed. the system GL can't get right value.
So once you modify the above tables. manually you need to setup the "System and General GL Setup" accounts once again. IF you go with programmatic, It wil be harder and more complex. manual and simple to adapt it.
hope it helps you .
@joe commit this fix on core
@bobloblian - I guess you have FA 2.4.3 or older version, am i right ?
Because in 2.4.4 it works earlier versions, it has the problem with print of barcodes
@gj6n68 - Read this and get new version of FA before you install it on your new PHP version.
https://frontaccounting.com/punbb/viewtopic.php?pid=33023#p33023 Hoping to hear, it worked
Steps to Upgrade it
1. Backup the database from your current version FA 2.3.24 .
2. Install a new fresh FA 2.3.26 on separate directory.
3. Restore the database which you backed up on FA2.3.24 and login as admin in FA 2.3.26
4. Again here Backup database from 2.3.26 and save it on your pc
5. Download Fresh New FA copy, 2.4.4 and install it fresh.
6. Now you need to Restore the backup you exported from FA2.3.26
7. Now when you login as administrator, FA will ask you to update your database.
8. Now go to Software Upgrade. You can see Update option, Just click and update the Database.
Once these steps done successfully, everything will be alright with new version.
@Verma, - I am not sure, whether he has done this thing before.
@gj6n68 - you need to keep the version of php also same.
Because upto FA 2.4.3 ,it throws error on php 7.0 and above. But from 2.4.4 it works fine there.
So if you want to use 2.4.2 on php 5.6 its fine. But if you upgraded the server php version. you need to swtich to FA2.4.4.
Otherwise you need to update the program manually by checking the changes log of FA.
anyway, you need to upgrade program of FA to 2.4.4. and connect the 2.4.2 database. only few field differences are there. That i already stated above for your understanding purpose
FrontAccounting forum → Posts by kvvaradha
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.