Solved

I would like to create a custom field on the Customer form which has a list of options basically stating why the customer’s acccount is in the “OnHold” state. Basically a combo box. Going through the Acumatica Univeristy, it shows you how to create the field but not the difffent types using the Acumatica tools. Most of the later part of the demo uses coding which I am not familiar with. Is this doable just using the gui instead of coding?

Under Customers, after clicked on generate on demand then click on print statement, I tried to click send. But the email template not pop up, pls help:)

I have a simple combo box with a list of entries. To add a new entry, I thought you just added an item to the lists. List (shortened because it’s my full customer list):[PXDBString(50)][PXUIField(DisplayName="Customer")][PXStringList(new string[] { "", "MCU"}, new string[] { "", "MULTIPLE CUST."})] I update it to:[PXDBString(50)][PXUIField(DisplayName="Customer")][PXStringList(new string[] { "", "MCU", ”NXT”}, new string[] { "", "MULTIPLE CUST.", ”NEXT CUSTOMER”})] I publish and nothing changes. To make this a bit weirder, I can also adjust the user-visible text in the list, publish, and nothing will change like shown below.Example:[PXDBString(50)][PXUIField(DisplayName="Customer")][PXStringList(new string[] { "", "MCU"}, new string[] { "", "Some New Crazy Text"})] Is this a 24 R1 bug, is there a new method for updating combo boxes in 24 R1, or am I just missing something here? Acumatica 2024 R1Build 24.102.0053 

There are two tables with same colomns. Is there anyway to get the union result using Generic Inquiry?

We are experiencing an issue where we want to round the labour actual hours to the nearest 30 minute interval, however our options are to either change the actual time or change the extended price. If we change the extended price, then the unit price will show on the invoice as something other than our flat unit price rate. For example: a 22 minute job that we want to bill out an hour for…. if we change the extended price to 110 (which is our hourly rate) on the invoice the unit price shows as $200 and change. Ultimately we want to capture the actual hours worked by technicians, but invoice to a minimum of 1 hour, or the nearest 30 minute interval.  

I am trying to add the PO# and PO Creator to the Bills and Adjustmetns GI but am getting duplicate rows.  I have added the APTran table and linked it to APInvoice.  I was hoping to get the PO# from the APTran table but now I am getting duplicate rows.  Any suggestions would be much appreciated!  

The font option and size is very limited in Notification Template.Can we add more? If so, how? 

Wir haben ein Problem in der Produktion mit der Maschinenplanung.wenn ich in einer Ressource AM207000 eine Maschine AM204500 hinterlege und in der Stückliste AM208000 eine Maschineneinheit und Maschinenzeiten eintrage.  Dann einen Produktionsauftrag erstellen nach dem speichern ist dieser zuerst auf unbegrenzte Kapazität eingeplant. Wenn ich jetzt auf “Einplanen” gehe, wird dieser auf unbegrenzte Kapazität eingeplant. In den Maschinenkapazitäten AM406000 werden die Maschinen erst angezeigt, wenn der Produktionsauftrag richtig eingeplant wurde Auch in Maschinen Planung AM000012 werden die Maschinen erst angezeigt, wenn Sie auf begrenzte Kapazität geplant wurde. Wenn ich nun den Auftrag auf “ungeplant” setzte und neu einplane, dann werden die neuen geplanten Zeiten auf die aktuellen einfach aufaddiert jedes mal wen ich den Prozess wiederhole, erhöhen sich die geplanten Blöcke der Maschine.  Diese Zeiten lassen sich durch “Planung und Kapazitäten aktualisieren” AM512000 auch nicht mehr

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.