Logout and Login again for settings changes to come into effect. Also check the account setting for the discount.
402 07/04/2021 06:00:23 am
Re: Create a new calculate field in profit and loss report (1 replies, posted in Reporting)
Clone reporting/rep707.php and alter after the line with 'Calculated Return'.
403 04/04/2021 03:01:15 am
Re: Anyone using FrontAccounting with OpenCart? (9 replies, posted in Modules Add-on's)
http://libgen.is may have the old books.
404 04/03/2021 06:12:21 am
Re: Anyone using FrontAccounting with OpenCart? (9 replies, posted in Modules Add-on's)
Although the System Requirements state that PHP 5.4+ is sufficient, the OpenCart v3.0.3.7 expects:
PHP8+ Required
The non-composer usage vendor folder is at upload/system/storage/vendor for OpenCart 3.x.
The ebooks available are for OpenCart v2.x only as on date and the online documentation is for that version which sports 131 tables at first install at the end of which there is a solicitation to buy the PHPMailer Addon for USD 20/- which can be manually hacked in as stated in a Github project and seconded here.
Free modules for OpenCart are here.
Attached is the set of screenshots of v2.3.0.2 install and sql / bash instructions that would be useful to integrate with FA.
405 04/03/2021 05:55:50 am
Re: need someone to upgrade php 5 scripts to php 7 (2 replies, posted in Jobs wanted/offered, non-free offers)
Provide FA and platform versions from / to you want to upgrade and the bounty you offer.
406 04/03/2021 05:33:19 am
Re: Anyone using FrontAccounting with OpenCart? (9 replies, posted in Modules Add-on's)
https://github.com/opencart/opencart
http://docs.opencart.com/en-gb/requirements/
It uses MySQL database.
Can use triggers and procedures between FA and OpenCart DBs if on the same server.
Choose which application should be used for customers/suppliers data to be managed from.
Also whether accounting work in OpenCart and FA should be both ways or one way (which way).
407 04/03/2021 04:59:45 am
Re: Invoice for a deposit? (5 replies, posted in Accounts Receivable)
Treat Deposit as a non inventory item and bill it. When final invoice is ready, invoice that and make a Journal Entry for the original Deposit invoice into payment for the final invoice.
408 04/02/2021 03:06:08 am
Re: Invoice for a deposit? (5 replies, posted in Accounts Receivable)
Split the order into two parts - one for the work that the deposit tentatively pays for and another that can be for extra adjustments to the original order as a new order even it is just an addendum and then receive payment for that when done.
409 03/29/2021 04:56:06 am
Re: Manage Child/Franchise of Company Record (4 replies, posted in Setup)
Subsidiary ID can be introduced for all transactions in FA 2.5 with just the unique suffix of each such company and having a set of UNION views for the holding company for all FA tables using it in a read only mode. The list of subsidiary companies (or profit centres / branches) that need to be UNIONed into views for the holding company can be autocreated with some description field holding the company #s.
Try using Tags / Dimensions as a first choice though.
410 03/29/2021 04:50:41 am
Re: Upgrade to 2.4.9 from 2.4.8 (7 replies, posted in Installation)
Use a phpMyAdmin or SQLyog or any other MySQL client to get the job done on a GUI. Alternatively on a linux / windows commandline, do a restore of the sql.
411 03/29/2021 04:47:11 am
Re: Foreign currency on print for general ledger and journals entry ledger (1 replies, posted in Reporting)
Using phpMyAdmin or some MySQL client, hammer out a sql construct that displays the information you want and then make it into a custom report and share it to see if it makes it to the core.
412 03/29/2021 04:44:19 am
Re: Can I keep a credit for my customer in the system? (7 replies, posted in Accounts Receivable)
Just check customer ledger balance / statement before asking for payment. If such information as account balance shows up in an invoice, then all payments made thereafter and in invoice printouts taken later would be different.
413 03/29/2021 04:42:06 am
Re: REP709.php TAX REPORT BUG (21 replies, posted in Reporting)
@joe: Any clues?
414 03/25/2021 08:06:13 am
Re: Bank account balance is not the same in trial balance. (11 replies, posted in Banking and General Ledger)
Check if there are any un-reconciled entries in your bank account that is not there in your trial balance and vice-versa and pass necessary Journal entriess.
415 03/25/2021 07:51:04 am
Re: How to Create an opening balance in Fixed Assets? (4 replies, posted in Fixed Assets)
Create an anatomy for the Fixed Assets Entry:
1. Take FA backup
2. Make single Fixed Asset Entry
3. Take second FA backup
4. Check the difference between the two backups
5. Create a set of INSERT and UPDATE statements to achieve the same.
6. Substitute the values for all other entries say from excel.
7. In one shot, load in all the sqls into the FA db.
416 03/18/2021 07:01:18 pm
Re: Troubleshooter wanted. (2 replies, posted in Jobs wanted/offered, non-free offers)
See your PM.
417 03/12/2021 08:30:10 pm
Re: Special Customer pricing (1 replies, posted in Wish List)
Percentage / Fraction type pricing is available across all items like Wholesale / Retail in FA.
Yes, this would entail a new table and hence can either be an extension for now or await FA v2.5.
418 03/12/2021 08:25:58 pm
Re: COGS inflated (3 replies, posted in Banking and General Ledger)
There are a total of 93 fields(en_US-new.sql) that re "double" type that are good for binary base computations that mess with decimal computations where a decimal field type should have been used. But this should not create such a huge difference unless an additional mess with signed and unsigned field type attributes are in the same expression.
419 03/08/2021 07:46:31 am
Re: php 7.4 function money_format() is deprecated (4 replies, posted in Report Bugs here)
Attachment is the code in file format.
420 03/08/2021 07:43:28 am
Re: Cron Job Module (11 replies, posted in Modules Add-on's)
@joe: There must be a better way to do this by calling it based on last timestamp of call taken from some log file in the index.php file itself.
421 03/08/2021 07:40:19 am
Re: Exchange Rates - ECB rates parsed as strings (1 replies, posted in Report Bugs here)
@joe: ?
422 03/08/2021 07:39:14 am
Re: Exchange Rates - Add Australian RBA as Provider (1 replies, posted in FA Modifications)
@joe: ?
423 03/08/2021 07:37:28 am
Re: Exchange Rates - show default currency and provider (1 replies, posted in FA Modifications)
@joe: ?
Will need to change the translation strings as well.
424 03/08/2021 07:28:54 am
Re: Exchange Rates - date not refreshed on update (2 replies, posted in Report Bugs here)
@PaulShipley: Which exchange rate provider was chosen?
@joe: ?
425 03/08/2021 07:26:28 am
Re: Cannot download repo index file. error 2.4.6 (10 replies, posted in Report Bugs here)
Try with PHP 7, 7.1 and 7.2 and see it broke then. Try switching the exchange rate provider. Some broke earlier.