Skip to main content
Solved

GI, Purchase Receipt History

  • 11 August 2023
  • 1 reply
  • 31 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

 

View original
Did this topic help you find an answer to your question?

1 reply

dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 583 replies
  • 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

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings