FrontAccounting forum — Fixed Asset - Process Depreciation

Re: Fixed Asset - Process Depreciation

null@example.com (itronics) — Sat, 18 Jan 2020 08:10:51 +0000

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

null@example.com (joe) — Fri, 17 Jan 2020 16:09:39 +0000

I have asked Janusz to look at this.

Joe

Re: Fixed Asset - Process Depreciation

null@example.com (apmuthu) — Fri, 17 Jan 2020 13:34:23 +0000

@joe: is this a real solution?

Re: Fixed Asset - Process Depreciation

null@example.com (atena.ohs) — Fri, 17 Jan 2020 08:32:56 +0000

Thanks for solving my problem

Re: Fixed Asset - Process Depreciation

null@example.com (apmuthu) — Sat, 30 Nov 2019 17:11:04 +0000

@joe: is this warranted?

Re: Fixed Asset - Process Depreciation

null@example.com (serviciosac101) — Thu, 28 Nov 2019 21:10:33 +0000

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

Re: Fixed Asset - Process Depreciation

null@example.com (apmuthu) — Wed, 27 Nov 2019 02:11:15 +0000

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

null@example.com (serviciosac101) — Tue, 26 Nov 2019 21:01:01 +0000

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

null@example.com (apmuthu) — Tue, 26 Nov 2019 17:38:39 +0000

Your Transaction number is negative. How did that happen?

Re: Fixed Asset - Process Depreciation

null@example.com (serviciosac101) — Tue, 26 Nov 2019 17:06:23 +0000

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

null@example.com (serviciosac101) — Tue, 12 Nov 2019 16:25:13 +0000

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

null@example.com (apmuthu) — Sat, 09 Nov 2019 07:28:29 +0000

You have credited and debited the same account!

Fixed Asset - Process Depreciation

null@example.com (serviciosac101) — Fri, 01 Nov 2019 18:10:03 +0000

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