Skip to main content
Solved

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

  • May 31, 2022 9:16 AM UTC
  • 3 replies
  • 416 views
  • Translate All

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

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Answer
  • May 31, 2022 9:46 AM UTC

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

 

[PXFilterable]

Public PXFilter<NonexistenceTable> ViewName;

Translate

Hashini
Freshman I
  • Author
  • Freshman I
  • May 31, 2022 10:08 AM UTC

@Naveen Boga Thanks, that worked. 

Translate

Dmitrii Naumov
Community Manager
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

 

Translate