401

(1 replies, posted in Setup)

Logout and Login again for settings changes to come into effect. Also check the account setting for the discount.

Clone reporting/rep707.php and alter after the line with 'Calculated Return'.

http://libgen.is may have the old books.

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.

Provide FA and platform versions from / to you want to upgrade and the bounty you offer.

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

(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

(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

(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

(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.

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.

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

(21 replies, posted in Reporting)

@joe: Any clues?

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.

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.

See your PM.

417

(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

(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.

Attachment is the code in file format.

420

(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.

@joe: ?

@joe: ?

@joe: ?
Will need to change the translation strings as well.

@PaulShipley: Which exchange rate provider was chosen?

@joe: ?

Try with PHP 7, 7.1 and 7.2 and see it broke then. Try switching the exchange rate provider. Some broke earlier.