FrontAccounting forum — Fixed Asset - Process Depreciation

Re: Fixed Asset - Process Depreciation

2020-01-18T08:10:51Z

Update_no=-1 make no sense. More over, audit trail update at this point is just obsolete. Fixed in repo.

Janusz

Re: Fixed Asset - Process Depreciation

2020-01-17T16:09:39Z

I have asked Janusz to look at this.

Joe

Re: Fixed Asset - Process Depreciation

2020-01-17T13:34:23Z

@joe: is this a real solution?

Re: Fixed Asset - Process Depreciation

2020-01-17T08:32:56Z

Thanks for solving my problem

Re: Fixed Asset - Process Depreciation

2019-11-30T17:11:04Z

@joe: is this warranted?

Re: Fixed Asset - Process Depreciation

2019-11-28T21:10:33Z

Only change $update_no = -1 to $update_no = 1

Re: Fixed Asset - Process Depreciation

2019-11-27T02:11:15Z

Did you change the code? The above code is identical with that in the repo.
What did you do differently now that it works?

Re: Fixed Asset - Process Depreciation

2019-11-26T21:01:01Z

Hello, I don´t Know how it happened, but, I reviewed the file fixed_assets/includes/fixed_assets_db.inc and I saw the code $update_no = -1

Now, I made the Process

Thanks for your answer

  $sql = "UPDATE ".TB_PREF."stock_master SET 
    depreciation_date='".date2sql($cart->tran_date)."',
    material_cost=".db_escape($new_cost)."
    WHERE stock_id=".db_escape($stock_id);
  db_query($sql,"The depreciation start date could not be updated");

  $update_no = -1;
  add_audit_trail(ST_JOURNAL, $update_no, $date_);
  commit_transaction();

  return $trans_no;

Re: Fixed Asset - Process Depreciation

2019-11-26T17:38:39Z

Your Transaction number is negative. How did that happen?

Re: Fixed Asset - Process Depreciation

2019-11-26T17:06:23Z

I've enter to debugging mode and get the following message, maybe because it, I can´t run the process:

ERROR DE BASE DE DATOS : Cannot add audit info
error code : 1264
error message : Out of range value for column 'trans_no' at row 1
sql that failed was : INSERT INTO audit_trail (type, trans_no, user, gl_date, description, stamp) VALUES('0', '-1',1,'2019-11-26','', CURRENT_TIMESTAMP)

https://photos.app.goo.gl/NCtQBrP4dH2aRLmL7

Re: Fixed Asset - Process Depreciation

2019-11-12T16:25:13Z

Thanks for your answer,

I have the same account because I was testing. But I've changed the account and I had the same result.

Details Fixed Assets
https://photos.app.goo.gl/cT3zkR8aeEsSqsLF7

Process Depreciation
https://photos.app.goo.gl/w8pRCkBErYsfuBT29

Result
https://photos.app.goo.gl/SjaLGxAUhSuWynPUA

For more Information I give you the database and config.php

https://drive.google.com/open?id=1XOICJGBCBBZYHyraC3nYs0_ItYDHGdr_
https://drive.google.com/open?id=1nWlnfzAYGJXAOzDyVELQPjLPsLCG4tWI
https://drive.google.com/open?id=1xeHJPWXw-3CN-NQnd-UVXiTM9nKCQOz_

Re: Fixed Asset - Process Depreciation

2019-11-09T07:28:29Z

You have credited and debited the same account!

Fixed Asset - Process Depreciation

2019-11-01T18:10:03Z

Hello,

I made de Process Depreciation but nothing happens, I configure it like said in wiki and everything ok.

Doesn´t show any message so I don't know what should be the error.

https://photos.app.goo.gl/7P2d8FCoP6gd4u4cA
https://photos.app.goo.gl/Xti9mKaCrr32C6GX7

Thanks

Regards from Nicaragua