You can print the balance sheet only in the home currency of the company in FA now. We will need the exchange rate for the day on which the Balance Sheet is prepared and make allowances for rounding off errors and create another report (or the same one with an extra currency field) based on the current one for multi currency by just factoring in the exchange rate given.
4,026 06/09/2015 02:33:44 am
Re: Balance sheet/Trial Balance report with multiple currency (2 replies, posted in Reporting)
4,027 06/06/2015 02:04:01 am
Re: Dimensions and customer payments (1 replies, posted in FA Modifications)
Unless the sales invoice was "dimensioned" making a customer payment on a dimension would be orphaned.
4,028 06/06/2015 02:02:37 am
Re: Backup not done (6 replies, posted in Setup)
Try to optimise your database like from within phpMyAdmin.
Also check which tables are having huge number of records and/or are occupying huge space and delete records that are useless like SQL audit trails.
See if the database has some other tables not related to FA but having the same table prefix as the FA instance.
4,029 06/06/2015 01:59:51 am
Re: trans_no in 0_debtor_trans table (4 replies, posted in Items and Inventory)
To make sure that the new trans_nr is 1 more than the maximum of any previously allocated trans_nr which may or may not have been voided.
4,030 06/06/2015 01:57:57 am
Re: Unable to Launch report in PDF format (1 replies, posted in Reporting)
Looks like you are using some un-escaped character in your data that is not in the decoded list.
4,031 06/06/2015 01:56:53 am
Re: Report: Local Purchases and External Purchases (3 replies, posted in Reporting)
Have you tried GRNs for imports?
What distinguishes an import from a local purchase? Currency? Supplier location? Import Duties entry?
4,032 06/06/2015 01:55:27 am
Re: How to handle this problem with tax-es? (1 replies, posted in Setup)
Are you offsetting inward taxes with outward taxes like in VAT where only the difference is payable?
The taxes in FA are only for sales.
The purchase taxes need to be handled as part of total cost (debit COGS) and credit supplier.
4,033 06/06/2015 01:45:11 am
Re: quick entries question (5 replies, posted in Banking and General Ledger)
@joe: nice one to correct or add on with a flag in the config for such base value calculations.
4,034 06/06/2015 01:43:27 am
Re: zh_TW updates (14 replies, posted in Translations)
Zip and upload somewhere and paste the link here.
4,035 05/27/2015 03:45:43 pm
Re: email logging (3 replies, posted in Wish List)
If you choose to have FA email clients and some sort of sent items folder (db table...) is available, it might serve as a trace for the record. If there is an email id attached to the client / branch, and emails are enabled, the emails will get sent on the date the invoice gets booked into the accounts.
A line to record the event can be hacked into the email sending code fragment - a sort of email log.
4,036 05/27/2015 03:41:20 pm
Re: Discrepancy: value of stock in balance and inventory valuation report (6 replies, posted in Items and Inventory)
Please check if this issue still persists in FA v2.3.24+ as well
4,037 05/26/2015 02:45:06 pm
Re: email logging (3 replies, posted in Wish List)
on the date of the invoice isn't it?
4,039 05/26/2015 02:42:36 pm
Re: Change Home Currency to EURO (1 replies, posted in Report Bugs here)
Make sure you start with a blank CoA - no transactions. If you are using the en_US-demo.sql, then accounts with transactions will not allow for currency changes...
4,040 05/26/2015 02:40:34 pm
Re: Purchase Order Entry - second line of item (1 replies, posted in Report Bugs here)
Patience with Ajax race condition...
4,041 05/26/2015 02:39:33 pm
Re: Popup Editors in tabs (1 replies, posted in Report Bugs here)
Browser and version on platform OS and version?
4,042 05/22/2015 02:06:18 am
Re: Problem with Manufacturing Auto Increment reference is not working (4 replies, posted in Manufactoring)
@joe: include into core?
4,043 05/22/2015 02:05:17 am
Re: How to clear all transactions? Prepare for business... (3 replies, posted in Setup)
Just restore from a blank CoA or create a new company with a blank coA (eg., sql/en_US-new.sql)
4,044 05/22/2015 02:04:12 am
Re: Report: Item history (3 replies, posted in Reporting)
As a workaround, just make quotations for each customer for each period and generate the invoice with the appropriate rebate at the end of the period in just 1 invoice for each customer then.
4,045 05/22/2015 02:02:34 am
Re: Decimal places of prices (14 replies, posted in Setup)
@joe: can @redoctober83's suggestion be taken into revising the formulae used in FA? Multiply rate with quantity first and then round off...
4,046 05/22/2015 01:58:08 am
Re: 2 ways synchronization between vtiger and front accounting - RELEASED (31 replies, posted in Modules Add-on's)
Try various APIs (SOAP) in the wiki. Even simple addons like Asterisk integration cost $700/- in EspoCRM!
4,047 05/18/2015 03:08:25 pm
Re: Created table in database as dynamically (3 replies, posted in Setup)
Read the wiki and search the forum on how to create an extension and analyse the assets register extension.
4,048 05/18/2015 03:07:23 pm
Re: Add new modules for created menu (1 replies, posted in Announcements)
Refer this post.
4,049 05/18/2015 03:02:50 pm
Re: How to input GRN for sample item from supplier? (3 replies, posted in Accounts Payable)
Buy from supplier at 0 price or 0.01 price!
4,050 05/18/2015 03:01:41 pm
Re: Report: Item history (3 replies, posted in Reporting)
If you mean Item Sales Price history, then "No". The only place you will get Sales and Purchase Price history is in the Sales and Purchase Invoices!