0

Retrieve timestamp from when Purchase Order was created

Jet Reports Historic Posts

September 25, 2009 20:22

None

Follow

I want to pull the creation date of a purchase order.
I see a field in the PurchaseHeader database called 'timestamp' but I am not able to pull it with JetReports.

Is it possible to pull that value? or is there another field used to retrieve the date that the record was created?

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts September 28, 2009 18:34

  What type of database are you using? Purchase Header sounds like NAV, but timestamp is not default field.
  
  If you are using NAV, there is no default field for this, but one could have been added. If so, you probably want to double check that it is being populated according to your expectations.
  
  Another possible option is to use the order date, but this depends on the processes of the client. Many clients use order date for the original date and update posting date when the document is posted. Document date controls the terms and allows the decision to update the starting date for terms to be made independently of the original order date and/or date posted.
  
  Regardless of whether you are using NAV, if you can see the field in the application, there should be a way to make it show up in Jet.

• 0
  
  Jet Reports Historic Posts September 30, 2009 15:58

  It is NAV on SQL Server.
  
  They have been altering the Order Date in the past (not sure why)
  so I disabled that field on the Purchasing Card.