Solved

I am developing a form that presents a summary of the invoices of a seller, in the header the filter variables are selected and in the grid for each line is presented an accumulated by month and seller of the invoices collected, the customer requires to see, by clicking an action button on the grid, the form that presents separately the detail of the invoices that make up the summary of each line of the grid.Example: I will appreciate your support. Thank you.

Hello, Our push notifications are part of our customization project, and we publish our customization project to all three of our tenants to keep them in sync. When we do this, the push notification URL is set to the same value for all three tenants, whereas we need each tenant to use its own specific push notification URL. Is it possible for the push notification URL to be dynamic? We’d like each tenant to use different  push notification URL depending on the CompanyId of the tenant.Thank you, Dave

Hello, We are integrating with the Acumatica SAAS product via the REST API by means of lambda functions. This is working fine in general. However, we find that after a period of inactivity, the response to an API request takes much longer than usual. The lambda function is configured with an execution time of 15 seconds, and it often stops executing before the response is received. An Acumatica support rep once mentioned that this could be due to "cache expiration", but we can't find any documentation about this. Is it possible to configure the cache expiration time, or something similar that would help us solve this problem?Thank you,Dave

For my each SO Line, I have 2 salesperson, where the salesperson can be different people or they can be the same people. The amount in each SO Line have to be split among the 2 salesperson where each salesperson get a percentage of the amount.In that case, how do I calculate the sales performance for each individual salesperson and display it on dashboard? 

I am unable to select the tenant with Edge and Firefox.At the login screen there is a tenant preselected that cannot be edited but deleted. If I enter my credentials without a tenant in Chrome, a second dialog appears to select the tenant.But with Firefox or Edge this second dialog is skipped. How can I change the mentant then? My instance is vesion 2021 R1 Build 8.013.0000.40 [21.113.0011]

2Hi All,I have  2 customized fields in subcontract Lines. while creating AP bills from subcontract I want to carry forward this field values to another custom field in Bills and Adjustment Line. I tried to achieve this through “CreateAPInvoice” override method in Subcontract ,  but i’m not sure how to execute this correctly below are my incomplete lines of code. Could anyone please help me on this.  Regards,Ramya

Hi All,I’m trying to pass few fields  value from document details tab to another custom tab on same screen(subcontract). here i need to filter and carry forward only the non stock item type =”N” from document lines to my custom tab.I already created a view to bring the fields from Document details to my custom tab, but not sure how to apply the filter condition for the view. could anyone please help me on this.  Regards,Ramya

Hi,I’m having trouble with the acumatica’s automated testing wherein I wasn’t able to make the test pass every time I’m passing a value to the subaccounts. I’m getting this errorNoSuchElementException: Could not find a web element by the locator: css=#_ctl00_phG_tab_t0_PXGrid1_lv0_es div.buttonsCont > divI already re-generated the wrapper file.Tried using .Typescreen.VariableRateDetail.Row.ARSubAccountID.Type(detRow["ARSub"].ToString());Tried using .Selectscreen.VariableRateDetail.Row.ARSubAccountID.Select(detRow["ARSub"].ToString());Tried overriding the Locatorscreen.VariableRateDetail.Row.ARSubAccountID.Locator = screen.VariableRateDetail.Row.ARSubAccountID.ClearLocator;Unfortunately, the error still persists. I have no clue on what causes the error.I hope you can help me. Thank you.-------------------------Additional Information: The lookup mode for the Subaccount Segmented key is currently By Segment: All Avail. Segment Values.

We are using the integrated shipping connector within Acumatica. We are having inconsistent challenges when attempting to ship to Puerto Rico. I noticed Acumatica has a setting where the country can be PR (which does not make sense). I am curious how others are able to ship via UPS and what information we need to input. The error we get is either - no international information is entered, or incorrect zip code.  

We have a running live environment for a couple of years now. Due to business ownership change and/or restructuring, the financial year for the company has changed. Current: Jan to Dec - 13 periods (with period 13 as adjustment period) The change:The current Financial Year 2020 has increased to 18 months until June 2021 (i.e. Jan 2020 until Jun 2021).After that, the Financial Year will be 13 periods again from July 2021 to Jun 2022…. and so on. I need help on how can this be smoothly implemented. Thanks  

Hello,I am setting up a new Acumatica instance in AWS. The DB is MySQL 8.0 and hosted on AWS RDS.When we try to setup a new instance, it is throwing below error.I have checked server variable “log_bin_trust_function_creators” and it is ON.Can someone please help me out to resolve the issue?Appreciated,HarishD

HI, We have created a AP Invoice and Created a Cheque. After six months Customer not process the cheque and we need to Void it. After void the Payable Check, needs create a New Check. What Would be the way to do this? Re-Print Check Functionality can be used for this?Can be used same Cheque Number using Re-Print Check Number? Regards   

Hi Guys! Do you have suggestions or recommendations on an ISV solution for AP payments? I have a customer that need to send hundreds of checks every week. Thanks. Jorge    

Hi,We tried to login the Acumatica instance using different branches through postman. When we check the System Monitor screen, it always showing the first logged in record and other records not showing on the screen.Can any one please let us to know why all the records not showing on the System monitor screen?

Hi Is it any possible way to logout the instance based on the branch using REST API?

I would like to save emails directly from outlook to existing Project Issues and not have to convert email to PDF. I have the Acumatica add on button to me Outlook Ribbon but it only gives me the option to create a new Project Issue. 

See attached document. Why do the two salesforce sync screens show a different list of entities? Is there a way to make them the same? If not, is there a way to schedule the integration for the entities that are not on the shorter list?

I’m trying get the unit cost on the opportunity document details.  I’m following the same process I was given for enabling the unit cost on sales order lines. (https://community.acumatica.com/customizations-147/how-can-enable-the-unit-cost-field-on-the-details-tab-of-sales-order-6709?postid=21524#post21524) I’ve added the new workflow with the unit cost field and the row selected event handler. The OpportunityMaint doesn’t have a definition for  Base.Document and Base.Transactions but I’m not sure those are necessary since I removed that code from the sales order line and it still has the unit cost enabled.  When I add a line to the opportunity document details the unit cost is editable but then when I select an inventory item the unit cost is no longer editable.  I’m not sure what I can do to change that behavior. 

Hi, I was trying to create a Purchase order adding Project and Task. Using the Stock Item.It is showing following error. have there any additional Configuration need to be done?RegardsNethupul   

Dear Experts,We are facing a peculiar issue that I wanted your input with.  We have a few non-stock items with a price-sheet in Acumatica. We also built an external integration via REST APIs to create an invoice in Acumatica from an external system. The pricing is different in Acumatica’s price sheet vs External System for one particular Invoice Item, say PRODUCT_X. Since we don’t want Acumatica to calculate it’s own list price when the price comes from External System, we tried to set the UnitPrice, ListPrice, ExtPrice and Amount fields through the API. Acumatica accepts all of them except for ListPrice. It always sets the ListPrice to be the price that Acumatica calculates through the Sales Price Sheet. Do you know if this a known behavior? I am still able to edit the List Price from the UI, but it’s just that I am not able to set it via API. Thanks again for your valuable input, as always!

So apparently my client has had more than 1 issue with his employees imputing the wrong date in a field. Like 2120 instead of 2021. How can I create a customization that red flags this and doesn’t allow a save. Something like if date doesn’t equal 2021 -2022, red flag. I think I’d like to implement this system wide to any date field, thoughts? Thanks!

How I can save each grid in its own table (Even if I click on save at the level of each grid nothing is saved)

Hello:I have a requirement to generate a “signature” in the body of an Event in Acumatica as a default when creating a new Event.  There does not appear to be an option to select the “source” for an Event, so I am attempting to code it.  I have been able to get the currently logged in users name and set it using the below code:namespace PX.Objects.EP{  public class EPEventMaint_Extension : PXGraphExtension<EPEventMaint>  {    #region Event Handlers    protected void CRActivity_Body_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e)    {      //var row = (CRActivity)e.Row;      var userId= PXAccess.GetUserID();      var displayName = PXAccess.GetUserDisplayName();      e.NewValue = "<br /><b>Name:" + displayName + "</b><br /><b>Phone:</b><br /><b>URL:</b>";    }    #endregion  } };However, I am also needing to get the currently logged in employee’s Business 1 phone number and Web address to complete.  I imagine this w

Is there a way to see everyone who has made edits to a service order in Acumatica?

Following code is able to search customer by CustomerID. I need to do similar search by Customer’s Create Date. How should I do that? List<Command> cmdSelect = new List<Command>();            cmdSelect.Add(AR303000.CustomerSummary.ServiceCommands.EveryCustomerID);            cmdSelect.Add(AR303000.CustomerSummary.CustomerID);            cmdSelect.Add(AR303000.CustomerSummary.CustomerClass);            cmdSelect.Add(AR303000.GeneralAccountAddress.AddressLine1);            cmdSelect.Add(AR303000.GeneralAccountAddress.City);            cmdSelect.Add(AR303000.GeneralAccountAddress.State);            cmdSelect.Add(AR303000.GeneralAccountAddress.PostalCode);            cmdSelect.Add(AR303000.Contacts.Contact);            List<Filter> filters = new List<Filter>();            filters.Add(new Filter()            {                Field = new Field()                {                    FieldName = AR303000.CustomerSummary.CustomerID.FieldName,                    ObjectName