Use a journal entry:
To Debit Payee Account $a
To Debit Bank Charges $b
To Debit Bank Tax Payable $c
By Credit Bank for Cheque paid $d
such that $d = $a + $b + $c
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by apmuthu
Use a journal entry:
To Debit Payee Account $a
To Debit Bank Charges $b
To Debit Bank Tax Payable $c
By Credit Bank for Cheque paid $d
such that $d = $a + $b + $c
Check for extra blank line and see that the CRLF is all replaced with LF as line endings of text / csv file.
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).
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.
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.
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.
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.
@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.
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.
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.
@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.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.