webERP Forum
Expiry date became 2000-00-00 when perform Transfer Controlled Items - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (/forumdisplay.php?fid=8)
+--- Thread: Expiry date became 2000-00-00 when perform Transfer Controlled Items (/showthread.php?tid=2178)



Expiry date became 2000-00-00 when perform Transfer Controlled Items - joadi_2003 - 03-25-2014 07:12 PM

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:

[attachment=275]


RE: Expiry date became 2000-00-00 when perform Transfer Controlled Items - joadi_2003 - 03-28-2014 08:49 PM

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.


RE: Expiry date became 2000-00-00 when perform Transfer Controlled Items - Exsonqu_Qu - 03-28-2014 09:32 PM

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


RE: Expiry date became 2000-00-00 when perform Transfer Controlled Items - joadi_2003 - 03-28-2014 10:02 PM

Hi Exson,

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

Best Regards,
Joanes


RE: Expiry date became 2000-00-00 when perform Transfer Controlled Items - Uhuru - 03-28-2014 10:10 PM

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


RE: Expiry date became 2000-00-00 when perform Transfer Controlled Items - Exsonqu_Qu - 03-28-2014 10:18 PM

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


RE: Expiry date became 2000-00-00 when perform Transfer Controlled Items - Exsonqu_Qu - 03-29-2014 11:10 AM

[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