As FA currently stands, after I have added a new item to the database (Items & Inventory -> Items -> New Item) I then have to click on the Sales Pricing link and enter a new selling price for the item.  Then, I have to click on Items & Inventory and click on the Purchasing Pricing link and enter a new purchasing price for each vendor I purchase the item from.  This is not all that convenient, and is time consuming.

I have managed to figure out how to add a Purchasing Pricing link to the Items & Inventory menu bar so, now, I at least don't have to go back to the main Items & Inventory screen to get to the Purchasing Pricing link.  However, I'd prefer to have both the Sales Pricing and Purchasing Pricing links work as pop-up windows to the main Items screen so that I don't have to keep going back to that screen when I'm entering multiple new items.

Can someone explain to me how to do this?  I found the get_js_open_window function in includes/ui/ui_view.php but I can't seem to get it to work properly.

Thanks for any help/suggestions offered.

Regards,

Chris

77

(10 replies, posted in Installation)

It looks to me like you have to fix the following problems before you can proceed further:

gdel wrote:

PHP MySQL extension     Required     No     Your PHP has to have MySQL extension enabled.

You need to enable the MySQL module to PHP.  I think this only requires an edit to the PHP configuration file, but I'm not sure.

gdel wrote:

Database auth file     Required     ../config_db.php     Can't write '../config_db.php' file. Check FA directory write permissions.
Main config file     Required     ../config.php     Can't write '../config.php' file. Check FA directory write permissions.

It looks like the permissions for config.php and config_db.php are wrong.  To fix this from a terminal command line, execute this command in the root FA directory (eg. /var/www/frontaccounting):

sudo chmod 755 config*.php

Btw, be sure to change the permissions back to not-writeable once you get FA totally set-up as having the config*.php files writeable is a security risk.

gdel wrote:

OpenSSL PHP extension     '../installed_extensions.php' is not writeable
Extensions configuration files and directories should be writeable

Same problem as above, so change to the directory where the installed_extension.php is located (I can't remember it offhand) and execute the same command as above but change "config*php" to "installed_extension.php".

Once that's done, run the install script again to see if everything is now okay and you can proceed.  If not, keep fixing problems until you can.

Hope that helps...

Regards,

Chris

78

(9 replies, posted in Reporting)

Works for me, Joe.  Thanks!

Regards,

Chris

79

(9 replies, posted in Reporting)

itronics wrote:

You have to activate the installed extension for every company you like to use it in.  Go to 'Install/Activate Extension' select your company in top selector and activate the report extension.

DOH!!!  I hadn't done that...  silly me!  (BLUSH!)

Okay, now the report appears in the list on the Inventory Reports & Analysis page but, again, when I try and run it nothing happens.  No error message, no PDF viewer (not even a blank one, nothing.  I tried various combinations of date ranges and inventory category filters (including no filter), and still nothing happens.

Any ideas where to go from here?

Thanks!

Regards,

Chris

FYI, I'm fairly new to FA too, so I'm still learning about how it works too.

Yes, the Direct Invoice function allows you to enter a supplier invoice without having to create a purchase order and goods received note.  There's also a Direct Invoice function in the sales modules which allows you to invoice a customer without going through the quotation -> order -> deliver -> invoice process.  I use both the sales and purchasing Direct Invoice functions because I'm a small, one-man operation so I seldom need to go through the full processes.  The only time I use the Sales Quotation function is if I'm asked for a quotation and the customer insists on a formal, written quote.  Other than that, I skip right to the invoice.

Another set of functionalities you might want to look into are Quick Entries.  When using the Direct Invoice functions in sales and purchasing, you must create an item and supplier/customer.  The Quick Entry functions allow you to bypass all that and post entries directly to the GL.  I use quick entries for repetitive monthly entries (e.g. rent, utilities, etc.) and for one-time transactions where it isn't worth the time/effort to set-up a customer/supplier and/or item.  As well, you can use quick entries to do some pretty fancy calculations before posting the transaction.  For instance, I work out of my home so my monthly rent and utilities quick entries do an automatic split between personal and business costs, and only posts the business costs to my GL.  It's a bit complex to figure it out at first, but ver handy once you do.  Check it out!

Anyway, I'm glad my comments were helpful.  I'm not a programmer so I can't contribute much on the technical side of FA, but I do try and contribute on the non-technical side when I can.

Regards,

Chris

That fixed it here, too.  Thanks!

Regards,

Chris

joe wrote:

Please try to change line 362 in /includes/session.inc from:

header("Cache-control: private");

to

header("Cache-control: no-cache");

and see if it helps.

/Joe

Did that.  No change.  sad  I still get the 500 error but when I refresh the page I get in.

Regards,

Chris

My assumption, which was apparently wrong, was that when the original company was "split" the new company would "start" with opening GL account balances comprised of a percentage of the assets, liabilities and equity of the original company based on how they were split-up when the partners separated.  If not, and you're starting from scratch, then everything else I said applies.  Just don't enter any opening balances from the old company.

The "bottom line" is that FA does handle multiple companies by using different table prefixes for each company.  Then, when someone logs onto the system, the select the commpany they want from the drop down list.

Regards,

Chris

Again, it's best to talk to your accountant about the best way to establish your chart of accounts and items to meet your business needs.  I'm only offering "things to think about" as opposed to accounting advice.  Your requirements will be unique to your specific business, so only you can decide what's "best" for your business.

The same comments I made before apply whether you're only recording expenses or whether you're recording both revenues and expenses for an item.  Since you're creating "service" items for domains, nothing is hitting inventory so all tracking/analysis takes place through GL reports (trial balance, balance sheet, income/expense, etc.)  If you don't need to separately track/analyze expenses for internal domains, then creating one item called "internal domains" will do.  But, if you need to analyze/track expenses for internal-only domains separately, then your choices are:

  • create individual items for each internal domain, or

  • create separate GL expense accounts for each internal domain

The latter way (separate GL expense accounts for each internal domain) gets messy quickly, but if you only have one or two internal domains and not a lot of GL expense accounts it's doable.

Anyway, the "bottom line" is what you think your future reporting/tracking/analyzing needs are going to be.  Think very long and hard about this NOW, before you start entering transactions into FA.  While you can change things around later, it gets quite time-consuming and messy doing so, and you'll lose the consistency and continuity in your records.  So, it's better to decide one way or another now and stick to it rather than rushing into a decision and finding out later it should have been done another way.

Hope all this is helpful.  Again, maybe have a chat with your accountant.

Regards,

Chris

Glad you're enjoying getting FA setup.  For me, it's been a bit traumatic but the support 'round here is fantastic so it's finally taking shape.

You should probably talk to your accountant about how best to setup FA for your business.  Having said that, the main advantage for setting up each domain as a separate item is that you'll be able to track revenues/expenditures by domain.  If you create one item called "domains" and make it editable, all revenues/expenses coded to that item get lumped together, so if you want to split-out transactions later for analysis it will be more difficult.

On the flip side, creating separate items for each domain is (of course!) more work, and if you buy/sell a lot of domains managing things can get cumbersome.  So, I guess you have to decide if the extra work and risk of things getting a bit cumbersome is with having the ability to analyze revenues/expenses on a per-domain basis.

Hope that's helpful, or at least gives you some things to think about.

Regards,

Chris

86

(9 replies, posted in Reporting)

After a bit of sleep....

Okay, I checked and when I install the extension it creates the directory modules/rep_stock_movement but it doesn't add the report to reporting/reports_main.php.  I tried to manually add this to reports_main.php:

$reports->addReport(RC_INVENTORY,"_stock_movement",_('Stock &Movement Report'),
    array(    _('Inventory Category') => 'CATEGORIES',
            _('Location') => 'LOCATIONS',
            _('From Date') => 'DATE',
            _('To Date') => 'DATE',
            _('Comments') => 'TEXTBOX',
            _('Destination') => 'DESTINATION'));                

That adds the report to the Reports and Analysis screen.  I can now bring up the report but when I click on Display: Stock Movement Report I get this error:  Cannot find report file '_stock_movement'.

What am I doing wrong?

Thanks!

Regards,

Chris

87

(9 replies, posted in Reporting)

Yes, it's the "rep_stock_movement" extension (version 2.3.4-1) by Chaitanya-India.

Since it's an extension, just for giggles I uninstalled and re-installed it, and now it's not showing up on the Reports & Analysis screen.  It's late, so I'm going to go to bed and try again tomorrow.

Thanks for your help!

Regards,

Chris

88

(2 replies, posted in Items and Inventory)

joe wrote:

This is strange. I cannot reproduce this. If you look at the Standard Cost for the items in Items and Inventory you should see the correct values.

Actually, I went into Standard Cost in Items and Inventory, and it shows $1.81 for Item "B" and $0.00 for Item "A" which is exactly what was used to move the value of the items from Inventory to COGS when I made the sale.  So I went ahead and correct the amounts.

The question is, how the heck did those costs get there???  I did a random check of the Standard Cost for various other items and they are all correct...  they're the purchase cost when I bought the items from suppliers.

That's really weird!  Is there a report/query I can run that will show all of the standard costs for all items so I can easily check everything?

joe wrote:

Did you do some item adjustments with zero price? Or something else that influenced the Cost Price?
/Joe

Not that I remember.  I did void a sales invoice for the sale of the two items because the account coding was all messed up, but that appeared to process correctly.  Maybe that caused the problem?

Anyway, I'll keep an eye on things and let you know if I find any more such quirks.

Thanks for your help!

Regards,

Chris

I ran into another problem today...  the Stock Movement report isn't working.  If I do an Inventory Movement Inquiry from the Items & Inventory screen, I can see the stock movements.  But, when I run the Stock Movement report from the Reports & Analysis screen absolutely nothing happens when I click Display: Stock Movement.  No error messages, no PDF viewer popup, nothing.

Any ideas how to fix this, please?

Thanks!

Regards,

Chris

90

(2 replies, posted in Items and Inventory)

I purchase two items as follows:

Item "A" - Purchased for $6.25 each
Item "B" - Purchased for $3.62 each

Recently I sold 2 pieces of Item "A" and 1 piece of Item "B" as follows:

Item "A" - Sold 2 @ $9.40
Item "B" - Sold 1 @ $5.50

I was expecting my COGS to be as follows:

Item "A" - 2 units @ 6.25 = $12.50
Item "B" - 1 unit @ 3.62 = $3.62
Total COGS = $16.12

However, I noticed that only $1.81 was credited to Inventory and debited to COGS.  Interestingly, this is exactly 1/2 the purchase price of Item "B".

How is FA calculating COGS?  And, how do I go about reversing the erroneous transaction and posting the correct transaction?

Thanks!

Regards,

Chris

I'm not sure if this helps you, but you can create a new company by going into Setup -> Create/Update Companies.  Be sure to enter a different table prefix for the second company.  Once that's done, when someone goes to login they're presented with a drop down box to select the company they want to log into, the first company being the original company (two partners), and the second company being the new company (after the split).

Once the second company is created, you can do journal entries to post the starting balances from the old company (i.e. the account balances at the time of the split.)  The data is still in the old company in detailed format, and is now also in the new company as an opening balance.  Then, you just carry on with entering transactions into the new company as they occur.

I hope the above is helpful to you.

Regards,

Chris

In case it will help, I did a screenshot of the page info in Firefox for one of the instances when the login bombed with a 500 error.  Since I can't upload it here, it is available for viewing here.  As well, a search of the logs for my site found the following line:

70.67.201.56 - - [19/Jan/2013:12:23:46 -0500] "POST /accounting/ HTTP/1.1" 500 568 "https://www.crazychris.ca/accounting/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"

Hope that is helpful to someone...

Regards,

Chris

erwindebruin wrote:

seems to be there's a relation with my "302 error problem". I sometimes experience the same 500 error as described above.

https://frontaccounting.com/punbb/viewtopic.php?id=3767

Did you try the fix to includes/session.inc that was suggested?  If so, did it fix the problem?

Thanks!

Regards,

Chris

apmuthu wrote:

Which version are you upgrading from?

2.3.13

apmuthu wrote:

What platform / hosting service is being used?

My site is hosted by HostPapa.  Here's some info on their setup:

Operating system     linux
Architecture     x86_64
Kernel version     2.6.32-379.9.1.lve1.1.9.7.2.el6.x86_64
Apache version     2.2.23
PHP version     5.3.20
MySQL version     5.5.28-cll
Perl version     5.10.1

Btw, I have the following in my includes/session.inc file in case it's useful:

// ini_set('session.save_path', dirname(__FILE__).'/../tmp/');

ini_set('session.gc_maxlifetime', 36000); // 10hrs
ini_set('session.cache_limiter', 'nocache'); // prevent 'page expired' errors

$Session_manager = new SessionManager();
$Session_manager->sessionStart('FA'.md5(dirname(__FILE__)));

// this is to fix the "back-do-you-want-to-refresh" issue - thanx PHPFreaks
header("Cache-control: nocache");
apmuthu wrote:

There is a cache issue introduced in v2.3.14 when adjusting the includes/session.inc for faillog protection (not because of faillog protection) and is a known issue for certain shared hosting that relies on numerous redirects (302 error).

Refer link for causes.

Hopefully the info provided above will help someone track down the problem and fix it.  In the meantime, it's no big deal...  I'll just keep refreshing the page when I login.

Regards,

Chris

I just finished updating to version 2.3.14 and now when I login I get a 500 error:

---------
500 Internal Server Error

The page cannot be displayed.
---------

When I refresh the page (which requires resending the data), FA loads correctly and everything seems to be working.  I followed the instructions on the Wiki to the letter.  The only change to config.php was the addition of the default_orientation variable.  I also added a bcc_address to the company setup.  Other than that, everything is as it was before.

Any idea how to get rid of this error message?

Thanks!

Regards,

Chris

P.S.  The upgrade looks pretty good!  I particularly like the new functionality to select the report orientation.... very nice!

96

(10 replies, posted in Announcements)

DUH!!!!

It's in the Wiki.

Sorry for wasting time/space with a very dumb question!  (blush!)

Regards,

Chris

97

(10 replies, posted in Announcements)

As a newbie to FA, I'm a little unsure of how to upgrade to the new 2.3.14 release.  I don't have the ability to execute patch on the server, so applying the patch file is out.  Do I just download the new version and copy all of the files over the old version?

An "Upgrading for Dummies" posted somewhere, preferably as a "sticky", would be very helpful!

Thanks!

Regards,

Chris

Sounds like it's going to have some great new features!  I'm looking forward to it coming out!

Thanks for the info...

Regards,

Chris

Cool!  That will be useful for some of the reports that have lots of columns (e.g. Annual Expense Breakdown, etc.).  I look forward to checking it out when v2.4 is released.

Btw, just out of curiosity...  when is v2.4 scheduled to be released?

Thanks!

Regards,

Chris

100

(16 replies, posted in Wish List)

Just to finish up a previous side conversation...

apmuthu wrote:

Obtained the backup sql of your system and am testing it out in an OpenVZ VPS - a sort of test ride  troubleshooting using it.

The changes from the stock FA v2.3.13 to the Mercurial Build now as far as the database is concerned is only the following statements (You are using company 0 with a table prefix of "f1_"):

(SQL Statements removed)

Thanks for that info.  If I decide to do a backup of my production data and restore it into Mercurial I'll remember to run those SQL statements so the the db is correct.

apmuthu wrote:

Typo in Company Name - Extraordinaire.

Thanks for pointing that out!  lol  I type that word so often I often don't look at it closely any more!

apmuthu wrote:

The config.php must be matched with the config.default.php to make up for the missing/changed entries. Stick to default themes for now till the other themes are updated to accommodate the changed function locations that affect the renderer.php in the older themes.

I'll keep that in mind, too, if I decide to do the export/import thing into Mercurial.

apmuthu wrote:

The choice of white background in your logo blends well with stock white paper invoice!

Yes, it does.  I tried a logo with a transparent background but the transparency converted to black in the PDF reader.  I never use colored paper for business purposes, so the white background works just fine.

apmuthu wrote:

COA has Retained Earnings, Owner's Drawings and Owner's Equity in Owner's Capital type(7).

That's right.  Owner's Equity is my capital investment in the company (i.e. shares).  Owner's Draw is used for occasionally putting some operating funds into the company or drawing-out funds for personal use.    Although I could record draws to Owner's Equity, I prefer to keep those two types of transactions separate.

apmuthu wrote:


Working on the prettier link without having to change the code much.....

See my comment above.

Thanks, again, apmuthu for your help!

Regards,

Chris