Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Hi,I did a process to create a PO from a SO in the Sales Order screen. It works a bit different than the current create PO process where you specify the vendor details on the SO line and create the PO by clicking on an Action.The problem I have is when I call thePOCreate.CreateProcI don't get any exception that there was an error creating the PO. I only see the error afterwards in the Trace.PXLongOperation.StartOperation(Base, delegate () { try { POCreate.CreateProc(list, poFilter.PurchDate, poFilter.OrderNbr != null); } catch (PXRedirectRequiredException ex) { // Acuminator disable once PX1050 HardcodedStringInLocalizationMethod [Justification] // Acuminator disable once PX1051 NonLocalizableString [Justification] throw new PXException(ex.Message, ex.InnerException);
I’m using 2022 R2 Acumatica version. The use case here is to not allow some users to export in any form the reports, they can just view it.
Hi everyone, We have a requirement to implement PTO functionality in Acumatica. The Payroll module is not enabled in the system, and there is no plan to use it. Therefore, as I am aware, we cannot use the in-built PTO functionality of Acumatica. We are looking for a way (in-built or ISV integration) that could handle this requirement. The detail of the requirement is as follows:Employees accrue 1 day (8 hours) of PTO for every month of work performed (40 hours). This needs to be accrued throughout the year. Total of 96 hours can be accrued within a year. Partial carryover of PTO (40 hours) at the end of year is allowed. Employees should be able to request PTO leave for a particular date/dates. Ideally, there would be a calendar where they can view the requested and approved leaves. Approved leaves should be routed to the employee's manager for approval/rejection. Employee should be able to view their leave balance. Managers should be able to view Employees' leave balance summary.Apprec
User Description custom filed copy data create child order action click
I am struggling getting the redirect from my results to the document for the Inventory Allocation page on mobile. I have found the command it needs to use (ViewDocument), but I get an error anytime I try to tap on the record.Tracing the error, table name it is requesting is in the ASPX of the site, but I don’t know how to bring that in and tie it together.Refer to pictures & code below: Allocation DetailsFilter for Allocation DetailsError when I select a record on Allocation Detailsadd screen IN402000 { type = FilterListScreen add container "Selection"{ add field "InventoryID"{ selectorDisplayFormat = Key } add field "Available" add field "OnHand" # add field "Warehouse"# add field "Location" } add container "ItemPlansAllocationDetails"{ add field "AllocationType"{ listDisplayFOrmat = CaptionValue } add field "AllocationDate"{ listDisplayFOrmat = CaptionValue } add field "ReferenceNbr"{ listDisplayFOrmat = CaptionValue
We want to add the option to enter a Bill on the Mobile Workspace.On the Mobile Workspaces [AU220012] the Workspace ID for Payables is not visible.Possible workaround:Add a GI on the Mobile Workspaces MainpageI create a GI and selected Expose to the Mobile Application to view the Vendor Bills. On Acumatica you have the option for the GI to create a new bill as the Entry screen settings is set to Bills and Adjustments.This entry screen is not visible on the Mobile workspaceSecond workaround:Create a Dashboard that display the GI and display the dashboard on the mobile.Again the option to create a new Supplier invoice is not possible. How can this be achieved?
Hello all,Do we have a function in Acumatica that we pass a date and returns the WeekID which is used in EPTimeCard.WeekID? The format of WeekID stored in DB I see is “YYYY##” which ## is a sequential counter. I see Acumatica is using EPWeekRaw that has some properties including Start and End Date but I need it opposite. I have the date and I need the equivalent WeekID. I can calculate the Week # but I want to be consistent with what Acumatica does. considering Acumatica has Custom Weeks
Debug point not hit on the acumatica maint in 23R1 Version:23.105.0016
Hi,I want a custom selector on my project screen that functions the same way as the 'Owner' selector on the Project Quote screen. I have provided my code, and although I am getting a selector, it does not match the 'Owner' selector Of the Project Quote screen. #region UsrOwner public abstract class usrOwner : PX.Data.BQL.BqlInt.Field<usrOwner> { } [PXSelector(typeof(Search<Contact.contactID, Where<Contact.contactType, Equal<ContactTypesAttribute.person>, And<Contact.isActive, Equal<True>>>>), SubstituteKey = typeof(Contact.displayName), DescriptionField = typeof(Contact.fullName))] [PXDBInt(BqlField = typeof(CROpportunityRevision.ownerID))] [PXUIField(DisplayName = "Owner", Visibility = PXUIVisibility.SelectorVisible)] public virtual int? UsrOwner { get; set; } #endregionThe below mentioned data I want in my custom
Hello. Is an extension project required for use in the workflow API? I don’t see this question answered in the training class, although it’s example uses the extension library. When building a workflow code file for use in the website App_Runtime folder (instead of a .Net library), an error happens in a transition. I’m unsure if the ambiguity is legitimate or not.
On my custom screen, I have a “dummy” form that includes a tab with two tab items. Each tab item has it’s own form. Each form is essentially a screen with it’s own DACs.I COULD create two separate screens, one for each tab item, but I want to include them on one screen.For a single form I would add the primary DAC to the graph declaration to add the full toolbar to the form (cancel, save, new, Next Last etc.)However, each tab is a unique form. I want to show this in each tab item.To reiterate, this graph does not have a true “primary” DAC. The main form just has a dummy primary DAC (PXFilter<MasterTable> MasterView;). I’ve hidden the standard buttons for the main form.This is the aspx for this screen.<%@ Page Language="C#" MasterPageFile="~/MasterPages/FormTab.master" AutoEventWireup="true" ValidateRequest="false" CodeFile="IC102000.aspx.cs" Inherits="Page_IC102000" Title="Untitled Page" %><%@ MasterType VirtualPath="~/MasterPages/FormTab.master" %><asp:Conten
Hi,I need to add Vendors list popup on details grid on sales order page. I created new field in database with customization studio. Also added DAC extension then I update sales order screen (SO301000)but it just displays regular I want to have it like on Vendor Price screen (AP202000)
I have extend endpoints manufacturing(21.200.001) and using BillOfMaterial but I also want to expose data of Material and Tools, not able to do, Is there any way to expose the data of Material and Tool with BillOfMaterial. URL: {{URL}}/entity/MANUFACTURING/21.200.001/BillOfMaterial?$expand=operations,operations/Material,operations/Tools&$Select=BOMID,Status,InventoryID,Warehouse,InventoryUoM,Revision,operations/WorkCenter,operations/OperationDescription,operations/Material/QtyRequired,operations/Material/Warehouse,operations/Tools/ToolID,operations/Tools/LineID
I’m trying to add the Sales Order Custom Field “UsrBoard” to the SOShipment DAC but I’m getting Object reference error: namespace UsrSOBoard{ public class SOShipmentExt : PXCacheExtension<PX.Objects.SO.SOShipment> { #region UsrCustomField protected int _UsrSOBoard; [PXDBInt] [PXIntList(new int[] {0, 1}, new string[] {"WMS", "MTM"})] [PXUIField(DisplayName = "Board")] [PXUnboundDefault(typeof(Search<SOOrderExt.usrBoard, Where<SOOrder.orderNbr, Equal<Current<SOLine.orderNbr>>, And<SOOrder.orderType, Equal<Current<SOLine.orderType>>>>>))] public virtual int UsrSOBoard { get { return _UsrSOBoard; } set { _UsrSOBoard = value; } } public abstract class usrSOBoard : IBqlField { } #endregion }}
We have a custom field called UsrLocation and we want this to show up in the appointment screen under Details, I have found out that it needs to be added under the Service Order Details Grid. The issue is that the custom field was added to the Equipment form and is not showing up under the Service Order form. I understand that I need to make that custom field available (I think by adding it to the DAC?) to other forms, I am not sure how to do that under the customize project screen. Any help would be appreciated.
Does anyone know how can we modify the view of the Sales Prices(AR202000) screen? I just copied and pasted the view(from Business logic) of this screen for the graph and then all the data didn't appear.Before anything to modified (data appears)After copying and pasting the original view code to the graph. The data didn't appear.
I have created a shortcut button for Create Blanket Sales Order on the Sales Order Menu and on the Customers three dots menu.This feature is used to: from creating a customer to creating a blanket sales order in a single click.However, I have a problem: when I click the "Create Blanket Sales Order" button, it goes to the Sales Orders page then I notice that the "Create Child Orders" button is not displayed.Also it works properly if I select the order type manually. Please help me see if I am wrong or missing any part of the code. Thank you everyone for your help.Here is the code----------------------------------------------------------------------------------------------------------namespace PX.Objects.AR{ [PXCacheName("SOOrder Extension")] public class SOOrderExt : PXCacheExtension<SOOrder> { #region UsrCreateChildOrders [PXBool] [PXUIField(DisplayName = "Create Child Orders")] public virtual bool? UsrCreateChildOrders { get; set; } p
i have code to block duplicate Customer Order Nbr, but i want it should be filtered just for the “SO” Order Type.how can i do that? [PXCheckUnique(Where = typeof(Where2<Where<SOOrder.orderType, Equal<Current<SOOrder.orderType>>, And<SOOrder.customerOrderNbr, Equal<Current<SOOrder.customerOrderNbr>>, And<SOOrder.customerID, Equal<Current<SOOrder.customerID>>>>>, And<SOOrder.status, NotEqual<SOOrderStatus.cancelled>>>), ErrorMessage = "Order already exists with this Customer Order Nbr and Customer ID ")]
I’m building a custom data provider where I have a parameter that stores a number of documents processed and that needs to be increased every time the export was successfully send the document.I was thinking to use a parameter for it in the Data Provider but not sure if there’s a way to update it from the export method.
Hi All, I have created a new grid screen. Now I want to Show RowNbr in the Grid by adding a new column.I tried to do that as below in my graph. [PXFilterable] public PXSelectJoinOrderBy<SOLine, InnerJoin<SOOrder, On<SOLine.orderType, Equal<SOOrder.orderType>, And<SOLine.orderNbr, Equal<SOOrder.orderNbr>>>, LeftJoin<InventoryItem, On<SOLine.inventoryID, Equal<InventoryItem.inventoryID>>>>, OrderBy<Asc<SOLine.orderNbr>>> Transactions; protected IEnumerable transactions() { var result = Transactions.Select(); int rowNumber = 1; foreach (PXResult<SOLine> lineBoxed in result) { var line = lineBoxed.GetItem<SOLine>(); var lineExt = line.GetExtension<SOLineExt>(); lineExt.UsrRowNbr = rowNumber; rowNumber++; } return result;
Hi,I got a xml string as the json response body from the third party API.When I call the API.It;s response is json format.{ "referenceId": "b7e0fdacd8bd", "profileId": "PC12345678", "statusCode": "ACCP", "statusDesc": "Account transactions report generated successfully.", "reportBase64": "PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPCEtLSBTYW1wbGUgWE1MIGZpbGUgZ2VuZXJhdGVkIGJ5IEZGRlMgKHd3dy5ma2wuZmkpIEIyQyBwcm9qZWN0IGZvciBGSW5uaXNoIEFjY291bnQgUmVwb3J0LCAyMDA5LTExLTAyLCBmb3IgZGlmZmVyZW50IEVudHJ5IGluc3RhbmNlIGZvciAtLT4KPCEtLSBNVDIxMCAvIFByZW5vdGljZSBvZiBpbmNvbWluZyBpbnRlciBuYXRpb25hbCB0cmFuc2FjdGlvbiAod2l0aG91dCBiYWxhbmNlcykgYW5kIG9uZSBzaW1wbGUgaW50cmEgZGF5IGJhbGFuY2UgcmVwb3J0IHdpdGggb25lIHRyYW5zYWN0aW9uLS0}reportBase64 has the encoded string.When I decode it ,It showed a xml string like below.?xml version="1.0" encoding="UTF-8"?><!-- Sample XML file generated by FFFS (www.fkl.fi) B2C project for FInnish Account Report, 2009-11-02, for different Entry instance
Hi,I have a third party rest api to get bank details. When calling the API it response is json format.When I click the ADD Order Button I need to add response statusDesc with sales order descirption field.public PXAction<SOOrder> MyAction; [PXUIField(DisplayName = "ADD ORDER", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] [PXButton(CommitChanges = true)] public virtual IEnumerable myAction(PXAdapter adapter) { var URL = "https://sandbox.corporate-api.hsbc.com/mock/v2/transactions"; var httpRequest = (HttpWebRequest)WebRequest.Create(URL); httpRequest.Method = "POST"; httpRequest.ContentLength = 0; //IRestResponse response = client.Execute(httpRequest); var httpResponse = (HttpWebResponse)httpRequest.GetResponse(); //string responseBody = httpResponse.Content.ReadAsStringAsync(); SOOrder order = Base.Document.Current; //or
Hello All,Does anyone know what is the difference between “Base.ViewName.AllowUpdate = true” and “Base.ViewName.Cache.AllowUpdate = true”?My understanding from the Acumatica resources is the former is a shorter form of the latter. I have been using the short form forever and haven’t had any issues so far. I recently came across a weird situation in RowSelected event I am setting AllowEdit = true in the short form but when I trace I see the AllowEdit is still false RANDOMLY when this line of code is executed resulting in the line being read-only. I spent 4:30 tracing and chasing ghosts and finally, I just thought let's use the long form and surprisingly it is working.The funny thing is I have two Grids in the form and of course, each is tied to a view. One of them works just fine without any issues but the other one is acting up. The only difference between these two views is the one which is acting up has a view delegate while the other one is just a simple public view.Does anyone have
Hi,I have created a custom graph and its screen. It works fine but I have an unexpected behavior with standard navigation button : when I select the last record of main view (button “Go to last Record”) and when I click on “Go to Next record”, a new virgin record is proposed so that user can enter values and create a new object. In our case, I do not want the user to be able to create a new record.Is it possible to configure navigation actions to avoid new record creation ?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.