Solved

Preview InventoryItem Inquiry That has ALL Field Details including Attributes

  • 25 April 2023
  • 5 replies
  • 42 views

Userlevel 2
Badge

I had stumbled upon an Inquiry screen that allowed me to Preview and Export to Excel ALL InventoryItems and their respective field values including Attributes. I am struggling to find that Inquiry. The output Excel filename began with Preview - InventoryItem Inventory Item then the export date.

Looking for help finding such a standard Acumatica Inquiry screen.

Thank you,

-Don Green

icon

Best answer by DonGreen 25 April 2023, 14:41

View original

5 replies

Badge +16

Hello,

Don’t worry, we all lose things sometimes. 🙂

Attributes are unique to each site. Any inquiry that lists all attributes side by side, is likely custom.

Check More Items → Data Views. Data Views is the home for many generic inquiries.  If the inquiry wasn’t added to the menu, you can find it in Customization → Generic Inquiries. I filtered for IN module in this example:

Consider too, you might have seen it in your test tenant.

Userlevel 2
Badge

Thank you Laura. We are brand new to Acumatica. Go Live was April 1, 2023. We do not have Custom Inquiries. I believe you have me going down the right path… I have looked as you have suggested. Is there any way I may be able to figure it out from the Export Filename ? I did not change that after I exported….. just looking for clues :-)

Badge +16

I think an Acumatica export to Excel using the Excel button will take on the name of the screen that I exported. The word “Preview” makes me think it came from the “Preview List” screens that we see when selecting a screen name from the menu.  Have you tried Global Search for the some of the Words in the filename? Global search circled in yellow, in the below example of  Preview List for Stock Items.

 

Userlevel 2
Badge

Found it !! I noodled through Generic Inquiry and got to the InventoryItem DAC → Selected Source Data then Cntl-A to Select All and Right Click Export.

Many thanks for your help Laura…. sent me down the right path 4 sure.

Userlevel 7
Badge

Thank you for sharing your solution with the community @DonGreen !

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved