Solved

Hello - We noticed that we have missing numbers in the sequence for our payments for one of our properties. They are creating automatically from the AP suggest next record, and no one has access to modify that setting. The system skips from reference number 7526 to 7528, skipping two reference numbers. The auditors caught this and are wondering the cause, and have deemed it an actionable issue. As far as I am aware, once a payment is created and a reference number assigned, it cannot be deleted, only voided, which still leaves the reference number. My question is, what possible scenarios could cause this, outside of someone changing the Last Reference Number on the payment method?  

Hi ALL,For example: Inventory Balance report > Click SEND   In the Email Activity screen > FILES > File name is the default.How to rename this default file in Email Activity screen before sending email ? Best Regards,NNT   

This is because the document the user is looking at has been updated and the one they are looking at is not the updated version.  If the user were to refresh after saving (when the business event has changed a field value) then there would be no problem.  Instead, if the user continues to work on the document after saving/updating and they are actually working on an old version of that document which is why they get the error upon saving. What is needed is a way to create a business event that will update the record AND do a refresh of sorts.  One of these ways is to click on CANCEL after clicking on SAVE.  CANCEL will bring into the document the latest updated values. Has anyone found a way to refresh/re-cache the document in a users browser after updating it via import scenario or actions?  I know I can get around the issue by putting it on a schedule or setting a timer to update after the user has terminated working on the document but this is something that really handicaps the imp

We just upgraded to 2023R2 and have issues with the Sales Order screen.When using CREATE SHIPMENT action on the screen, Order Date changes to Requested On date.Anyone also had this issue?  

I want to record the bank deposit received from Shopify Payments and move the payments from my clearing account to my regular account. However no payments that used Shopify Payments show up when I go to do a bank deposit 

We have a customer that builds large assemblies.  The welding of these assemblies spans several days.  Since the Bill of Material/Production Order Details only allow up to 23:59 for Run Time, we are entering fractional Run Units to plan hours >= 24:00 per operation. For example, if the planned hours are 250 hrs for a weld operation, we would enter 0.04 Run Units at 10:00 Run Time.However, there are some cases however where we cannot plan the hours accurately due to run units only being 2 decimal precision.  Has anyone else run into this and have another solution?Thanks!LF

 Would like to have a Column Set that only adds the months up to the “TO” period in the Parameter.  Was using a copy of the Rolling 12 column set but it includes totals for months past the parameter selection.  For example if we run it from 01-2023 to 03-2023 we want it to only include amounts for periods 01 to 03 and nothing beyond that.  

I have a non-stock item set to Close PO Line: “By Amount”. If I add this item to a Purchase Order manually, the Close PO Line setting carries over to the PO Line correctly.If I use the Create Purchase Orders screen to create a PO with that same non-stock item, the PO Line is created with Close PO Line = “By Quantity”.  The Close PO Line field is not editable on the Purchase Order line and this is impacting our ability to process partial AP Bills correctly against the PO Line.Has anyone else run into this situation?Am I missing something in the configuration?  Inquiry showing the issue for just one of our items set to Close PO Line by Amount 

Hi all!I have a custom popup with a dropdown list. When I move popup window, the list from dropdown doesn’t move with the window. I found the same behavior with “Create Snapshot” popup on Tenants screen.I want to fix it with my custom popup. Is it possible? 

Has anyone performed stock take for item that is allowed negative? I find that the Book Qty doesn’t look right. What do I miss?This what allocation detail says: there is 300 EA on hand and 100 EA shipped hence Book Qty should be 200 EA. The OH quantity is positive but it started from negative: Stock take is initiated and the Book Qty is 1200 EA. Then the following error occurs when trying to complete the stock take. 

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?