Solved

Hello. Having an odd one with AutoNumbering. Below is the Numbering Sequence, the New Number Symbol is <NEW> like others.  The custom screen is below. When I click add, the Car ID is set to ‘NEW’ not ‘<NEW>’.There are also 2 spaces before the value NEW.If I enter car details and click save, the auto numbering works.  The DAC is below[Serializable][PXCacheName("PinnCar")]public class PinnCar : IBqlTable{ #region Carid [PXDBString(15, IsKey = true)] [PXUIField(DisplayName = "Car ID", Visibility = PXUIVisibility.SelectorVisible)] [PXSelector(typeof(PinnCar.carid), typeof(PinnCar.carid), typeof(PinnCar.make), typeof(PinnCar.model))] [PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)] [AutoNumber(typeof(INSetupExt.usrCarNumberingSequence), typeof(PinnCar.createdDateTime))] public virtual string Carid { get; set; } public abstract class carid : PX.Data.BQL.BqlString.Field<carid> { } #endregion //make, model and reg field //Acumatica fields.}The graph code is very s

Hi everyone, it's me again and I want to know if anyone had this problem before.The following  situation is … I need to change background color in a field using a validation method in my graph extension but I don't know how to do it. In the past you could change the color of a button using JavaScript, but it would be helpful to know if it's possible using VS.Any help will be of great help.Thank you for reading. 😎

Hello-I’ve created a custom screen where auto numbering is used. When I access the screen I get the following message.  The DAC for the AutoNumber field is below.[Serializable][PXCacheName("PinnATWDW1")]public class PinnATWDW1 : IBqlTable{ #region RefNbr [PXDBString(15, IsKey = true)] [PXUIField(DisplayName = "Ref Nbr")] [PXSelector(typeof(PinnATWDW1.refNbr), typeof(PinnATWDW1.refNbr), typeof(PinnATWDW1.hMRCWarehouse), typeof(PinnATWDW1.period))] [PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)] [AutoNumber(typeof(PinnATWDSetup.w1NumberingSequence), typeof(PinnATWDW1.createdDateTime))] public virtual string RefNbr { get; set; } public abstract class refNbr : PX.Data.BQL.BqlString.Field<refNbr> { } #endregion ...other fields...It has a child table, the DAC for the key fields are below. [Serializable][PXCacheName("PinnATWDW1Line")]public class PinnATWDW1Line : IBqlTable{ #region RefNbr [PXDBString(15, IsKey = true)] [PXUIField(DisplayName = "Ref Nbr")] [PXDBDefault(ty

I have a report created in Report Designer (an .rpx file) within Acumatica 2023 R1.I would like to ask:Is it possible to export an .rpx report directly to a CSV Excel file?is CSV export is supported,

When we click CONFIRM SHIPMENT, we get the following error:Carrier Service returned error. USPS:The request could not be understood by the server due to malformed syntax. ProviderEndShipper address.name or address.company requiredCan anyone tell me what needs to be entered in Acumatica to avoid this error and allow confirming the shipment?Thanks,David

Hi all,Is it possible to create a BOM for a non-stock item? As my team described it to me, they want to do this as it’s not an “item” per se but more of a “service” with no on-hand inventory levels. Is this possible? Any docs/tutorials on this if it is possible?

Acumatica allows expired materials to be used in production despite the fact that an expiration date is set. No warning to user or hard stop.Does anyone have a workaround for this other than a custom inquiry that allows to find expired material and remove it from the shelves?We are in a regulated industry (medical device) and current feedback from Quality is that the workaround is not sufficient and an active warning, if not a stop, from the system is the minimum that has to be implemented.

StateColumn property of PXToolBarButton, it disable the custom action button on grid header based on assign field value true/false, in Modern UI is there any substitute code or solution 

A previous discussion identified the Cash Account Balance on the Reconciliation Statement Report as the “Cash Account Balance on bank Statement date”.  I would expect that to tie to the ending balance per the Trial Balance, but it does not.  Do I have an error somewhere, or just a misunderstanding?Thanks 

Hi, I've joined the APInvoice table with the APTran table to display the line-level tax amounts in the Project Transaction Register report.However, I’m encountering duplicate records, and I’m unsure which join might be missing or if there’s an additional table that needs to be included to eliminate the duplicates.I’ve attached project transaction register report for your referenceIf anyone has any insights, I would appreciate your help.   

Hi Community,Is there any way to get a side panel on this Inventory Allocations screen via Customization projects? It does not seem to have the option under the Action Types. Thanks,RJ

Hello, I’m looking for a way to make matrix items with only one variable. I have a product that comes in 4 colours, but doesn’t have any other variables. Is this doable? 

I am trying to create a Sales Invoice with a Payment but i get the following error: "An error occurred during processing of the field CuryAdjdAmt: Nullable object must have a value.."I am using the /Default/23.200.001/SalesInvoice endpoint and this is my request:What am I missing or do i need to create first the Sales Invoice, then the Payment and then apply it? {     "ReferenceNbr": {         "value": "<NEW>"     },    "CustomerID": {        "value": "ABAKERY"    },     "ExternalRef": {        "value": "801PM00000DhqGnYAJ"    },       "Type": {        "value": "Invoice"    },    "IsSpecialOrder": {        "value": false    },    "Date": {        "value": "2024-04-22"    },       "ShipToAddressLine1": {        "value": "Test"    },    "ShipToOverrideAddress": {        "value": true    },    "ShipToOverrideContact": {        "value": true    },    "ShipToCity": {        "value": "Test"    },    "ShipToCountry": {        "value": "US"    },    "ShipToPostalCode": {        "value":

Hi Community I have never seen this before, but what would cause the Owner field to show in every other tab except for the Conditions tab?  I need this APQuickCheck.OwnerID as a Condition, but it does not show up. I can see it in the Parameters, Results Grid, and everywhere else.   Thanks,RJ  

I'm experiencing an issue when updating a custom field (usrDebitAccount) on the Transfers screen (IN304000) within the Transfer Details grid, specifically in a Released document. In the INTran_RowSelected event, I’ve enabled the custom field usrDebitAccount  when the row is released, like this. I have also enabled the field from workflow as well.protected void INTran_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler){ InvokeBaseHandler?.Invoke(cache, e); var row = (INTran)e.Row; if (row == null) { return; } if (row.Released == true) { Base.transfer.Cache.AllowUpdate = true; Base.transactions.Cache.AllowUpdate = true; PXUIFieldAttribute.SetEnabled<INTranExt.usrDebitAccount>(cache, row, true); }}The issue is: When I change the value of usrDebitAccount on a single row and try to save, the Save button appears enabled but it shows the below error message         If I click ok button of above pop up

Hello all,I’m trying to find a way to import multiple corporate cards at once. My company has a lot of employees and each of them have a card that needs to be in the system. I see where you can enter each individual card, but I can’t find a way to mass-import all of these. Any help on this would be appreciated.Thank you.

Hello Everyone, I have an import scenario and business event that create a new project from an SO Quote. There is an attribute on the project to bring in the quote number. After the project is created I have another import and business event that is supposed to insert the projectID and taskIDs back into the quote. I keep getting an error that says the ‘project task’ cannot be empty. Here is my most recent import mapping: As additional info, I made the taskID = the LineNbr on the quote of the original import that creates the project. Anyone have an idea on why this one is erroring out? Thanks

We’re running 2023R2 and I’m trying to update the UnitPrice to equal the UnitCost when entering items in a “No Charge” Sales Order.  Using the following code:namespace PX.Objects.SO{  public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry>  {     // Update prices when order quantities updated    protected void _(Events.FieldUpdated<SOLine.orderQty> e)  {    var order = Base.Document.Current;    var line = e.Row;    if (order?.CustomerOrderNbr?.Contains("SE") == true && line != null)    {        // Use SetValueExt to ensure all business logic and UI updates occur        e.Cache.SetValueExt<SOLine.curyUnitPrice>(line, line.CuryUnitCost);    }  }    // Update prices when CustomerOrdNbr changes    protected void _(Events.FieldUpdated<SOOrder.customerOrderNbr> e)    {        if (e.NewValue?.ToString().Contains("SE") == true)        {            foreach (SOLine line in Base.Transactions.Select())            {           if (line.CuryU

Hello Community, We are having an issue when attempting to confirm a shipment and receiving the following message:On the shipment, we are not trying to delete any items, simply clicking the “Confirm Shipment” button and receiving that error. The quantity lines are as follows:These are serialized items, and all have a serial selected so no unassigned quantities. No duplicate shipments were sitting out there, and the lines are all allocated correctly. The order itself shows the lines as open for shipment and every line is marked “back order allowed”. Has anyone seen this error before? 

We are currently exploring options to streamline the process of converting business accounts (BAs) to customers in Acumatica, ensuring efficiency and maintaining control over the conversions. Our client relations team receives calls from customers who wish to place orders over the phone and pay with a credit card. In order to proceed, the client relations team adds these customers as new Business Accounts (BAs). The BAs are then converted to customers to conduct business, but only our accounts receivable team has the ability to convert BAs.Is there a way to create an exception in Acumatica where our customer service team can ONLY convert BAs to a specific customer class, such as "Credit Card Customer," which automatically assigns them credit card terms? This would enable our customer service team to securely utilize Acumatica payments for credit card purchases. We are seeking advice on how to implement this exception effectively to ensure our customer service team can manage credit car

Is it possible to merge lots of inventory within Acumatica?

I'm trying to create a Generic Inquiry that identifies sales orders where a required TaxID is missing, based on the Customer Tax Zone. Here’s what I want: If the TaxZoneID is STNRETAILR, the order should have both TNOTP66SALES and TNSTEX If the TaxZoneID is MSRETAILR, the order should have both MSOTPEXS and MSSTEX If either is missing, I want to show that order in the results so it can be corrected Below condition is working fine . But When i tick all together it shows 0 Records Means condition is not working when i active all. 

Within the Payables section I’d like to be able to produce a report that shows only the Vendor Name and Payment Method.  Is this at all possible?I do not want to see anything else. Such as addresses or GL codes.  

I’m hoping I’m simply missing something obvious.I looking for a report that I can define a date range, a warehouse, and a specific part and get a total amount that has been consumed for that part, through BOTH sales and production. The Turnover report doesn’t seem to take into account production usage.Before i go making a custom GI/Report based on the Inventory Transaction History screen to get a simple summary of issues and invoices, is there a stock report that my smooth smooth brain just isn’t noticing?

Hi Acumatica Community,I do have a concern. I was trying to create a dashboard for my Acumatica cases, and I want to get the total time of the initial response.Upon checking, the Initial responses are not populating any time, unlike the resolution time it has hours and minutes. My question here is, how do the initial responses work in Acumatica Cases 23r2?