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
Attached is the skeletal set of changes needed to implement a drill down from account classes to account groups.
It can be extended to accounts master as well.
A link for removing the filter can be added.
Repetitive columns can be moved to a header when in filter mode.
@joe: can extend and add it.
Pending Issues:
1. Accounting for expenses as part of Cost of Goods Purchased
2. Request to add 100% translated Hindi and Tamil in Install Wizard - Commited with 1, 2.
3. Update Language Packs for Hindi and Tamil
4. Account and Type Ordering
5. Merge Customers
6. Unable to Edit or Void a Credit Note - Was postponed to later minor release earlier
7. Multiple Sales Orders into Single Delivery - Feature Request - Currently keep editing a Single Sales Order till delivery. Was postponed to later minor release earlier
8. Move add_access_extensions(); to header.inc from all themes and extensions - being studied for Ajax and related security issues.
9. Remember Inquiry forms date / date ranges
10. Clone and Edit Sales Quote
11. Default Bank Account in select box order. - Committed
12. Zero price Supplier Invoice Item Entry
13. Backup Upload Fix - revert to multi-part form - Committed
14. Fixed Assets Depreciation Processing Fix - Committed
15. Voided Transaction Number re-used for new one errors out on old records present
16. items_db.inc Wrong Error Message - Committed.
@andijani: Excellent way.
This can be a Standard Operating Procedure in such instances for all FA users.
Wiki-ed it.
@joe: want to commit this with a check for if (empty($val)) { ?
@joe: I'm out of my depth here!
Possibly keep editing/ adding to the GRN till all costs are added in.
The reason is that it is a very big numner for these conversions:
1 EUR = 24810.7356 STD
The inverse obtained is obviously too small:
1 STD = 0.000040305133073120169802623667474011 EUR
This is more than the 4 digits after the decimal place.
Hence Google needs to increase the number of decimal places for such evaluations.
Doing it in FA with the default values will be of no use and hence @notrinos solution is elegant.
If you search for "1 STD = ? EUR" you will get 0.000040 as the answer now.
Hence their evaluator for the search engine is okay.
Incidentally, we may have a Chart of Accounts for Sao Tome among the forum users - @odaio!
Alternatively, if all the reverse rates work, then we can swap the currencies and make just 1 single check. The reverse for IDR to OMR does not work.
USD to any currency works - hence only when a non USD is involved as the From and To currencies, we will need 2 conversions and then a division! Here we will have the second check only when the first fails.
Try to use line items to add the costs you want apportioned to the items and provide feedback. Also check if there are any settings - config, sys_prefs, etc that modify FA's computations.
Yes. The currency in which settlement takes place is fixed to the specific customer account. If it is a one off / rare transaction in another currency, use the currency exchange rate to get the equivalent in the default currency for the customer account and book it, providing the exchange rate conversion in the memo.
1. Check if there are any write permissions issues for the tmp folder.
2. Make sure you have OpenSSL extension enabled in your php.ini file (and restart webserver on any changes).
3. Check if any issues are listed in the wiki you may need.
4. What OS do you have for your local install?
5. When the report generation is complete, check if you have it present and valid in your company/#/pdf_files folder where # is your company id.
6. What do your Apache and FA logs say?
7. Turn on the various debug options in your FA config file and troubleshoot it by referring to the wiki.
You will need to use MySQL 5.6 and lower. If you want it to run on MySQL 5.7 and above you will need to turn off strict mode for dates. Search the forum on how to do it. Later versions of MySQL do not look kindly on dates such as '0000-00-00' and zero timestamps as well. Hope you have installed the dejavu.zip fonts and enabled popup windows for localhost in your browser.
FA v2.4.3 is out and some post release fixes are in the Announcements page. There is no FA 2.4.23 yet. What browser and version are you using? Try Firefox 52.x ESR. Compare with versions on your remote server.
By Credit Supplier B Invoice - GBP 1000 booked as CAD 1800 (based on the exchange rate for the day.
Debit Purchases for CAD 1800.
By Bank Credit Cheque issued CAD 1800
To Debit Supplier A (the 3rd party currency exchange broker) - CAD 1800.
When the money is wired as Forex to Supplier B:
By Credit Supplier A - CAD 1800 (wired as GBP 1000)
To Debit Supplier B - CAD 1800
If the Supplier B needs to have their accounts settled in GBP, then make the entries in GBP for them and how they get paid, keeping the CAD for local account heads only.
Payments made to Supplier A (appropriately GBP adjusted to CAD) can also be treated as having been made on behalf of Supplier B and allocations made in GBP itself.
Please consult your accountant on making journal entries such as this.
@joe: Most new Debian and other distros are now defaulting to MariaDB. Verify and commit the above.
Actually, in all cases involving reports, the cookies will store the parameters so it did not matter if there were more than one date in the form. The screen forms for data entry generally had just 1 sticky date that was remembered in the session user variable's sticky_date property. In case of all inquiry forms this feature has not yet been coded to work.
The alternative would be to temporarily change the transaction days value to a figure that would generate the desired starting date from now.
@joe: can we code it to use cookies to store the various date ranges in screen inquiry forms?
The latest AU general chart will always be here. Just right click the "Raw" button and choose to save it. There have been some updates in it after the previous release too, to accommodate the new barcoding option.
If you used "Direct Invoice" menu item with Payment Terms "Cash Sale", then the payment is also made when the invoice is generated.
See this wiki page.
This functionality has now been integrated into FA 2.4.x with the settings in the users table as the fields:
sticky_doc_date
transaction_days
save_report_selectionsMake sure that the browser cache is cleared and the company's js_cache is also cleared. Logout and login again and see what gives. In the last case above, this user choice data are stored in cookies and you must have it enabled. The others store it in the session.
The function date_cells() is the one that sets the form element. There appears to be no mention of sticky_doc_date(), new_doc_date(), etc there to remember the dates. The _last_val attribute of the date cell should be set from the sticky value.
@joe: needs a check to extend it to search forms as well?
All customer payments can be allocated to invoices when they are raised. Prepaid invoice is a special instance where the amounts paid and payable on the invoice match. If a client pays into his deposit account with the company, then an equivalent credit limit too can be provided and then contra-ed when settlement occurs.
@cambell: In your releases you can exclude the public/.git folder.
Extended the API to cover specific Tax_Type endpoint after synching with @cambell's latest release.
Added json output download example.
The Hindi and Tamil install wizard translations have been 100% done for a while now for FA 2.4.x.
Request that it be included into the FA 2.4.x core, now that they have been inducted into the official PKG repo as well.
They are present in my FA24Mods repo too.
The attachment has balance translations done for Arabic (ar_EG) and Vietnamese (vi_VN) as well that you may include after approval from native speakers. Both languages have their core translations 100% done too and updated in my FA24extensions repo.
Using the rapid translation technique listed in the wiki, the entire Vietnamese (vi_VN) core strings in FA 2.4.x translation has been achieved in 2 hours without knowing Vietnamese.
Native speakers of Vietnamese may use it and advise on corrections.
Post Release FA 2.4.3+ fixes attached herein.
See this post on db updation and this post on prepaid invoice enablement.
Read this Forum Post if you are on any PHP version older than and not including PHP 5.6.
Updated AU, UK, PH, IN, SG, CN general 4 digit Charts for new sys_prefs variables.
Updated also for Prepaid sales enablement with Deferred Income account inclusion.
New installs using these charts will match with the standard schema of the default charts. The Indian and Australian fiscal years too have been taken into account. Check out the FA24extensions repo for the latest files, fork it if you want to submit pull requests of your changes and follow the commits there.
@itronics: Please fix this commit as above.. Committed.
The function get_full_price_for_item() takes only 5 arguments but the usage in the said commit calls for a change from 6 to 7 arguments now!
FA remains broken till this is fixed.
Thanks @joe. It appears that this feature is enabled by default. Looks okay.
@joe: rerun with line 121 of sql/alter2.4.php:
'barcodes_on_report')");being changed to:
'barcodes_on_stock')");to match variable used in code.
Also update the standard Charts too with it in the sys_prefs table possibly disabling it by default with to match current installs.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.