Solved

Hello,           Is there a way to get the conversion factor (shows 60 in below) by code.Actually, need the case to lb conversion factor exactly.                

Hi all. I am trying to update stock items with a default supplier, minimum order qty and attributes. However, I keep getting an error Field: Supplier ID, Value:           , Error: 'Supplier ID' cannot be found in the system.Please see below mapping and let me know what I am missing: 

Just to preface, I am self-teaching on Import Scenarios for the most part, and I don’t have a lot of experience with them yet. This is around the third Import Scenario I have built from scratch, and it has one complicated part I am really having trouble getting right. Now on to the problem:I have some Stock Items that I want to make default a certain vendor. The vendor is already on the Stock Items, I just want to use Import Scenarios to check the default box for that specific vendor. There are multiple vendors on these items, so I need the Import Scenario to choose the line that vendor is already on and check that lines box for the default. I have set it up a ton of different ways, and I can get it to check the box, but it always checks the box on the first vendor in the list. Alternatively, the way I have it set up at the moment is giving an error about adding a duplicate line. Screen shots below. If any other info would help just let me know. Stock Item Vendor List: I have cut the e

Hi everyone,There is a requirement to override the "Create Child Orders" action in the Blanket Order screen (SO301000), which is handled by the SOOrderEntry graph.I tried to do this through the Customization Project Editor, but when I click "Override Method", the "Select Methods to Override" panel pops up, and CreateChildOrders is not listed among the available methods to override.I also used the Inspect Element tool in the UI, and it confirms that the button is linked to the action named CreateChildOrders.Any guidance or recommendations would be greatly appreciated! 

I have a customer that would like the estimated margin amount on the sales order to show a value even if the unit cost is zero, i.e. 100%. I have located the formula in the SO/GraphExtensions/SOOrderEntryExt/Margin.cs code file. That code appears to be an override of the existing DAC attributes of the field.  Is it possible to override this from a customization project or is there another approach that should be used?Code from Margin.cs:        [PXMergeAttributes]        [PXFormula(typeof(Switch<            Case<                Where<                    SOLine.curyExtCost.IsEqual<decimal0>                    .Or<SOLine.behavior.IsEqual<SOBehavior.tR>>                    .Or<SOLine.pOCreate.IsEqual<True>.And<SOLine.pOSource.IsIn<INReplenishmentSource.dropShipToOrder, INReplenishmentSource.blanketDropShipToOrder>>>>,                Null,            Case<                Where<                    SOLine.curyExtPrice.IsEqual<dec

I would like to manually assign a Production Order ID to a specific line item on a sales order.  Can I do this via the API?  If so, how?  The SalesOrder endpoint does not seem to have these fields available.Thanks!

Is there a trick to getting entry types to show up on the Receivable Payments screen, Charges tab? We are considering using that to record wire fees.On the Entry Types screen, I checked the Deduct from Payment box, but the entry type does not show as an option on the Payments screen. Is there another step I should take? We are on 2022 R1. Thank you.  

Hi,We are currently able to change the default Acumatica logo by setting it in the Branches screen on the Visual Appearance tab, but when the left side menu is collapsed, the small Acumatica “a” logo is displayed.Is it possible to set another custom image as the logo when this menu is collapsed?Thanks in advance

Hi, i want to restore one of my snapshot but  while i try to restore there is an error said “Violation of PRIMARY KEY constraint 'CloudTenant_PK'. Cannot insert duplicate key in object 'dbo.CloudTenant'. The duplicate key value is (2).”Can someone help me to solve about this?

Is there a way to warn or halt the creation of a production order when the item being created has a BOM that is on any status that is not Active?

Hi there,I’m looking to set permissions that separate the AR and AP teams’ access to vendors.  The AR team needs to be able to extend customers as vendors in order to process refunds.  They should not, however, be able to create other/regular vendors.  Currently, they’re able to extend the customer as a vendor, but they cannot save the “new” vendor because they don’t have that permission.  Is there a combination of permissions that would allow this? 

Hello everyone,I would like to upload the new leads directly from Excel into the marketing campaign so that the system can create the leads immediately.Does anyone have a suitable Excel template that I can use?I have exported the columns, but the system says that it cannot create the data record with this information alone.Thank you very much!

Please include the ability to revalue fixed assets - its a requirement from IFRS 

Hi, i want to ask, can we delete the budget that already released?I already created a reverse but can we deleted the trace of the budgets, so it will clear the list.Please help me to solve about this 😔Thank you

Hi All I am working on a report in report designer and need to pull the below line only into the report for the field I am setting up. Since there are many values in the Cross Reference section, does anyone have a suggestion on how to write it so only the one line pulls and nothing more?   

I have a problem when upgrade acumatica to 2025R2, my clissic ui input and save show error cann empty. But when I switch to moder ui cannot input and save normally. 

Hi. I have Prepayment on AR302000 screen. On Application of the Prepayment to a Normal AR Invoice, i need change debit account id. How I can do this? 

 I have created a new custom field in SOOrder, I want to retrieve SalesPerson.descr from SalesPerson table but not showing value. I want SalesPerson Description insert it into the SOOrder table.[PXDefault(typeof(Search<SalesPerson.descr, Where<SalesPerson.salesPersonID, Equal<Current<SOOrder.salesPersonID>>>>), PersistingCheck = PXPersistingCheck.Nothing)][PXDBString(60)][PXUIField(DisplayName="SalesPerson Description")] 

How do I give a user access to ONLY the Cross-Reference segment of the Stock Item screen?I can give them rights to images and packaging just fine. Those live under:Inventory → Stock Items → InventoryItemI have DELETE rights to Inventory → Stock Items → Cross-ReferenceBut I still can’t access that grid. I’m obviously missing something here. Any help is greatly appreciated.

I have a field that was added to our customer locations to define their standard trip: I am trying to display that field on a dashboard.  In the GI it shows correctlyBut when I display in the Dash Board all i get is 100.  I know the description says minutes but that is not how they set it up to be entered.  Thoughts on how i get this to display correctly in the Dashboard, even when it is already correct in the GI.   Thanks for your help!  23R2

Hello,I built a simple GI that has two parameters - a date from and date to. These parameters are required and used as part of the Condition to load data.Everything works as expected for the GI. I supply the parameters and the appropriate data records are returned. However, this becomes a problem when I try to create a Pivot table from it. Specifically, no data loads and there seems to be no way to supply the parameters specified as required in the GI. I cannot use Pivot Table Filters either, since, presumably this requires some data to actually filter on.To get the Pivot Table to function, I realize I could remove the condition from my GI and then rely on Pivot Filters. However,  this is not ideal for my use case since I would like to keep the GI parameters and conditions as is.How might I accomplish this?Thanks.

Hi everyone,I’m creating a custom report in Report Designer where my main data source is INTran.The goal is to display item-related details from InventoryItem such as InventoryCD and PICKSEQ_Attributes.When previewing the data, the InventoryID field in INTran looks like a string for example, it shows values like 3033-70 but technically, it’s stored as an integer foreign key (int) that points to InventoryItem.InventoryID.This led me to think I could join using InventoryItem.InventoryCD, which is a string (nvarchar) field containing user-facing item codes like “3033-70”.However, when I try a relation like:<RelationRow> <ChildField>InventoryCD</ChildField> <ParentField>InventoryID</ParentField> </RelationRow> or even attempt a conversion with:<CalculatedField Name="INTranInventoryCD" DataType="String"> <Value>=CStr([INTran.InventoryID])</Value> </CalculatedField> I get errors such as:“The report cannot be opened because it includ

Hi everyone,I'm building a custom API screen in Acumatica with a virtual DAC (PXVirtual) to trigger an authorization process. My screen has:public PXFilter<VXAuthorizeExistingRequest> MasterView;public PXSelectReadonly<VXAuthorizeResponse> DetailsView;public PXAction<VXAuthorizeExistingRequest> RunAuthorize; The RunAuthorize action calls a helper class to execute some logic, then inserts a result record into DetailsView (a virtual table VXAuthorizeResponse), like this:DetailsView.Cache.Clear();DetailsView.Cache.Insert(new VXAuthorizeResponse{    Success = res.Success,    Message = res.Message,    PaymentDocType = res.PaymentDocType,    PaymentRefNbr = res.PaymentRefNbr,    LastTranType = res.LastTranType,    LastTranStatus = res.LastTranStatus,    ProcessorTranNumber = res.ProcessorTranNumber});DetailsView.Cache.IsDirty = false;MasterView.Cache.IsDirty = false;When I call the API endpoint like this:POST /entity/AuthorizeAPI/22.200.002/vxcreateauthorizeapi/runAuthorize

One of our clients is in the process of automating their ACH batches to auto-sync to the bank’s SFTP site.I have the file sync settings saved in the data provider, but it isn’t being added as new ACH batches are generated. Is there an automated way to do this without customization and/or a business event/import scenario?I’ve attached both the export scenario and data provider for reference. Thank you in advance!

Is the Sales Territory Management feature still an experimental feature or is it a permanent one?We currently use version 24R2 and are going to be upgrading in the next few months. We were going to enable the feature now but want to make sure it’s going to continue to be a feature in newer versions of Acumatica before introducing it into all necessary employees.