|
Viewing Issue Simple Details
[ Jump to Notes ]
|
[ View Advanced ]
[ Issue History ]
[ Print ]
|
|
ID |
Category |
Severity |
Reproducibility |
Date Submitted |
Last Update |
|
0000103 |
[Both Evo and DBA Classic] |
minor |
always |
2010-02-02 17:50 |
2010-02-19 15:55 |
|
|
Reporter |
dkpruett |
View Status |
public |
|
|
Assigned To |
JEMM |
|
Priority |
normal |
Resolution |
open |
|
|
Status |
assigned |
|
|
|
|
|
Summary |
0000103: IN-F QC Items not Actually included |
|
Description |
When running IN-F Print Inventory Value for a "prior" date and selecting Y to "Include units in QC", items actually received and in QC prior to the "As-Of Date" but released subsequent to the "current" date are not accounted for; items "still in QC" as of the "current" date are in fact accounted for. |
|
Additional Information |
When we run this report, I always have to run the following sample SQL query against table BKQCTRAN and merge the results with that from IN-F to acurately account for all inventory.
SELECT * FROM BKQCTRAN where BKQC_trn_ardte < '2009-10-01' and Bkqc_trn_bodte > '2009-09-30' order by bkqc_trn_code
Of course, this query would be matched up with a report from IN-F with an "As-Of Date" of '2009-09-30' |
| Tags |
No tags attached. |
|
|
Banner Date |
|
|
Error Message |
|
|
Program Name |
|
|
Repeatable in Test Company |
|
|
|
Attached Files |
|
|
|
Relationships 
