Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 160 of 247)
Topics by apmuthu User defined search
Posts found: 3,976 to 4,000 of 6,171
The following 42 tables in your mysql data folder zip are corrupted:
audit_trail
bank_trans
budget_trans
comments
crm_categories
crm_contacts
crm_persons
cust_allocations
dashboard_reminders
dashboard_widgets
debtor_trans
debtor_trans_details
dimensions
fiscal_year
gl_trans
grn_batch
grn_items
item_tax_type_exemptions
item_tax_types
loc_stock
purch_order_details
purch_orders
recurrent_invoices
refs
sales_order_details
sales_orders
stock_master
stock_moves
supp_allocations
supp_invoice_items
supp_trans
sys_types
tax_group_items
tax_groups
tax_types
trans_tax_details
voided
wo_issue_items
wo_issues
wo_manufacture
wo_requirements
workorders
Do you still want the data from the other tables recovered? The missing tables schema can be populated from your original sql but their missing data needs to be reconstructed manually.
The 2 dashboard_* tables can be deleted and reconstructed by reinstalling the dashboard theme and extension.
Practically all your InnoDB tables have been lost!
As a trusted ERP that FA is, the sales register is designed to be not easily editable. Just void the invoice and create a new one.
For Purchase Invoices refer this post.
Purchases => Supplier and Purchasing Reports => Supplier balances => Filter Supplier.
Moved @sorna post above as new topic to this post.
@sorna's post: How to create purchase invoice register as similar to sales invoice register. Its hard to edit sales invoice register.Please provide me a solution.
Check your apache (webserver) error logs and the FA error log in the [WEBROOT]/tmp folder for any clues.
Which version of FA are you using and from where did you get it?
@kvvaradha: Thanks. Wikied it.
Just make a new report that has the contents of both.
1. Login as admin to your company and navigate to Journal Entry in Banking and General Ledger.
2. Set the date to 30th June 2014.
3. Make a single Journal entry with all line items from your Balance Sheet's closing balances.
They should balance out correctly.
Make sure all your Balance Sheet Account heads are available in your Chart of Accounts before doing so.
The Wiki is self-explanatory. If you do not understand the language in it, consult someone locally who does.
Files in the Git repo can be linked, but others not there will need to be put into the Github's Wiki or attached to the GitHub Issues - most will not take the trouble to do it.
Thanks for looking into it anyway. It is probably set so to avoid bandwidth leeching.
Committed in my GitHub repo.
Thanks @jornrikkers and @raddison.
All Brahmi derived scripts from Tamil to Hindi to Bengali and Sinhalese and possibly Cambodian cannot be used for reporting in FA as is since the complex kernings have not been implemented in TCPDF/FA as yet.
You can read more on this in my GitHub Issue 6.
The .po / .mo is meant for display only and that will work for Bengali if available / made.
@joe: It might be useful to enable downloads without registration so that we do not have a bloated set of users with 0 posts. Can then delete users with 0 posts as well.
Would you like to provide the changes in db schema and the fileset to the project?
Would you like to provide a diff or changed fileset to the project?
Actually, the GET button can be renamed to get the current rate only rather than disabling it - most currencies are not that volatile ordinarily and will serve as a reference to manually adjust them from other manually looked up sources.
Getting historical data is possible from providers like XE.com but then somewhere else we would need to pre-populate the date before submitting it as a GET request. To this end you may lookup the function provided in my GitHub phpprojects/XE and incorporate it into FA. You may need to buy their API license (about USD 800/- a year!) if you use it often as they record IPs.
FA 2.4 Theme Screenshots available in my unofficial GitHub Wiki.
Dashboard Extension and the Dashboard Theme / Exclusive Theme for Dashboard install properly.
Dashboard widgets show some boxes in each tab. The Dashboard tab is setup blank. The Dashboard Setup and reminder Setup lead to blank pages.
The elegant theme has been tested in FA 2.4.
The page_edit.png file is missing in it's images folder. We can take it from the exclusive theme.
The left menu shortcuts have the correct URL values when the top menu items are clicked. When the menu links in the body of the page are clicked, the left menu shows the URLs from the webroot instead of the FA application root when FA is installed in a folder under the webroot.
apmuthu wrote:FA v2.4 beta can be installed after incorporating the fix detailed in this post.
sys_types and movement_types tables are still present in en_US-demo.sql while being absent in en_US-new.sql - not used in FA 2.4.
journal, reflines and wo_costing are the new tables introduced in FA v2.4.
If you have installed the en_US-demo.sql, then update the currency symbols with:
UPDATE `0_currencies` SET `curr_symbol`='£' WHERE `curr_abrev`='GBP';
UPDATE `0_currencies` SET `curr_symbol`='€' WHERE `curr_abrev`='EUR';
The above have now been set right in the FA Repo commits 1 and 2.
Screenshots of FA 2.4 Beta - Install, Usage, Extensions available and Themes.
1. Start with the standard Indian CoA.
2. Take a backup.
3. Add in the taxes you wish.
4. Take another backup.
5. Compare the backups in WinMerge and port the changes into the standard Indian CoA you started out with. That will be the new Indian CoA. Upload the new CoA into the [WEBROOT]/sql/ folder and it will be available for new company creation.
List the menu navigation steps you used.
The relevant files to replace are in his repo at:
https://github.com/elax/fa-rep-customer_account_statement
Compare with the files as on that date for that version and port it accordingly.
Try a blank (or value: auto) hidden field for it.
See if the default URL for ECB works:
http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml
The relevant code is in lines 114-115 in gl\includes\db\gl_db_rates.inc
All forex rate service providers harnessed in FA are for current exchange rates only.
Posts found: 3,976 to 4,000 of 6,171
