Develop Customizations

The following is the code causing the errors; Unable to cast object of type 'APDocumentResult' to type 'PX.Data.PXResult`1[PX.Objects.AP.APDocumentEnq+APDocumentResult]     What could be the issue? Kindly assist Thank you

On the shipments form I have my shipped volume as shown belowI need the shipped volume to appear on transfer form on the summary area as shown below. Any ideas on how to go about with the business logic? 

Hi Expert.I try disale field So Notes depends on the condition of the shipment  in below:I try set break point at:PXUIFieldAttribute.SetEnabled(cache, row, true);                        PXUIFieldAttribute.SetEnabled<SOOrderExt.usrSoNote>(cache, row, true); break point ok, program touch here. protected void SOOrder_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler)        {            InvokeBaseHandler?.Invoke(cache, e);            var row = (SOOrder)e.Row;            if (row != null && row.OrderNbr != null)            {                Base.Document.Cache.AllowUpdate = true;                Base.Transactions.Cache.AllowUpdate = true;                SOOrderShipment ship = PXSelect<SOOrderShipment, Where<SOOrderShipment.orderNbr, Equal<Required<SOOrderShipment.

Hello Everyone,I am facing this error while publishing the customization.see below: Have tried to troubleshoot but couldn’t resolve it.Kindly assist,Thank you allany kind of response will be highly appreciated.

I am in the process of trying to connect a SQL Server View to Acumatica. Right now I am on the “Create Code File” and there should be, in the drop down the ability to select lBqlTable but it does not exist. The only selections that are available are:New Graph, New DAC, Graph Extension, DAC Extension, Code File, and Customization Plug-in. 

Has anyone added /activated existing functions keys, that are currently not available on the mobile app. I had a case on this and was pointed to the following articles.Which are informative but disjointed and most likely over complicate what has to be done to activate the existing Action keys. I attempted to follow the instructions, I  have supplied a image of the customization, and an image of what mobile functions are available.  When the PO is in pending print status. A couple issues using the mobile app the PO cannot be opened (open Status)  which is what is wanted. The print /no print options were deemed not essential an left off the mobile app, as space is limited.  I checked this from my end. By default, due to the space constraints of a phone screen, not every function is available in the mobile application. Therefore, you will have to custo

Hi,I have customized a new screen. To my screen I’m getting data from soorder DAC and soline DAC. This time, I need to get sales orders without duplicating from the view to my custom screen. When new row is inserted into my line level, I need to update TotalDiscount field of header level with soorder.curydisctot value which is taken from the soorder screen header level. To accomplish avoid duplicating when adding same sales order number , I tried the below code in the row inserted event but it didn’t work.protected void APProformaItemList_RowInserted(PXCache cache, PXRowInsertedEventArgs e) { var row = (APProformaItemList)e.Row; APProforma item = APProformas.Current; //add so discount into form var distinctSOLines = this.APProformaItems.Select().FirstTableItems.ToList().Select(x => x.Ponbr).Distinct(); foreach(var itemlist in distinctSOLines)

Hi,I create a new data field into my purchase order screen poline DAC,[PXDBString(10)][PXUIField(DisplayName="uomnew")]Then I try to set field value in rowselected event. public class POOrderEntry_Extension : PXGraphExtension<PX.Objects.PO.POOrderEntry>  {    #region Event Handlers    protected void POLine_RowSelected(PXCache cache, PXRowSelectedEventArgs e)    {            var row = (POLine)e.Row;      POLineExt poLine = PXCache<POLine>.           GetExtension<POLineExt>(row);      poLine.Usruomnew= "news";     if(poLine != null){       poLine.Usruomnew= "new";     }          }        #endregion  } After adding POOrderEntry_Extension and published It shows an error below like that.

I need to add new two columns with Item wise weight and UOM to the Sales Order form (SO301000) line level. Can you please provide the work around how it is archived from the customization project editor.

I set up a new sandbox and database and uploaded a backup of my production ERP to populate the database. I can see that the database tables populated, however my data is not showing up in the sandbox. Can someone please help me troubleshoot? Thanks!    

Hi,I was trying to publish a new change I made to a client’s system and I got the exception shown below:System.IO.FileNotFoundException: The file '8670b8ca-b605-473b-9152-e7f09e536cba' has not been found.What would be the best way to resolve this issue?Kind regards,Andrew

Hi, I’m struggling to insert a new Customer Contract record into Acumatica using code. The screen is CT301000Here is the screen shot:and here is the important part of the code I’m using with added comments//create the graphContractMaint contractMaint = PXGraph.CreateInstance<ContractMaint>();//create a new instance of the dacContract contract = (Contract)contractMaint.Contracts.Cache.CreateInstance();//insert into the viewcontract = contractMaint.Contracts.Insert(contract);//set the contractCD, it's using a segmented key but I think this is the way to set the valuecontract.ContractCD = "D -D -<NEW> ";contract = contractMaint.Contracts.UpdateCurrent();//set the template id, update the contract record with cont

I’m programmatically setting the value of a custom field depending on another field’s value. I want it to happen first thing when the page is displayed, before anything is changed by the user. I which event should I put the code?Thanks is advance for any suggestions.

I created a very simple sub-report with the below specifications. Please see the below screenshots.Parameter of the sub reportFilter in sub reportThis sub-report worked well after being published in the instance. But when I connect this sub-report with my main report, data from the sub-report is not coming. Please see the below screenshot. Main report with sub reportPlease give me a support to overcome this issue. Thank you.

Hi,In the receive and put away form, when the item is lot/ser I want to enter separate lines even if the lot or expiration date is the same. It is possible?  I dont want to create multipe receipts. Which method I can edit or replace? Thanks,EV

Hi!I’ve trying to deploy the ability to print the SalesOrder/Quote report in the Mobile App. I follow the code described in this article Acumatica but nothing happens. The PrintSalesOrder/Quote action doesn’t appear in the container “Order Summary”. I was able to add the report screen in the main menu but i want to have the redirect within a specific Sales Order record.Anybody know what is missing?Thanks!

How do I add a “Total Budget” column to current P&L? I have report design rights. 

I tried following the instructions from the link below to create a hyperlink in a grid; however, I am receiving an error message during validation/compile, (error message below. The code snippet also here shows what I have written. public PXAction<CRCase> ViewCase; [PXButton] protected virtual void viewCases() { CRCase row = CasesGraphView.Current; string caseCD = row.Casecd; CRCase casenbr = PXSelect<CRCase, Where<CRCase.casecd, Equal<Required<CRCase.casecd>>>>.Select(this.Base,row.Casecd); CRCaseMaint graph = PXGraph.CreateInstance<CRCaseMaint>(); graph.Case.Current = casenbr; if (graph.Case.Current != null) { throw new PXRedirectRequiredException(graph, true, "Cases"); } }

Has anyone come across - is it possible to add a document to this page using Rest API. Which API entity can be used for this. I tried to find a separate document or find a link to the vendor, but I can't find it. The vendor can expand the api using the WebService Endpoint, but there the work is carried out not with a collection of documents, but with one - and there is a warning that the documents must be requested one at a time and not included in the upload, the message is not clear what is available and how to do with this. Does anyone have experience with this entity using Rest API, I will be glad for any ideas 

Hello Everyone, kindly advise, How to add below Addressline1 & Addressline2 details from customer Location screen(AR303020) to existing Sales Order screen(SO301000) in Location field.   ​​​​ Data Class: SOOrder and field name is CustomerLocationID from Sales Order screen .

We are relatively new to Acumatica and we are looking for an easy way for our AR people to see what a customer owes in each of the aging buckets when they call to make a payment. Most of our customers have consolidated accounts - meaning one parent account with a number of children accounts rolling up to the parent. When a customer calls in to make a payment we are not able to easily see what they owe as a function of aging. All we get is a balance amount which includes everything including the invoices that will appear on next months statement. Ideally we would like to be able to go to the customers screen (AR303000) see what they owe in each of the aging buckets then click the Create Payment action which opens the AR302000 screen and have it show the aging amounts for the customer there as well. Right now we have to bounce around between various reports, write down the amount and then go to the payment screen and create the payment. Has anyone heard of or done anything with displa

I have created a new grid in Cases where when you populate the Relations grid tab with invoice documents it then populates this new grid called CAMRelations with all of the invoices entered in the Relations tab.Right now, I have it working where the CAMRelations grid pulls the invoices one at a time from the Relations tab, but I want it to populate with all of the invoices from the Relations tab, not simply one at a time. If you highlight each item in Relations the CAMRelations pulls the correct invoice information, but again only one at a time and not a list of the invoices from the Relations grid.The screen shots below show what I am seeing.Basically below is the logic I want to use, it simply fails validation.  So I do not know what I should do for this.                    var items = Base.Relations.Select().FirstTableItems.ToList();                                        foreach (CRRelation item in items)

Hi,I have developed a new report in acumatica.I need to the create variable and need to the add above highlighted fields into the variables.and then all the values i need to the show in the header level.Can u please give the suggestion to that.

I have read through several posts here but am still have a problem trying to put the sum of a column from multiple rows of a grid into a header column. I have seen code snippets, however, I think I am not arranging my code correctly.I am still very new to Acumatica coding.    Below the error message is the full CS code I am using.  Everything validates and compiles, but when I try to access the Cases screen I receive this error message.  So I obviously do not know where and what I need to do here.Can someone point me in the correct direction?What I am trying to do is on the Cases screen, use the Relations tab to associate Invoices to a Case and then in a new grid populate that grid with all of the invoice information from the Relations tab. (the other problem I have is that the new grid called “CAM Relations” only lists one invoice at a time, but that is a different problem not for this topic; unless dear reader you know what I am doin

Ive developed a custom SQL view and associated DAC which generates a table of available quantities of stock kits.Im trying to show the Qty in the Sales Order by adding PXDBScalar to the SOLine DAC detail screen however I keep getting null?  namespace AutoKitAssembly{  public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>  {        #region UsrKitQtyAvail        [PXDefault(TypeCode.Decimal, "0.0")]        [PXDBScalar(typeof(Search<KitAssy.qtyAvail,            Where<KitAssy.builtItemID, Equal<Current<SOLine.inventoryID>>,                And<KitAssy.siteId, Equal<Current<SOLine.siteID>>>>>))]        [PXUIField(DisplayName = "Kit Qty Available")]        public virtual int? UsrKitQtyAvail{ get; set; }