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 (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/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

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

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

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

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

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

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

[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