Skip to main content
Solved

Invalid object name 'InventoryTranHistEnqFilter' in Generic Inquiry


nhatnghetinh
Captain II
Forum|alt.badge.img+10

Dear ALL,

I created Generic Inquiry using “InventoryTranHistEnqFilter” table. But when I pressed “VIEW INQUIRY” to see the result it gave error “Invalid object name 'InventoryTranHistEnqFilter'”.

Please explain the cause of the error and help how to fix it !

Many thanks !

NNT

 

Best answer by Naveen Boga

Hi, @nhatnghetinh The DAC - InventoryTranHistEnqFilter is a virtual DAC, where this table does not exist in the database, hence when you click on the VIEW INQUIRY, it is trying to fetch the details from the database and gives us the error.

Instead, you can use below DACs/Tables and hoping you will get the required information.

  1. INItemSiteHistD
  2. INItemSiteHist

 

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

5 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • June 18, 2022

Hi, @nhatnghetinh The DAC - InventoryTranHistEnqFilter is a virtual DAC, where this table does not exist in the database, hence when you click on the VIEW INQUIRY, it is trying to fetch the details from the database and gives us the error.

Instead, you can use below DACs/Tables and hoping you will get the required information.

  1. INItemSiteHistD
  2. INItemSiteHist

 


nhatnghetinh
Captain II
Forum|alt.badge.img+10
  • Author
  • Captain II
  • 389 replies
  • June 18, 2022

Dear @Naveen Boga

I saw Inquiries “Inventory Transaction History” (IN.40.50.00) use this DAC - InventoryTranHistEnqFilter and it worked fine.

Can you help me to know why this Inquiries “Inventory Transaction History” works when using DAC - InventoryTranHistEnqFilter while Generic Inquiry can’t.

Thanks,

NNT

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • June 18, 2022

Hi, @nhatnghetinh  Yes, that is correct.

In the Inventory Transaction History screen, all the values are dynamically calculated and displayed on the screen but they will NOT fetch from the database.

In Generic Inquiry, when we do VIEW INQUIRY, the system will try to fetch the details from the database and since the table is not present in the database, hence it is throwing an error.

 

 


nhatnghetinh
Captain II
Forum|alt.badge.img+10
  • Author
  • Captain II
  • 389 replies
  • June 18, 2022

Dear @Naveen Boga,

How to know DAC and virtual DAC in Generic Inquiry/Table Name ?

Thanks,

NNT


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • June 19, 2022

Hi @nhatnghetinh 

You cannot able to know whether the DAC is Virtual DAC/Table OR Database DAC/Table.

 

But, if you can able to know if you the VIEWs in Graph file and DAC fields like below.

  • Click on the Inspect Element
  • click on the Actions DropDown
  • You can see options like Data Class Source code and Business Logic Source Code

 

In the Inventory Transaction History screen header, the DAC view is FILTER, which can help us to enter the data and the results will be displayed in the GRID.

 

After entering the details in the Header fields, the system is fetching the data from multiple tables like INTran, INTranSplit, etc. You can create a GI for this table but not for the InventoryTranHistEnqFilter DAC.

 

 

 

Header DAC

 

 

GRID DAC:

 

GRID DAC

 

 


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