Solved

Hi all, I know that’s possible to write a generic inquiry and pull in a note from say a Customer or a Sales Order Line.But I would like to be able to add a note that is specific to a generic inquiry itself. For instance, I just wrote a GI for our team that identifies potential issues (undercharged on a sales order, for instance). But I don’t want to use the notes attached to the sales order, because many of the notes attached to the so are important and don’t want them overwritten.Basically, I’m looking for a way so our team can ‘tag’ or highlight a row result in a GI (ie, a tage could mean ‘investigate further’ or ‘ignore’).Maybe I could create a user-defined field called “mark” and then could the end user somehow glag that UDF from the GI? 

How should we set up the Group/Sort Section to sort the report by Customer Account Name vs BAccountID?I went into the Build Schema, Looked at Sorting and Grouping, and tried to change the groupCustomer to CustomerMaster.AcctName Ascending vs CustomerMaster.BAccountID but I get the wonderful “We’re Sorry!” error... Edition: ConstructionVersion: 2022R2Thank you for your help in advance

I want o build a dashboard, how can I show the sales orders with credit hold 

We recently used Aatrix for W-2 processing but ran into an issue where many employees did not receive a mailed copy of their W-2. After investigating, we discovered an Employee Payroll Setting that enables consent for electronic W-2 filing on a per-employee basis.We have no idea how this setting was enabled for the majority of our employees or when it was introduced in Acumatica. Users don’t have access to modify this setting, and some employees who had it checked have never even logged into Acumatica.When we filed in 2024, this wasn’t an issue—everyone received a mailed copy. However, we can't find a clear pattern as to which accounts have this setting enabled.Does anyone have insight into how this might have happened?We are currently on 2023R2 - Build 23.209.0023.

 I am an Admin in Acumatica, and I need to update Access Rights by Screen frequently. Currently, I do this manually through the UI, but I want to automate this process.I attempted to use an Import Scenario, but I am facing difficulties mapping the tree structure of the Access Rights by Screen form. I couldn't find a way to properly set access levels for different roles using this approach.Has anyone successfully automated access rights updates in Acumatica?Is there an alternative method, such as using APIs or custom processing, to simplify this process?Any guidance or suggestions would be highly appreciated

Hi need help in this report because the data is duplicating and i need to add the tax id and taxrate on APTaxTran is there another solution tho this?

Hi all,Currently, my company has two branches. Previously, we had only one. My import scenario mapping is working, but after that, it continues to show an error. I checked all the branch settings in both the Customer and Customer Class, but the error still exists.My provider is a Generic Inquiry that pulls data from the Request screen (RQ301000).Pls advise me if you have any idea. Thanks in advanced.

Hey there everyone, Is there a way to connect a Google sheet into an Acumatica screen to get real time data?  

How hard is it to get to seeing the history of a field once the auditing is turned on. I am having trouble finding info on this.

Hello community,Hope someone can shed some light the the this issue that I am having.Trying to set the ‘Create Bill’ field to read only on the Purchase Receipt form, through the Access Rights by Screen form.However,  our attempts to change the access rights to from ‘Inherit’ to ‘View Only’ does not take effect as on saving it.  The higher level access rights setting, which is inherited by the ‘Create Bill’ object, is set to ‘Delete’. 

Hello - wondering if there is a way to create an attribute, selector type that looks at the GL Account table? I see it as an option to select but the actual account does not appear to be an option in the schema field. Only group, class, cury..   

One of our team has entered a prepayment into the Receivables Payments and Applications area.This was done in error, as no prepayment was received, so the entire transaction needs to be voided/deleted.If we simply VOID the entry/transaction. Will this eliminate from the customer Aging, as well as the General Ledger?  Our concern is what it might do to the customer history and aging.Thanks!

The Require Single Document per Document checkbox is not checked in AP Preferences.  I also cannot find any customization or business event that would populate the Project field on the header of an AP Bill.We have added the Project field (APInvoice.ProjectID) to the Bills and Adjustments primary list and here is an example of what we see:These four records happen to be for the same vendor and there are additional records with company WESTMIN that show Project X.The Detail line for both of the LPC bills has an active Project.  We are on version 23.210.0017.If anyone has an idea why or how the Project in the header is being updated, please respond.

HOW KNOW WHAT ITEM IS IN A CONTAINER

Hi Everyone,We’re in the process of onboarding acumatica platform company-wide and I would love to hear from those who have successfully implemented similar rollouts. We are nervously excited. We are a small business roughly 100+ employees Operations, Wearhouse, service etc. Specifically, i am interested in any best practices, challenges to anticipate, and any insights on training and adoption strategies.If you’ve gone through this process before, i would really appreciate any lessons learned. Looking forward to your thoughts!Thanks in advance,

Hello,One of our people posted an AR payment in the wrong amount (I surprised the system didn’t give a warning that the payment amount entered did not match the AR invoices loaded). Then he did a payment void but did that to the wrong period. So I am looking on how I can fix that so the GL matches the subledger. I can’t reclasify the batch because that does not correct the AR subledger. I can reverse the Journal transaction but again that only address GL and does not correct the AR Subledger. This is the second type of mistake that has been made that I have essentially been told “sorry once its released it can’t be fixed” which does not seem correct. So thought I would reach out to the community.  Thanks

I am needing to clear our entire AP subledger. I am testing the most efficient way to do this and initially thought I would create a new Cash Account (Clearing Account) and Payment Method for this purpose. My goal was to issue a mass (dummy) payment against all invoices which would get posted to the new cash clearing account, as it is not a real payment. I have everything set up but when I open Prepare Payments, the cash accounts do not appear in the dropdown once I have selected my Payment Method.You can see that these cash accounts appear under this payment method:The payment methods also appear under the Cash accounts - example below:Any idea why these don’t show up in drop down? Is there a different approach I should be taking for clearing out the AP subledger then doing dummy mass payment?

I am trying to set up and activate customer contracts via import scenario using the import scenario below but I’m getting an error. What is missing?The contracts have already been created and I’m just trying to run the set up and activate process. 

I’ve created a Sales Order and assigned it to a Project. At the line level, I have both Stock and Non-Stock Items, each assigned to a Project Task. The invoice has been successfully processed for the Non-Stock Items. However, I’m unable to process the shipment for the Stock Item with quantity and zero value.The issue arises because the system doesn't allow stock allocation, showing that the quantity will go negative, even though there is enough available for shipping. This only happens when a Task ID is assigned to the line item. Without a Task ID, it doesn’t allow saving or shipping, as the Sales Order is associated with a Project.Can anyone help me understand what I might be doing wrong or missing in this process? Appreciate your expertise!

Hi,I have created few custom fields on Invoices form and allowed them to update through the code. then added them to the workflow to set them as editable at any time.below is the DAC field and the extended graph code. // DAC field public class ARRegisterExt : PXCacheExtension<PX.Objects.AR.ARRegister>{ #region UsrBillStatus [PXDBString(4)] [PXUIField(DisplayName = "Bill Status", Enabled = true)] [PXStringList( new string[] { BillStatus.WorkInProgress, BillStatus.BillAtProduction, BillStatus.BillAtSubcontract, BillStatus.ForwardToFinance, BillStatus.PaymentReceived, BillStatus.ReturnToProduction, BillStatus.JobDeleted }, new string[] { TextValues.WorkInProgress, TextValues.BillAtProduction, TextValues.BillAtSubcontract, TextValues.ForwardToFinance, TextValues.PaymentReceived, TextValues.ReturnToProduction, TextValues.JobDeleted } )] public virtual stri

We have a request from someone who would like an SQL backup of their data to give to an analyst to run Power BI on it.We will be doing a backup in SQL Server Management Studio, and FTPing a .BAK file.We don’t want them having access to any of the customizations that we have written and published. So, we need to remove them from the SQL Server database. Where do I need to go to scrub all of the published data. I know I need to remove any usr field we have added. I already have a script for that. I need the rest of it.Just looking in the database file, I see:CustProject which has a structure of:      [CompanyID]      ,[ProjID]      ,[Name]      ,[IsWorking]      ,[Description]      ,[CertificationStatus]      ,[CertificationWarning]      ,[CertificationStatusDateTime]      ,[DevelopedBy]      ,[Hash]      ,[CreatedByID]      ,[CreatedDateTime]      ,[LastModifiedByID]      ,[LastModifiedDateTime]      ,[ParentID]      ,[tstamp]      ,[Level]      ,[NoteID]      ,[SnapshotID] But that doe

This is how the report looks like when I run it now:  I’m trying to get the report to run without duplicating the header of every inventory item separately. I had previously grouped by first the Vendor, and then grouped them by inventory ID so multiple purchases of the same product sums up and we see the total amount.  How can I remove the header from showing up before each inventory item?

I'm overriding the Persist method in the Invoices and Memos (AR301000) screen.  I'm using a foreach loop to update the unit price of an item. However, the loop is executing twice, resulting in incorrect calculations.  The values before calling baseMethod() are correct, as verified using PXTrace.  Therefore, I suspect the issue occurs during the execution of baseMethod(). I've tried various approaches to resolve this, but none have been successful. How can I fix this?Any detailed instructions, tips, or code snippets would be greatly appreciated. Thank you! [PXOverride]public virtual void Persist(Action baseMethod){PXResultset<ARTran> TransactionLines = PXSelect<ARTran,    Where<ARTran.refNbr, Equal<Required<ARTran.refNbr>>,    And<ARTran.tranType, Equal<Required<ARTran.tranType>>>>>    .Select(this.Base, currentView.RefNbr, currentView.DocType)                var multiplicationFactor = contractExt.UsrAdjustmentDays //Custom field where use

​Hi everyone,I'm experiencing an issue with the french translation of a field I added using a DAC extension. I thought I had done everything right, but my implementation isn't working (the english term is displayed instead of the french one) and I can't figure out why.Version : Acumatica 24R114. 1°) The Field declaration in its DAC : #region CegEStatus[PXDBString(50, IsUnicode = true)][PXDefault(PersistingCheck = PXPersistingCheck.Nothing)][PXUIField(DisplayName = "Electronic Status", Enabled = false, Visibility = PXUIVisibility.SelectorVisible)][EIStatuses.List]public virtual string CegEStatus { get; set; }public abstract class cegEStatus : BqlString.Field<cegEStatus> { }#endregion 2°) EIStatuses list attribute configuration    public class EIStatuses    {        #region Constants        /// <summary>        /// Published when the invoice has been uploaded to eFacture        /// </summary>        public const string IUploaded = "100";        /// <summary>      

Hello Acumatica Community,I am working on a customization where I modify the InventoryID field in INTran. The customization works fine on the Transfer (IN304000) screen, but when applied to Receipt (IN301000) and other screens, the InventoryID selector appears empty.Here is my code:[PXNonInstantiatedExtension]public class IN_INTran_ExistingColumn : PXCacheExtension<PX.Objects.IN.INTran>{ #region InventoryID [PXDefault()] [StockItem(DisplayName = "Inventory ID")] [PXSelector(typeof(Search2<InventoryItem.inventoryID, InnerJoin<InventoryItemCurySettings, On<InventoryItem.inventoryID, Equal<InventoryItemCurySettings.inventoryID>>>, Where<InventoryItemCurySettings.dfltSiteID, Equal<Current<INRegister.siteID>>>>), typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr), SubstituteKey = typeof(InventoryItem.inventoryCD))] public int? InventoryID { get; set; } #endregion}Ques