Discussion Forums

I’ve been asked to provide an estimate for a new customization.  I’ve done several advance things in Acumatica but this one I’m wondering if a) is this possible? and/or b) should it even be attempted?They want to use Matrix Items with 8 attributes in a template.   They want to be able to add cost/labor to each attribute value and have the price calculated during entry and saved directly to AR prices when item is createdAdd custom fields to Attribute values: Use these values to calculate a price during matrix entry: This does not look like traditional graph extension with overrides.  I’ve tracked down some code PX.Objects\IN\Matrix\GraphExtensions\HeaderAndAttributesExt.cs which looks like where the fieldupdating event is being hooked up to each attribute value but I can’t see a way to sub-class or extend this abstract class.I guess I’m at the point where I just need to hear if this is a fools errand and/or if there is some other possible way to accomplish this.  Customer does not want/

I can’t figure out why my business event wont trigger…no matter how much i google and click on ‘this is how you set up business events” videos and walk through.  Everything I see online is “set up where you want it to point to, who you want it to email, and when you want it to email” and yet it wont send….

My client needs the ability to have multiple shipment open on a sales order simultaneously. The create shipments to tell the warehouse to prepare configuration of the shipping items, prepares a pro-forma invoice, and creates a shipment to send to US Customs.What have others done for their clients to achieve this or this type of need, workflow customizations?

Hey, Does anyone know if it is possible to display just the time of a transaction on its own in a GI? I am trying to use a filter to show what was done during normal operation hours and what was done on overtime. But with the current date/time display, I cannot filter the time portion, without filtering the day as well.  I want to have the time by itself so that I can group things within that week that were made during normal hours, not just on a specific date, if that makes any sense.

If I want to add new DB fields on this screen, which table they will be added I know its ScanHeader DACExtension but I am not able to find the respective table. I need to add details like on which day this shipment was scanned it was scanned by whom and data like that. 

Hi,Previously I sent documents to Acumatica files for bills with the help of such requesthttps://myacumatica.com/entity/ARTSEndpoint/20.200.001/Bill/INV/002272/files/image (3).pdfFor Checks and Payments it worked via such requesthttps://myacumatica.com/entity/ARTSEndpoint/20.200.001/Payment/payment/002272/files/file.pdfHow to do same for Purchase Receipt tab ? I tried several variations but did not succeed in it 

Hello!I am attempting to add some conditional formatting on the SO Order Details grid where the SO Lines are viewable when looking at a Sales Order.I have implemented a customization on the SO Order Entry graph which calculates the mark up of each line amount over total average cost of the line, which then puts this number into a custom field on an SO Line DAC Extension.I want to highlight the SO Line rows in red where the the custom field(usrMarkupPct) is less than 0.1.Everything I am finding says to edit the ASPX file of the Sales Order screen but I am not sure that is the best way to do this.Does anyone have any experience with applying formatting conditionally to SO Lines?As always, any help will be greatly appreciated!!

I’m trying to set an attribute invisible using this line of code : var row = (SOLine)e.Row; if(row != null){                var rowExtension = row.GetExtension<Objects.SO.SOLineExt>();                PXUIFieldAttribute.SetVisible<rowExtension.UsrStkDispEntrp>(cache,row,false); }   but i’m getting this error : 'rowExtension' is a variable but is used like a type thanks.

 ​@lauraj46 Looking for assistance with placement of the attached sub-report within the main report so that all the fields line up within the main report. Still trying to navigate all the data fields accurately, so always welcome to better ideas. I could whip this out easier in even an older version of SSRS.

Hello everyone,I've encountered an issue concerning how item descriptions are handled between the Stock Item  master and its usage within the Bill of Material module.When I update the Description of a standard Stock Item (e.g., on the Stock Items (IN202500) screen), this change is not automatically inherited by the corresponding component line item within any existing BOM. I must manually open and update the BOM to reflect the new description.Why is this the intended behavior in Acumatica? From a data consistency and efficiency standpoint, it seems logical that the BOM component's description would always reference or automatically update from its master Stock Item record.Could someone explain the design philosophy behind this apparent lack of synchronization? I'm trying to understand why this would be implemented as a feature to be managed manually, rather than an automatic system update. Is there a specific business scenario this design supports?Any insight into the technical or func

I have a new PXAction that I added to the InventoryItemMaint graph.    public class InventoryItemMaintExtension : PXGraphExtension<InventoryItemMaint>    {        public PXAction<PX.Objects.IN.InventoryItem> PrintItemLabel;        [PXButton(CommitChanges = true)]        [PXUIField(DisplayName = "Print Label")]        protected virtual void printItemLabel()        {        }    } update screen IN202520 { update container "HeaderView" { add recordAction "PrintItemLabel" { behavior = PrintItemLabel } update layout "FooterLayout" { update layout "Line1" { add recordActionLink "PrintItemLabel" remove recordActionLink "ScanBarcode" } } }}My goal is to add this Print action to the IN202520 mobile application screen, and to remove the current “Scan” action, which is unnecessary both because the device has an attached harward barcode scanner, and we don’t want to use the camera to do scanning anyway.My sit

Just curious to see if anybody started to use Acumatica Survey from Github? If so how has your experience been so far? If you haven’t why not? If you like to learn more ask a question here.

Hi All,In BigCommerce the sales categories are mandatory to create a new item, so that is why Acumatica-BigCommerce connector requires to have at least one category during the export. I would also recommend you to manage Sales Categories in Acumatica, this will simplify the process and allow you to have one source of truth. However, if you really need to manage sales categories in BigCommerce only, I can suggest you the following customization that will disable categories synchronization for existing items. Only new items will still require at least one sales category: Step 1: Go to Item Sales Categories screen (IN204060) and create 1 category with name “Unassigned”. Name can be anything, Unassigned was used just for example. Step 2: Go to BigCommerce Stores (BC201000) and used Unassigned category as the default Stock and Non Stock Item category. This will allow you to export a new item created in Acumatica to BigCommerce without any error. Step 3: Publish the attached customization “B

I added my ICCProcessingPlugin in the R2 instance that was working on the R1 instance. When I try to create a Processing center I am not seeing the plug in I created as an option (see screen shot) would anyone be able to advise? 

Hello all,Can anyone let me know from where can we display this Allocated text in the footer of the screen?The build version of the instance is 22.113.0040 Thanks in advance.

I need to change the SO line SalespersonID on multiple sales orders via import scenario. However, I’m not sure where to affect that field in the import scenario under “Line Details” as I would expect.I have a list of order numbers and their order types along with the new salesperson ID. Any thoughts on how to set this up via import scenario?

I wanted to take a minute to share this with the community. If you have the following feature enabled on Microsoft Edge, it breaks the ability for Acumatica to export to excel ( the little excel buttons on every grid in the system ) if you are using Modern UI. Disable it and you can export to excel again.  

So far, here are the ones supported. There could be more. Would request the community to update this list. Authorize.net (native) APS PayPal PayFlow Braintree WorldPay eBiz AcuCharge (Vantage Card) PayPal Request for Money (not a payment gateway, but a way to send email to customer and get money via their PayPal account)

We are trying to work out how to automate the allocation of stock to orders which cannot be fully completed.There is no process to automatically “allocate” stock to orders.  It would be great if there was.Due to stock shortages and the need to keep customers happy our client has to manually allocate stock to orders which is very time consuming.  Some customers end up getting 10% of the order, some all of it if it is a very large order; there are many factors that come into play. Thanks 

The SMARTSHEET SETTINGS tab added to Projects Preferences by the Acumatica/Smartsheet integration provides the ability to load Smartsheet templates into Acumatica.  You then map fields in the Smartsheet templates to Acumatica fields.  Invoking this features loads a number of existing templates.  What I’m not able to determine is, how do I add to this list Smartsheet templates that I've created myself? 

Hey all,I’ve been working on the production order performance report for about two weeks now and am nearing completion with it My current issue is that it is printing separate line items for each inventory ID within a work order, when I would rather it sum the line items into a general work order. How do I achieve this?Thank you!

We have a subreport for an Invoice that is working fine for the most part. The issue is that sometimes we have a duplicate item, qty of 1, that is listed as “Free”, gets a LotSerialNbr of it’s own. When we have this type of scenario, the LotSerialNbr’s from both get printed with each other. I have attached a Word document and the rpx of the subreport. I’m thinking that it has to do with the linenbr(s) from the subreport, but unable to narrow down as to the why. I’ve already tried passing the main report line numbers to the subreport as a parameter, and in that case all of the lotserialnbrs went away, even the one number that is assigned to the item in line 2.

Hi, I need to add a custom unbound field to my smart panel. So I created a definition for an unbound field ‘selected’ in a DAC extension for POLine like below. This DAC extension is defined in my Graph extension which I use for my custom screen.public sealed class PoSelected : PXCacheExtension<POLine>{ public static bool IsActive() { return true; } #region Selected [PXBool] //[PXDefault(false)] [PXUIField(DisplayName = "Selected")] public bool? Selected { get; set; } public abstract class selected : PX.Data.BQL.BqlBool.Field<selected> { } #endregion}(I’m not sure whether this definition is right or wrong, If there is something to be added please let me know also)My purpose of using this field in the smart panel is allow the user to select rows and add to the custom screen like below.For now I use the selected field which is already in the P

I am currently configuring an automated invoice emailing process in Acumatica using Business Events + Email Notifications + Attached Reports.My setup is the following:Business Event Type: Trigger by Record Change Screen: AR Open Invoice (GI based) Trigger Condition: Old Status = Balanced New Status = Open Subscriber Type: Email Notification Attached Report: AR641000 - Invoice/Memo “Use Event as Data Source” is enabled Source Table = ARInvoiceThe Business Event and Email Notification are working correctly:The email is successfully sent The subject/body correctly resolves dynamic values such as: ((ARInvoice_refNbr)) ((ARInvoice_docType)) The Related Entity in Business Event history correctly shows the invoice reference number The AR641000 report displays correctly when manually run from the screenHowever, the issue is that the PDF attachment generated from the Email Notification is blank.The PDF structure/layout loads, but no invoice data appears inside the report.I already test that

When adding a new custom feature switch i get an error when changing another feature due to the null value in the new feature switch field. How can i prevent this?[PXDefault(false, PersistingCheck = PXPersistingCheck.Nothing)] doesn’t help here!