Search options (Page 2 of 15)

I enabled general logging and it seems to stop working

after
2024-12-29T17:07:18.634304Z        10 Query     SET foreign_key_checks=1
2024-12-29T17:07:18.634803Z        10 Query     SET NAMES utf8

See below - another mysql setting I am missing?

2024-12-29T17:07:18.204770Z         9 Execute   INSERT INTO backlog (seq, query, timestamp) VALUES (1066,'INSERT INTO `0_tax_group_items` VALUES\n(\'1\', \'1\', \'1\')',1735492038161)
2024-12-29T17:07:18.208097Z        10 Query     INSERT INTO `0_tax_group_items` VALUES
('1', '1', '1')
2024-12-29T17:07:18.294283Z         9 Execute   INSERT INTO backlog (seq, query, timestamp) VALUES (1067,'INSERT INTO `0_tax_groups` VALUES\n(\'1\', \'Tax\', \'0\'),\n(\'2\', \'Tax Exempt\', \'0\')',1735492038253)
2024-12-29T17:07:18.296397Z        10 Query     INSERT INTO `0_tax_groups` VALUES
('1', 'Tax', '0'),
('2', 'Tax Exempt', '0')
2024-12-29T17:07:18.379515Z         9 Execute   INSERT INTO backlog (seq, query, timestamp) VALUES (1068,'INSERT INTO `0_tax_types` VALUES\n(\'1\', \'5\', \'2150\', \'2150\', \'Tax\', \'0\')',1735492038338)
2024-12-29T17:07:18.382010Z        10 Query     INSERT INTO `0_tax_types` VALUES
('1', '5', '2150', '2150', 'Tax', '0')
2024-12-29T17:07:18.465588Z         9 Execute   INSERT INTO backlog (seq, query, timestamp) VALUES (1069,'INSERT INTO `0_users` VALUES\n(\'1\', \'admin\', \'5f4dcc3b5aa765d61d8327deb882cf99\', \'Administrator\', \'2\', \'\', \'adm@example.com\', \'C\', \'0\', \'0\', \'0\', \'0\', \'default\', \'Letter\', \'2\', \'2\', \'4\', \'1\', \'1\', \'0\', \'0\', \'2021-05-07 13:58:33\', \'10\', \'1\', \'1\', \'1\', \'1\', \'0\', \'orders\', \'30\', \'0\', \'1\', \'0\', \'0\', \'0\')',1735492038424)
2024-12-29T17:07:18.468261Z        10 Query     INSERT INTO `0_users` VALUES
('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2021-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0')
2024-12-29T17:07:18.551540Z         9 Execute   INSERT INTO backlog (seq, query, timestamp) VALUES (1070,'INSERT INTO `0_workcentres` VALUES\n(\'1\', \'Work Centre\', \'\', \'0\')',1735492038511)
2024-12-29T17:07:18.554467Z        10 Query     INSERT INTO `0_workcentres` VALUES
('1', 'Work Centre', '', '0')
2024-12-29T17:07:18.631815Z         9 Execute   INSERT INTO backlog (seq, query, timestamp) VALUES (1071,'SET foreign_key_checks=1',1735492038595)
2024-12-29T17:07:18.634304Z        10 Query     SET foreign_key_checks=1
2024-12-29T17:07:18.634803Z        10 Query     SET NAMES utf8
2024-12-29T17:07:18.714956Z         9 Execute   INSERT INTO backlog (seq, query, timestamp) VALUES (1072,'UPDATE 0_sys_prefs SET value = \'Flux Testing\' WHERE name=\'coy_name\'',1735492038674)

Do any of these flags control/modify how the cost of an item is calculated?
Is average the only method that is currently supported?

Would the (majority) of the changes needed to support FIFO be localized into a few functions?

FIFO means the COGS is directly related to the exact cost of buying the oldest item being sold
So if the cost shot up the COGS would not change until all the existing inventory was sold.

Thanks
Tom

Is there a list of the mb_flag values and their meanings?

I searched the code and found A B D F and M, but no comments listing the values and meanings

tom

I am not overly concerned with live import, I was considering monthly import maybe via CSV profit/loss and tax reporting

I saw your other post, not sure which thread is most appropriate...

It dawned upon me that what I referred to as "current asset value" was actually Cost Basis.
I also think that both the Cost Basis, Unrealized Gains and Profit are all Tax/Reporting issues.

So I think I need to better understand how item cost is calculated and used in inventory.

More later
Tom

Ok, I was able to manually import the US demo data and I get an error:

ERROR 1067 (42000) at line 35: Invalid default value for 'tran_date'

The table is:

CREATE TABLE `0_attachments` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(60) NOT NULL DEFAULT '',
  `type_no` int(11) NOT NULL DEFAULT '0',
  `trans_no` int(11) NOT NULL DEFAULT '0',
  `unique_name` varchar(60) NOT NULL DEFAULT '',
  `tran_date` date NOT NULL DEFAULT '0000-00-00',
  `filename` varchar(60) NOT NULL DEFAULT '',
  `filesize` int(11) NOT NULL DEFAULT '0',
  `filetype` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `type_no` (`type_no`,`trans_no`)
) ENGINE=InnoDB;

I am using mysql:8.3.0 (docker image)
Maybe I need to use an older version. The docs did not recommend any specific mySQL version...

Thanks!
ps. I don't think I can use an older mysql due to some clustering that is being done.

I did see that the valid date range is : The supported range is '1000-01-01' to '9999-12-31'.

Will the default value of 1000-01-01 cause any SQL issues?

Is the zip file better than git master branch?

Both the github mirror and sf.net git do not have release tags for 2.4.18 so is master the latest release?

I am building a docker image and it's usually best to refer to the version tag so a rebuild doesn't get an unexpected update.
(Yes I know it is really mature... just good practice...)

Maybe a 2.4.18 tag could be added? (github or sf, either is fine)

Tom

I would have but all the webpages point to CVS and sf and the labels are not current

I found the problem

elseif( $Mode == 'Delete')
{
        //the link to delete a selected record was clicked instead of the submit button

        $cancel_delete = 0;
        // PREVENT DELETES IF DEPENDENT RECORDS IN 'bank_trans'

        if (key_in_foreign_table($bank_id, 'bank_trans', 'bank_act') || key_in_foreign_table(get_post('account_code'), 'gl_trans', 'account'))
        {
                $cancel_delete = 1;
                display_error(_("Cannot delete this bank account because transactions have been created using this account."));
        }
 

get_post('account_code') returns 1060 and the bank_id I am trying to delete has account 1063

Maybe it should get t he account from the bank account info...

What's the best way to fix this?

This worked:

        $myrow = get_bank_account($bank_id);

        if (key_in_foreign_table($bank_id, 'bank_trans', 'bank_act') || key_in_foreign_table($myrow['account_code'], 'gl_trans', 'account'))
 

Tom