deepgrewal22
Member
I am using a 3rd party program which I have written to successfully populate the following fields in the table below in JDE OneWorld E810 (DEMO)
F06116Z1
-------------
VLAN8*, VLDWK*, VLPDBA*, VLPHRW*, VLANI, VLEQWO, VLEQCG, VLQOBJ, VLSBL, VLSBLT
* = Required fields for F06116Z1
Next, I run R05116Z1I (PROOF) to analyze the data in F06116Z1 table and report errors. An error is always reported if VLEQCG (equipment used on job) and VLQOBJ (equipment object account #) are filled out for a record.
Below is a sample of the data which I am inserting into F06116Z1 in JDE OneWorld E810 (DEMO):
<font class="small">Code:</font><hr /><pre>
AN8 = 4800
DWK = 2/26/2009
PDBA = 1
PHRW = 400
ANI = 6100.1341
EQWO = 00000123
EQCG = 00000123
QOBJ = 1341
SBL = 65010
SBLT = W
</pre><hr />
The simplest data to enter to recreate the error looks like this:
<font class="small">Code:</font><hr /><pre>
AN8 = 4800
DWK = 2/26/2009
PDBA = 1
PHRW = 400
EQCG = 00000123
QOBJ = 1341
</pre><hr />
Below is the error which is encountered after R05116Z1I has been run. Note that 1355 was never used during data entry into F06116Z1. After running R05116Z1I, F06116Z1 still does not contain 1355 in any field.
<font class="small">Code:</font><hr /><pre>Error: Account Number 6100.1355. is Invalid</pre><hr />
I tried entering the same data without the 3rd party application using P051121 (writes directly to F06116). If I fill in every field exactly the same way and leave QOBJ blank during an add, "1355" automatically populates in the QOBJ column of the interactive application. However, this value also throws an error. If I change the value to "1341", the record is successfully added to F06116.
How can "1341" be a valid value for the QOBJ field in F06116, but not a valid valid value when attempting to add to F06116 via F06116Z1 and R05116Z1I?
F06116Z1
-------------
VLAN8*, VLDWK*, VLPDBA*, VLPHRW*, VLANI, VLEQWO, VLEQCG, VLQOBJ, VLSBL, VLSBLT
* = Required fields for F06116Z1
Next, I run R05116Z1I (PROOF) to analyze the data in F06116Z1 table and report errors. An error is always reported if VLEQCG (equipment used on job) and VLQOBJ (equipment object account #) are filled out for a record.
Below is a sample of the data which I am inserting into F06116Z1 in JDE OneWorld E810 (DEMO):
<font class="small">Code:</font><hr /><pre>
AN8 = 4800
DWK = 2/26/2009
PDBA = 1
PHRW = 400
ANI = 6100.1341
EQWO = 00000123
EQCG = 00000123
QOBJ = 1341
SBL = 65010
SBLT = W
</pre><hr />
The simplest data to enter to recreate the error looks like this:
<font class="small">Code:</font><hr /><pre>
AN8 = 4800
DWK = 2/26/2009
PDBA = 1
PHRW = 400
EQCG = 00000123
QOBJ = 1341
</pre><hr />
Below is the error which is encountered after R05116Z1I has been run. Note that 1355 was never used during data entry into F06116Z1. After running R05116Z1I, F06116Z1 still does not contain 1355 in any field.
<font class="small">Code:</font><hr /><pre>Error: Account Number 6100.1355. is Invalid</pre><hr />
I tried entering the same data without the 3rd party application using P051121 (writes directly to F06116). If I fill in every field exactly the same way and leave QOBJ blank during an add, "1355" automatically populates in the QOBJ column of the interactive application. However, this value also throws an error. If I change the value to "1341", the record is successfully added to F06116.
How can "1341" be a valid value for the QOBJ field in F06116, but not a valid valid value when attempting to add to F06116 via F06116Z1 and R05116Z1I?
