Solved

Hi Team, I am working on creating task in task Screen. But while creating a body it shows me two errors. One in “” Owner cannot be empty even I have mention owner value in body. Second I can see that the "RelatedEntityType" and RelatedEntityNoteID. Can anyone guide me on that. I have attach the screen shots below”my query: http://local/AcumaticaSB/entity/Default/22.200.001/Task?$select=Body,Owner,Summary,RelatedEntityType,RelatedEntityNoteID 

We had a user accidentally delete a custom object that uses automated number sequencing. I am able to restore the object from a copy from a different tenant. (<NEW>, then copy and paste). However, Acumatica generates a new ID for the object. Other objects reference this one based on the ID.Can I temporarily turn on Manual Numbering, restore the object, and use the old ID? If I do, does this operation impact anything outside of what I am attempting?

We would like to restrict visibility of Requisitions for a user to only have permission to view their own requisitions (ie, they can not see reqs submitted by other users).Is it possible to do this in Access Rights by Screen?

Hello, I have followed this article to create a multiselect combo box. https://asiablog.acumatica.com/2016/03/multiselect-combo-box.htmlEverything operates in the way it is shown in the article, values are displayed in the combo box, I can select 2 values and those values are saved to the database. However, when I leave the current record and then return to the record, the combo box value is empty. The values are in the database but they don’t appear on the combo box. Here is my DAC[PXDBString(255, IsUnicode = true)][PXUIField(DisplayName = "Brands")][PXStringList(new string[] { "D", "C", "T", "I" }, new string[] { "Development", "Consulting", "Training", "Implementation" }, MultiSelect = true)]public virtual string UsrBrands { get; set; }public abstract class usrBrands : PX.Data.BQL.BqlString.Field<usrBrands> { }..and the ASPX<px:PXDropDown runat="server" ID="CstPXSelector334" Size="M" DataField="usrBrands" AllowMultiSelect="True" />I’m not sure what else is required, can

Hi,I need help to hide report buttons so that no one can see it. I am using a clean instance of acumatica for test purposes. Reports- AR EditI wish to hide the AR Edit button so that the users and administrators will not see the button anymore. I know the basic of how to hide buttons using access rights, where on the invoice and memo screen(AR301000), i was able to hide the default buttons where it will not be seen by anymore on the actions menu. For some reason i cant hide any buttons under reports. Can someone please help me. My version is the followingCopyright © 2005-2024 Acumatica, Inc. All rights reserved.Acumatica Cloud ERP 2024 R1Build 24.107.0004 +

I have an item I need to return but I don’t have any PO receipts. It had it’s qty set initially with a manual receipt and then the qty was updated with a physical inventory count. As far as Acumatica knows we have never purchased this item. Now I need to return this item to our vendor. Normally I would start with the original PO Receipt and process a return from there. Without that starting point what is my best path forward?

How do I set up approval map by workgroup? I keep getting a message that employee cannot be blank but I need to allow one of 2 employees to approve.

As Acumatica (understandably) is getting more strict on ERP transactions, I am trying to limit inbound email processing.    

Hello all,Is it possible to display the data separated into different weeks. So if I select a financial period, the report should segregate & display the data based on weekly format.

Hi ,Can we set up a minimum order quantity for an stock item which needs to be considered when calculating the quantity to replenish. Example : There is a item which need to be ordered at least 1000 qty for an each order. Otherwise it is not profitable with the high transport cost. Thank you,Dulanjana

I am looking to see if it is possible to create an excel export for ACH batch payments and get it to export an excel file instead an txt file. Thank you.   

I have a customer that paints the lines on roads that is using the construction edition that wants to know for billing purposes how much material he has used by the meter so he knows how much to bill. They also want to track this material costs and labor out in the field so they can track actuals against the estiamte/budget. Does anyone know how Acumatica can handle this or a if there us a 3rd party solution out their that might be able to help

Hello Everyone,I was wondering how the payroll module pulls taxable wage amounts. Let’s talk about the California SUTA wage base amount. Say an employee has gross wages of $10,000. The taxable wages for the California SUTA will stop at $7,000 (unless overriden of course). Does it stop at $7,000 because Acumatica is pulling this limit from the tax symmetry engine?I am just trying to get confirmation on how this works.Thanks

Hello all,Is it possible that Acumatica can automatically assign the workgroup based on the owner?  

How is everyone handling retention billings with the Acumatica generated AIA billing form?  It is my understanding that if you have several periods of billing, you will get a separate billing form for each one. Is there a way to get one retention bill?  

We have 9 fields in a tab under contacts in Acumatica and in order to get credit for it our sales representatives must have at least 3 of these fields filled out with some form of information, my manager has asked me to figure out a method of filtering down the list of Contacts to just those that have a minimum of 3 of these fields that are not Null in value. how might I go about doing this?Attached are 2 images, one of the fields as they look under the Contact Profile and the other is how they are in the results tab of the Generic Inquiry (GI) editor.

Why Sometimes this query return null and some time it will return result?     var result = PXSelectReadonly2<PX.Objects.GL.Branch,        InnerJoin<PX.Objects.GL.DAC.Organization, On<PX.Objects.GL.DAC.Organization.organizationID, Equal<PX.Objects.GL.Branch.organizationID>>,        InnerJoin<PX.Objects.CR.BAccount, On<PX.Objects.CR.BAccount.bAccountID, Equal<PX.Objects.GL.DAC.Organization.bAccountID>>,        InnerJoin<PX.Objects.CR.Contact, On<PX.Objects.CR.Contact.contactID, Equal<PX.Objects.CR.BAccount.defContactID>>>>>,        Where<PX.Objects.GL.Branch.branchID, Equal<Required<PX.Objects.GL.Branch.branchID>>>>.Select(graph, graph.Accessinfo.BranchID);

Did anybody ever get the following Error when saving a Production Order on initial Creation?Inserting 'Schedule Operation' record raised at least one error. Please review the errors. Error: 'Queue Start Date' cannot be empty. Error: 'Move End Date' cannot be empty. I have never seen this Error before and I cannot really locate what is causing it.Any common causes for this can be really helpful.

Hi There,I have a query which for various reasons has quite a long filter parameter passed in the URL - in fact it exceeds the maximum length for a URL (which is something like a 1000 chars).It seems to be the idea that going forward you should be able to pass this in the body of a POST request (getting around the length limitation) and postfixing the URL with /$queryAs per Passing OData query options in request body - OData | Microsoft LearnHowever - when I do this with Acumatica - I get a “Method Not Allowed” error which smells of - this hasn’t yet been implemented?Is this correct? And if so - are there plans to do so?Many thanks,Daniel Graham

Hey Acumatica Community,Is there a way to create a table in a Notification that displays the articles within an order along with their corresponding ImageUrls?I've tried the following html code, which generates the article list, but I can't get the actual images to display. Any suggestions?  <div class="article-list"> <h3 class="highlight">Artikelübersicht:</h3> <ul> <li data-foreach-view="Transactions"> <span>((Transactions.InventoryID))</span> <span><img src="((Transactions.InventoryID.ImageUrl))" style="width: 100px; height: auto;"></span> <span>((Transactions.OrderQty)) ((Transactions.UOM))</span> </li> </ul> </div> 

ACU V 24.105.0036 - Sensitive custom ARM reports are showing for a user who’s roles have the reports Revoked. For example, Here is a list of the User’s Roles that should NOT see the highlighted report in the second screenshot.This is what each of the four roles above looks like: This is what comes up for the User with those four roles (and it runs perfectly, allowing access to transactions): This user should not have access to any of the Financial Statements.  Ideas?

Hi thereI have created a Payment Statement report for suppliers, having one supplier payment statement per page. So if there are 20 suplliers, there will be 20 pages each with their specific data.We would like these to be sent as a ‘bulk’ emial, but each supplier should only receive their own statement and not the whole report.Is there a way to set this up?Thank you.

Hi All, @Tim Rodman , I have setup a Multistep PO Approval where I cant get the second step to work. The first step is for two users to approve where I have used the “Collect All Approvals….” (Rule Actions\On Approval which works fine).  If the PO is < $15,000 then it need not go further and can be approved.The second Step is where I am having the issue.  I have read the documentation and applied the rules but am still having issues. Please see attached for setup.Any help appreciated.Cheers,Laura

Hello,I'm seeking a method to determine the remaining balance of an invoice as of a specific date in a generic inquiry. Consider the following scenario:Initial Invoice Amount (01/01/2024): $1,000.00 Payment Made (02/01/2024): $400.00 Payment Made (04/01/2024): $200.00 Payment Made (05/01/2024): $300.00 Current Balance: $100.00My goal is to find the balance of the invoice on a past date, such as $400.00 on (04/25/2024).While I can join the ARInvoice with the ARAdjust table and filter by the ARAdjust entries made before my specified date (04/25/2024) to calculate the total amount paid, this does not provide me with the balance. Unfortunately, the ARAdjust table lacks a field that reflects the document balance after each transaction. Thank you for your help!

I am attaching the basic GI I am trying to create which all it is doing is displaying the PMActivity information and then simply converting the PMActivity.TimeSpent from Minutes to Hours by dividing the minutes by 60.  HOWEVER, Acumatica is NOT calculating this correctly, as you can see from the screen shot below.  One of the returned rows calculates 28800 / 60 correctly to 480 hours. But the OTHER two returned rows are NOT calculating correctly at all.  Not even close.  29070 / 60 should = 485.5 hours.  And 31920 / 60 should = 532.  NEITHER of those are even close to Acumatica calculating them to be 421 and 439 hours respectively. Is this a major Acumatica bug?  Or is this simply something that Acumatica cannot do, and is there some way to simply have it perform this automatically?Here is the equation from the attached GI