Solved

Client has a customer that has a 5% discount code on all orders. When a sales order is created the discount is applied and is under the discount details tab, which is automatically taken of the sales order amount However, in a situation where the customer is returning stock and a return for credit sales order is created the RC sales order does not include the discount amount in the credit, so the original sales order amount is displayed in the RC sales order: Is there a way for the discount to pull through on a credit memo or RC sales order if discount has been applied with a discount code and not on the line item itself?

Hi All,I have created a custom processing screen and now I need to call the processing method using the process buttons. Can some one help me out?My Processing Classpublic class HMRCVerificationProcess : PXGraph<HMRCVerificationProcess>    {        public PXCancel<HMRCVendorRegisterDetail> Cancel;        public SelectFrom<HMRCVendorRegisterDetail>.Where<HMRCVendorRegisterDetail.excludeverification.IsEqual<False>>.ProcessingView AllVerifiedVendors;        #region Overridden Properties        public override bool IsDirty => false;        #endregion        public HMRCVerificationProcess()        {            AllVerifiedVendors.SetProcessCaption("Run");            AllVerifiedVendors.SetProcessAllCaption("Run All");        }            }My Graph public class HMRCPeriodicVerifyMaint : PXGraph<HMRCPeriodicVerifyMaint>    {        public PXSave<HMRCVendorRegisterDetail> Save;        public PXCancel<HMRCVendorRegisterDetail> Cancel;        //Or

Currently in our Acumatica instance we have two screens that are in the hidden folder:1. Sales Price Worksheet2. Sales PricesThey are accessible through URL/Screen ID.However, we want to move them to the ‘Sales Order’ menu.Is this possible? Only resources I could find were on how to move something TO the hidden folder.Thanks!

Hi guys,Any ideas, maybe one of us has had a similar problem to mine.I want to obtain the PDF file that I have uploaded on the Invoices and Notes screen "AR301000" by consulting through postman, the acumatic version is 2019R21.- I was able to insert using postman, here is the result. The postman's query and response failed.I hope I have been clear, maybe my English is not correct.Could you tell me what I'm doing wrong, I would appreciate it, thank you very much.

We currently operate a cutting location where aluminum bars are cut into different pieces. As we plan to enable the Manufacturing Module in a couple of months, we are seeking advice on the best process to record these transactions in the interim.Should we utilize Inventory Adjustments and include scrap in the adjustments? We are looking for insights and best practices from the community.Thank you in advance for your advice!

I got this error log. I try to find column in my customization but i see only oneSystem.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'UsrAccountName' in table 'dbo.Address' is specified more than once. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32

Community,Question on adding an additional hyperlink on this report.  There is currently a hyperlink that takes a click action to the customer information.  I have a manager that would like to have it set up when they click the “Past Due” numbers to take them to the invoices that are open.  How would I set up an additional hyperlink on this report.  This is in the Report writer.   This is the report.  The highlighted in yellow are the columns they want to click on and open up into the invoice. Thank you in advance for pointers.Trisha

Hi All,We have created an import scenario for stock items—finished goods. But the style tag and the item class are not picking up correctly. The subaccount is taken as the style tag.Please see the below screen shots. Anyone know how to fix this?    Thank you!

Hi Team,I added two customized fields to Branch table and created new tab in the company form (CS101500).But those two fields are read only. Can someone please help me out to enable this field.My Screen public sealed class BranchExt : PXCacheExtension<PX.Objects.GL.Branch>    {        public static bool IsActive()        {            return true;        }        #region UsrComUTRNo        [PXDBString(20)]        [PXUIField(DisplayName = "Company UTR No")]        public  string UsrComUTRNo { get; set; }        public abstract class usrComUTRNo : PX.Data.BQL.BqlString.Field<usrComUTRNo> { }        #endregion        #region UsrComAORefNo        [PXDBString(20)]        [PXUIField(DisplayName = "Company AO Ref No")]        public  string UsrComAORefNo { get; set; }        public abstract class usrComAORefNo : PX.Data.BQL.BqlString.Field<usrComAORefNo> { }        #endregion    } ThanksBhagya

Some custom field already update to database already with last customize and I just add one custom field to other customize and publish. but it go to omit one or two in other table.  

I am unable to see dashboard widgets for a particular role, which seems to be locked. How can I resolve this issue? Are there any access rights that need to be given?  

Wondering if anyone else encountered the error “Data is absent” during the Sales Order Line upload function? 2022R2The client provided an excel workbook, and I added an upload tab as the first tab in the workbook for the upload data.If I copy that upload data to an empty new workbook, it will upload, so I know my data is clean.What settings on the excel workbook might be causing this error?  I have verified that the sheet and workbook is not protected. What else could it be?  Any idea would be appreciated.  We have not seen this error before. 

I’m working on UI tests using Acumatica’s Test SDK which wraps around selenium. There are a number of things that I would like to do which the Test SDK does not seem to provide functionality for. My question is, can I use vanilla Selenium alongside the Test SDK and if so how? Specifically I’m wondering how/if I could go about connecting to the same WebDriver(which to my understanding is how Selenium sends commands to the browser). When I try creating a new WebDriver and using that it ends up creating a new browser window which is not what I’m wanting. Other info Browser : ChromeOS : Windows 10Acumatica Version : 23r2 Here is the sample code I used to create a new WebDriver but like I said it opens in a new window not the window that is already open. var driver = new ChromeDriver("C:\\Projects\\TestSDK_23_105_0016_17\\Chrome"); 

I am trying to filter the results of a report based on the below filters However, it is calculated field in the table as shown below:  I am using the same formula on the filters tab like below:    However, on the report - it does not list the items that are aged between 45 and 90 days ONLY. Can you please advise what I am missing here? thank you@lauraj46, @Robert Sternberg - any ideas? thank you!

We have a report that has text box with nothing but information on where to call, or order items online. The text box reads: Questions? Call 123-456-7890 | (yes that is a pipe symbol included) Order Online at www.company.com. For some reason it is throwing an error. I have tried using single and double quotes in various places but still no joy. 

I need to know the endpoint to get the employee branch field.  This endpoint: {{testacuBaseUrl}}/Employee/C15315Just gives these fields:{    "id": "35029378-2110-ec11-89fc-000d3ac574da",    "rowNumber": 1,    "note": {        "value": ""    },    "EmployeeID": {        "value": "C15315"    },    "EmployeeName": {        "value": "Jason Olschewski"    },    "LastModifiedDateTime": {        "value": "2023-10-05T17:28:43.78-06:00"    },    "Status": {        "value": "Active"    },    "custom": {}}I’ve tried to expand the BAccount but it returns an error.I am currently using Build 21.212.0039

I need to create 2 user roles and assign permissions to it for:1. Sales Price Worksheet: AR2020102. Sales Prices: AR2020003. Customer Price Classes: AR208000One is a view-only role, the other will be insert/delete.When I go to Access Rights by Role, there is no option (+) to create a new role. And without a role I can’t add permissions (View/Insert) to a group.None of the existing roles with access will work, as this is for a new group (Sales team) to have access and the groups are financial roles mostly.Any help would be appreciated, thanks!  

We're looking at the "Sales not allowed" checkbox for inventory locations, and we've found that it blocks Sales Orders and production orders from pulling from that location. Is there a way to have it only block Sales Orders?

Can I get an email/notification of some kind when a new build is released ?(for example, https://community.acumatica.com/supported-releases-67/acumatica-2022-r1-update-7-build-22-107-0022-10166 ).Thanks!

I’m trying to build an import scenario to edit the promise date on the inventory line on a Purchase order. However, it’s not changing based on the import I built.  Attached is an XML of the import scenario.

Having a issue joining FSARTRAN in a GI with ARInvoice and ARTran - does not show as related table and can not add manually.  Yes - Field Service is enabledWhat am I doing wrong?  

Hi, I tried to modify our Check Report to show more line under remittance. But it stop at row 12. Try to add more variable but do not know what I missed because it still does not work.Can someone help me with it ?Thanks  

When use PXNonInstantiatedExtension. How to use it ?

Is there anyway to see the file size of Acumatica emails generated ?  do no see size on All Emails view

My customer would like to add the State field to the Vendor Selector form on the AP BIlls and Adjustments form.I have followed this article https://www.info-sourcing.com/how-to-add-fields-to-acumatica-selector-lookup-no-coding/  but it is not adding the column.Has anyone had any success adding a column to the vendor selector window?