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 2 of 6)
I tried installing both the dashboard theme and module. When i activated the module, I got this error message:
file(../modules/Dashboard/sql/update.sql): failed to open stream: No such file or directory in file: /var/www/accounting/admin/db/maintenance_db.inc at line 293Invalid argument supplied for foreach() in file: /var/www/accounting/admin/db/maintenance_db.inc at line 298
So, I logged out and logged back in again. I then activated the dasbhoard theme from the Preferences screen. When I did that, I got these error messages:
Debug mode database warning:
error code : 1146
error message : Table 'accounting.0_dashboard_widgets' doesn't exist
sql that failed was : SELECT DISTINCT column_id FROM 0_dashboard_widgets WHERE user_id ='1' AND app='system' ORDER BY column_id
mysql_fetch_array() expects parameter 1 to be resource, boolean given in file: /var/www/accounting/includes/db/connect_db.inc at line 89
Also, when I go to the Setup page, I don't see any "Dashboard Setup" option.
Any ideas on what I did wrong and how to fix it? (Note: e-mail also sent to author as requested above.)
Thanks!
Regards,
Chris
To hopefully answer your question about setting up the printer, if you go to "Setup -> Print Profiles" and use "Browser Support" for your default printer and then set everything else to "Default" FA will bring-up the browser's print dialog. If you need anything fancier than that, there's a bit of help here.
Hope that's helpful...
Regards,
Chris
I can't help you on how to automatically send the mail, but just wanted to remind you... don't forget to save a backup copy of any file(s) you change. Otherwise, your change(s) will get overwritten if you do an update and those files are effected and you'll have to redo all the changes.
Regards,
Chris
I'm glad that I was helpful, TheoW!
Chris
You can put anything you want in the "Bank Account Name: field in "Banking and General Ledger -> Bank Accounts" so I'd suggest changing that field to "HSBC" or something other than your company's name. You also put the bank's name in the "Bank Name" field. Here's how my checking account is setup:
Bank Account Name: Current Checking Account
Account Type: Checking Account
Bank Currency: CA Dollars (I'm i Canada)
Default Currency: No
Bank Name: Bank of XXXXXX
Account Number XXXX XXXX XXX
Address: The bank's mailing address
When I'm in a payment screen I see "Current Checking Account in the bank account field.
Hope that helps...
Regards,
Chris
I'm not sure if I understand your issue, but the bank account name can be changed to anything in "Setup -> Bank Accounts" so if it's confusing to you just change it to something that isn't confusing, right? For instance, I have 3 bank accounts:
Cash on Hand
Checking Account
PayPal Account
If I'm missing something, let me know and I'll try again.
Regards,
Chris
I'm just wondering if those changes will adversely effect other reports? I haven't tried other reports (yet) to see if the logo is changed for them, but will do so in the next few days.
Just wondering...
Regards,
Chris
Setting "$this->row + 15" helps.
Thanks!
Regards,
Chris
@erwindebruin: Wish this Canadian could make some income! 
February is my slow month. Hopefully, March will be better.
Hi, Joe!
Setting COMPANY_WIDTH to anything greater than "40" makes my logo large enough to get in the way of the report header, so leaving it at that value has fixed the problem.
One thing I noticed, though... I think the problem isn't so much that the logo is too big (although that's a factor) but that it's printing too low on the report. I've noticed on other reports that the logo prints at the very top of the page, but for this report it's printing more down by the header.
I really wish I knew more about PHP so I could fiddle with this stuff myself! (SIGH!) But, maybe if somehow the logo could be moved up just a bit that would help?
No big deal! Don't waste time on it if there's other more important things to work on. Just thought I'd mention it.
Thanks, again, for all your help!
Regards,
Chris
@Tom:
Ahhh! I didn't realize that it's been that long since you worked with the code Sorry to bother you with it, then.
@Joe:
No problem, Joe. It's not a major issue (at least with me), so whenever you have time to take a look that will be fine.
Regards,
Chris
I just sent Tom an e-mail. Hopefully he'll be able to help.
Thanks!
Regards,
Chris
I'm not in the Netherlands, but this sounds like my company.... lots of expenses but no income! LOL! 
Regards,
Chris
Here's a couple of things to check:
1. Check Setup -> Points of Sale and make sure that "Allowed credit sale terms selection" and "Allowed cash sale terms selection" are checked.
2. Check Setup -> Access Setup -> Sales Transactions and see if there's a difference in how the two installations are configured.
Hopefully, one of the above will solve your problem. If not, then one of the developers might have an answer for you.
Regards,
Chris
No problem, Joe. Since this is an extension, I don't really expect you to spend a lot of time debugging it. I just wanted to let you know that the "quick fix" you suggested didn't work. When you get back to the office, if you have any contact info for Tom that will be helpful as I'll contact him and see if he can help.
Thanks!
Regards,
Chris
Joe:
Seems I'm having the same problem. I adjusted the LOGO_HEIGHT variable (there isn't a LOGO_WIDTH variable), but that didn't change anything.
Did you mean change the actual size of the logo????
Regards,
Chris
This extension was developed by Dennis Gichangi (dennis AT dennis DOT me DOT ke) so maybe if you contact him he can help you? I'm not a developer so I can't be all that helpful, but I would suggest setting one or more of these variables in config.php and see if you get any error messages:
$debug = 1; // show sql on database errors
$show_sql = 1; // show all sql queries in page footer for debugging purposes
$go_debug = 1; // set to 1 for basic debugging, or 2 to see also backtrace after failure.
$pdf_debug = 1; // display pdf source instead reports for debugging when $go_debug!=0
Btw, don't leave these variable set for long as they can generate a lot of clutter!
Another thing to check is that all of your assets are setup correctly. Sometimes, if certain fields are missing or incorrect it can mess things up.
I hope some of this is helpful to you. Sorry that I can't be of further help.
Good luck!
Regards,
Chris
Sorry, but I can't be of much help with this one as I've never used the recurring invoice feature. Maybe someone else who's used it will have some helpful thoughts?
Regards,
Chris
You're smart to be thinking of this kind of thing now, before you get to far into entering data into FA, so congrats on that.
Sounds to me like the setting up the items as "service" items will suit your needs, since tracking in/out movements isn't a issue for you Now, you have to decide whether to create one generic item (e.g. "Templates") and dump all templates into that, or create individual items for each template. Again, both methods work it's just a matter of how granular you want the data for future reporting/analysis purposes. Using separate items for each template will gives you more granular/detailed info but could get cumbersome if you're dealing with a lot of different templates.
Good luck to you in getting FA setup exactly how you want to suit your purposes! It sounds to me like you're well on the way!
Regards,
Chris
The "best" way is what works best for you but, basically, if you create it as a "purchased" item then it will be tracked in the inventory module so you can easily see movements in/out of inventory. If you create it as a "service" item you lose the movement tracking in the inventory module although can still post the debit to a COGS account instead of an expense account when you purchase the item.
So, I guess the question you have to ask yourself is how important is the tracking functionality to you?
That might have been part of why my attempt at wiping the database clean didn't work. What happened was not all of the data was erased, and some of the indexes got mangled. When I tried to then restore the real data from a backup, stuff got jumbled up.... GL accounts weren't balancing, reports were wrong, etc.
I found an SQL script somewhere in the forum for an earlier version of FA (can't remember which one but I think it was 2.2.x) that supposedly wipes the data clean. I tried to modify it to work with 2.3.13 but when I ran it it made a terrible mess of things so I ended up having to start from a clean install.
My recommendation is to NOT try and wipe the sample data and reset the database. There are just too many interrelated tables and if something goes wrong you're totally screwed. In the end, it is probably much easier to just start fresh with a clean install. However, if you wish to give it a try I do wish you the best of luck.
Regards,
Chris
One of the developers can tell you if it's possible and, if so, how to do it. If not, and if you're only dealing with a few items, I suppose you could set-up separate items for VAT and non-VAT, but that's a kludge and won't work if you're talking about a lot of items.
Btw, have you reviewed the Tax System section on the Wiki? Maybe that will give you some help?
Hope I'm being helpful here...
Regards,
Chris
The GL accounts for suppliers sets the Accounts Payable, Purchase Discounts (eg. for prompt payment of their invoices) and Expense/COGS accounts. You want to set the Expense/COGS account to "Use Item Inventory/COGS Account" so that when you purchase items from that supplier the expense is coded properly. Then it will work as it should.
Hope that helps...
Regards,
Chris
Posts found: 26 to 50 of 135
