Discussion Forums

I have an api that pushes salesorders and it works if I set the version to 18.200.001.When I move it to 20.200.001 it fails with the error    [message] => An error has occurred.    [exceptionMessage] => Sequence contains no matching element    [exceptionType] => System.InvalidOperationException    [stackTrace] =>    at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)   at PX.Api.ContractBased.EntityExportContextBuilder.ExtractFieldMappingKeyForDetail(String mappingKey, EntityField field, EntityMappingProjection[] entityFields, IMetadataProvider metadataProvider, IEntityMappingKeyService entityMappingKeyService, String endpointName, String version) in C:\build\code_repo\NetTools\PX.Api.ContractBased\EntityExportContextBuilder.cs:line 1343The only information I can find about changes is on page 55  of  https://www.acumatica.com/media/2020/09/AcumaticaERP_IntegrationDevelopmentGuide.pdWhere it says‘• The type of the Payments field is changed.• Map

I’m getting this message when trying to do our first VAT return. Anyone got any ideas as to where to look to correct this. I don’t seem to be able to prepare any VAT returns without this being configured. Thanks in advance a tax report cannot be prepared for the selected company and the tax agency because the report version for the tax period has not been found in the system

Is there a way to set a cost on an item being sold intercompany/branch based on a percentage, similar to the margin feature in Acumatica? I see where I can set a Sales Price or manage pricing based on costs. The problem is with intercompany sales; you start with a Sales Order in the Customer-facing branch, which pulls the item cost, which really is different from the intercompany cost. Take this example: Company2 sells a widget to customer1 The widget is added to the line, and the “cost” is pulled from the item at that time. The problem is we want to sell the widget from company 1 to company 2 at a 5% markup (for example). All of the features only work at the pricing level so the intercompany order might be able to add a correct price of cost +5% the original order does not reflect that costing rule and shows cost.(I hope that made sense) I am sure others do similar things. What do you do to manage this? 

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share  Samvel Petrosov - Acumatica Community Featured Member for April 2025Meet Samvel Petrosov our Acumatica Community Featured Member for April 2025. It’s great to have you as part of the Acumatica Community ​​@Samvel Petrosov! Save the date: Coffee & Code - Modern UI Apr 22Join us for the first Coffee & Code event of the year - Modern UI, a webinar where Acumatica’s Varthini Bhaskaran and Vignesh Ponnusamy dive into the modern UI and best practices. Moderated by Ekaterina Androsova. Grab a coffee and let’s talk code!Tue, Apr 22 - 11:00 AM - 12:00 PM PDTRegister here: Teams Webinar Acumatica User GroupsNew! Michigan Acumatica User Group, Northern New England Acumati

Hello, new to Acumatica and looking for help. I’ve looked through the receivables and noticed that I can’t select certain past due invoices to the same customer with attached copy of their invoices by email. Are we able to do this? Also, are we able set up a schedule for past due invoice(s) to customer by email along with a copy of the invoice(s)? Thank you!!

The Generic Inquiry has more than 3000 of records. In the footer the Aggregate Sum is not showing. Any Idea to get the Aggregate Sum ?

Facing attached error after upgrading my enviroment from 2022R1 to 2023R2Database is MySQL 8.0, Windows 2019 server StandardInsufficient stack to continue executing the program safely. This can happen from having too many functions on the call stack or function on the stack using too much stack space. Any Help Appreciated

Current procedure requires the manual selection by BRANCH to see the UNPOSTED BALANCE prior to release of activity that has been uploaded for each subaccount.  Is there a quicker way or system report that would return the end of period UNPOSTED BALANCE listed by SUBACCOUNT?  The Account by Subaccount only reflects the RELEASED BALANCE.

Hi All,We have some weird behavior currently.We are trying to adjust out expired Inventory. Receipt states QTY on Hand is Zero, yet the Lot is stating a different story:We are currently not able to released this Adjustment due to the following error which is caused by the QTY On hand on the Receipt equaling 0Any ideas if what is going on and how to resolve this?

The Import Branch and Mapped Branch are errors, and I don't know what I should fill in for it. Please kindly advise with thanks 

Would it be possible to use a Microsoft Teams for large document storage.  For example photos and drawings. The documentation is vague about the Teams integration capabilities.  I don’t want to upload the photo to Acumatica and affect the storage limits.  The thought would be to create a file for each project in Teams.  Then upload the photos/drawings to Teams. I would like to be able to add a link to the file in the appropriate project in Acumatica.  Understanding of course that moving or renaming the file would break the link.

We use Parent/Child Account relationships extensively for our Customer base.  We also use a ton of Customer part numbers as Alternate IDs for our stock items.  This is becoming very difficult to manage when we have some parents with 100 child companies. Is there a way to set an alternate ID of a part number for a Parent account, and have it be used for its child accounts?  We can’t use Global in this scenario because we need to be able to use the alternate IDs on customer facing paperwork as well.  

Hello Community, We are in the middle of Acumatica Implementation for a Canadian Heavy Civil Construction Company. We have been using ADP for our payroll system but constantly running into issues with them. It has made our payroll person very frustrated (I am aware of ongoing issues personally too).That being said, we have been looking into alternative payroll systems from two broad angles.1) capability of managing payroll as if was a standalone software and2) integration with Acumatica.We have reviewed pretty much in depth a few payroll systems including Dayforce(Ceridian), Acumatica Built-in, Lumber and Avanti. We have come to conclusion thatWith Ceridian possibly we will experience the same issues of ADP as they are very close in nature, functionality and corporate structure Acumatica Built-in and Lumber are very unmature and they possibly will work for smaller companies with very basic needs and no complexity. Avanti has the most robust payroll engine with maximum control over payr

Hi Guys,I need help to sync Line Item properties to Acumatica. Shopify apparently stores the variant options in and array format. Default connector only syncs the 1st option from line item properties but it could have up to 10+ options in that field.Is there a way we can create a loop to loop through the array and show all the options in Acumatica? Thanks for your help.

I created a DAC that adds 2 decimal fields within the DAC for a grid. I can’t figure out why after publishing,  the field is a text field and not a decimal field. How do I display it as a decimal field?    #region EstCostAmt    [PXDBDecimal()]    [PXUIField(DisplayName = "Est Cost")]    public virtual Decimal? EstCostAmt { get; set; }    public abstract class estCostAmt : PX.Data.BQL.BqlDecimal.Field<estCostAmt> { }    #endregion    #region EstFeeAmt    [PXDBDecimal()]    [PXUIField(DisplayName = "Est Fee")]    public virtual Decimal? EstFeeAmt { get; set; }    public abstract class estFeeAmt : PX.Data.BQL.BqlDecimal.Field<estFeeAmt> { }    #endregion    #region EstTotalAmt    [PXUIField(DisplayName = "Est Total Amt", IsReadOnly = true)]    [PXFormula(typeof(Add<estCostAmt, estFeeAmt>))]    public virtual Decimal? EstTotalAmt { get; set; }    public abstract class  estTotalAmt : PX.Data.BQL.BqlDecimal.Field<estTotalAmt> { }    #endregion     

We have set an approval map for the PO owner to be the approver for an AP invoice, but on some occasions we need to approve so require to set individuals with overriding capability.So far, we have not been able to set this up either with creating steps within the approval maps which seems to duplicate the AP invoice in the Invoices and Adjustments list, creating a workgroup in the company tree, or delegation under employees.This is the current approval map set for the PO owner:  

I would like to set up subaccounts for our business and have been testing it in our test tenant but I’m not seeing that these sub accounts show up on any financial reports like our P&L. Does this require a form customization or am I utilizing the wrong report?

I had learned from the Book named “F110 Data Migration ". I tested the ACU Import AP Prepayments but had one error that can't be imported. Please kindly advise. Thanks for your support and help.

I've built out an Acumatica Webhooks project. I've successfully got it reading the incoming POST, and figuring out what to what to do. So far I can successfully insert Customers, Customer Locations and Projects without an issue. Honestly, from someone who does a fair amount of integration work, this is basically magic. These integrations are as close to real-time as is practical, so amazing work Acumatica.That said, using nearly the same code, I'm trying to insert AP or AR Invoices and I get bizarre or meaningless errors.I’ve stripped that code down to the most basic version, and when running the code that lives in the webhooks dll from a button on a graph it works exactly as expected. When it runs within the webhooks environment itself I get weird errors.For what it’s worth I’m running in 22R2, but I moved the code over to 23r1 and I get the same issues.My case in “in engineering review” so I thought I’d field it here to see if anyone has thoughts on what it is about the AR/AP graphs

When using paperless picking, the pick ticket can be in one of multiple statuses - On Hold, Added to Queue, Assigned, Being Picked, Returned to Queue, Picked, Completed, or Cancelled. Is there anything similar for Pack status?

Hello,Before I go down this path, I wanted to know if it would be a viable solution to add a button in an email to approve or reject a document based on selecting the link. I have been able to get an elementary version of this to work through sending certain text in an email for intake but the client wants to get more sophisticated with an actual actionable button.I believe this would be possible with some variation of the portal- they click the link, brings them to the portal, they can approve- but not all customers will have an access. So ultimately I need to be able to get a response back without the need to authenticate.Any input or experience on this topic would be greatly appreciated! 

Hello, looking for a sanity check.  I can “Restrict Visibility” to a company for Vendors and customers.  However, there is not “restrict visibility” option for stock items and non-stock items correct? It seems I need to use restriction groups for this which would be very cumbersome. Am I missing any other options? Thanks,Larry

Is there a way to view unposted Journal transactions in ARM reports? I tried searching the community forums but all the posts are 5 years or older so I am not sure if this feature was ever added. We would like to put expenses into the GL as unposted and see how it affects our finances overall in these reports so our team can make informed decisions.

        public SelectFrom<CustomTable01>.View FilterView;                public PXFilter<CustomFilte> Filter;        public virtual IEnumerable deleteLine(PXAdapter adapter)        {    /// Code to retrieve the PXResultset                    foreach (var CustomTable01Row in CustomTable01Rows)                    {                   Method 1 --------- this.FilterView.Delete(CustomTable01Row);                                     Method 2 --------- this.FilterView.Cache.Delete(CustomTable01Row);                   Method 3 --------- this.FilterView.Delete(CustomTable01Row);                                               this.Persist();                   Method 4 --------- this.FilterView.Cache.Delete(CustomTable01Row);                                               this.Actions.PressSave();                                            }    }I created a custom screen with a filter with a results grid. When a user selects a line and presses an action button, I want to delete the selec

Adding files attached in header files section of the particular order in the Purchase order email template automatically and option to remove before sending the emailfor eg the PO has two files attached, but when we get into the email template, we are again forced to add the two attachments along with the PO document which is redundant.Anyways it can be done.