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.
477 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.
478 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.
479 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.
480 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.
481 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.
482 03/29/2021 04:42:06 am
Re: REP709.php TAX REPORT BUG (21 replies, posted in Reporting)
@joe: Any clues?
483 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.
484 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.
485 03/18/2021 07:01:18 pm
Re: Troubleshooter wanted. (2 replies, posted in Jobs wanted/offered, non-free offers)
See your PM.
486 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.
487 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.
488 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.
489 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.
490 03/08/2021 07:40:19 am
Re: Exchange Rates - ECB rates parsed as strings (1 replies, posted in Report Bugs here)
@joe: ?
491 03/08/2021 07:39:14 am
Re: Exchange Rates - Add Australian RBA as Provider (1 replies, posted in FA Modifications)
@joe: ?
492 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.
493 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: ?
494 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.
495 03/06/2021 08:23:23 am
Re: Hide Menu options if not authorized (for Report) (6 replies, posted in Wish List)
This workaround is for those who want it and is documented in the wiki.
Sometimes, bosses do not want their staff to see what reports the management is capable of viewing!
496 03/05/2021 04:44:34 pm
Re: Re-open Closed Work order (1 replies, posted in Wish List)
Void and re-create?
497 03/05/2021 04:43:59 pm
Re: Hide Menu options if not authorized (for Report) (6 replies, posted in Wish List)
@joe: ?
498 03/05/2021 04:38:57 pm
Re: How to Create an opening balance in Fixed Assets? (4 replies, posted in Fixed Assets)
As opening balance or a set of Asset depreciation entries or as a single consolidated asset depreciation entry.
499 03/05/2021 04:34:22 pm
Re: Customer Statement by Customer branches (6 replies, posted in Reporting)
@joe: can hammer out a new report for this in the core.
500 03/05/2021 04:31:12 pm
Re: Cannot download repo index file. error 2.4.6 (10 replies, posted in Report Bugs here)
What browser and version are you using?