2,326

(86 replies, posted in Modules Add-on's)

By end user I mean those who install, maintain and use FrontAccounting by themselves with the Slim API, not the FA application operatives using what someone else installs and maintains.

What is wrong with line 6 of index,php? Just a plain include of all php files in the src folder so that any function in any endpoint can use it. I am planning on working on it to make sure that native FA functions are used for the most part. It works for me.

If there is anyone for whom the code does not work, please let me know - I'd like to know why and will do what needs to be done. I am keeping it as backward compatible as is possible so that those on older PHP versions too can still keep their installs whilst leveraging the REST API.

If you put in some test access values in util.php, you can easily browse to say: http://localhost/fa24/modules/api24/category/1

I've been packaging the original submission from Andres Amaya Diaz for FA 2.3 and worked on it while it was being hammered out. You check the wiki history and the original threads too.

2,327

(86 replies, posted in Modules Add-on's)

Mine is packaged to work without composer and it's dependencies  by default. The community now has the options of using it
1. with composer (your default) or
2. editing your release to work without it or
3. using mine (default no composer) directly.

Also my version does not need the PHP 5.4+ dependency of the new array declaration []. The FA and API paths are hardcoded in mine though.

Hope these differences will help end users make their choice.

2,328

(86 replies, posted in Modules Add-on's)

Have synched my repo. Standardised the braces. It continues to work without composer. Latest version attached.

2,329

(5 replies, posted in Announcements)

With the release of every new version, interest in the community peaks and so do the spammers who wish to be seen by those crowding in.

Attached is the stats for user registrations and their posts during the 30 day period ending today.

Two-thirds are unwanted registrations.
One-fifth are such posters and posts.
Average visibility of spammers - 2 hours.

Opening too many windows may confuse cookies / sessions. This is more of a drill down to create a new account / account group without having to choose in a select box - especially one that is too long.

It will also be helpful for mobile layouts.

If we are to drill up and display as popups for information purposes, it should be okay for that.

2,331

(2 replies, posted in Accounts Receivable)

It can be a database permission error. Does the db user have update permissions on the FA database?

There is only one function that outputs this string - function page_processing() when it's lone argument is true. It is defined in includes/ui/ui_controls.inc.

You need to backport this fix from FA v2.4 which has been done in my repo commit of 2015-08-29.

This has been extended to Ac Master as well.
The consolidated changes are attached herewith.

@joe: when committing, please add filter removal link where appropriate.

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.

2,334

(9 replies, posted in Announcements)

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)) { ?

2,337

(19 replies, posted in Accounts Payable)

@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.

2,339

(19 replies, posted in Accounts Payable)

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.

2,340

(1 replies, posted in Accounts Receivable)

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.

2,341

(9 replies, posted in Reporting)

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.

2,342

(9 replies, posted in Reporting)

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.

2,344

(3 replies, posted in FA Modifications)

@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.

2,347

(5 replies, posted in Accounts Receivable)

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_selections

Make 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?

2,349

(5 replies, posted in Accounts Receivable)

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.

2,350

(86 replies, posted in Modules Add-on's)

@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.