acumatica - Add extra note field to grid line -


i have client add note field grid. if not possible, there way have large text field in grid uses pop window editing large amount of text in field?

priority: 1.) add note field grid, if possible. 2.) failing #1, there way add popup window edit large standard user text field.

i believe answer number 1 question no. if grid has note cannot have another. had question come before.

for #2, should able smart panel displays field. use pxtextedit , setup new view panel point based on selected/current row.

to add smart panel (pop panel) need handful of things in place. prefer using aef graph , table extensions. there documentation in t200/t300 training material these topics. in example add note ability sales order page. copied of logic existing "po link" button , panel posupplyok pxaction , currentposupply view (page so301000).

first need new field add sales line extension table/field:

 [pxtable(typeof(soline.ordertype), typeof(soline.ordernbr), typeof(soline.linenbr), isoptional = true)] public class solineextension : pxcacheextension<soline> {     #region xxmynote     public abstract class xxmynote : px.data.ibqlfield     {     }     protected string _xxmynote;     [pxdbstring]     [pxuifield(displayname = "my note")]     public virtual string xxmynote     {                 {             return this._xxmynote;         }         set         {             this._xxmynote = value;         }     }     #endregion }

then need create new graph extension add view panel , pxaction button open panel.

public class soorderentryextension : pxgraphextension<soorderentry> {      public pxselect<soline,         where<soline.ordertype, equal<current<soline.ordertype>>,             and<soline.ordernbr, equal<current<soline.ordernbr>>,                 and<soline.linenbr, equal<current<soline.linenbr>>>>>> mypanelview;      public pxaction<soorder> mynoteaction;     [pxuifield(displayname = "add note", mapviewrights = pxcacherights.select, mapenablerights = pxcacherights.update)]     [pxbutton(imagekey = px.web.ui.sprite.main.dataentryf)]     protected virtual ienumerable mynoteaction(pxadapter adapter)     {         if (base.transactions.current != null &&             mypanelview.askext() == webdialogresult.ok)         {             //extra stuff here if needed when ok pushed         }          return adapter.get();     } }

now need "edit" sales order page. need changes customization project , go edit page direct in visual studio under site\pages\so in example. come , paste in code customization project opening project , performing following steps:

  1. click on screens , + sign add new screen
  2. enter so301000 , save
  3. click on so301000 hyperlink open layout editor sales order
  4. click actions > edit aspx
  5. paste in changes (mentioned below)

in so301000 page add following:

[1] add ds callback command within pxdatasource tag

<px:pxdscallbackcommand name="mynoteaction" visible="false"      commitchanges="true" dependongrid="grid" />

[2] add button toolbar above sales line grid adding following pxgrid > actionbar > customitems tags of grid in document details tab. (just search "po link" in page find location easier or of listed buttons above grid).

<px:pxtoolbarbutton text="add note" dependongrid="grid">     <autocallback command="mynoteaction" target="ds" /> </px:pxtoolbarbutton>

[3] add panel code represents panel like. can play around sizing fit needs, make sure set pxtextedit use multiline using following example code. @ current sales order page know fits page syntax:

<px:pxsmartpanel id="pxsmartpanelnote" runat="server" caption="my note panel caption"     captionvisible="true" designview="hidden" loadondemand="true" key="mypanelview" createondemand="false" autocallback-enabled="true"     autocallback-target="formmynote" autocallback-command="refresh" callbackmode-commitchanges="true" callbackmode-postdata="page"     acceptbuttonid="btnmynoteok">     <px:pxformview id="formmynote" runat="server" datasourceid="ds" style="z-index: 100" width="100%" captionvisible="false"         datamember="mypanelview">         <contentstyle backcolor="transparent" borderstyle="none" />         <template>             <px:pxlayoutrule id="pxlayoutrule44" runat="server" startcolumn="true" labelswidth="s" controlsize="xm" />             <px:pxtextedit id="cstxxmynote" runat="server" datafield="xxmynote" textmode="multiline"/>         </template>     </px:pxformview>     <px:pxpanel id="pxpanel10" runat="server" skinid="buttons">         <px:pxbutton id="btnmynoteok" runat="server" dialogresult="ok" text="ok"/>     </px:pxpanel> </px:pxsmartpanel>

i have not tested above quick slap brought panel no errors. using version 6.00.0955 same steps should work in 5.x versions. hope helps.


-

Comments

Post a Comment

Popular posts from this blog

many to many - Django Rest Framework ManyToMany filter multiple values -

i have 2 models, 1 defining users, other defining labels on these users. using django rest framework create api. able query users @ least labels ids 1 , 2. for instance users' labels are: [(1,2), (1,2,3), (2,3), (1,3)] want query return [(1,2), (1,2,3)] . so far, i've managed query users given label (let's id=1) doing: /api/users/?labels=1 , unable query users labels 1 , 2. i've tried /api/users/?labels=1,2 or /api/users/?labels=1&labels=2 return invalid users, i.e. users without labels 1 or 2... any welcome. thanks, dimitry github test repo: https://github.com/thedimlebowski/drf-m2m-filter code: models.py class label(models.model): name = models.charfield(max_length = 60) class user(models.model): labels = models.manytomanyfield(label) filters.py class userfilter(django_filters.filterset): labels = django_filters.filters.baseinfilter( name='labels', lookup_type='in', ) class meta:...
Read more

java - Jasper subreport showing only one entry from the JSON data source when embedded in the Title band -

Image
i having issues populating data in subreport in title band of main report. data populated correctly in subreport in detail band of main report. trying find wrong in json query. appreciated. json sample data source (expenses.json) { "expenses": { "date": "8 sep 2016", "accounts": [ { "title": "xyz corp (111)", "accountname": "xyz corp", "accountnumber": "111", "transactions": [ { "date": "21 jun 2016", "name": "gas", "price": "17.50" }, { "date": "12 may 2016", "name": "shopping", "price": "111.99" }, { "date": "30 apr 2016", "name...
Read more

Java Entity Manager - JSON reader was expecting a value but found 'db' -

i have code working: entitymanager entitymanager = getentitymanager(); entitymanager.gettransaction().begin(); string query = "db.band.find({})"; list<band> list = (list<band>) entitymanager.createnativequery(query, band.class).getresultlist(); entitymanager.close(); return list; it returns list no problem. want sort list date : entitymanager entitymanager = getentitymanager(); entitymanager.gettransaction().begin(); string query = "db.band.find({something__id:objectid(\"" + myid + "\")}).sort({\"somethingelse.date\":-1})"; list<band> list = (list<band>) entitymanager.createnativequery(query, band.class).getresultlist(); entitymanager.close(); return list; my console gives me message: org.bson.json.jsonparseexception: json reader expecting value found 'db' i checked string working in mongo console , did. ideas? edit: tried putting "something__id" between quotes because would...
Read more