Actually, FA has been good with common base workflow for the PC. Now that other small screen and touch centric devices have become commonplace, the UI will evolve.
5,551 04/20/2013 11:37:29 pm
Re: Sales Order Inquiry show invoice# (11 replies, posted in Accounts Receivable)
5,552 04/20/2013 11:29:40 am
Topic: New rep308.php submitted with updations. (2 replies, posted in Reporting)
The erstwhile rep_stock_movement extension for FA has Standard Costs as one of the parameters in the SQL and material cost was computed in it. When the extension was merged into the FA core as rep307.php on 2013-01-24, the Standard Material Costs got left out due to paucity of space on the standard A4 and Letter paper sizes and was called Inventory Movement Report.
Another report, rep308.php was made by Janusz/Joe around the same time but was not included in the FA core. Attached herewith is the improved version which is fully functional:
1. Commented out hardcoding of $orientation.
2. Retained UOM (units).
3. Moved extra function below regular function just as in rep307.php
4. Adjusted the indent values of the displayed fields - set for A4 but should work for Letter as well.
5. Ordered the report ids in the reports_main.php
Kindly include it in the FA Core. I have named it Costed Inventory Movement Report for now.
5,553 04/20/2013 11:19:50 am
Re: is FA used in France/ Est-ce que FA est légal en France (1 replies, posted in Banking and General Ledger)
Google Translated:
Hello,
I wonder if FA may be legally used in France and if not why.
I recall that 10 years ago, for example Excel could not be officially used, because it can delete / modify rows in the ledger that was not legal. Is this still the case?I do not live in France, so I'm asking more out of curiosity than necessity (and I have the time, not necessary contacts).
thank you
5,554 04/20/2013 07:46:33 am
Re: Chart of Accounts Question (5 replies, posted in Misc. Charts of Accounts)
You can install chart of accounts even after installing FA. The newly installed COAs can be used in subsequent creation of companies. All this can of course be done only from the Setup /Create Company Menu in the Default / Main Company (generally 0) only.
5,555 04/20/2013 07:42:46 am
Re: Sales Order Inquiry show invoice# (11 replies, posted in Accounts Receivable)
Attached your screenshot herein.
Since the Invoice Date is part of the Invoice No., either the Invoice Date field can be dropped or the date prefix in the Invoice No. be removed.
The Status field is to be numbered 6 in your list above.
Nos. 6 to 16 in your list above are to be Nos. 7 to 17.
The View Icon (No. 10) can be removed and the link provided in the Invoice No. Field itself.
You can generate the said page using the one page script from Adminer, or use the commercial HKVStore / XLineSoft products. The final product can be made into an extension for use in FA.
What application did you use to obtain the screenshot's underlying data layout?
Alternatively, all the icons can be replaced with a single drop down box and the checkboxes at the left of the records can become radio buttons to feed the parameters to the URL generated by selecting the action.
5,556 04/19/2013 06:19:04 pm
Re: Install in local server and online server (3 replies, posted in Installation)
Create the FA installs locally in each POS machine with the same SQL as in the online one. Then change the Reference Nos to be an unique prefix in each Setup->Forms Setup.
Now arrange to export the local db changes to the remote one filtered for the local prefix. This can be done with a php script linked to a "single click button" on the local POS install. This ofcourse assumes that there are no file uploads / documents in the local install that may have been changed.
5,557 04/19/2013 06:06:17 pm
Re: Fixing Usage - report generator (40 replies, posted in Modules Add-on's)
RepGen Extension v2.3.9-3 has been updated to v2.3.13-1 in my personal GitHub repo.
5,558 04/19/2013 06:41:59 am
Re: Bug in Customer Balances & Supplier Balances Reports (13 replies, posted in Report Bugs here)
Thanks Joe. HG 3122 did the job.
5,559 04/19/2013 06:31:53 am
Re: Edit Login window (3 replies, posted in Installation)
In the config.php file, set:
$text_company_selection = true;5,560 04/19/2013 06:21:18 am
Re: Missing gbsn00lp.php (5 replies, posted in Translations)
Updated Wiki at:
https://frontaccounting.com/fawiki/index.php?n=Help.InstallUpdateLanugages
5,561 04/19/2013 06:15:14 am
Re: FrontAccounting git repository (4 replies, posted in Announcements)
Thanks Janusz.
Now we can take snapshots at will.
Please update the git/hg with the missing rep308.php file
5,562 04/08/2013 03:03:14 pm
Re: POSTING METHOD (8 replies, posted in Setup)
Review transactions in each company and take action (contra to revert) even if they stand posted in real time.
Each branch can be a profit centre - Use Dimensions / Tags
5,563 04/08/2013 02:56:24 pm
Re: Getting Consolidated Reports (4 replies, posted in FA Modifications)
Dimensions and Tags may solve your issues.
Otherwise, a federated table structure may help outside of FA.
Creating UNIONised VIEWS (with apporpiately prefixed primary keys) of corresponding tables from all companies into a read-only consolidated virtual company's database will enable FA to do what you want.
5,564 04/08/2013 02:55:01 pm
Re: redirecting to login page again and again (19 replies, posted in Installation)
It will work in current PHP v5.3.x - maybe specific early versions in PHP 5.3.x may be broken.
Just remove the .htaccess file and see if it works - then fix the .htaccess settings to match your hosting provider.
5,565 04/08/2013 02:52:03 pm
Re: Mobile addon caused total failure of install ... (3 replies, posted in Setup)
Quite a few DB changes have been done and older variables may be deprecated. Check out the apache error log and see what gives.
5,566 04/08/2013 02:50:07 pm
Re: Simple REST API (45 replies, posted in Modules Add-on's)
The account numbers for the Journal Entries are hardcoded in inventory.inc - lines 321-323 are:
// TODO Obtener cuentas contra las cuales hacer asientos
$_SESSION['gl_items']->add_gl_item('1510', 0, 0, ($info['quantity']*$info['standard_cost']*-1), $info['memo']); // Cta de Inventario del Producto
$_SESSION['gl_items']->add_gl_item('4010', 0, 0, ($info['quantity']*$info['standard_cost']), $info['memo']); // Cta Configurada para Obsolteos, Propios, etc ...The comments are in Spanish - Please make it in English.
5,567 04/07/2013 01:09:56 pm
Re: Function needs Object (2 replies, posted in Modules Add-on's)
Please use the SimpleAPIModule.
5,568 04/07/2013 01:05:47 pm
Re: Simple REST API (45 replies, posted in Modules Add-on's)
@andresamayadiaz:
Your recent GitHub change has an error in line 14 of inventory.inc:
include_once($path_to_root . "/gl/includes/dl_db.inc"); should be
include_once($path_to_root . "/gl/includes/gl_db.inc"); The included file name is gl_db.inc and not dl_db.inc
5,569 04/07/2013 12:53:02 pm
Re: Sales Order Inquiry show invoice# (11 replies, posted in Accounts Receivable)
To save us the trouble, please list a set of URLs that you would use to achieve all of this along with the original source URL for the invoice. That way we can build the URL with the variables needed and put it in the invoice page.
Looks like the FA team has not yet returned from the Easter holidays as a few of the bugfixes (2172, 2183) in the Bugtracker have yet to find their way into the code base.
5,570 04/07/2013 12:40:58 pm
Re: POSTING METHOD (8 replies, posted in Setup)
AFAIK FA has real time posting and real time import (using addon).
Batch upload and review before posting is a nice feature - do not know if FA can accomodate it in the current version.
Possible Workaround:
Take backup
Do real time batch import
Check the registers and printouts
If found to need major record level corrections, then edit in the import source file
Restore from earlier backup
Re-import after corrections.
5,571 04/06/2013 12:34:54 pm
Re: POSTING METHOD (8 replies, posted in Setup)
Why do you need to switch at all?
Just keep it real time and post batch realtime as well.
5,572 04/06/2013 12:33:37 pm
Re: Sales Order Inquiry show invoice# (11 replies, posted in Accounts Receivable)
The view pages can have hyperlinks to the detail pages requested.
Very nice feature that FA can benefit from.
5,573 04/06/2013 12:31:26 pm
Re: Help required to create Chart of Accounts (5 replies, posted in Misc. Charts of Accounts)
What language do you want to use? Will en_US suffice?
What kind of COA do you want - Service, Manufacturing, Trading, etc?
How many digits do you want in the COA - 4, 5, or 8 or any other?
5,574 04/05/2013 03:12:20 pm
Re: Help required to create Chart of Accounts (5 replies, posted in Misc. Charts of Accounts)
Be more specific.
Do any of the COAs from the FA Repo suffice?
Can you not be modify them to suit your needs?
5,575 04/01/2013 10:55:00 am
Re: PDF-Prints (5 replies, posted in Reporting)
In FireFox, go to
File -> Page Setup -> Margins & Header/Footer
And chose to remove any Headers and Footers (set them to blank).