Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Expiry date became 2000-00-00 when perform Transfer Controlled Items
03-25-2014, 07:12 PM (This post was last modified: 03-27-2014 08:17 PM by joadi_2003.)
Post: #1
Expiry date became 2000-00-00 when perform Transfer Controlled Items
Dear Sir,

When I perform transfer controlled items for one or more serialised items, the expiry date always become '00/00/2000' instead of copying the original expiry date.

Appreciate your help.

Many thanks,
Joanes

See attached/below screenshot:

   
Find all posts by this user
Quote this message in a reply
03-28-2014, 08:49 PM
Post: #2
RE: Expiry date became 2000-00-00 when perform Transfer Controlled Items
Hi All,

Since there is no response from the developer, I did some workaround;
1. Before transfer controlled items, copy stockserialitems table contents to Z table.
2. After transfer controlled items done, update expirationdate field in stockserialitems table from Z table.
Find all posts by this user
Quote this message in a reply
03-28-2014, 09:32 PM
Post: #3
RE: Expiry date became 2000-00-00 when perform Transfer Controlled Items
Hi, Joanes,

Thank you for your report!

I've noted this problem during stock adjustments. So I fixed the problem happened during stock adjustment. Not sure if it fixed your problem. Please download the attached files and replace those files with same names in includes directory.

Hope it's helpful.

Best regards!

Exson


Attached File(s)
.zip  includes.zip (Size: 8.09 KB / Downloads: 3)
Find all posts by this user
Quote this message in a reply
03-28-2014, 10:02 PM
Post: #4
RE: Expiry date became 2000-00-00 when perform Transfer Controlled Items
Hi Exson,

I just tried, it works. Thank you very much. You save my life Smile

Best Regards,
Joanes
Find all posts by this user
Quote this message in a reply
03-28-2014, 10:10 PM
Post: #5
RE: Expiry date became 2000-00-00 when perform Transfer Controlled Items
Hi Exson,

This particular problem is caused by the fact that sql statements at lines 131,143,245 and 257 of StockLocTransferReceive.php do not update the expirationdate field of the stockserialitems table. If you look at lines 261 and 282 of StockTransfers.php you will see what I mean as it is done correctly there.

You are right with the code you changed though as that needed doing as well.

Thanks
Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
03-28-2014, 10:18 PM
Post: #6
RE: Expiry date became 2000-00-00 when perform Transfer Controlled Items
Hi, Tim,

Thank you for your attention for this issue and review my code. Very appreciated!

I've checked what you said and I'll find some time to fix it later.

Best regards!

Exson
Find all posts by this user
Quote this message in a reply
03-29-2014, 11:10 AM
Post: #7
RE: Expiry date became 2000-00-00 when perform Transfer Controlled Items
[undefined=undefined]Hi,Tim,[/undefined]

I've checked the relative scripts and found that expiry date for bulk inventory transfer not supported, as you said whether it is dispatched or received. But normal stock transfer working now with my patches.

I think currently it is OK for this. At least it's can be handled now.

Best regards!

Exson

(03-28-2014 10:10 PM)Uhuru Wrote:  Hi Exson,

This particular problem is caused by the fact that sql statements at lines 131,143,245 and 257 of StockLocTransferReceive.php do not update the expirationdate field of the stockserialitems table. If you look at lines 261 and 282 of StockTransfers.php you will see what I mean as it is done correctly there.

You are right with the code you changed though as that needed doing as well.

Thanks
Tim
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: