Discussion Forums

I am currently working in Acumatica 2025 R1 and have encountered the following issues:Custom Screen – Field Alignment1) I have applied the TextAlign property at the field level on a custom screen; however, the alignment is not rendering correctly. The margin is not aligning properly from the right side as expected.Customizing FormView Layout2) Is there a way to display more than three columns in a FormView layout in the Modern UI(Example: Adding 4th column in Sales Order Header)Site Map Screen – Continuous Loading3) The Site Map screen is continuously loading for an extended period , making it inaccessible and preventing any updates or navigation.Customization Project – Files Tab Not Loading4) When accessing the Files tab within the Customization Projects screen, the section keeps spinning and never loads, preventing file review or uploads.Kindly advise on how to resolve these issues.Thank you in advance. Premalatha N

Does anyone else need to connect to Markettime to get Sales Orders into Acumatica? We are currently using Syncware to connect Markettime to Acumatica, but are not happy. Is there another option to get Sales Orders that outside, field reps write in Markettime into Acumatica? Looking forward to any suggestions or advice from the community!

At present, in order to generate expense claims from expense receipts, the claim option on the expense receipts form, automatically groups receipts by customer if the expense receipt is linked to a project/ service order or if a customer is selected. This results in an employee having different claims for each customer. I would like to get your thoughts on this topic. Your responses will greatly help our engineering team in building the right solution.Would you rather prefer if receipts were grouped by employee only irrespective of customer? Is there any other criteria by which you would like to group expense receipts automatically ? How often do you use the automatic claim option to group expense receipts ? If you are currently grouping receipts by customer, how does this benefit you? What don’t you like about the automatic grouping of expense receipts by customer?Thank you!

Hello Community,On the Employment Time Card screen, I want to filter the Project Task selector field to display only records with the status 'Active' or 'In Planning'.I attempted this by overriding the base class and customizing the attribute. Below is a snippet of what I tried, where I attempted to add a condition to the generic type query:public ProjectTaskCustomAttribute(Type projectID){ if (projectID == null) throw new ArgumentNullException("projectID"); projectIDField = projectID; Type SearchType = BqlCommand.Compose(typeof(Search<,>), typeof(PMTask.taskID), typeof(Where<,>), typeof(PMTask.projectID), typeof(Equal<>), typeof(Optional<>), projectID, typeof(And<,>), typeof(PMTask.status), typeof(Equal<>),typeof(Aberdeen.Messages.A

Cannot resolve the table name: [PX.Objects.Localizations.CA.TX.TaxRegistration] Getting this error on trying to print SOInvoices

Hi all,My objective is to connect my java client with the SignalR Hub.I added a push-notification with Destination Type SignalR Hub as it is described here: Push Notifications: To Connect to the SignalR Hub.I use the following code snippet to connect my client with the SignalR Hub:String login = "<my_user>"; String tenant = "<my_tenant>"; String password = "<my_password>"; String basicAuthPlain = login + "@" + tenant + ":" + password; String encodedBasicAuth = Base64.getEncoder().encodeToString(basicAuthPlain.getBytes()); HubConnection hubConnection = HubConnectionBuilder.create("https://<my_x360_domain>/PushNotificationsHub") .withHeader("Authorization", "Basic " + encodedBasicAuth) .build(); hubConnection.start().blockingAwait(30, TimeUnit.SECONDS);... However, after executing start().blockingAwait() I receive the http status 401. Do I miss something? Can anyone tell me how I can sucessfully connect/authenticate the client? Thanks in advance

I amended an existing GL and am trying to set it up in Acu. I saved to server with a new report name (GL633002), added it into the site map. Updated the site map URL.Here’s my problem - It won’t show up on Acu’s menu and when I try to nav to the report Screen ID, it boots me to the home page.I can save a different version within the existing GL report and it populates/runs properly. But I can’t get a new report to generate on our menu/within our software. Anyone know how to fix this? I watched the S150 Report Designer 2025 R1 training on Acu & Johann had the same issue but he skipped over the fix. 

This webinar will focus on some of the do’s and don’ts of publishing, creating actions and conditions, adding new fields, modifying workflows, combining customizations and business events, and understanding the makeup of a screen. Tips and tricks will be sprinkled throughout.Presented by David Gross @dgross About David: I have been an Acumatica business consultant and implementation specialist since 2018. My areas of expertise include Distribution, Manufacturing, Field Service, CRM, and Ecommerce to name a few. I can create complicated GI’s and Reports (ARM and regular) and I am able to guide my clients through complicated needs assessment and create the solutions required to satisfy those business needs. My interest in customizations was borne out of necessity and sustained by curiosity. The more I am able to do without contracting a developer the better, and I am happy to share what I have learned (through much trial and error) so others can feel less intimidated and more empowered.P

Hello!Does anyone know how to get the layout property 'FilterByAllFields' to appear in some screens while in the customization project editor? I want to enable that attribute on the Account field of the Details section in the Bills and Adjustments screen but it's not showing up there even when showing more items with the filter. Thanks

Link to GI Fields in Mobile Notification Message and to dropdown?

Hello all, we just installed a local sandbox. I imported a snapshot to cover the data side, and I downloaded all of our Live customization projects to then import into the sandbox. When publishing, one of the packages is throwing the error:Cannot create 'UsrCIsBarCodeOrSerial' column in table 'TSMIGOpportunityQuotePricing' because that table is not found in the database. Please update the customization to match the current data schema.I seem to remember in the past reading about updating a customization to a current schema but can find no information… any ideas? Thanks 

Hello, I am working on creating an Action to preview and send an email created from an email template. I have the email template created and now I want to add an action to a page to call the template and show a preview where the user can edit the email if necessary. However, I am not finding anything on this. Any help is appreciated.Thanks

it looks like some of my fields are missing. it suppose to have this but i see only thishow do I get it in the is table of InItemCost

Good day,Attached is what I thought would be a simple import for Funds Transfer data.  Any ideas where I have issue.  I am not sure if it my file or the scenario.Any suggestions.I appreciate your assistance.Evan

Hi Acumatica,I am trying to add a customer Attribute DEALERCODE to the customer statement; however, when I refresh all on the tables, I lose fields rather than gain the Attribute I am looking for.  It is the out of the box Customer Statement report, but I cannot get the Customer Attribute I am looking for to show up I was able to get it to pull in on the Invoice and Sales Order layouts, but not this Customer Statement. Any suggestions? Thanks,RJ

Using 2021 R2.  We have an order that was shipped in full in one shipment.  The order stays in Back Order status.  Why?

Hello everyone,I have a customer asking whether Matrix items can support the bill of materials (BOM) functionality. Where can I get some information about that ? Thanks

Hi everyone i need one help very important. There is one report which is called as" Sales profitability by Item class and Item(Detailed). In this report customer told me to add one column as Qty. I have added but it not working as a date time period For ex:- From -13/06/2023             To - 1/07/2024              Qty - 604,69.00             Net Sales - 674,69.00             It Should be Same as Net Sales I have tried by adding INItemSiteHistDay using table and added the relation "InventoryID - InventoryID" Plz help me how can i fix this and show proper data in the Qty field.

I try to clear error and reset new value in post code filed update but not clear and not set new value. if input right code it’s ok but I input wrong code, i will raise error message and after I reinput the right code again it’s not clear error and not set new value.protected virtual void _(Events.FieldUpdated<CRAddress.postalCode> e){    if (e.Row == null || e.NewValue == null) return;            e.Cache.RaiseExceptionHandling<CRAddressExt.usrDistrict>(e.Row, null, null);             if (postal.Length == 4)            {                string province = postal.Substring(0, 2);                string district = postal.Substring(0, 4);                e.Cache.SetValueExt<CRAddress.countryID>(e.Row, "KH");                e.Cache.SetValueExt<CRAddress.state>(e.Row, province);                e.Cache.RaiseExceptionHandling<CRAddressExt.usrDistrict>(e.Row, e.Row, null);                e.Cache.SetValueExt<CRAddressExt.usrDistrict>(e.Row, district);           

I am trying to create an AWOE screen from scratch and have extended the ScanHeader to include the fields I need.   simplified I have this (I have tried WMSScanHeader, QtyScanHeader, ScanHeader also) :  public sealed class TestingScanHeader : PXCacheExtension<ScanHeader> {#region HdrOrderType[PXDBString(2, IsKey = true, IsFixed = true, InputMask = "")][PXUIField(DisplayName = "Order Type")][PXSelector(    typeof(Search<AMOrderType.orderType>),    SubstituteKey = typeof(AMOrderType.orderType),    DescriptionField = typeof(AMOrderType.descr))][PXDefault("RO")]  // Set default value to "RO"public string HdrOrderType { get; set; }public abstract class hdrOrderType : PX.Data.BQL.BqlString.Field<hdrOrderType> { }#endregion#region HdrProdOrdID[PXDBString(19, IsKey = true, IsUnicode = true, InputMask = "")][PXUIField(DisplayName = "Prod Ord ID")][PXSelector(    typeof(Search<AMProdItem.prodOrdID,           Where<AMProdItem.statusID, In3<PX.Objects.AM.Attributes.Produc

Hello,I want to sort data displayed in PXSelector by LineNbrhere the Selector: PXSelector(typeof(Search<Choixfournisseur.inventoryCD, Where<Choixfournisseur.reqNbr, Equal<Current<Choixfournisseur.reqNbr>>>,OrderBy<Asc<Choixfournisseur.lineNbr>>>), new Type[] { typeof(Choixfournisseur.lineNbr), typeof(Choixfournisseur.orderQty),typeof(Choixfournisseur.itemDesc),typeof(Choixfournisseur.curyEstUnitCost),typeof(Choixfournisseur.curyEstExtCost),typeof(Choixfournisseur.inventory) },ValidateValue = false, Filterable = true)] But it dosn’t work Thanks for your feedback. 

When a Purchase order has been received and later returned. We need the system to block the bill of the PO Receipt.On the PO Receipts the history Tab will show the Returned items.Sample Scenario:Purchase 10 items.Receive all 10 items. Return 5 Items and create and release the Debit Adjustment to return the 5 items.On the  Purchase Receipt, when I enter AP Bill the Bill QTY is 10 and it does not consider the 5 Items that I have returned.How can I stop the Enter AP Bill for all 10 items 

Hi @all,our client creates non-stock kits as templates.When they add those templates to a Quote or Sales Order they want to change components and quantities there.Does anyone know, if this is possible? Or do you have any idea, how to solve this requirement?Kind regards Michael

E.g.So description is showing below; But when you switch to other tab then return back to the description, it disappears;  

I have created action with PXAction and it is showing on the screen but when I try to add this action in Acumatica Web Service Endpoint screen with respective endpoint screen it is not showing to add