Contents tagged with Images

  • How to display images in grid of Acumatica

    Hello everybody,

    today I want to leave a short post on how to display images in grid of Acumatica. 

    I'll demonstrate it on sample of Sales Orders pages, which is known as SO301000.

    End result will look like this:

    In order to make it work, I've done the following:

    Created extension to SOOrderEntry and added there some kind of reading of url images

    Created DAC class for demo purposes

    Added few controls and css/js on customized so301000 page.

    Now a bit more details. For SOOrderEntry I've created following extension:

        public class SOOrderEntryExt : PXGraphExtension<SOOrderEntry>

        {

        public PXSelect<SOImageItem> Images;

        protected virtual IEnumerable images() … more

  • Inventory items images structure in Acumatica

    Hello everybody,

    today I want to document some information about how images for inventory items are stored in Acumatica. 

    Database structure (Acumatica)

    InventoryItem - A table that contains all InventoryItem data

    > ImageURL - A data field where the image file name being saved.

     

    UploadFile - A table that contains attachments data

    > Name - A data field where you can use to join with InventoryItem using InventoryItem.ImageURL = UploadFile.Name

     

    NoteDoc - A table that contains all NoteDoc data

    > FileID - A data field unique ID where you can use to join with UploadFile using UploadFile.FileID = NoteDoc.FileID

     

    A SQL query that get data necessary to create the imageExternalLink … more