Skip to main content
Solved

Create a Data Member from a non existent table - Inventory Allocation Details


Hashini
Freshman I

Dear all,

I’m using acumatica version 21.117.0037. My requirement is to create a custom screen like “Inventory Allocation Details (IN402000). In the grid of that screen, the DAC used to create the data member is “InventoryAllocDetEnqResult” which is a non-existent table. The same [PXFilterable] view (ResultRecords) as in “InventoryAllocDetEnq” BLC was created in custom entry page, but when assigning the view for the data member of custom class, server error occurs.

Can anyone help me to create a view for this kind of scenario?

 

Best answer by Naveen Boga

Hi @Hashini  You can simply provide like below in your Graph file.

 

[PXFilterable]

Public PXFilter<NonexistenceTable> ViewName;

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

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3404 replies
  • Answer
  • May 31, 2022

Hi @Hashini  You can simply provide like below in your Graph file.

 

[PXFilterable]

Public PXFilter<NonexistenceTable> ViewName;


Hashini
Freshman I
  • Author
  • Freshman I
  • 5 replies
  • May 31, 2022

@Naveen Boga Thanks, that worked. 


Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7

For some screens it makes sense to compose the data ‘on the fly’ rather than select it straight from the database. 

To implement that behavior you need to use Data View Delegate. 

See here: https://help-2022r1.acumatica.com/Help?ScreenId=ShowWiki&pageid=f3c57501-ccca-4d62-93d2-7eb4ea8e377f

 


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