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 apmuthu
Release date 2021-06-20 as of GitHub commit https://github.com/FrontAccountingERP/FA/commit/c37b1d3a42a2ed774135aae6a337614bf8121a09
Needs following fixes for working:
2.4.10 Balance and Profit and loss reports fail to print
select item not working in purchase order and sales order entry
@kvvaradha: In FA v2.4.10, en_US-new has 2019 and en_US-demo has 2020. Both are outdated fiscal years, kindly update them and release it again.
@joe: I thought about that when releasing, However it is good to have at least one year back, so that in an eventuallty, a prolonged or deferred fiscal year can be created.
@kvvaradha: Ok. But we have to provide current year selection in the company setup and fiscal years. Those who comes to try new to our fa. They can't create invoice. Because of fiscal year is not new. New users may not know how to deal with it. Hope you understand the situation for the new users.
@rafat: I somehow tend to agree with @kvvaradha and would suggest that at least the demo version to contain the current fiscal year as the default so new users can navigate easily thru the system before they get into the serious stuff. I have some observations about the new Dashboard and would like to bring them out. Which section of the forum is most suitable?
@joe: Ok, I will update the COAs and commit and replace them at Sourceforge. Regarding observations, maybe FA Modifications or Report Bugs Here are suitable.
@apmuthu: Actually, a set of SET commands for a few date variables can be listed early in the sql dump and used everywhere whenever a fiscal year change is needed.
https://frontaccounting.com/fawiki/index.php?n=Main.Support
Use a journal entry:
To Debit Payee Account $a
To Debit Bank Charges $b
To Debit Bank Tax Payable $c
By Credit Bank for Cheque paid $d
such that $d = $a + $b + $c
Check for extra blank line and see that the CRLF is all replaced with LF as line endings of text / csv file.
Logout and Login again for settings changes to come into effect. Also check the account setting for the discount.
Clone reporting/rep707.php and alter after the line with 'Calculated Return'.
http://libgen.is may have the old books.
Although the System Requirements state that PHP 5.4+ is sufficient, the OpenCart v3.0.3.7 expects:
PHP8+ Required
The non-composer usage vendor folder is at upload/system/storage/vendor for OpenCart 3.x.
The ebooks available are for OpenCart v2.x only as on date and the online documentation is for that version which sports 131 tables at first install at the end of which there is a solicitation to buy the PHPMailer Addon for USD 20/- which can be manually hacked in as stated in a Github project and seconded here.
Free modules for OpenCart are here.
Attached is the set of screenshots of v2.3.0.2 install and sql / bash instructions that would be useful to integrate with FA.
Provide FA and platform versions from / to you want to upgrade and the bounty you offer.
https://github.com/opencart/opencart
http://docs.opencart.com/en-gb/requirements/
It uses MySQL database.
Can use triggers and procedures between FA and OpenCart DBs if on the same server.
Choose which application should be used for customers/suppliers data to be managed from.
Also whether accounting work in OpenCart and FA should be both ways or one way (which way).
Treat Deposit as a non inventory item and bill it. When final invoice is ready, invoice that and make a Journal Entry for the original Deposit invoice into payment for the final invoice.
Split the order into two parts - one for the work that the deposit tentatively pays for and another that can be for extra adjustments to the original order as a new order even it is just an addendum and then receive payment for that when done.
Subsidiary ID can be introduced for all transactions in FA 2.5 with just the unique suffix of each such company and having a set of UNION views for the holding company for all FA tables using it in a read only mode. The list of subsidiary companies (or profit centres / branches) that need to be UNIONed into views for the holding company can be autocreated with some description field holding the company #s.
Try using Tags / Dimensions as a first choice though.
Use a phpMyAdmin or SQLyog or any other MySQL client to get the job done on a GUI. Alternatively on a linux / windows commandline, do a restore of the sql.
Using phpMyAdmin or some MySQL client, hammer out a sql construct that displays the information you want and then make it into a custom report and share it to see if it makes it to the core.
Just check customer ledger balance / statement before asking for payment. If such information as account balance shows up in an invoice, then all payments made thereafter and in invoice printouts taken later would be different.
@joe: Any clues?
Check if there are any un-reconciled entries in your bank account that is not there in your trial balance and vice-versa and pass necessary Journal entriess.
Create an anatomy for the Fixed Assets Entry:
1. Take FA backup
2. Make single Fixed Asset Entry
3. Take second FA backup
4. Check the difference between the two backups
5. Create a set of INSERT and UPDATE statements to achieve the same.
6. Substitute the values for all other entries say from excel.
7. In one shot, load in all the sqls into the FA db.
See your PM.
Percentage / Fraction type pricing is available across all items like Wholesale / Retail in FA.
Yes, this would entail a new table and hence can either be an extension for now or await FA v2.5.
There are a total of 93 fields(en_US-new.sql) that re "double" type that are good for binary base computations that mess with decimal computations where a decimal field type should have been used. But this should not create such a huge difference unless an additional mess with signed and unsigned field type attributes are in the same expression.
Attachment is the code in file format.
@joe: There must be a better way to do this by calling it based on last timestamp of call taken from some log file in the index.php file itself.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.