Solved

I'm working on a custom script to automatically update the external ID and description of an employee after the record is inserted into the Data Maps table for Type "Employees."I created a simple Inserted event to test the trigger, but I'm encountering an error.using System;using PX.Objects;using PX.Data;namespace MYOB.AdvancedLive.People.Objects.PP{  public class MPTimesheetDataMapMaint_Extension : PXGraphExtension<MYOB.AdvancedLive.People.Objects.PP.MPTimesheetDataMapMaint>  {        protected void DataMap_RowInserted(PXCache sender, PXRowInsertedEventArgs e)        {            PXTrace.WriteInformation("DataMap_RowInsertedevent triggered.");            var datamap = e.Row;            if (datamap == null)                return;             }  }} 

Hi Community, I am struggling to maintain data security in MYOB because a user can see other users’ purchase request and so on. Please help me out. I want to manage it properly and document it. However, I am confused as it is complex to understand. In our scenario, there are 3 types of access rights.Access Rights by License Type Access Rights by Role Access Rights by ScreenThere are modules, forms, functions and what not.Example: If we grant ‘Employee’ License and ‘Administrator’ role to them. And both have different level of access rights.In this case,Which access right over-rides to each other? Is there a hierarchy ? Admins cannot modify access rights by license type as it is purchased accordingly. How does this all work Is there anyone experts here regarding this topic?RegardsAbhishek 

Either this is a bug, or I’m missing something simple.On the PO505000 Create Purchase Orders Screen, fields from joined DACs are always empty.Controls for Joined Data FieldsThis works on other grids, and I don’t see any difference on the Create Production Orders screen, but it’s not working and a lot of the columns on the screen are empty.Any Ideas?For example, the customer name column is added, and the column is visible on the grid, but is always empty. 

Hi EveryoneI have provided details to some of my colleagues on downloading the mobile app but they are having issues gaining access.I had originally set up 2FA and the app was requesting an access code but no notification anywhere of what the code is.I followed the basics for them to remove the app entirely and reinstall after I removed the 2FA. It is still requesting a code.I even generated access codes but none of these are working.Any ideas?Thanks!

I have setup an email account for sending from Acumatica. When I send an email, for example using the email form attached to the Sales Order print feature, the email is not sent immediately. If I go to Send and Receive Email and “Process All”, it sends the email. What am I missing here in terms of setup, to get the system to send email as soon as the email is submitted to the system to be sent?

I’m trying to add a button to the Sales Orders list - S301000PL. I’ve defined the action in a Graph Extension and see it available as a ‘Graph Action’ on the Customization Project screen (SCREENS → SO301000 > Actions). The action is available on the drop-down panel on SO3010PL alongside the standard options.Clicking the action gives the error “At least one record hasn’t been processed”Trace gives:Autofac.Core.Registration.ComponentNotRegisteredExceptionThe requested service 'PX.Data.DacDescriptorGeneration.IDacDescriptorProvider' has not been registered. To avoid this exception, either register a component to provide the service, check for service registration using IsRegistered(), or use the ResolveOptional() method to resolve an optional dependencyI have set a breakpoint within the action handler, but it doesn’t get hit.The action is defined by this code:     public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry>    {        public override void I

Hi,We’ve recently adopted Acumatica for our business and currently in the implementation phase.I am trying to add the PO owner who is ultimately the purchase invoice approver to the Invoices and Adjustments GI but am failing miserably on the relations from adding data tables. I’ve added employees, users, and EPApproval, but either get random approvers, blank, or invoices duplicating.Ultimately, I am trying to create a widget on a dashboard so our PM’s can see that they have an invoice to approve.Any ideas?Thanks!

 Hello!I’ve been trying my own to figure this out but couldn’tI saw there is two ways for doing this, one is creating a unit set and the other one, that I prefer, is create a column set.As you can see I was able to create two columns but I can’t call the branch I want, instead, the two of them are called together printing the same calc in two different columns.Can you help me? I need to enter a value somewhere to get the branches separatelyThis is my column set Thank you!

Good day,I have a business event that is throwing system errors.  (i have the same event working for another notification for PO Pending Approval emailing workgroups members) The purpose of this one is to send the workgroup members an email when a Quote is pending approval.  I set it up the same; the GI works fine.  I have attached the Business Event and GI.  Below is the system errors.  Any ideas and the issues?  Also, it seems to fire on it own.Thank you for your assistance in advance.EvanCustomMessage = Too many events of this kind (EventID).EventID = BPEventNotifications_SendingFailedEventIdSourceContext = BusinessEventsBPEventName = NXT-Workgroup Notification-QuoteContextScreenId = SM502030ContextUserIdentity = adminCurrentCompany = Critical Infrastructure HoldingsEventID = BPEventNotifications_SendingFailedEventIdSourceContext = BusinessEventsException =System.ArgumentNullException: Value cannot be null.Parameter name: key   at System.ThrowHelper.ThrowArgumentNullException(Except

On expense receipt screen we need customization.We need to add Customer and Customer Name for mobile app.(We can easily add Customer Name for web).But for mobile app. How can we add additional field.Original Acumatica Code:[PXDBInt][PXUIField(DisplayName = "Project/Contract")][PXDimensionSelector(ContractAttribute.DimensionName,typeof(Search2<Contract.contractID, LeftJoin<EPEmployeeContract,On<EPEmployeeContract.contractID, Equal<Contract.contractID>,And<EPEmployeeContract.employeeID, Equal<Current2<employeeID>>>>>, Where<Contract.isActive, Equal<True>, And<Contract.isCompleted, Equal<False>, And<Where<Contract.nonProject, Equal<True>, Or2<Where<Contract.baseType, Equal<CTPRType.contract>, And<FeatureInstalled<FeaturesSet.contractManagement>>>, Or<Contract.baseType, Equal<CTPRType.project>, And2<Where<Contract.visibleInEA, Equal<True>>, And2<Feat

I have created a custom screen which contains two grids in separate tabs. one grid is a read only grid. while other grid allows to CRUD operations. In this grid I use fully custom DAC. when I trying to insert data, even when insert correct values (not null) for each column sometimes it gives “cannot insert values to columns since null”.  Even I set values after clicking save button it inserts an empty row as above.DAC:using System;using PX.Data;namespace EMPPlanningToolR4N5{ [Serializable] [PXCacheName("PTFillerReelWidths")] public class PTFillerReelWidths : IBqlTable { #region Width [PXDBInt(IsKey = true)] [PXUIField(DisplayName = "Width")] [PXDefault(0)] public virtual int? Width { get; set; } public abstract class width : PX.Data.BQL.BqlInt.Field<width> { } #endregion #region PaperTypeID [PXDBString(2, IsKey = true, IsFixed = true, InputMask = "")] [PXUIField(DisplayName = "Paper Type ID")] [PXDefault("##")] [PXSelector(typeof(PTPaperTyp

Hi everyone,I have an invoice report that is truncating text for no apparent reason. In screenshot below I blacked everything out except the “NO”. On the actual invoice, transaction description shows “NOV2024”. As you can see, there’s plenty of space for 5 more characters. I set field to “CanGrow” (see settings in second screenshot). Any ideas?   

I had import AR to Import by scenario, but it has notification That “Customer ID Can't empty “ . Please give advice and Thanks so much.     

We seem to have many States (State-CountryStates) within Countries (country-CountryID) that are setup incorrectly over the 7 years we’ve been on Acumatica/Merged in Data and this is causing issues now that we are using an External Tax Provider.How do we get a request in for Acumatica to develop the ability to have an Active checkbox on these states so that we can deactivate them when they’re incorrect?The best I can come up with right now, is marking them do no use because without being able to update all records where they’re referenced which are now complete/locked records via SQL I can’t remove them as they’re referenced in a record.“State (IN, MUMBAI) cannot be deleted because it is referenced in the following record: Address (105882).” Tagging some of my favorite people in case they can point me in the right direction ;) ​@Doug Johnson ​@Laura02    

We have AP document handling set up. We use a Gmail account for vendors to send invoices.Originally we had Acumatica set up to read directly from the gmail inbox. But, we intermittently got RSC datetime format errors. When we got these errors Acumatica would error and not read any emails. Acumatica support directed us to set up a gmail folder and point Acumatica to that folder. Since gmail doesn’t have folders, we added a label, via gmail filters labeled all incoming email with an attachment with that label, and pointed Acumatica to that label using the folder setting. This change resolved the datetime format error.Our vendors usually send invoices in batches - each invoice in its own email. Acumatica only reads the most recent email from each vendor; the other emails remain in gmail as unread. (This problem existed prior to the label change as well). This problem appears to only exist for each batch.We are on Acumatica version 24R1, use IMAP and Oauth to connect to our gmail account.H

Hi! I have enabled the mass update function on a GI for ‘carrier’ and ‘carrier location’ fields. These two fields are user define and pulls in vendor and vendor location. When I do a look up in the values for update screen, I can only search by Vendor ID not the Vendor Name. Same with location, I can only search by location ID not the location name. Is there a setting somewhere that I missed that is preventing me from searching by the names? Thanks!!Test Vendor is an available carrier to selectCannot search by Test Vendor 

We’re getting ready to switch our ecommerce site to Shopify and I am in the process of trying to export our open non-web orders to the site so customers can see their order status.  We’re on 23R1 for now (planning on upgrading after this migration).  We’ve setup a new order type for orders being imported from Shopify (WB).  I have also configured an existing order type (SB) that we want to export.  The sales order entity is configured for a bi-directional sync direction.  After running some tests on a handful of our open SB orders, they’re being exported as expected and at first glance everything is working great.  However, after these SB orders get created in Shopify, the connector sees that they have been modified externally and the next time I process one of them a bunch of fields get updated in the ERP that we do not want to change.This list is not exhaustive but here are some changes I am seeing happen after the re-import:Both the Order date and the Cancel By date get changed from

What would cause the following behavior? Everything prints except the document details (Customer details, line items, etc.). It started occurring after a recent update to 2022 R2 Build 22.218.0023. We are using Device Hub when processing the print. The printers are set in the users profile. 

Hello all,Can anyone guide me on how one can make use of Acumatica for cheque printing. I am looking out for start till end steps & how to test it & process in real scenario.Thanks.

i am not able create check after upgrade acumatica in october 2024got this error{"message":"The request is invalid.","modelState":{"":["An exception occurred during input parsing"]}}please suggest me but missing my endpoint https://local//entity/Acumatica/1.0.3/Checkjson body this {"CuryOrigDocAmt":{"value":0},"CashAccount":{"value":"10060"},"Type":{"value":"Check"},"Vendor":{"value":"V001097"},"CurrencyID":{"value":"USD"},"Hold":{"value":false},"PaymentAmount":{"value":10.19},"PaymentMethod":{"value":"CREDITCARD"},"Details":[{"CashAccount":{"value":"10060"},"PostPeriod":{"value":"102024"},"BranchID":{"value":null},"InventoryID":{"value":null},"OrderQty":{"value":0},"WarehouseID":{"value":null},"AmountPaid":{"value":10.19},"Balance":{"value":10.19},"CashDiscountBalance":{"value":null},"DocType":{"value":"Bill"},"ReferenceNbr":{"value":"001301"}}],"PostPeriod":{"value":"102024"}}

Hi,I customized a ARM Balance Sheet Report to reflect 6 different branches at a time. What formula can I use in each column to pull the branch name automatically versus having to input manually for each colums? Here is a snapshot of the column set and highlighted fields.   Thanks,Frances   

Scenario: Issuing a Bill with a 5-Step Approval Flow A company, prepare bill to customer and needs approval before processing the payment.🔹 Approval Steps:1️⃣ Step 1: Accountant Review – Checks bill details and submits for approval.2️⃣ Step 2: Finance Manager Approval – Verifies bill accuracy and compliance.3️⃣ Step 3: Department Head Approval – Confirms budget availability.4️⃣ Step 4: General Manager Approval – Ensures approval for major expenses.5️⃣ Step 5: CEO Final Approval – Authorizes high-value payments before processing. Thanks in Advance  

Hello, I have a GI where add new button is not working. If I click the button nothing happens. It works well for all other GIs. Is there any change that I can do in the GI?I have attached the GI here.

Every time I try to search a customer or phone number with the universal search, I receive an error message. We have tried restarting the full-text search, cleared the cache, processed all in the rebuild full-text entity index, rebuilt a new database for my site, upgraded to the most recent version, and applied a new license. The problem still persists. 

I have two custom fields Absolute Variance Quantity for rows and Total Absolute Variance Quantity in the header. I can get these fields to update via PI Review and Scan and Count just fine, but when I do an action such as Set Not Entered To Zero, the custom header field won’t update.Here, the only value that got send to the custom header field was the first line (21), but the header field should be close to 101,772Here is my code for the field definitions and this screen:INPIHeaderExt.usrTotalAbsVarQty[PXDBQuantity][PXDefault(TypeCode.Decimal, "0.00")][PXUIField(DisplayName = "Total Absolute Variance Qty.", Visibility = PXUIVisibility.SelectorVisible, Enabled = false)]INPIDetailExt.usrAbsVarQty[PXDBQuantity()][PXUIField(DisplayName="Absolute Variance Quantity", Enabled = false)][PXFormula(null, typeof(SumCalc<INPIHeaderExt.usrTotalAbsVarQty>) )] Code Editor: INPIReview (Physical Inventory Review)using System;using System.Collections;using System.Collections.Generic;using System.L