Take a backup before and after creating a Credit Note and see what tables and fields are affected - if no summary postings in multiple tables arise, just edit the atomic change!
3,752 11/08/2015 10:47:38 am
Re: Supplier Payment v Bank Payment (4 replies, posted in Banking and General Ledger)
That is mimicked in FA using Quick Entries.
3,753 11/05/2015 05:35:16 pm
Re: How do I record cash payments? (3 replies, posted in Banking and General Ledger)
FrontAccounting system transaction types are listed in includes/types.inc and maps onto the labels in the Forms Setup screen. You cannot add new transaction types (except through custom or standard extension modules). Cash Payment Voucher is a type of Bank Transaction. In the said file look up: Bank transaction types:
// Bank transaction types
//
define('BT_TRANSFER', 0);
define('BT_CHEQUE', 1);
define('BT_CREDIT', 2);
define('BT_CASH', 3);Under Banking & General Ledger tab check out the Bank Accounts screen - you will find that petty Cash is a Bank Account.
When setting up a bank account, choose it's type from the the above choices - in your case, it will be Cash account (BT_CASH => 3).
Bank and Cash Vouchers use a same numbering sequence.
Packing List and Delivery Note use another same numbering sequence.
3,754 11/05/2015 05:26:58 pm
Re: Unable to enter any data in Forms Setup - Ver 2.3.2 (3 replies, posted in Setup)
Which version of FA are you using? Try to use the latest stable FA 2.3 snapshot. After setting the preferences in Forms Setup, logout, clear browser cache and login again and check it out.
3,755 11/05/2015 11:39:03 am
Re: faulty escape in empty.po (2 replies, posted in Report Bugs here)
This has now been committed to the unstable FA 2.4 repo but not as yet in the FA 2.3 stable repo. Hence in the FA v2.3 repo, it will not be translatable still.
This will also need to be followed with each language translation being affected in the official pkg repo.
3,756 11/04/2015 10:37:09 pm
Re: Translation portal (20 replies, posted in Translations)
Have created an account for FrontAccounting on Transifex for public viewing - interested translators can request for write access.
Tested out GlotPress and it has the same UTF-8 only limitation although it allows for downloading .mo files. It can run as standalone on Windows XAMPP - just tweak the directory settings by replacing "\" with "/".
3,757 11/04/2015 07:08:47 pm
Topic: faulty escape in empty.po (2 replies, posted in Report Bugs here)
Line 6704 in lang/new_language_template/LC_MESSAGES/empty.po has a double backslash for escaping a line feed:
--- "old/lang/new_language_template/LC_MESSAGES/empty.po"
+++ "new/lang/new_language_template/LC_MESSAGES/empty.po"
@@ -6701,7 +6701,7 @@ msgid "Items"
msgstr ""
#: includes/ui/ui_controls.inc:604
-msgid "Entered data has not been saved yet.\\nDo you want to abandon changes?"
+msgid "Entered data has not been saved yet.\nDo you want to abandon changes?"
msgstr ""
#: includes/ui/ui_input.inc:632 reporting/includes/reports_classes.inc:222The following language .po (and consequently their .mo files as well) files too have the error:
ar_EG
el_GR
es_CL
es_ES
es_NI
id_ID
ka_GE
nl_NL
pl_PL
pt_PT
ro_RO
ur_PK
zh_TW
3,758 11/03/2015 04:50:04 am
Re: Script BASIC (17 replies, posted in Announcements)
ScriptBASIC will then be replacing the entire PHP code with it's "compiled" version. A sort of a Desktop FA that has been done using PHPDesktop earlier. FA updates would then need fresh compilations - nice business sense to sell "service"!
3,759 11/03/2015 04:46:54 am
Re: Translation portal (20 replies, posted in Translations)
Just tested Transifex:
1. Help pages are outdated.
2. Do not allow downloading of .mo files - no conversion.
3. Needs a desktop client and then use CLI to pull/push.
4. Free for Open Source projects.
5. Supports only UTF-8 for upload and download currently.
6. Bulk Review of Translations does not filter reviewed strings on clicking "download of reviewed strings" link.
7. Displayed languages not sortable (stays in default order of No. of UnTranslated strings, Language Name, Lang Code).
8. Resource wise languages listing not available.
9. The translation pairs are arranged in alphabetical order of the original strings and not in the order of the original resource po file. GlotPress maintains the order of the source resource and preserves the original resource file line numbers in the comments that precede the translations also.
3,760 11/03/2015 02:41:02 am
Re: Script BASIC (17 replies, posted in Announcements)
Then would it mean that the proxy is to be used by the Apache conf file to manage folder paths selectively to enable sbhttpd to partake of port 80 as it's publicly accessible port and for PHP to partake of the real proxy port ( say port 8080 ) in it's interaction with ScriptBASIC?
3,761 11/02/2015 03:00:34 pm
Re: Script BASIC (17 replies, posted in Announcements)
@John: Thanks for the detailed info on ScriptBASIC. Just trying to find what part of C interfacing with FrontAccounting would need to justify using it.
MySQL interaction in a thread safe manner is the current way FA works with the MySQL server and that is as close as we get with C interaction with PHP and possibly no worse than ScriptBASIC. Hence any ScriptBASIC interfacing on the database side will not provide for any significant advantage especially if some form of cachiing (APC, memcached, etc) is used.
Interfacing with sensors for embedded applications where no php extension is available may be a use case for using PHP with ScriptBASIC.
If the recommended way to use ScriptBASIC is as a proxy to Apache and Apache runs on port 80 and the proxy runs on say port 8080, must the client then use port 8080 to access the application?
3,762 11/02/2015 07:47:38 am
Re: Payroll (16 replies, posted in Wish List)
The idea is to make a highly simplified payroll module in FA to hold employees particulars and payslip tables with a defaults table for the ensuing month field defaults. The Country / State specifics can be used to extend this module.
3,763 11/02/2015 07:44:35 am
Re: Adding field to Sales or Purchase screens (4 replies, posted in FA Modifications)
@roymagura: it would be appreciated if you provide your code for the community to develop and maintain and possibly integrate into later versions.
3,764 11/02/2015 07:41:01 am
Re: Script BASIC (17 replies, posted in Announcements)
Hence ScriptBASIC in it's final use case would be to replace the entire Apache/PHP/MySQL stack with a pure ScriptBASIC compiled (or intermediate compiled) alternative and no advantage in using both together.
What is it that can be done in ScriptBASIC that cannot be just as easily done in PHP?
The reason why PHP in general and FA in particular became popular is that it is in open text form and loosely typed and easy to program for the non programmer. "Protecting / Obfuscating" code will mitigate against the userbase. Proprietary code and compiled applications can hold users to ransom. Those who wish to retain independance in the code they use will run away from it! When acceptable alternatives like ScriptBASIC arrive, there must be a compelling reason to undertake a fresh learning curve and migrate to it.
With the arrival of Triggers, Procedures and Functions in MySQL, most PHP code can be replaced by them in getting logically directed computed storage done.
As your sbhttpd is a proxy, does it still depend on the availability of a real web server like Apache?
3,765 11/01/2015 10:53:07 pm
Re: Script BASIC (17 replies, posted in Announcements)
Please post some php source interacting with ScriptBASIC source code.
3,766 11/01/2015 10:47:30 pm
Re: Annual Balance Breakdown Report -- Net Asset calculation (9 replies, posted in Report Bugs here)
When doing so, he can refer my repo for many fixes to Charts (en_GB) and extensions (zen_import) and missing extensions.
Version bumps on addons with no changes in content should be avoided.
3,767 11/01/2015 08:57:11 pm
Re: Script BASIC (17 replies, posted in Announcements)
Whilst FA is interpreted, executed and presented to the Web Browser (not necessarily on CGI), how would we get to use ScriptBASIC with it? Please provide an example of it's usage with PHP (non CGI).
3,768 11/01/2015 08:54:40 pm
Re: License compatiblity for CoA from other ERP (23 replies, posted in Misc. Charts of Accounts)
If you model it on the en_US-new.sql then changes will be comparable.
3,769 11/01/2015 08:53:33 pm
Re: Annual Balance Breakdown Report -- Net Asset calculation (9 replies, posted in Report Bugs here)
The current Annual Balance Breakdown Report pkg in the official repo has not been updated as yet despite a lot of version bumps in the last few times ending on 2015-10-25.
3,770 11/01/2015 06:53:42 pm
Re: License compatiblity for CoA from other ERP (23 replies, posted in Misc. Charts of Accounts)
There is nothing proprietary in heads of accounts and classifications - suit yourself. FA has it's own table structure anyway.
3,771 11/01/2015 01:12:31 pm
Re: Adding field to Sales or Purchase screens (4 replies, posted in FA Modifications)
How do you propose to handle the case of differing VAT rates for multiple items in a single invoice - you will just get a consolidated value? Is it that it should be displayed dynamically (using a variable in the report to accumulate it) or to be taken from some table later?
There is atleast 1 thread in this forum that might assist you in it's backport from FA 2.4.
Attached your screenshot here as well.
3,772 11/01/2015 01:09:48 pm
Re: importing bank statements (4 replies, posted in Banking and General Ledger)
You will need to activate it for the company you want it in.
3,773 11/01/2015 01:08:43 pm
Re: Bank reconcillation (1 replies, posted in Banking and General Ledger)
You will need to activate it for the specific company you want it in.
3,774 11/01/2015 01:07:15 pm
Re: FA Themes (1 replies, posted in FA Modifications)
Have a look at the theme files in my repo.
The wiki too should be referred.
3,775 11/01/2015 01:04:55 pm
Re: Errors in new install of FrontAccounting - wrong Webroot Path (10 replies, posted in Installation)
@joe: Would you like to correct the commented out line in session.inc (Post 4 in this thread) to match tm/George's construct?
