Solved

Hi all, I am trying to build a generic inquiry to show all the inventory items regardless if it has transaction history however I am getting multiple result by inventory ID but when I tried grouping it with inventoryID I am losing inventoryID that do not have transaction history. The ff are my main DAC I used:PX.Objects.IN.INItemSitePX.Objects.IN.INItemSiteHistDayPX.Objects.IN.INSiteStatusPX.Objects.AR.ARTran I have also attached the extracted GI incase anyone of you have any input how to make the inventory ID unique in the result. Thank you.   

Hey Acumatica community!We are planning to move to Acumatica 24r2, and I just notice some of my filter settings with @me is not working anymore, which used to work on the Acumatica 23r2. Does anyone knows what changes on the filter setting? 

How to keep show header if data subreport in page 2?Invoice is subreport page 1 Page 2

I am trying to add a column to the GI for the Inventory Issues screen. I just want to  add the Project ID so that I can filter on it. I have tried adding what I have thought was the correct table, but it is not pulling the information. This is the screen I am referring to:When I select an Issue, I want to following column to show up on the first screen:Please help!

I have a GI that is pulling another GI in as a data source.  Both GIs have a similar Formulated field that is just the code for the month.“=Year([SOOrder.OrderDate]) * 100 + Month([SOOrder.OrderDate])” which should return something like this: 202506  meaning 06 2025 (June). And they both do this on their own correctly.  But when I try to bring the other GI in as a data source, the formulated field is not an option in the relations tab which I believe is normal, so I re-enter the expression into the active relations:=Year([SOOrder.OrderDate]) * 100 + Month([SOOrder.OrderDate])   equals  =Year([AMBatch.CreatedDateTime]) * 100 + Month([AMBatch.CreatedDateTime]) But for some reason, the system can’t find [AMBatch.CreatedDateTime] as an actual field? Which doesn’t make any sense because I can pick the [AMBatch.CreatedDateTime] as a field by itself, but when it’s in this expression it cannot find it?  The idea for this is, I want to have a simple GI that is grouped by month, with a column fo

How to set parameter from relation?in report designer for now customer location id showing all data but I want filtering data customer location ID from customer ID.please help me, im stuck 

I am attempting to debug some base Acumatica code, but I am receiving a message that the breakpoint won’t be hit because “the current source code is different from the version built into PX.Objects.dll”,. I have seen similar posts for 23r1 versions of Acumatica, but I am on 2023R2 (Build 23.211.0017).I have copied the PDB files from Files/Bin to my instance folder but without success. Furthermore, if I disable the option to “Require source files to exactly match the original version”, while the breakpoint is hit, I cannot step through the code and the lines do not appear to match (i.e. variables are not present in the “Locals” tab nor available for watching when they should be).What might the issue be? 

HiI want to add a segment value using apiI added the screen, and I am able to pull exiting data. I now want to add a value on the segment value  

Attempting to import item classes and I am getting a “Value cannot be null. Parameter name: Key” error. Any idea what may be causing this error?

I have a custom non-persisted field defined on the CRQuote DAC:public class usrDays: Constant<string> { public usrDays() : base(" working day(s) to ship") { } }[PXString(60)][PXUIField(DisplayName="Lead Days Description")][PXFormula(typeof(Add<CRQuoteExt.usrRevLeadDays, usrDays>))]CRQuoteExt.usrRevLeadDays is:[PXDecimal(0)][PXUIField(DisplayName="Lead Days (Rev)")][PXDBCalced(typeof( IsNull< CR.Standalone.CRQuoteExt.usrLeadDays, CR.Standalone.CRQuoteExt.usrRevLeadDays > ), typeof(decimal))]usrDays is a string, as defined above. I want to concatenate the decimal and the string in the PXFormula. I have tried many combinations of Add, Concat, Use, and have not been able to get these fields combined. The current configuration publishes, but when I try to load CRQuotes, I get: System.FormatException Message: Input string was not in a correct format.  I cannot find any examples of casting types, or combining strings with

 Good morningI'm sure this will be an easy fix, but I can't seem to find it. Our payslips currently go out addressed as below.... Dear SURNAME, First name I would prefer it to show as  Dear First Name,  is this possible? thanks

An employee accidentally delete a customer from the receivables. How can I recover that customer?  

Best regardsIs there a possibility within report designer to let them know a Record Per page amount to process?since at the time of running it takes longer than estimated and that it is harming the operation the amount of time that is taken to upload the data.  

Acumatica RQRequisition.Status defines Closed status as… Closed: Reflects that the requisition was fulfilled and the requested items were received. The requisition gets this status if the order quantity is zero for all items in the requisition. However, my test requisition is still in Released status even after receiving the purchase order that is linked. I went as far as creating the Bill and Releasing it. I also made sure that the linked Sales Order is shipped, created Invoice, and Release AR Invoice. I feel like I’m missing something, does anyone have any ideas?  

How to add Extended DAC Field in the Sales order screen Payment tab Create Payment popup (Smart Panel) in the Modern UI tried with below codeTS fileimport { PXView, PXFieldState, PXFieldOptions } from "client-controls";import { SOQuickPayment } from "../../common/panel-create-payment/panel-create-payment";export interface SOQuickPayment_customfields extends SOQuickPayment { }export class SOQuickPayment_customfields {    UsrPSSOCashTaken: PXFieldState<PXFieldOptions.CommitChanges>;    UsrPSSOCashChange: PXFieldState<PXFieldOptions.CommitChanges | PXFieldOptions.Disabled>;}HTML file<template>    <field after="#QuickPayment_CreatePaymentFormLayout0 [name='CuryID']" name="UsrPSSOCashTaken"></field>    <field after="#QuickPayment_CreatePaymentFormLayout0 [name='UsrPSSOCashTaken']" name="UsrPSSOCashChange"></field>    </template> 

I have a client with multiple companies in one tenant.  While you can pull an ARM report for Company A while you are in Company B, the header information displayed is still for Company B.  What is the correct formula to display the selected Company Id instead of the current Company you are in?  The default formula is:=Report.GetDefUI('RowCompanyBAccount.AcctName') 

My customer asked me to show the Shipping Address Line 1 and line 2 in a new 4th column in the header of the Sales Order screen.I created two unbound string fields to store the values from the Addresses tab (shipping address info).Even using the “nuclear” option of the SOOrder RowSelected handler, the values will not show in the custom fields.In debug, I can see the values being set correctly in the custom fields, but when the screen displays, they are empty.I don’t think it is possible to do this using PXUnbound in the DAC extension because I need the custom fields to be updated if the user overrides the address lines in the Addresses tab.I tried to do the update after the RowSelected handler has been invoked, but that didn’t make any difference.  Here is my DAC:public sealed class GTSOOrderExt : PXCacheExtension<PX.Objects.SO.SOOrder>{ public static bool IsActive() => true; #region UsrShipAddressLine1 [PXString(50)] [PXUIField(DisplayName = "Ship Address Line 1", Enabled = f

We had to backdate a payment to our customer’s account.  After posting, we realized we had entered the amount incorrectly (the handwriting was difficult to read) so the payment was voided.  Unfortunately, the payment was posted in May but the void was posted in June.  As a result, the May statement balance is not correct.  Is there a way to correct this?  

We add one custom column call “Brand” in stock and non stock item.InventoryItemExt.UsrBrand is the extended DAC (free text field). In Details tab of Appointment screen (Screen ID: FS300200)  we have a selector for Inventory Item.I wants to add Brand column in above popup box.I try with “PXCustomizeSelectorColumns” and “PXSelector” but it replace all column.I wants to keep all columns as it is and append one more column as brand.I check code and found that “InventoryIDByLineType” attribute is used. But I cannot get how can we add one more column in it. And I cannot get original logic for all above columns otherwise I can copy paste and change. 

Is it normal that we do not have any verification or notice when we create manually an equipment for a service call (serial number already exist… change the owner...already exist with another description or code, continue)?As example, we create a new equipment manually with serial number, but this equipment already exist for same owner or was register with previous owner. and system let us create the same equipment twice without any notice or verification.Is there any option that could be activate to have any kind of notice?

Hello - Any idea on how to handle aggregating information/notes from techs across multiple appointments?  We have situations where one tech may go the first day on one appointment and then two days later a different tech would go on a different appointment (to the same place) and needs to be able to see the notes/information that the first tech did?

I followed the instructions from this Acumatica help page: Access to Budget Nodes: Implementation Activity A client of ours uses their subaccounts for their departments and I’ve configured a budget node for each subaccount. Each node contains leaves for each Account-Subaccount combination they budget for. I then created a restriction group (Group Type A) for each subaccount and added the respective budget node to each restriction group. I then added the 2 users for the 1000 subaccount/budget node to the restriction group. When I sign in as other users, I’m still able to view the 1000 subaccount/budget node and edit it. It was my understanding that adding users on the GL Budget Access screen would make it so that only those users would be able to view that budget node. Do some roles override restriction groups? I don’t understand what’s going wrong, any help would be greatly appreciated!

Hi, a client is running 23.210.0017 and is having a strange behavior in PO entry: The default project (X) disappears from the field when a GL account associated with an Account Group is entered in the Account field. In production, when the project is put in again, the subaccount field empties and has to be reentered to get all three to be complete. If a valid project is entered, no issue. If a GL account unassociated with an account group is entered, no issue.I ran it in a local instance with no customizations published and the only change was the subaccount didn’t disappear.We tested it in an more recent instance with sales demo data and it didn’t occur. I don’t know if it’s a config issue, or a glitch?

We do a lot of service work where an appointment might branch more than one day and warrant a return visit.  In addition to that, it might not always be the same technician returning to complete the work so we need the notes/documents to roll forward.What is the best way to schedule a service order for multiple days?  Consecutive days and nonconsecutive? And what is the best way to get all the notes to aggregate so a tech can see what all was done before him?