Skip to main content
Solved

GI, Purchase Receipt History

  • August 11, 2023
  • 1 reply
  • 51 views

I need a GI to show the Purchase Receipt History info, and the Element Properties show the name POReceiptPOOriginal. But this error message prompts ‘Invalid object name 'POReceiptPOOriginal'.’. Any other way to get the relation table?

 

Best answer by dcomerford

That table does not exist in the database if you look at the DAC you will see it is a projection and the view is based on the POOrderReceipt

So you could use this table in your GI i believe it will give you what you want

 

1 reply

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • Answer
  • August 11, 2023

That table does not exist in the database if you look at the DAC you will see it is a projection and the view is based on the POOrderReceipt

So you could use this table in your GI i believe it will give you what you want