Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
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.
Hello everyone! I have a question, I recently had to update my custom code, but I saw that the PXLongOperation.SetCurrentItem method was removed in Acuamtica 2023 R1. Does anyone know what I'll have to do or if the method has another implementation?Any help would be appreciated :) Thank you so much for your attention!
Hello All,I am adding a restrictor to ProjectID as follows:[PXRestrictor( typeof(Where<PMProject.defaultBranchID.IsInSubselect<SelectFrom<PX.SM.UserPreferences> .Where<PX.SM.UserPreferences.userID.IsEqual<AccessInfo.userID.FromCurrent>> .SearchFor<PX.SM.UserPreferences.defBranchID>>>), "Invalid Project")]The Selector works fine and shows the desired list but when I select a project from the list which is valid, the field does not hold the value and it clears it out. I checked the SQL query for the Selector and it is fine as well and returns the desired ResultSet. Any idea what is happening on the interface?
Hi guys!,I have a question. I am using the check and payment module, at launch I make GL insert a new line in addition to the existing one, and I have customized the GL screen and within it. I am using the public void Persist(PersistDelegate baseMethod) method and adding code to insert a new line in the GL details.However, when I put the interrupt point I see that it enters many times.Could you please tell me which event or method should I use and which is efficient?. public delegate void PersistDelegate(); [PXOverride] public void Persist(PersistDelegate baseMethod) { Batch batch = Base.BatchModule.Current; GLTran gL = Base.GLTranModuleBatNbr.Current; CurrencyInfo curren = Base.currencyinfo.Current; string TBienServ = string.Empty; decimal? detra = 0m; decimal? changetype = 0; if (batch != null && batch.AutoReverseCopy == false && batch.OrigBatchNbr == null) {
Hi, I have spent a few hours trying to work out how to programmatically add lines to Bills and adjustments and get the totals and taxes to correctly calculate on the header. The below shows a bill where the single line for $150 has been added programmatically. Note that the totals in the header are all Zero. The below is what a manually keyed bill looks like with the same record (ie the answer I’m trying to get to)A few comments on the first screen shot where the line has been programmatically added:The totals in the header appear to be incrementally calculating. For example if I change the price on the line from $150 to $160, the total shows the net difference from the original line addedThere is no Tax detailIf I manually add a record here the taxes appear in the header correctly calculated (but the Detail Total and Balance is still incorrect)I have tried programmatically adding record into APTaxTran before and after APTran but thus far have been unable to get the Bill to funct
I need to show an error message when unit price is 0 in sales order line details.User can upload the sales order line details from excel into sales order screen and according to the inventory item unit price is automatically capture from arsales form.I add fieldverifing event below like that.protected void SOLine_CuryUnitPrice_FieldVerifying(PXCache cache, PXFieldVerifyingEventArgs e, PXFieldVerifying baseMethod) { SOLine row = e.Row as SOLine; if (row.CuryUnitPrice == 0) { throw new PXSetPropertyException("Unit Price should not be 0"); } }After uploading so line from excel ,If condition is true or false error message is shown.
Hi,I have a third party rest api to get bank details. When calling the API it response is json format.I need to add response details into my sales order screen.In SOOrderEntry Graph extension I have created a action and calling the API below like that.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; var httpResponse = (HttpWebResponse)httpRequest.GetResponse(); SOOrder order = Base.Document.Current; order.OrderDesc = httpResponse.StatusCode.ToString(); return adapter.Get(); }When
On my processing page, I have a filter to select based on an inventory item.It is working and selecting rows for my grid using this BQL public PXFilteredProcessingJoin<SOLine, RecordsToProcessFilter, InnerJoin<SOOrder, On<SOOrder.orderNbr, Equal<SOLine.orderNbr>>>, Where<SOLine.inventoryID, Equal<RecordsToProcessFilter.inventoryID.FromCurrent>, And<SOLine.completed, Equal<False>, And<SOLine.openQty, Greater<decimal0>, And<SOOrder.status, Equal<SOOrderStatus.open>>>>>> SOLinesToUpdate;I want to add OrderBy so that the lines are displayed in order by Sales Order Nbr, Line Nbr.This is the BQL I cannot get to compile public PXFilteredProcessingJoinOrderBy<SOLine, RecordsToProcessFilter, InnerJoin<SOOrder, On<SOOrder.orderNbr, Equal<SOLine.orderNbr>>>, Where<SOLine.inventoryID, Equal<RecordsToProcessFilter.inventoryID.FromCurrent>, And<SOLine.completed, Equal<False&g
Hi,I need to add new field name as ‘Claim Percentage’ into sales order invoice screen. And when the claim Percentage is entered Invoice Amount need to be calculated like below formula.amount = unit price * qty * (claim Percentage/100)I have add fieldUpdated event into SOInvoiceEntry screen. protected void ARTran_UsrClaimPercentage_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (ARTran)e.Row; ARTranExt detail = PXCache<ARTran>.GetExtension<ARTranExt>(row); decimal? val1 =detail.UsrClaimPercentage/100; decimal? val = row.CuryTranAmt*val1; row.CuryTranAmt = val; // cache.SetValueExt<ARTran.curyTranAmt>(row, val); }When adding the claim Percentage at 1st time formula is working properly.But, after that when changing the same field Amount calculation is wrong.1st change 2nd change for same row same field.Amount need to 25 Why This is happened?
Hi all, I want to show detail lines horizontally in a report. How can I do it.
This comes up from time to time. Acumatica will throw an error (popping up an error box). It is usually on the "MoveNext" command, but it sometimes happens in other events. But when I attach VS2022 to the IIS app, it never throws an error inside of my debugger, so I can't see where the problem is.This is the latest example of this...First this is the C# Extension code:public class OpportunityMaint_Extension : PXGraphExtension<OpportunityMaint>{ internal CurrentCostingInfo currentCostingInfo = null; public static bool IsActive() { return true; } protected virtual void _(Events.RowSelecting<CROpportunity> e, PXRowSelecting InvokeBaseHandler) { if (e.Row == null) return; var row = e.Row as CROpportunity; if (UseMarkupInsteadOfMargin == null || !UseMarkupInsteadOfMargin.HasValue) UseMarkupInsteadOfMargin = false; SetDisplayFor_MarkUpOrMargin("CROpportunity", UseMarkupInsteadOfMargin, e.Cache);
I am trying to add currency conversion from base to selected currency but cant seem to put the pieces together. I am able to save the base currency but the conversions is not working. What am I missing? The DACclass GTItems { #region CuryInfoID [PXDBLong] [CurrencyInfo] public virtual long? CuryInfoID { get; set; } public abstract class curyInfoID : PX.Data.BQL.BqlLong.Field<curyInfoID> { } #endregion #region ItemAmt [PXDBBaseCury] [PXDefault(TypeCode.Decimal, "0.0")] public virtual Decimal? ItemAmt { get; set; } public abstract class ItemAmt : PX.Data.BQL.BqlDecimal.Field<ItemAmt> { } #endregion #region CuryItemAmt [PXUIField(DisplayName = "Item Amount", Enabled = false, Visibility = PXUIVisibility.Visible)] [PXDBCurrency(typeof(curyInfoID), typeof(ItemAmt))] [PXDefault(TypeCode.Decimal, "0.0")] public virtual Decimal? CuryItemAmt { get; set; } pu
Hi all,I want to attach a report pdf to files section of an invoice. I tried the below code snippet. It works for a single invoice only. But when we process multiple invoices from Process Invoices screen, file is attaching only for first invoice. For other invoices, file is not attaching.Any idea about fixing this?public delegate IEnumerable ReleaseDelegate(PXAdapter adapter);[PXOverride]public IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod){ foreach(ARInvoice invoice in adapter.Get<ARInvoice>()) { //Report Paramenters Dictionary<String, String> parameters = new Dictionary<String, String>(); parameters["ARInvoice.DocType"] = invoice.DocType; parameters["ARInvoice.RefNbr"] = invoice.RefNbr; PXReportSettings settings = new PXReportSettings("AR641000"); //Report Processing PX.Reports.Controls.Report report = ReportLoader.CheckIfNull(nameof(ReportLoader)).LoadReport("AR641000", null); ReportL
Hi,I have a custom description field sitting in the Projects screen that is replacing the original Description field. This is because I needed the field to support a larger amount of characters for reports and I wasn’t able to achieve the correct result with the original description field sinc the reports would grab the original length the Description field rather than the new length. Back to the main issue, when invoices are generated, the Transaction Description is grabbing content from the original Description field, but I would like this to come from the new custom description field I created. I have tried something like the below to achieve this, but I can’t seem to get it working. I am trying to match an invoice line from the grid with the relevant project task in the Projects screen so that I can transfer the the content from the custom field to the invoice field. What would you recommend to achieve this? I should note that this customisation is be published against the Invoices
Hi,There is a requirement which is to remove quote type ‘sales quote’ and show only ‘project quote’ in the create new quote pop-up screen when clicked on create quote button of opportunities. Screenshot is attached for the reference.show only the ‘project quote’Could this be done using customization project editor?Thank you.
I have created a custom bool field on SOOrder. #region UsrFreightRecovered [PXDBBool] [PXUIField(DisplayName = "Freight Recovered")] [PXDefault(false, PersistingCheck = PXPersistingCheck.Nothing)] public bool? UsrFreightRecovered { get; set; } public abstract class usrFreightRecovered : PX.Data.BQL.BqlBool.Field<usrFreightRecovered> { } #endregionThis field indicates that freight charges are to be handled in a non-standard way. I need to present the fact that the custom field is true on the invoice header. From reading here, and attempting to code this, it seems that I have to pass the value to ARTran. The field needs to be immutable on the invoice, so I added it as a non-persisted string. I want to mark the value as true in the invoice header if any ARTran line has the value as true.I am at a loss at this point. I have no idea how to access the the Order Nbr field for each detail line in order to look up the custom field val
Hello Everyone!So I am getting this error in the Sales Order Entry Screen, S0301000 Now regarding the customization mentioned here, This is the Previous Version: and after deciding to do some refactoring I decided to move this DAC away from PurchaseOrders to a new customization HSCatQuota, with the following DAC:HSCatQuotaAlso I removed the dac and the associated graphs in PurchaseOrders, after the refactoring. Now I added the dependencies to the previous PurchaseOrders customization using the add from dependency, from the bin, I can build the solution but can’t create a new Sales Order. Is there something I might be missing, during these step?I even checked in my other customizations ,and nowhere is the PurchaseOrders namespace being used. Thanks,Jugraj
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.