By using this website, you agree to our Terms of Use (click here)
If I understand correctly, a GI of the InventoryItem table linked to the CSAnswers table to pull all the attributes and values for each item requires a separate SQL join and filter for each attribute ID. And if you add more attributes, the SQL joins must be manually updated in the GI.
Am I accurate on this, or missing something?
Is there no "easy" way to generate a file with the item number and all the inventory attributes associated with that item number?
Just checking...
It depends on what you want to do with that file. If you can take the data vertically, just link Inventory and CSAnswers by NoteID and refNoteID. Then display a row for each item/attribute combo.
If you want the attributes as columns, there are two ways I thought of. If all your data is numeric you could just do a pivot table in Acumatica against that GI I mentioned above. You could have attribute as a column and do a Max on value for the value. InventoryCD as the rows.
If your data is not numeric (most likely), I found an interesting way to do a real excel pivot table and show text values in the pivot table ( https://sfmagazine.com/post-entry/july-2018-excel-reporting-text-in-a-pivot-table/ ). I was able to take an excel export of the GI I mentioned above, apply the steps in the link, and then get item codes as rows, attributes as columns, and values of the attributes in the intersection. If you wanted this on a regular basis, just save the excel sheet and then copy your new data into it ad refresh your pivot table. To be honest, if you wanted it on a regular basis, I would just add the links for each attribute. If you have a lot of attributes and you only need the data once, this is a fairly quick process.
It would be nice if Acumatica had a class setup with all the attributes as columns and you could just add new ones to the results of the GI.
Something else I was thinking about - if you just want to see the data, you could use a side panel on the stock item list screen.
Nice Ryan! I love CONCATENATEX.