Solved

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

Dear ALL,How to process a "Purchase with immediate payment" transaction without posting to the "Accounts Payable" account? Best Regards,NNT  

I see how to change labels on actions at this topic:However, buttons in the grids don’t show on the Actions menu.I am trying to abbreviate some buttons on the SO Grid because the Biz-Tech buttons get pushed to the right and don’t display without clicking the down arrow on the grid menu.  I tried changing the text in the project editor, but the change does not “stick”.Do I have to override the action in VS and change the label there?  

Hi everyone , I’m seeking help for this issue to balance our Profit and loss Report In our Inventory Preference their is one Reason code only for Return and issue including the transfer so every time we do a transaction for  ( return , issue , transfer  ) only one GL account  is allocated for this transaction , so the Debit and Credit keeps up when call the ending balance in our report  The problem is we can set only one GL Account in Inventory Preference  for Issue / Return / TransferHow to de we fix this ? Thank you Acumatica Family 

Hi all,I’m calculating labor cost for a generic inquiry using this:=Round( CInt( [AMProdTotal.ActualLaborTime] ) /60.00 , 2 ) * 47.33But, I would like change that default rate if the following user names are true:=iif(InStr([CreatedByUser.Username], 'barcode')>0 or InStr([CreatedByUser.Username], 'slitter')>0, Cint([AMMTran.LaborTime]), 0)Is there a way to say, labor rate is 94.66 if username contains “X” or “Y”, otherwise labor rate is 47.33? Also, I’m trying to calculate the labor time here based on username, converting the minutes into hours, but I have this messed up! (probably the parentheses!) Any ideas?Thanks for any input!

Is it possible to configure a user to block the release button in transfer process?

Hello,I noticed that various instructions, including the latest 24R2 developer release notes, specify that the URL for the generic inquiry-based OData interface is:<Acumatica ERP instance URL>/t/<TenantName>/api/odata/giThe I300 university video and the only way it works for me is:<Acumatica ERP instance URL>/OData/<TenantName>/<giname> The latest help.acumatica.com article specifies using the /api/odata method as well, even though I have never seen that work.Thanks! 

I have couple customization where in some I have the code base and others were published by old employee. I dont have access to those code. Is there a way to combine mine with other just by dll files?

We’re setting up the Customer Portal for one of our customers, and we want them to be able to choose from some of the Sales Order Order Types. Adding the SO type was easy, but now the customer has access to all SO Types. We want there to be some internal Order Types that the customer can’t select. Is this something that can be added? Would it be in the Order Type page or the Customization Projects?

Only some of our users are seeing this message. Is there a permission or something that throws this notice up? Thanks in advance.

I have an ARPayment object that has an PMInstanceID but this is an integer.  How do I retrieve the CardAccountNbr as shown on the Payments and Applications (AR302000) page? 

I completed the T210 course and proceeded to apply it to a real world use case where I need multiple custom fields attached to a specific class of Customer.  Rather than the user field approach, which will enhance Business Account and extend those fields to all related entities using the shared DB table, I want to use a custom table to limit the storage to Customers only. It doesn’t seem to work on Insert though.  Is there something additional that needs to be done to insert a new record in a custom table from a graph extension? I don’t remember doing that in T210 for the custom tab on the Stock Items screen. I have the PXDBDefault and PXParent attributes assigned.  Aren’t they supposed to facilitate insertion as well as other operations? On Create, with an explicitly assigned Customer code, I get the error “BAccountID can’t be null”, but if I manually insert a record from SSMS after create, everything works fine.What did I miss?  Thanks.Here is the start of the DAC definition:using Sy

Is there a way to set the Activity screen to not have the "Track Time and Costs" and "Billable" check boxes marked when creating a new activity from a project?  We would like to have it that the user would have to check the boxes if they apply instead of them automatically being checked to start.

Hello,Is there a way to set the “Export” button on screen AP305000 to only work one time? Long story short, we accidentally sent duplicate ACH files from our system because that button was clicked again after the ACH file had gone out. I have a feeling it can be done with a customization project, but wanted to check in with the community first.Thank you,Justin Long

When I go to our Storage Details By Item Warehouse Location GI I initially get a list of all of the stock items as seen below But when I filter by warehouse, no stock items are found. II think the GI just got edited and messed up I wasn’t sure if there is an easy way to get the default settings for this GI?

What happened to "SELECT ON MAP” functionality? We just upgraded from 2023 R2 to 2024 R1 and the “SELECT ON MAP” button has disappered. We now have only “VIEW ON MAP”, which does not verify addresses as "SELECT ON MAP” did. 

Hi Community!Anyone else having trouble publishing the lot serial attribute github customization for 24r1? I’ve been using this customization for years but not I’m getting this error when trying to publish: Error during file upload: Object reference not set to an instance of an object.This is for 24.104.0008

Is there a way to retrieve a stock item that was deleted in error?

When creating an email activity off of a Case record, an error is returned. Email cannot be saved or sent. When attempting, the following message displays: "An unhandled exception has occurred in the function 'MoveNext"." trace log exception message: "Object reference not set to an instance of an object". It is happening on every case currently.  

How will i edit this info Attention without overiding?