Need time of PO Receipt - SQL help please

(0) Share

Report

Posted on by Community Member

I need help knowing what tables and fields will help me prove at what TIME an item was received. More like the time the receipt batch was posted for the item.

All tables and reports seem to give are dates with no time of receipt( I can't understand why time isn't in every datetime field).

2016-03-22 00:00:00.000   I know this wasn't received at 12:00 AM since no one was here.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

MattPaulen 6,912 on at

Like (1)

Report
Copy link

Link copied!

From what I've found, GP doesn't tag the time to the majority of the date fields so you'll always see the 00:00:00:000 time indicator for those date fields. Some tables you will see a DEX_ROW_TS where that will show the time as well as the date. Unfortunately it doesn't look like the POP or the IV tables for the receipts have the DEX_ROW_TS field in them.

If you really need the timestamp you may need to look in to an auditing tool like Fastpath or Rockton.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I have been asking myself exactly the same question and never got any rational answer.

This is poor design. In evaluating GP and its competitors, this should be a disqualifier...

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Hi,

What it sounds like you are needing is more like an audit trail as mentioned earlier. There are three excellent options to choose from to add this functionality.

Kind regards,

Was this reply helpful? Yes No