E812 Commit failed error when processing GRN in P4312 - Purchase Order to receive

Hi,  In the version of  E812, the processing option in P4312 - purchase order to receive :Process tab\Supplier Analysis On : 1
This would check the transaction order date if exceed to 999 value (3 years above),  If the date is 3 years back, it would hit the commit fail error when doing P4312 purchase order to receive  (GRN)..

Solution 1 :

Create a new verion of P4312 and turn off the supplier analysis - Proc Option - Process Tab - Supplier analysis : blank out


Solution 2:
Apply ESU JK21694 to fix the bug 12335832



JDE log :

2656/5916 WRK:Starting jdeCallObject                Fri Jan 16
10:13:02.218232                Jdbodbc.c8337
        ODB0000164 - STMT:00 [22003][30160] [IBM][iSeries Access ODBC
Driver]Column 21: Numeric value out of range.


2656/5916 WRK:Starting jdeCallObject                Fri Jan 16
10:13:01.234012                Jdb_exet.c7458
        JDB9901232 - Canceling transaction because: TC033 UpdateTable:
update failed

attached is the white paper relating to this error code TC033..




Hope that helps...



Thanks