Develop Customizations

Wondering if anyone can offer some insight here.  I was working on adding screen SO509000 to the mobile app and I was having an issue with the site map schema which I have since figured out. When I went back in to create a new customization of the mobile app by adding SO509000 screen I am getting the following error: ‘The 'SO509000' screen is already used in the current customization project. Select another screen.’The issue is that I have unpublished and deleted the original customization project that had this screen in it. Since then I have attempted the following. I have unpublish all of our customizations and republished the ones that are relevant and verified that the screen SO509000 is not being used in any other customizations. Additionally, I can still see the initial object that was created on the mobile app even without a customization or a Mobile Workspace telling this to be here. I have tried to reset the Mobile Workspaces to the defaults as well.  It would appear that the

Hello everyone,I published POS 2021 R2 version on my ERP 2021 R2, made all necessary configurations  but on the pos orders after pressing the PROCESS button its supposed to take me to a screen to print the receipt but its not doing so. If I press the REPRINT RECEIPT button, no action is triggered.The payment created is also left status: open instead of closed. I’m not able to find solution to this.Kindly assistALL responses will be highly appreciated.Thank you.  

Hi everyone,I’m using a generic inquiry to trigger a business event. The business event then has a custom data provider as a subscriber to send data to a remote API.Whilst this is mostly working, I’m trying to use the GI field “Captions” to provide a known name for columns that may have a function attached (or if the user wants to customise the column names). At the moment in the EventAction’s Process(MatchedRow[] eventRows, CancellationToken cancellation) method, Captions aren’t pulled through from the GI, only the original field names or randomly generated names for the columns containing functions.I’d like to be able to get hold of the GI that triggered the business event so I can retrieve the caption names for some of the fields.Is there a way to get a reference to the triggering object (in this case a GI) within the “Process” method or elsewhere?Many thanks

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.orderNbr>>>>.Select(Base, row.OrderNbr.Trim());                if (ship != null && ship.ShipmentNbr != null)                {                    SOShipm

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 customize it based on the below help articles.https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=3484dde7-2027-4e12-a60e-223e5a518421 

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) { SOOrder order= SelectFrom<SOOrder>.Where<S

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.Can you please give solution for 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 contract template info//t has a value of coursecontract.TemplateID = t;contract = contractMaint.Contracts.UpdateCurrent();//set the customer id and update the contract record with customer info//c has a value of coursecontract.CustomerID = c;contract = contrac

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"); } } How to create a hyperlink user field in a griderror CS0029: Cannot implicitly convert type 'CustomerCasesTab.CRCase' to 'PX.Objects.CR.CRCase'Does anyone have some direction on what I h

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 displayin

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)                    {   PXSelect<ARInvoice, Where<ARInvoice.noteID, Equa