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
View original
+17
Hi,
Instead, you can use below DACs/Tables and hoping you will get the required information.
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
+17
Hi,
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.
+17
Hi
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.
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.
GRID DAC:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
