#11 Mantis ID:6393 - recieve none stocked items generates errors

open
nobody
None
3
2008-02-12
2008-02-12
omfgppc
No

Reporter: zzzzz
Severity: Patch
Category: S/R
Project: xTupleApps

Version: 2.3.0

Description:
If you receive each line item on PO one at a time the receive date is left null for none stock items this generates an error on the posting of the received lines items as the gl distribution date is left NULL

the problem down in the insert command as it only uses _timestamp variable which was being left null in some cases

Steps to reproduce:

Additional information:
this needs to be added to the to of the enterreceipt(text, integer, numeric, numeric, text, integer, date) function on Postgres side

IF(precvdate IS NULL OR precvdate = CURRENT_DATE) THEN
_timestamp := CURRENT_TIMESTAMP;
else
_timestamp := precvdate; --Fixes problem where PO date is left null
END IF;

Read more at http://www.xtuple.org/mantis/view.php?id=6393

Discussion


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks