Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ICHIST TRANSDATE vs PORCPH1.[DATE]

Status
Not open for further replies.

iwells

Programmer
Oct 2, 2012
284
CA
Hi,

Doing some auditing reports and noticing there are circumstances where ICHIST.TRANSDATE is different than the [DATE] field from most of the document header tables (PORCPH1, POINVH1, etc) in the PO module. This isn't a high percentage amount, but I'm being asked why.

I have some specific examples where I've examined the records in PORCPH1 and PORCPAH and I've been unable to find a date in either of those tables that matches what's populated the ICHIST.TRANSDATE field. Also, data integrity found no errors.

Aside from user error is there a system logic rule for populating this field that is something other than ICHIST.TRANSDATE = the header document date?

Thanks,
Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top