Develop Customizations

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 ? 

hello, i need to make integration between two databases to send the items and the quantities from database to another database automatically which tables should i make the integration with ?thanks in advance

I have done the following steps: Created the SQL list Put the list in “Database Scripts” of the customization project. Create the DAC for the database table and move it to the extension library that I'm working on. I'm storing the values as follows: DACName store = new DACName             {                 column1 = value1,                 column2 = value2,                 column3 = value3             };             PxGraphName.Caches[typeof(DACName)].Insert(store);             PxGraphName.Persist();             PxGraphName.Caches[typeof(DACName)].Clear(); The issue is that, whenever I run the program, I look into the table and the value isn’t stored. I know information might be a bit vague but it’s to not overcomplicate things. I also haven't added anything the DAC of the table that stores the values, so if i need to add something let me know.

sorry

I have a customization that adds a field: UsrASGMarkup -- which calculates a user’s suggested price based on markup logic. This field is added to FSAppointment.This customization creates the field in the database.But if I unpublish that customization -- and try to go into an appointment, I get this error:  Even though the only customization that requires that field is not published. Why in the world am I getting this error? And is there anyway to avoid it ?  

I need to add multiple emails to some customer records. These addresses will be accessed via the API. They will be used to alert the users (CSR team) of events that occur outside of Acumatica.Is there a built-in way to add internal (our company) email addresses? Or, do I need to add a custom field?

Hi all, I tried to use SOLine.aMProdOrdID in my customization project as below.But it shows me following error.The Type amProdOrdID does not exist in the type ‘SOLine’ But when I see SOLine table in Database, amProdOrdID column is there.How can I fix this issue? Thanks.

Hi Experts,I am working on a couple of things to include all Business Accounts in the selection on Projects (PM301000) screen. As of now only customers are displayed under selector of Business Accounts.I have tried the standard code as below.[PXDBInt][PXDimensionSelector("BIZACCT", typeof(BAccount.bAccountID), substituteKey: typeof(BAccount.acctCD), DescriptionField = typeof(BAccount.acctName))][PXUIField(DisplayName = "Business Account", Visibility = PXUIVisibility.SelectorVisible)]I have tried below workaround to achieve the same but unable to get the desired outcome on the Projects screen. #region Usrbaccount [PXDBInt] [PXUIField(DisplayName = "Business Account")] [PXSelector(typeof(Search<BAccount.acctCD, Where<BAccount.type, Equal<ContractExt.HardCodeValues.VE>, Or<BAccount.type, Equal<ContractExt.HardCodeValues.CP>, Or<BAccount.type, Equal<ContractExt.HardCodeValues.CU>, Or<BAccount.type, Equal<ContractExt.HardC

I’m not sure if this is the right forum for this.We are looking for a Power App developer who can help us with an existing application that integrates to Accumatica. The work involves debugging and modifying the App. The work does not have to be on site but preference will be given to someone in the Central New Jersey area (near Perth Amboy).Thanks,Shmarya Richler  

Hello Everyone,On requisition screen I moved the approval workflow to appear only when bidding is completed.i.e.  However I noticed that when the status is pending Bidding.The approval workflow is still there i.e. from my workflow I have specified that on removing hold condition is that bidding must be completed. Kindly assist on getting rid of this approval workflow from pending Bedding.thank you allAny kind of response will be highly appreciated.