@joe: Can integrate the Approvals System into atleast FA 2.5.
926 11/09/2019 07:42:25 am
Re: Approval System for GL Postings Demo and SourceCode (30 replies, posted in FA Modifications)
927 11/09/2019 07:40:30 am
Re: Front Accounting buggy in Chrome (8 replies, posted in Report Bugs here)
Which version of FA are you using and which PHP/MySQL versions are dissing out FA?
928 11/09/2019 07:39:20 am
Re: Installation problem (24 replies, posted in Installation)
Try with XAMPP v1.7.7 first.
929 11/09/2019 07:35:46 am
Re: Sales Order / Delivery Note - quantity stays at zero (3 replies, posted in Report Bugs here)
Firstly, you are using a very old version of FA. The last version in the FA 2.3.x series is FA 2.3.26 which may have addressed some of the issues till then.
Secondly, check if the PHP / MySQL version in your server has changed and if so, as to have it reverted to the older version in which your FA version was stable.
If you are technically handicapped, take professional assistance by posting your bounty in the Jobs board.
930 11/09/2019 07:32:59 am
Re: Project Management Extension (24 replies, posted in Modules Add-on's)
Take it from https://github.com/apmuthu/FA24extensions/tree/master/Extensions/kanban
931 11/09/2019 07:28:29 am
Re: Fixed Asset - Process Depreciation (12 replies, posted in Fixed Assets)
You have credited and debited the same account!
932 11/09/2019 07:25:17 am
Re: Standard Cost Changes and as such result to Negative Profit in Report (28 replies, posted in Items and Inventory)
Check out the dump of the original db and compare with the new one for duplicate primary key records and reconcile them first. Which 2.4.7 sql file are you trying to import?
933 11/09/2019 07:23:07 am
Re: Upgrade from FA 2.3.2 (5 replies, posted in Installation)
1. Check the versions of your source and target MySQL DB and PHP versions
2. Provide your source and target FA versions
3. List any extensions added in FA 2.3.x that may have spawned additional tables / file mods
4. List any custom FA and sql mods done
5. Checkout the FA source dump (backup - list size / open fiscal years) and compare schema with FA 2.4.7+ sql/en_US-new.sql schema.
6. Checkout all the sequential sql/*.sql and sql/*.php file updates after your existing versions
Test it out in a VM / container first. Paid assistance booty can be posted in the Job Offers board.
If all else fails, PM me.
934 11/09/2019 07:13:07 am
Re: recurring invoices - period (4 replies, posted in Accounts Receivable)
@joe: can commit?
935 11/09/2019 07:12:06 am
Re: Replacement for Fiscal Years admin function (3 replies, posted in Modules Add-on's)
Consider truncated fiscal years where the end_date is not 1 year ahead.
936 11/09/2019 07:07:58 am
Re: Supplier Payment for general expenses. (3 replies, posted in Accounts Payable)
You have to make a purchase invoice for the supplier and allocate the payment to the supplier. You have directly written off the expense and hence the loose left over payment entry.
Debit: Stationary Expenses Account [Amount :500]
Credit: Supplier - Invoice for Stationery [Amount :500]
Debit: Supplier - Payment made [Amount :500]
Credit : Bank Account [Amount :500]
937 11/09/2019 07:02:22 am
Re: Reconciliation Bank Account (3 replies, posted in Wish List)
This may be so where timezone issues are concerned when full timestamps are used and also for correction of dates as well.
938 11/09/2019 06:53:34 am
Re: Error when printing to Excel (2 replies, posted in Banking and General Ledger)
939 10/13/2019 03:25:40 pm
Re: TAX 5.0% not calculate correctly and not shows under n after subtotal (4 replies, posted in Accounts Receivable)
Upgrading to FA 2.4.7+ is recommended by downloading the post release fixes in this post and uploading to your server installation overwriting the existing ones.
940 10/13/2019 03:21:47 am
Re: TAX 5.0% not calculate correctly and not shows under n after subtotal (4 replies, posted in Accounts Receivable)
Upgrade to the latest FA 2.4.7+. Many bugfixes have been made since the release of FA 2.4.7. See this post.
Sales => Sales Type => Tax Included => No -- for the specific Tax.
941 10/12/2019 01:41:32 pm
Re: Attachment for Customers and Suppliers (27 replies, posted in Wish List)
Updated attachment in Post #17
942 10/12/2019 01:30:30 pm
Re: Problem with Inventory Valuation Report Sub-store (9 replies, posted in Reporting)
Yes. This is intentional in FA 2.4 by design.
943 10/12/2019 01:17:31 pm
Re: Direct Supplier Invoice Templates (1 replies, posted in Wish List)
Not that I know of.
Anyone using Customer Templates can chip in with mods for Supplier Templates.
944 10/11/2019 04:32:49 am
Re: Attachment for Customers and Suppliers (27 replies, posted in Wish List)
@Rmendez: Thanks for testing it.
The use of the string 'false' instead of the boolean false and the out of order include have contributed to the problem and has been rectified in the attachment which includes the diff file and the screenshot of successful addition of new supplier.
A few more files (need to properly check on what has worked till now anyway) that have this kind of construct (and 'true' as well) are:
reporting/includes/fpdi/pdf_parser.php
reporting/includes/tcpdf.php
includes/JsHttpRequest.php
@itronics / @joe: can commit it.
945 10/10/2019 03:04:46 pm
Re: Attachment for Customers and Suppliers (27 replies, posted in Wish List)
No problem adding customer.
See screenshots attached.
Provide more information regarding your issue with debug and sql_trails along with platform versions.
946 10/10/2019 02:34:35 am
Re: Attachment for Customers and Suppliers (27 replies, posted in Wish List)
Further testing reveals that popup windows need to be enabled for the FA site for the Setup => Attachments View button functionality to work. The Sales => Add?Manage Customers => Attachments View Attachment button works okay even without such settings.
This is so because, the former uses a "button" tag whilst the latter uses the "a href" tag.
# Setup => Attachments (needs popup exception for FA domain)
# Sales => Add/Manage Customer => Attachments (no need for pop settings)
The HTML code inspection reveals the Concerned Lines:
# Lines 199 and 227 in admin/attachments.php
<td><button type="submit" class="editbutton" name="view3" value="1" title="View">
<img src="../themes/default/images/view.gif"
style="vertical-align:middle;width:12px;height:12px;border:0;">
</button>
</td>
# Line 95 in includes/ui/attachments.inc
<td style="text-align: center;">
<a target="_blank" class="viewlink"
href="../../admin/attachments.php?vw=3"
onclick="javascript:openWindow(this.href,this.target); return false;"
accesskey="V">
<img src="../../themes/default/images/view.gif"
style="vertical-align:middle;width:12px;height:12px;border:0;">
</a>
</td>
947 10/10/2019 01:33:49 am
Re: Attachment for Customers and Suppliers (27 replies, posted in Wish List)
This feature has finally been incorporated into the FA Core by @itronics. Thanks a lot for the spit and polish and fully working state.
Commits:
https://github.com/FrontAccountingERP/FA/commit/3d95c6844745f183ebab970251cd254dd6cbdcec
https://github.com/FrontAccountingERP/FA/commit/15576cedd9e46caac2884c2815875e7ec9fd4802
Attached are the changed files for FA 2.4.7+ as on date.
Those who have used the old code will need to take note of:
To preserve some FA types numbering scheme consistency, the type_no used are 41 and 42 as customer/supplier attachment type (instead of 5 and 6 in original code).
Seems the original code was not ready for production, expect nobody will have problem with renumbering existing records in attachments table's field type_no with something like:
UPDATE 0_attachments SET type_no=41 WHERE type_no=5; UPDATE 0_attachments SET type_no=42 WHERE type_no=6;
Use Table prefix as appropriate instead of the 0_ above.
948 10/08/2019 01:30:57 pm
Re: Attachment for Customers and Suppliers (27 replies, posted in Wish List)
@itronics is working on it. We finally need to get rid of the includes/ui/attachment.inc file and get it working consistently across user interfaces.
Known issues:
1. Attaching MS Office documents like docx, xlsx, pptx, etc will result in error as the mime type exceeds 60 characters - need to increase the size of the field attachments.filetype to say 100 from the current 60 characters.
2. Edit of the attachment record in Sales => Add and Manage Customers => Attachments tab does not work as yet.
949 10/08/2019 06:05:29 am
Re: Attachment for Customers and Suppliers (27 replies, posted in Wish List)
File Attachment using Sales => Add / Manage Customers => Attachments now works for Adding file.
The changed files download has been updated in this post.
950 10/08/2019 05:44:37 am
Re: Error Restoring Database (3 replies, posted in Installation)
You can do a restore using PHPMyAdmin or other SQL client if very large.
Large DB Restore will need to be re-written in FA 2.5.