Create a Supplier Invoice first. Then receive goods in the PO as GRN (or as Direct GRN).
627 08/20/2020 06:51:20 pm
Re: Database Schema FA 2.4.6 (3 replies, posted in Banking and General Ledger)
https://frontaccounting.com/fawiki/index.php?n=Devel.ERDiagram23
https://frontaccounting.com/fawiki/index.php?n=Devel.ERDiagram24
628 08/20/2020 06:42:06 pm
Re: edit login page (2 replies, posted in FA Modifications)
You will then need to input the text string for the company name and not it's numerical id.
629 08/20/2020 06:40:04 pm
Re: Installment Sales with Payment Schedule and Reporting. (4 replies, posted in Accounts Receivable)
You will need an extension for this as also for the reporting it needs.
@joe: FA 2.5 can add this installment feature natively.
630 08/20/2020 06:37:23 pm
Re: Function for even out rounding problems (7 replies, posted in Banking and General Ledger)
@djgatasri: Which account do you want this error to get into (or split into) especially when tax can be computed with an exchange rate as well.
@joe: any thoughts?
631 08/20/2020 06:27:18 pm
Re: Showing Supplier Reference on Statement (1 replies, posted in Reporting)
Which "Supplier Statement" are you referring to among the following available natively?
Supplier Balances
Aged Supplier Analyses
Supplier Trial Balances
Payment Report
Outstanding GRNs Report
Supplier Detail Listing
Print Purchase Orders
Print Remittances
632 08/17/2020 05:35:30 am
Re: Report branch customers (9 replies, posted in Reporting)
@joe: nice feature - can implement it - branch-wise split up of sales for each customer. A simple checkbox (boolean flag) for branch-wise reporting should be sufficient in the report request form.
633 08/17/2020 05:31:37 am
Re: 2 Language on Item of Customer Invoice & Supplier Invoice (2 replies, posted in Installation)
Update your FA 2.4.8 install by taking in the post release files from this post.
634 08/17/2020 05:30:10 am
Re: How to setup FA for an existing business. (5 replies, posted in Setup)
In old accounting system:
1. Before closing your old accounting system previous fiscal year, take a trial balance.
2. Segregate entries for unpaid invoices and the partial payments related to them - AR and AP.
3. Get the segregated Trial Balance without the above entries.
In new FA system:
1. In your new FA system, create the previous fiscal and make your current balances as as the end of that fiscal from the segregated Trial Balance obtained above.
2. Make the subsequent entries for the previous fiscal's unpaid invoices for both AR and AP.
3. Create a new fiscal year for the current period in the new FA.
4. Now close the previous fiscal in the new FA.
5. You will now be able to allocate payments to the old AR/AP unpaid invoices in the new FA.
You may need to make a few iterations - so keep a backup at each stage in both the old and the new systems.
If in doubt, take professional assistance.
635 08/15/2020 02:43:47 am
Re: Password encryption (8 replies, posted in FA Modifications)
That is why the password.php can be bundled into FA in the next version and make it into a separate extension for the current one. Note that the standard Charts will then be unusable until suitably modified.
636 08/15/2020 02:42:18 am
Re: Multiple Units of Measure in Inventory (6 replies, posted in Items and Inventory)
Keep different sales units as separate inventory items.
Also make stock movements when "disassembly" of such items are desired amongst them.
637 08/15/2020 02:38:54 am
Re: Receive Purchase Order Items: stopped working since 2.4.7! (6 replies, posted in Items and Inventory)
Some new fixes can override other previous changes that might break some earlier functionality.
@joe: is this an issue?
638 08/15/2020 02:35:07 am
Re: Password encryption (8 replies, posted in FA Modifications)
No wonder! PHP version 5.5.0 onwards the function password_hash has been available.
639 08/15/2020 02:30:47 am
Re: Costed Inventory Movement Report (1 replies, posted in Items and Inventory)
reporting/rep30.php can be edited as needed. Also the "OpeningStock" label needs a bit more space as the last letter is truncated in the current FA version though the snapshot in the Wiki appears fine.
The reason why there is no total for Items is that the units for the items can vary and you can possibly get the confusing total of Apples and Bolts!
640 08/15/2020 02:19:59 am
Re: Password encryption (8 replies, posted in FA Modifications)
Please note that this mod can only be applied in FA 2.5 as older versions of PHP do not have these encryption methods as the function password_hash uses BCRYPT.
For those who wish to use this functionality in PHP 5.3.7+ till < 5.5.0, refer the backward port function at:
https://github.com/ircmaxell/password_compat
and include the file password.php before usage.
641 08/14/2020 07:27:05 am
Re: Customer Payment allocation error when customer invoices fail to load (11 replies, posted in Accounts Receivable)
Cross Reference:
https://frontaccounting.com/punbb/viewtopic.php?pid=37998#p37998
642 08/14/2020 07:26:38 am
Re: Dropdown Menu Behavior After Ajax Fail (8 replies, posted in Report Bugs here)
@joe: is this the solution?
Past references are in Posts 7 and 10 of:
https://frontaccounting.com/punbb/viewtopic.php?id=8672
643 08/14/2020 07:18:17 am
Re: Password encryption (8 replies, posted in FA Modifications)
Upload changes and before and after screenshots if necessary somewhere and place link here.
644 08/13/2020 09:25:18 am
Re: Modularizing the Dashboard (82 replies, posted in FA Modifications)
An around 12 MB video of the walkthrough of the demo link above is here.
Good job @joe!
Maybe a set of changed files for the current FA 2.4.8 can be zipped up and provided here for users to test out this theme and dashboard. - Done
Updated video with no Create Company screens and with GL dashboard.
645 08/13/2020 09:13:11 am
Re: Add currency symbol (3 replies, posted in Banking and General Ledger)
Upload your Filippino (Tagalog) language and it's English local counterpart you are using for the language files. The FA project can be enhanced with it so that many fellow users in your country can benefit from. The community can also help make it utf-8 compatible too.
646 08/10/2020 05:57:55 pm
Re: Installing via Cpanel leads to download of unidentified file (5 replies, posted in Installation)
Enable php for your web server for the path in which FA is installed. Looks like the cPanel script just copied over the FA files and found that it could not use PHP in the target folder. All that this has exposed is the contents of the raw index.php file without PHP operation.
647 08/10/2020 04:14:47 pm
Re: Installing via Cpanel leads to download of unidentified file (5 replies, posted in Installation)
If you are using the Vivaldi or any non-standard browser, check your file associations for htm, html, php and other files.
648 08/10/2020 04:41:16 am
Topic: All charts updated (0 replies, posted in Misc. Charts of Accounts)
All 41 charts have been updated with the new sys_prefs strings in my extensions repo.
649 08/10/2020 04:36:32 am
Re: Setting up in NL using Belgian COA (4 replies, posted in Setup)
Can you not install the iso-8859-1 version of Dutch on your NAS?
The nl_NL is the more recent version in my extensions repo and that too is iso-8859-1.
Attached is a specially compiled version in utf-8 from the above for your needs.
If you have already installed the iso version, then edit the installed_languages / installed_extensions file config file with the appropriate encoding as in the _init/config file in the attachment and replace the .mo file in the lang/nl_NL/LC_MESSAGES folder.
650 08/09/2020 09:27:22 am
Re: Change search list option (1 replies, posted in Setup)
FA => Setup tab => Company Setup => User Interface Options => Search Customer List / Search Supplier List / Search Item List
Tick the check boxes as appropriate and click "Update".
Now the said search box will act as a filter for the drop down box.