Solved

Is there any way to change the way Acumatica handles numerical ordering? For some reason, the system will treat numbers by whatever the first numeral is instead of the entirety o the number itself. Please see the example I’ve provided of how the system handles the order of tasks. I would refer the system listed the numbers as such102030405060708090100110120130140150160 rather than it displaying as1010011012013014015016020304050608090   

How can I modify the list of Termination Reasons under Employees > Employment History ?

In Shipment Screen if user will enter Notes at the Header of the Screen and in the Details Tab of the Screen as well It should display the Notes of Header as well as Grid. Both Notes should display.How can we display in the report? 

I noticed my email was wrong (andy instead of andi) so I reset it in the Acumatica portal in my profile. I also changed it in the Partner University (“Learn” link and changed the email on the Profile there) however this latter action seems to have broken the link as when I now go to “Learn”, everything I had achieved has gone.  It is if I am visiting for the first time.I note that on the partner portal when I click on my profile, the dropdown still shows the old (incorrect) email as if that is some sort of unique user ID, even though my actual profile shows it as now being correct.Is it possible to reset my portal user ID to the andi email (and that may then establish the link to the University) or have all my achievements gone for good?

Hi everyone.  Is there a way to deduct the applied credit memos of an invoice on the “Net Sales” field of Sales Profitability by Customer and Order? Thank you. 

I need to map the phone number associated with the default address from Shopify to a specific field in the customer record in Acumatica, but I can’t seem to figure out how to specify the phone number associated with the default address, not the phone number associated with one of the other (non-default) addresses, in a formula in the Customer entity.Does anyone have a suggestion regarding how to accomplish this? 

I would like to gain access to the download Product Pre-Release version of Acumatica 2023 R2. There is a new feature in there that I would like to explore called Territories since our sales team operate in states based on territories.

I have some items on Shopify assigned to non-Acumatica locations (drop-ship), I want that when the item does show up as available in a Acumatica warehouse it should sync to Shopify. It doesn’t sync with the real-time sync or the manual processing. Only when I sync the item through the sync history screen. What do I need to do to get it synced in real time?

{ "Date": { "value": "2022-05-12T00:00:00+00:00" }, "PostPeriod": { "value": "062022" }, "Description": { "value": "2022-05-12T00:00:00+00:00" }, "Details": [ { "InventoryID": { "value": "SAM-GAL-NOT-5-32" }, "Warehouse": { "value": "IMMDFW" }, "ReasonCode":{ "value": "IN RECEIPT" }, "LineDetails": { "LotSerialAttributes": [ { "Attribute": { "value": "ASSETTAG" }, "Value": { "value": "Passed000ggg" }, "custom": {} } ], "LotSerialNbr"

I am trying to add contact info in leads API. With the following URL and body. But it is giving an error  "Last Name or Account Name (or both) should be filled in." Can anyone help me here please. http://localhost/MyInstance/entity/Default/22.200.001/LeadBODY:{ "ContactID" : {"value" : "Param"}, "Description" : {"value": "My Test Lead"}, "Source": {"value": "W"}, "CRM Info":[{ "Contact Preferences":{ "FirstName": {"value": "Param"}, "LastName": {"value": "Test"} } }]} 

Hello, I'm working on a query result that i-m adding conditions and joins in the view delegate and it's working, but I would like to append group by statements on the query, Is there a way to achieve this in the view delegate?

Hello everyone, I created a table with the following script.CREATE TABLE [dbo].[GDLFAVehicleDetails]( [CompanyId] [int] NOT NULL, [AssetId] [int] NOT NULL, [VehicleRegNo] [nvarchar](50) NOT NULL, /***other fields left out***/ CONSTRAINT [PK_GDLFAVehicleDetails] PRIMARY KEY CLUSTERED ( [CompanyId] ASC, [AssetId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_GDLFAVehicleDetails_1] UNIQUE NONCLUSTERED ( [VehicleRegNo] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOI needed to make VehicleRegNo to accept only unique valuesso I added Iskey= true on the DAC as shown below;However when I add the Iskey=true value the user input disappears, when I remove it user input does not disappear on the UI and user is able to save the input entered.What could be the issue?  #region VehicleRegNo

Hello fellows,I’m facing a problem with running Acumatica instances, the instances are created but when it comes to run them it keeps loading then interrupted, any Ideas?  

I have PO with a non-stock/expense item costs $850, linked to project. Process PO Receipt without changing unit cost, then create Bill at $1,000. The project however is only costed at $850 even though the Bill journal shows additional expense of $150 as a result of purchase price variance. The PPV allocation mode is Inventory Account. Is there anyway to post the additional expense to Project?

Hello - I am trying to produce a report that shows AP Bill transaction detail (have this already) that also shows if that bill has been reclassed and if so, which accounts they were reclassed to. I’ve tried linking several different tables but none of them seem to work. I thought I was close by linking the GLTranForReclassification but the NewAccountID does not seem to work, keep receiving the below error. Does anyone know of a way to achieve this?  

I would like to know if any of you who uses UDI format barcode could share how you configured or customized Acumatica to read the UDI barcode to reduce data entry while capturing transactions (shipping, transfers, even product label generation etc.).  The UDI device identifier that we have to use is not at all like our inventory ID.  I am thinking that we will need a field added to the heading screen of stock items and a look-up table behind the scene to do the conversion...

Hi All, We have a unique need where our customer doesn't want to fill out the import templates for barcodes as these 10-16 digit barcodes for thousands of items are quite unrealistic as they are moving from paper based. Is there any way in acumatica where items with the these barcodes can be scanned ad hoc in the system without having a cross reference to start with either via purchase order or stocktaking. I will wait for any suggestions if any please.

If I want to create Workgroups in Acumatica, which is the suitable screen to achieve this?

Hello Everyone,I have override the Convert To Order action in the Sales Quotes screen, and copying the line field value from the Sales Quote to Sales Order line with the below code.Value are getting copied properly but caches are not updating as expected, when try to edit any other value and try to save it is giving me an error. Here is the code, can anyone review and share your thoughts.  [PXOverride] public IEnumerable createSalesOrder(PXAdapter adapter, Func<PXAdapter, IEnumerable> baseMethod) { SOOrderEntry SOGraph = PXGraph.CreateInstance<SOOrderEntry>(); PXGraph.InstanceCreated.AddHandler(delegate (SOOrderEntry graph) { graph.RowUpdated.AddHandler<SOLine>(delegate (PXCache sender, PXRowUpdatedEventArgs e) { SOLine objSOLine = e.Row as SOLine; if (objSOLine != null) { foreach (CROpportunityPr

Hello All,I have done action override a hundred times but I am facing an issue in Close Action of ServiceOrder that I am not sure why is happening. The problem is the "baseMethod" has a null value and as a result, I get an error that "An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details." Without this piece of customization, it is working just fine. Please note I have other stuff so that I am calling Base1 and Base2 in addition to the Base in my graph extension. Here is the part of the code relevant to the issue. Any help is appreciated.using System.Collections;using System.Collections.Generic;using System.Linq;using PX.Common;using PX.Data;using PX.Objects.FS;namespace Test{ public class MyServiceOrderEntryExt : PXGraphExtension<ServiceOrderEntryWorkflow, ServiceOrderEntryVisibilityRestriction, ServiceOrderEntry> { public static bool IsActive() => true; [PXOverride] public delegate IEnumerable Clo

Hello,I’m attempting to update pricing on existing stock items only. We have discrepancies in our Inventory IDs and instead of creating a bunch of duplicates the company only wants to update the stock items where a match is found. Is this possible using import scenarios? I’m having trouble finding documentation that supports this. Edit: Furthermore, I would love to be able to identify the records which are not found to be corrected. So maybe that is an alternative avenue. Thank you in advance

I added a custom action to the Details grid of the Sales Quotes screen.  It works as expected.If the setup for my module is disabled, I am able to disable the button, but I cannot seem to hide it from view.These are the ASPX changes to add the button.  (added to the top of the form: <px:PXDSCallbackCommand Name="ResetPrice" Visible="false" CommitChanges="true" DependOnGrid="ProductsGrid" /></CallbackCommands> Toolbar button added in the grid seciton: <px:PXToolBarButton Text="Reset Price" Visible="False">    <AutoCallBack Target="ds" Command="ResetPrice">      <Behavior CommitChanges="True" /></AutoCallBack> In the RowSelected, I check if my module is enabled.  If it is not, I try to set the Visibility to false.            if (setup == null || (setup.EnablePricingMarkup == null || setup.EnablePricingMarkup == false) || (setup.UseQuotesOpportunities == null || setup.UseQuotesOpportunities == false))            {                PXUIFieldAttribute.SetVi

HelloI want to override Subaccount field of GLTran when it is generated by Release an payment (APPayment) by the rule: take first 2 parts of existing SubCD then concat with a “ABCD”.For example: if the Subaccount is 000-00000-0000, it should be replace by Subaccount 000-00000-ABCD.And I found that there is a case that I can’t find by calculated SubCD, so I need to create new Sub by calculated SubCD (000-00000-ABCD) then set GLTran.SubID to the created one.How to create new Sub in event RowInserting of GLTran? Is it possible?  p/s: I don’t want to use RowPersisting event because I wonder they could impact the performance when generating a bulk of GLTran but I’m not sure.Thanks

 I had to add new field into SO303000 screen Detail Grid.Field name - Claim Percentage When the above filed is updated or entered amount need to be calculated like below formula. Amount = Amount*(Claim Percentage/100)When add the claim percentage without discount amount, It's calculations are okey. In my case,After I have add the  quantity,unit price and discount amount , the Amount shows below like that. Then,I added the claim percentage. When I add the claim percentage, Discount Amount,Discount percentage and Amount all the fields are changed.Why this is happened and how I resolve this? Below I have attached my claim p field updated event. protected void ARTran_UsrClaimPercentage_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e)    {            var row = (ARTran)e.Row;      ARTranExt detail = PXCache<ARTran>.GetExtension<ARTranExt>(row);      if(detail.UsrClaimP == null || detail.UsrClaimP == 0){        decimal? val1 =detail.UsrClaimPercentage/100;        decimal? va

I have a custom field that is throwing the following error:Error: An error occurred during processing of the field PD Inches/SQIN: Specified cast is not valid..I have the following  #region UsrPDinches [PXDBInt] [PXUIField(DisplayName="PD Inches/SQIN")] public int? UsrPDinches { get; set; } public abstract class usrPDinches : PX.Data.BQL.BqlInt.Field<usrPDinches> { } #endregionWhat could be causing this issue?Another questtion,This field is on a production order. I can’t find how to disable the field when the production order status is completed. How do I do that?