Discussion Forums

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 How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is needed from every Community user; everyone can provide valuable input using their individual skills and interests.  When more people participate, all members benefit - - we need diverse backgrounds, cultures, experiences, opinions, values and perspectives. Dipak Nilkanth - Acumatica Community Featured Member for October 2024Meet Dipak Nilkanth our Acumatica Community Featured Member for October 2024. It’s great to have you as part of the Acumatica Community @Dipak Nilkanth! Announcements, Hot Tips, Known Issues and BlogsAcumatica 2024 R2 Downloads and Release NotesAcumatica

Good afternoon!We had a question about mass updating Purchase Order numbers for Invoices after they were created. We have this functionality due to a customization that I blogged about in 2021: https://www.acumatica.com/blog/vlog-changing-an-acumatica-po-number-with-a-smart-panel-and-custom-action/One of our staff said “Sure, we can write an Import Scenario off of that.” Well, it was not as easy as we thought. The smart panel is very basic. https://gist.github.com/kjrichardson/4ec5742fe1cec2e245c3d1e89957e259The code to pop it is basic as well. A simple AskExt.  public PXAction<ARInvoice> ChangePONbr; [PXUIField(DisplayName = "Change PO Nbr", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] [PXUIEnabled(typeof(Where<ARInvoice.status.IsNotEqual<ARDocStatus.closed>.And<ARInvoice.status.IsNotEqual<ARDocStatus.canceled>>>))] [PXButton(Category = "Corrections", CommitChanges = true)] protected vir

My company has multiple warehouses.  I have added custom code in a SalesOrderEntry Extension to find the closest warehouse that has a requested item, if it isn’t available at the customer’s default warehouse.  If there isn’t enough inventory at any of our locations, a line is created to add the short quantity to the item default warehouse (where the item is manufactured).The code works if there is enough inventory to fill the item, but if there isn’t enough I get a line type error.  Our item classes are set to allow negative quantities.  I have manually entered the lines the way the code does it and it works manually.  In debug all fields are filled in, including line type.Example:Customer orders 200 widgets from location XInventory gets checked and 61 widgets are available in default warehouse YNew line is created for the 61 widgetsAnother new line is created for the remaining 139 widgetsOriginal line is deletedLine Type Error occurs when the screen is savedCode:var tagLine = createSO

I added the SOShippingAddress table with the Inner join type to the SOOrder parent table. this was done as I am making a copy of the report but one that tracks ship to address data for country, city and state. after doing so the report goes from loading in seconds to taking a minute or longer to load.is there a better way to do this join so it doesn’t take so long to run and parse data?  

Is there any way to turn off the "split" warehouse function on a sales order?  We use SA and SO when entering orders and this works the same in both entries.  This is very confusing, and our confirmations print out showing this line twice, which makes no sense.  It seems to split the line when there is stock in another warehouse/location.  I have flagged the warehouse to not "allow sales" and it still splits the line.  I have tried every function/flag possible (that I know of).  My other warehouses are not for resale, they are for instruments that we keep as samples for our internal reference only.  I do not want the system generating anything from our other two warehouses.  How can this be done?   Please see below example.  I would appreciate any input you can provide or if anyone handles inventory not for resale a different way in Acumatica. Hoping someone can help me understand this functionality better and provide a solution. Thank you!Maureen SO/shipment screen: confirmation ticke

Hello! I have an attribute field for call activities that is called the “CALLDURATION.” This field is alphanumeric, so I have a formula that converts it to integer when using aggregate functions. I need to calculate the total call duration of multiple call activities performed by each person and have it display in the result next to OwnerID, is there a way to calculate that in GI and what function/formula should I use?  This is the formula I use to convert the alphanumeric value to just calculate the number part.  In the Total Time Spent Column, I need a formula that would return the value of total call duration for each owner. ex: first row has made four calls, so Total Time Spent column should display the sum of all four calls made by first row owner.  

Hi,Wondering if anyone could help me with some code needed for the Inventory lookup attribute on Screen IN401000 so I can put in a lot/serial # and have the item come up as well. Default it just pulls by InventoryId of item.Or a easier way to do this?  Thanks so much everyone. Here is the default Attribute code. I need to add some code to be able to look up by Lot/Serial# as well. So you would put in a Lot/Serial# of a Inventory item[AnyInventory(typeof(Search<InventoryItem.inventoryID, Where<InventoryItem.stkItem, NotEqual<boolFalse>, And<Where<Match<Current<AccessInfo.userName>>>>>>),typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr),Required = true)] 

I am attempting to create a kit BOM GI to send to our warehouse. Our warehouses uses our products alternate ID (in this case ISBN) to identify our products. Is there a way to return the alternate ID for the kit header as well as each of the components? Thanks,​​​​​

I created an action button to create a service order from the customer screen. The customization works great. The only problem is the Address Lookup seemed to stop working. Any Idea what may be causing this?using PX.Data;using PX.Objects.CR;using PX.Objects.FS;using System.Collections;using PX.SM;namespace PX.Objects.AR{ public class CustomerMaint_Extension : PXGraphExtension<PX.Objects.AR.CustomerMaint> { public class CustomerServiceOrderDac : IBqlTable{ [PXString(4, IsFixed = true, InputMask = ">AAAA")] [PXUIField(DisplayName = "Service Order Type", Required = true)] [PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)] [FSSelectorActiveSrvOrdType] public virtual string ServiceOrderType{ get; set; } public abstract class serviceOrderType : PX.Data.BQL.BqlString.Field<serviceOrderType> { } } public PXFilter<CustomerServiceOrderDac> pXFilter; public PXAction<Cus

Hi all, I am creating a Production order using a configuration, I don’t have default warehouse nominated on my configuration lines. instead I am expecting the default issue warehouse on stock item or on item warehouse detail takes precedence of which warehouse the item should be issued from. by the look of the behavior it picks the warehouse attached to the work center instead. why is it behaving like this? we can’t ask a customer to override every line ! configurator setup item warehouse detail setup stock item setup the way it appears on the production line it should be picking shed 2 not the Fin Goods warehouse. not sure where is this going wrong?Thanks Ghazal 

for acumatica development, i am using a macbook (m3) running Windows 11 (ARM) VM.  on the windows VM, i’ve installed Acumatica and Visual Studio 2022 (ARM 64-bit).   i am able to build DLL’s with custom code and run Acumatica on the VM.  However, i am unable to install Acuminator.  when i download the 3.1.3 from the vstudio marketplace and attempt to install it, i get the message, “This extension is not installable on any current installed products.”are there any plans to provide an ARM-compatible version of the Acuminator, or does anyone have any workarounds for this issue?thanks   jim 

On Appointment screen I wants to set default sort order on Line Status column.Reason is Not Started items should be visible first. This helps a lot in Acumatica mobile application.I cannot find any help to set default sorting column. Is it possible or any other way to make this possible.“AppointmentDetails” view is used for it in “AppointmentEntry” graph. 

MS SQL Server seems to be the popular choice for PCS (Private Cloud Subscription) instances, why?Why would we not consider MySQL? Is it because most training and other documentation from Acumatica uses MS SQL Server? Has anyone experienced both and seen if there are performance differences?

Good day CommunityI have to change a number of records to adjust depreciation so I created an import scenario. The import goes through without any errors but the result is pure garbage and only 1 record has a value. I’m sure it is the scenario setup (incorrect fields) but I can’t seem to fid the problem. Can anyone help? Many thanks

Hi All,I am trying to add a custom button in the Move screen called “Print Label” in the highlighted section where on pressing it runs the report Move Serial Number Layout (MAIN6501) for the given line details generated.I have written this action but it’s giving me errors. Basically the line details Production Number, Inventory ID and the Lot/ Serial number are the parameters required to run the report.using PX.Data;using PX.Objects.CS;using PX.Objects.AM.Attributes;using System;using System.Collections.Generic;using PX.Objects;using PX.Objects.AM;using PX.Objects.IN;namespace PX.Objects.AM{ public class MoveEntry_Extension : PXGraphExtension<PX.Objects.AM.MoveEntry> { #region Event Handlers public PXAction<AMBatch> ReportSerialNumberLayout; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Print Label", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] protected void reportSerialNumberLayout() { var currentMov

Hello,I have been trying to create a customization that sets the Expense Claim’s date and description to match the Expense Receipt’s date and description when I click CLAIM (instead of the defaults of today’s date and Submitted Receipts).This is what I have so far, but it is throwing up an error : error CS0115: 'ExpenseClaimEntry_Extension.Persist()': no suitable method found to override Thank you for any help!

Hi! I have created a replenishment class, I have set replenishment parament for one item to test, but I still could not get the PO source to automatically show up Drop-Ship when I create a sales order. I have also tried the suggestions from this related topic Set item to always dropship | Community (acumatica.com). Are there any other settings I should be aware of to have drop-ship show up automatically?    

Hello, I am trying to persist a custom field from a SO to a PO when the purchasing details are updated through PO LINK. Nothing seems to be erring, but the value is not being updated on the PO. The PO is no longer On Hold so the fields are not updateable through the UI. Could this be what the issue is?        protected void SupplyPOLine_RowUpdated(PXCache cache, PXRowUpdatedEventArgs e, PXRowUpdated InvokeBaseHandler)        {            if (InvokeBaseHandler != null)                InvokeBaseHandler(cache, e);            var row = (SupplyPOLine)e.Row;            // Retrieve the Purchase Order based on the OrderNbr            POOrder poOrder = PXSelect<POOrder,                Where<POOrder.orderNbr, Equal<Required<POOrder.orderNbr>>>>                .Select(Base, row.OrderNbr);            POOrderExt poOrderExt = poOrder.GetExtension<POOrderExt>();            //Get the Sales Order Number from the SOLine            PXCache soLineCache = Base.Caches[typeof(SO

Hello, I have made a change to the way in which credit checks work by extending SOOrderCustomerCredit. The following article helped a lot with this I’ve added breakpoints to my code and these are being hit when I enter a sales order, so I know my code is working. The problem is that when I look at the SOEntry graph I cannot see any reference to the SOOrderCustomerCredit class. In fact, when I search the Acumatica code the only references to SOOrderCustomerCredit seem to be where it is defined (inheriting from an abstract class called SOOrderCustomerCreditExtension). I cannot see where the Acumatica code actually uses the SOOrderCustomerCredit class.Can anyone explain the link between SOEntry and SOOrderCustomerCredit please?   

How are you all doing version control on your report designer files.  I also am trying to solution a change log.  I was thinking Github may be a candidate for this.

public delegate IEnumerable PrintQuoteDelegate(PXAdapter adapter); [PXOverride] public IEnumerable PrintQuote(PXAdapter adapter, PrintQuoteDelegate baseMethod) { IEnumerable returnValue = adapter.Get(); try { returnValue = baseMethod(adapter); } catch (PXReportRequiredException ex) { ex.Mode = PXBaseRedirectException.WindowMode.New; throw ex; } return returnValue; }Any ideas?  Customer wants this to re-direct to a tab instead of same window

Hello all, I need to Nightly update 200-500 Projects Tasks to Completed and then Run the Allocation through the REST API. Works great for 1 project 1 task. But I will need to many each night. Is there a way to batch them in instead of 1 call to ProjectTask and 1 to run the Allocation?  IS the REST API not the best way to do it? Thank you

Is there a way to define the markup percentage (%) at the project quote level?  E.g. I have an old quote that I need to modify and I would like to change the mark-up percentage from 25% to 40% to cover material cost increases.  Is there a way in the system to do this?  Attributes?

Is build update restricted to SAAS accounts? Whenever we tried updating the site it says this error “Update could not be performed, because file 'c:\deployment\sites\PR00003841\siteroot\bin\CommandLine.dll' is locked by another process.”  

On the Sales Order screen, I have a custom field in SOLine (UsrNSUnitCost) that is persisted to the db.  I have a custom unbound “total” field in the header (UsrTotalNSCost) to show the total for that field, computed as Qty * UsrNSUnitCost for all SO Lines on the order.My PXFormula compiles and does not have any runtime errors, but the field is zero even when there are SO Lines with amounts in the custom field.This is the DAC field for the SOOrder table:public sealed class AABSOOrderExt : PXCacheExtension<PX.Objects.SO.SOOrder>{ #region UsrTotalNSCost [PXDecimal] [PXUIField(DisplayName = "NS Total", Enabled = false)] public decimal? UsrTotalNSCost { get; set; } public abstract class usrTotalNSCost : PX.Data.BQL.BqlDecimal.Field<usrTotalNSCost> { } #endregion}This is the DAC field for the SOLine table:public sealed class AABSOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>{ #region UsrNSUnitCost [PXDBDecimal] [PXDefault(TypeCode.Decimal, "0.00", Pers