trying to create a report based off of the data in the JOUR-I file that’s being created from us running the cycle count report ‘I’ for extended inventory based off of the inventory updates we are entering in the SM-A screen then going into SM-N-I to run the corresponding inventory report
we don't love the report that comes out of DDMS because for 1 thing we can’t ‘not’ include cost; she doesn’t want to see cost included on the report and the BIN locations are not being pulled into the report when you run it this way. Additionally the detail stored in the JOUR-I file it seems off, the field counts, the field length, something if off, how do we read this?
From the screenshot below you can see page 1 of the report we ran from SM-N screen and below the data from SQL; the JOUR-I file detail, see how in the report from DDMS the original OH qty column for item# AAG PM1228 it shows 60 but in that same field ‘ON hand’ in the SQL detail it shows a 6 and in the NEXT column under header CC count there’s the 0 which makes up the count of 60 but it’s in a completely different column.
Another example of the issue is the ‘update oh qty’ field; on the DDMS report is shows a qty of 88 for AAG PM128 but in the SQL detail of JOUR-I file the field shows 8 and in the next header/column record it shows the other 8 so something is not matching up.
SEE ATTACHED SCREENSHOT BELOW OF CYCLE COUNT FOR DETAILS DESCRIBED ABOVE.