Solved

While trying to get the Inventory ID and transaction description on the pivot table, we noticed that when the fields are added to the Values section, they are displayed as numbers in the pivot table.    The fields work fine in the other sections of the table except for that particular one. Any thoughts?  

In 21R2, I had created a small customization project to handle UI tweaks. One of these was to alter the grids on GL40.40.00 and AR40.20.00 so that they would generate 200 records at a time which could be scrolled through, and the rest could be accessed via paging. I accomplished this with these settings on the grid. AdjustPageSize: ManualAllowPaging: TruePageSize: 200 After upgrading to 23R1, these settings no longer work, and AllowPaging appears to behave like a mutually exclusive switch between paging with auto page size and scrolling with manual page size. Is this just the new behavior of these settings? Are scrolling and paging not allowed simultaneously anymore?

We just upgraded to the latest acumatica version R1 2023 and the StoragePlaceStatus status table is now obsolete.   I need quantity info from table for one of our generic inquiries.  Does anyone know which table may now contain that datafield that I am looking for.  Or is there a map available somewhere of the tables?

Has anyone deployed the Service Orders management screen to the Mobile App?  Are the any code snippets available for this?

Hello everyone!, I hope someone can help me 🙂I have to change the label of a button, but I realized that it does not change the Translation Dictionary. Does anyone know another way to do it?

how do you manage old customization (delete them or keep them in Acumatica for a certain period of time before deleting) We have many customers with customizations that we no longer use, for the sake of organization my team wants to clear these old customizations from the Project Screen and delete them. Is this common practice?

Hello everybody,is it possible to restrict a certain user that he/she can only DELETE files that he/she have created herself? As of now, I know only the option to restrict a user to not delete any file (no matter who created it).Many thanks in advance!

Through web api not able get vendor order by LastModifiedDateTime.

I have few customizations. I’m wondering why my Fields and Conditions in “e2SOCostCodeAndDepartment” are not reflecting. Maybe because I have another Customization for Sales Order after that? Here’s my customization:Here’s After it: 

Is there a process to reverse and apply debit for multiple AP bills as once ?

 I still can’t write off an AR balance after I have enabled write-offs for a customer,. What suggestions do you have?   

Hello, in Sales Order GI, the customer CD and Customer Name are displayed from the SOOrder Object.Object:SOOrder and Data Field:CustomerID this gives us customer cd, but when we use same in if condition it is giving us customer DB ID. Can someone please help us. We know we can join BAccount table but can i get customer cd without joining BAccount table.=IIf([SOOrder.CustomerID] >0 , [SOOrder.CustomerID], '0') here the result is Customer DB ID

How system takes promise date for planned production orders in MRP Detail Inquiry. I would like to know in three different constraintFinishes on Starts on User Entry We take for an assumption 6 working days as manufacturing lead time. How system takes promise date for all the three scenarios. 

Performing a timecard correction, because the labor Item was incorrect. The appointment show the corrected timecard number, but the labor item was not corrected in the appointment. It should be the corrected labor item per the timecard, reflected on the appointment to cost at a different labor rate.

I have created a button on the Opportunities (CR304000) called 'Convert to SO’ which converts the current opportunity to a Sales Order. I would like to move the button to the Action Menu > Record Creation, how can I do it?The Acumatica version I am using is: 23.105.0016 (2023R1)  

Hello All,   Does Acumatica have the capabilities to process indirect purchase orders?Completely separate form BOM tied items which would fall under direct BOM tied purchase orders? R&D/NPI  vs. Sustaining/Released into Production  Current issues with my R&D, non-stock, NPI department and materials issuing or receiving and stocking their items since they are not in final stages of the sustaining process.Same question with Work orders  and materials.  

Hi,I need to get all the contact emails related to the customer from the GI.When I join the customer and contact table GI is showing like that.Above customer has 5 contact emails. I need to show all 5 contacts as a list (not 5 rows only 1 row).ex: 1st email,2nd email,3rd emailHow I do that ?

When I create unit tests, I reference PX.Tests.Unit.dll, but always have this error.although I don't use this 'Microsoft.Bcl.AsyncInterfaces’. Is there any good way to solve this problem?“Could not load file or assembly 'Microsoft.Bcl.AsyncInterfaces, Version=1.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)”  

Hi, I am creating a GI and meet some problem on parameter.Here are my parameters requirement:No of PO (counted nbr, not ref nbr)I am using COUNT at the aggregate function and grouping the record with vendor, the result of the ref num will become counting how many PO of the vendors.  My question is how can I make the parameter to filter the counted number but not the ref number? attached with the GI XML, thank you.  

Hi,in quick checks, we have a report called payment voucher. in a case like this the report works fine But, as soon as the numbers increases by one 0, the report wont work. ex now the Amounts are 4,000,000.00. if those numbers are 40,000,000.00 the report wont work. does anyone can help me on this. i’m attaching the rpx file here as wellThank you. 

Hey All hope everyone is having a great weekend! i’m struggling with this Request i’m trying to make toGET: /ProjectTransactions,  i want to get ProjectTaskID or ProjectID  but when i added it i get this error {\"message\":\"An error has occurred.\",\"exceptionMessage\":\"GenericArguments[0], 'PX.Data.FieldNameParam', on 'PX.Data.Current`1[Field]' violates the constraint of type 'Field'.\     Thanks

I wanted to change a PXSelector attribute on a DAC field to Fluent BQL syntax if possible in order to include a subquery. Is there any way to do a Fluent BQL equivalent of PXSelector that you know of?

Sometime Acumatica performance start slow in one  or two client Computer. I check those Computers everything went well except Acumatica.

Looking for a way to decrease the length of the SOShipLine.InventoryID_description field on a pick list.  Currently prints the entire value (up to 250 characters but only want it to print the first 50 characters.  Have “Can Grow” set to False. 

 Hi,I did a process to create a PO from a SO in the Sales Order screen. It works a bit different than the current create PO process where you specify the vendor details on the SO line and create the PO by clicking on an Action.The problem I have is when I call thePOCreate.CreateProcI don't get any exception that there was an error creating the PO. I only see the error afterwards in the Trace.PXLongOperation.StartOperation(Base, delegate () { try { POCreate.CreateProc(list, poFilter.PurchDate, poFilter.OrderNbr != null); } catch (PXRedirectRequiredException ex) { // Acuminator disable once PX1050 HardcodedStringInLocalizationMethod [Justification] // Acuminator disable once PX1051 NonLocalizableString [Justification] throw new PXException(ex.Message, ex.InnerException);