3,201

(1 replies, posted in Items and Inventory)

1. Easy, you can register these tools as items and set the Inventory account for these tools to be of type capital assets. You can also mark them as exclude from sales.

2. If you want these additional costs to be included in the purchase prices you should be add these costs on the Supp Invoice Item Lines. You will have to distribute these costs for the line items.

Be aware then, that Import Tax may have to be booked as tax for the tax authorities. Ask your Accountant/Auditor.

/Joe

You will have to use the Items and Inventory and create service items to use for invoicing. You can change the description for the line by editing the line after adding it. And the price can always be changed.

/Joe

3,203

(5 replies, posted in Accounts Payable)

In Purchasing Pricing under Items and Inventory tab, you can enter the suppliers id and description for your items. This will then be printed on the Purchase Orders.

/Joe

3,204

(3 replies, posted in Accounts Receivable)

We call it Statements instead of reminders. To be printed from the Customer and Sales Reports, Print Statements.

/Joe

3,205

(13 replies, posted in Banking and General Ledger)

I think you need to talk to an account. You cannot have foreign currency accounts in your GL (General Ledger). You should setup your foreign currency accounts as bank accounts. Then use the Bank payment/deposit (MISC) to enter your interest etc for this bank account. This will create correct GL postings in the background.

/Joe

Hello Pete,

Yes the module/extension behaviour have changed a lot since earlier. Basicly because of the central repository for modules/extensions.

Please activate a couple of the latest extensions and look into it how it works and please ask questions if you are unsure.

Janusz has promised to make a documentation of this new behaviour, but unfortunately he is overloaded with work.

/Joe

3,207

(14 replies, posted in Report Bugs here)

Ericta, I am really sorry for your data loss.  Hopefully you can forgive us. We are doing all this on a voluntary base without any money involved.
We try to do the best we can to avoid this, and it is the first time we have run into this kind of problem. And hopefully it will be the last time.

But for your own safety, please make frequently backup of your companies.

Humble regards

Joe.

3,208

(1 replies, posted in Installation)

2.3 RC2 means release candidate 2 of 2.3. This is where the database structure is locked for 2.3.X.

/Joe

3,209

(10 replies, posted in Setup)

If you are using newer versions of MySql you have to replace the type with engine.
It should be ok to use some of the tables as myisam and other as innodb.

I hope you are getting this to work.

/Joe

3,210

(4 replies, posted in Accounts Receivable)

Also this should be fixed in 2.3.4

/Joe

3,211

(4 replies, posted in Accounts Receivable)

This have been fixed in the release 2.3.4 that is about to ship today.

/Joe

3,212

(12 replies, posted in Announcements)

Hello ad1t.

I am not sure I understand your question. If you mean how we communicate with the users, well this is one of the places. We also have News on Sourceforge and news on the Website.
We also have some miailing lists, developers and a more general mailing list. These can be found on the Sourceforge project page, were you also can subscribe to the lists.

/Joe

3,213

(9 replies, posted in Wish List)

Ok, I misunderstood your question.

I will see what can be done.

/Joe

And remember to restart your Apache Server after the changes in php.ini.

/Joe

3,215

(10 replies, posted in Setup)

There was, for some reason, a missing 0_sys_types table in your script.

Please copy these lines and paste into phpMyAdmin to your database, SQL form, and run the query.

--
-- Table structure for table `0_sys_types`
--

DROP TABLE IF EXISTS `0_sys_types`;
CREATE TABLE IF NOT EXISTS `0_sys_types` (
  `type_id` smallint(6) NOT NULL default '0',
  `type_no` int(11) NOT NULL default '1',
  `next_reference` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`type_id`)
) TYPE=InnoDB;

--
-- Dumping data for table `0_sys_types`
--

INSERT INTO `0_sys_types` VALUES(0, 19, '3');
INSERT INTO `0_sys_types` VALUES(1, 8, '2');
INSERT INTO `0_sys_types` VALUES(2, 5, '2');
INSERT INTO `0_sys_types` VALUES(4, 3, '1');
INSERT INTO `0_sys_types` VALUES(10, 19, '4');
INSERT INTO `0_sys_types` VALUES(11, 3, '2');
INSERT INTO `0_sys_types` VALUES(12, 6, '1');
INSERT INTO `0_sys_types` VALUES(13, 5, '2');
INSERT INTO `0_sys_types` VALUES(16, 2, '1');
INSERT INTO `0_sys_types` VALUES(17, 2, '1');
INSERT INTO `0_sys_types` VALUES(18, 1, '3');
INSERT INTO `0_sys_types` VALUES(20, 8, '3');
INSERT INTO `0_sys_types` VALUES(21, 1, '1');
INSERT INTO `0_sys_types` VALUES(22, 4, '2');
INSERT INTO `0_sys_types` VALUES(25, 1, '2');
INSERT INTO `0_sys_types` VALUES(26, 1, '8');
INSERT INTO `0_sys_types` VALUES(28, 1, '1');
INSERT INTO `0_sys_types` VALUES(29, 1, '2');
INSERT INTO `0_sys_types` VALUES(30, 5, '6');
INSERT INTO `0_sys_types` VALUES(32, 0, '1');
INSERT INTO `0_sys_types` VALUES(35, 1, '1');
INSERT INTO `0_sys_types` VALUES(40, 1, '3');

3,216

(9 replies, posted in Wish List)

In the various view popup screens there is a link to the attachemnt, if there is one. It is a link, Attachment, at the bottom together with the print, close links.

Joe

3,217

(6 replies, posted in Setup)

Normally the backup routine runs like a charm.
I guess we should look around. You got that when doing a backup.
Do you see any other errors in your errors.log in the /tmp folder?
Is this a huge company? Huge data?

/Joe

3,218

(10 replies, posted in Setup)

I am not sure if this is the problem.
Can you try to look in the database with phpMyAdmin and see if the table 0_sys_types exists and it is populated.

dirname(__FILE__) means the folder name where the file exists, but this line is commented, which means that it is not used.

/Joe

3,219

(6 replies, posted in Accounts Receivable)

You are right Pete. I have asked Janusz to fix this item.

/Joe

3,220

(6 replies, posted in Accounts Receivable)

Hello again. There is no join between the due_date field in debtor_trans and other tables. So it should be risk-free to do the SQL.

I will have another look into this subject you describe.

/Joe

You will have to enter the php.ini file in your server php setup. In this file under extensions, you will have to uncomment the OpenSSL extension.

If you can't do that yourself, you will have to ask your hosting provider to do that for you.

/Joe

3,222

(14 replies, posted in Report Bugs here)

This subject has just been fixed and will be included in the next release, 2.3.4 that are planned to ship tomorrow.
The script will not be updated any more.

/Joe

3,223

(2 replies, posted in FA Modifications)

Thanks Pete, nice to have an experienced guy back online again smile

/Joe

3,224

(4 replies, posted in Items and Inventory)

Hello again chvypwrd,

Which release of FA are you running?
I have now made rigorious testing for this in 2.3.3 without reproducing it.
We are in a hurry for shipping release 2.3.4 due to other serious bugs, so we need more info to investigate this. Otherwise we will continue doing this during the 2.3.4 release.

/Joe

There might be some problems with the tax calculations. I know that certain countries use som kind of even-out up/down to nearest amount without the hundredth part. Maybe this is some kind of the same.

There is, however, possible to give discounts when doing the payment(s)/deposit(s).

/Joe