No it is not possible to link a deminsion to a location. But you can generate a report, under Item and Inventory reports. Report 'Inventory Sales Report'. Here you have a Sales and COGS per Item and you can select a location.
/Joe
2,852 11/29/2011 07:21:37 am
Re: import Payments/Deposits/Journal Entry from excel (4 replies, posted in Banking and General Ledger)
You will have to write a module / extension for doing that.
/Joe
2,853 11/28/2011 09:22:59 pm
Re: Fiscal year: delete vs close (1 replies, posted in Banking and General Ledger)
When you close a year, you balance the accounts and you can no longer make entries to this year. But you can still look at the reports and inquiries for the closed year.
When you delete a year, the transactions are removed and the balance accounts are brought forwards. You can no longer se the transactions for a deleted year.
You initiate the closing of a year by selecting the year, and then select the closing and update the fiscal year.
/Joe
2,854 11/28/2011 02:37:51 pm
Re: Problems importing Customers into 2.3.7 (2 replies, posted in Accounts Receivable)
You cannot import directly with INSERT INTO debtors_master, because of a lot of secondary keys into other tables. You should use one of the extensions that are in the repository, Setup tab, 'install / activate extensions'.
/Joe
2,855 11/26/2011 10:02:42 pm
Re: Salesman listing not adding over page break in report (1 replies, posted in Reporting)
This is a bug. The HG repository has been updated. Thanks for reporting.
You can remove the following lines from line 108:
if ($rep->row < $rep->bottomMargin + (2 * $rep->lineHeight))
{
$salesman = 0;
$rep->NewPage();
}and from line 155 (151 if you do not count the above line) remove these lines:
if ($rep->row < $rep->bottomMargin + (2 * $rep->lineHeight))
{
$salesman = 0;
$rep->NewPage();
}/Joe
2,856 11/25/2011 09:26:23 am
Re: sys_types.type_no question (1 replies, posted in Banking and General Ledger)
Hello sahmed.
Sometimes it can be a litte confusing with this. Here typeno is really the trans_no. We will try to fix this in one of the next major releases.
/Joe
2,857 11/24/2011 10:31:58 pm
Re: Purchase account instead of COGS (8 replies, posted in Items and Inventory)
No hard feelings, barney.
It is just that we don't have the resources to help you with accountancy matters.
/Joe
2,858 11/24/2011 03:25:48 pm
Re: Purchase account instead of COGS (8 replies, posted in Items and Inventory)
As I said before this is a matter of accountancy, so please consult an accountant.
/Joe
2,859 11/24/2011 09:35:02 am
Topic: Release 2.3.9. Please update to this. (2 replies, posted in Announcements)
Due to some nasty bugs in release 2.3.8 regarding output buffering and incompatible static Session Manager you are kindly asked to update to release 2.3.9.
The package is located at Sourceforge .
This is very simple. Just overwrite your existing 2.3.7 or 2.3.8 installation and you are done.
/Joe
2,860 11/24/2011 09:31:21 am
Re: Purchase account instead of COGS (8 replies, posted in Items and Inventory)
HI,
This is not a problem for service items. Just put the Purchase account on the supplier and it will be used.
If you want to use a purchase account instead of the Inventory account, you will not be able to monitor your inventory and this can be a disaster. At least you should know what happens if you do. Eventually contact an Accountant.
FA is very flexible in setting up your items/suppliers/customers accounts.
/Joe
2,861 11/23/2011 02:28:59 pm
Re: Cannot create the database (4 replies, posted in Installation)
In the folder /sql there is 2 scripts. en_US-new.sql (for a new company) and en_US-demo.sql (for a demo/drill company).
Use an editor to search and replace the above.
Use phpMyAdmin to import one of these scripts to your created database.
Then you should be able to login (admin - password) and run FA.
/Joe
2,862 11/23/2011 09:02:55 am
Re: 2.3.8 Upgrade Problem (16 replies, posted in Installation)
Please look at this thread for ev. solutions. By liahsheep.
https://frontaccounting.com/punbb/viewtopic.php?id=2546
/Joe
2,863 11/23/2011 08:56:04 am
Re: Blank page on install C 2.3.8 (12 replies, posted in Installation)
Thanks liahsheep. Awaiting for Janusz to take action.
/Joe
2,864 11/23/2011 08:48:17 am
Re: Cannot create the database (4 replies, posted in Installation)
Newer versions of MySQL seems to not accept 'TYPE=' any more. Please replace 'TYPE=' to 'ENGINE=' in your sql script used for install.
/Joe
2,865 11/23/2011 12:56:29 am
Re: Mixture of InnoDB and MyISAM type for FA MySQL tables (6 replies, posted in Setup)
We would not recommend this. FrontAccounting is using transactions to handle the multi-user environment. If using myisam for the tables that should be innodb, we loose the ability to have multi-user operation.
I would recommend you to move to another hosting service.
/Joe
2,866 11/23/2011 12:52:01 am
Re: Blank page on install C 2.3.8 (12 replies, posted in Installation)
Is this blank page arising during the install?
Instead of waiting for the next release, please try to help us fixing this problem. In our development environments we cannot reproduce this error.
Therefore it is mandatory that you help us trying to find the problem.
We have explained how to trace the bug, if the install has finished and the program is starting in the following thread:
https://frontaccounting.com/punbb/viewtopic.php?id=2523
But if the blank page arise during the install phase, then we would have to examine the /install/isession.inc file.
/Joe
2,867 11/21/2011 09:26:24 pm
Re: Method of stock valuation (1 replies, posted in Items and Inventory)
FrontAccounting uses Averaging when working with stock valuation.
/Joe
2,868 11/20/2011 02:18:25 pm
Re: Overdraft (5 replies, posted in Banking and General Ledger)
FA goes backwards to see if the balance of the cash account per the transactiondate would be negative.
You can either use a later date or use todays date for the transaction (if you know it is positive).
/Joe
2,869 11/20/2011 01:11:09 pm
Re: 2.3.8 Upgrade Problem (16 replies, posted in Installation)
Thanks, try to comment out other lines nearby in /includes/session.inc. Sooner or later we will know where the problems are.
/Joe
2,870 11/20/2011 08:11:12 am
Re: Invoice number with multiple series (21 replies, posted in Setup)
FA can only handle 1 automatic serie, like A-0001-00005632. If you want more series, you will have to keep track of each individual serie, because FA will only update the last used serie.
/Joe
2,871 11/19/2011 08:01:55 am
Re: 2.3.8 Upgrade Problem (16 replies, posted in Installation)
Try the following to help us trace ev. bug.
Go into file /includes/session.inc.
1. Comment out line 297 and 298 by setting // in front of the lines. Save and try again. If you are still having problem, we should try to find the problem elsewhere and you can stop trace the Session Manager. Otherwise continue.
2. Take away the comment signs in line 297 and 298. Comment out line 37 and line 43. If you are still having problem,
uncomment the lines and try to comment out other member function calls. Sooner or later you should trace the problem.
Good luck.
/Joe
2,872 11/18/2011 11:42:47 am
Re: 2.3.8 Upgrade Problem (16 replies, posted in Installation)
This is strange. We solved a lot of problems when making the class Session Manager non-static in /includes/session.inc.
But some of you still report the same problem after the fix.
Can anyone help tracing these errors, please?
/Joe
2,873 11/18/2011 11:30:13 am
Re: Bug in exclusive theme (1 replies, posted in Modules Add-on's)
Thanks elax. Will be fixed asap.
/Joe
2,874 11/18/2011 06:52:56 am
Re: Logo Image Missing on Reports (1 replies, posted in Reporting)
The company logo is only printed on documents (orders/deliveries/invoces etc).
If you want to print the logo on other reports, please install/activate the custom report report annual expense break down and look here how to do that.
/Joe
2,875 11/17/2011 09:38:43 am
Re: 2.3.8 requires re-authentication every page (7 replies, posted in Installation)
If anyone in the audience has a god set of instructions how to configure/setup a Windows Server for FA (permissions etc), then please share it with us.
/Joe