Search options (Page 129 of 200)

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

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

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

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.

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

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

/Joe

Ok, I misunderstood your question.

I will see what can be done.

/Joe

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');

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

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

/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