Solved

Hi, I have customized the Inventory Register Detailed Report and no additional joins have been added on my end, but there is a duplicate line being printed on the report, this happens in the original report as well. How can I modify it to not print a duplicate line?Transfers Form has 2 recordsOutput has 4 lines  

Hi,I am still green to creating Generic Inquiries. I am trying to create a GI that displays the total inventory Items including qty and amount for each customer invoice. Then from there I am going to create a dashboard that shows the top selling items for each inventory item by qty. Here are screenshots for my total setup. How can I get the Customers Invoices to consolidate/filter correctly in my GI? Let me know or what conditions/settings I am missing? I have also attached an export of the GI if needed. Thank you,Frances Pantelidakis  Screen 1 Tables Setup: Screen 2 Relations Setup: Screen 3 Sort Order: Screen 4 Results Grid: Screen 5 Output of GI:  

I have been building some customization around the Add Items (Inventory Lookup) functionality of the Sales Order Entry screen. The query that populates the Add Items grid is located in the SOOrderEntry.cs class, and is a PXProjection (see code below). I’m adding it here because it took me a long time to find where it was located, so maybe this will shortcut it for someone else in the future. What I want to do now is to use the PXSubstitute functionality to override this query, so that i can populate that grid with my own data coming from a different source. However, I can’t find any mention of the PXSubstitute functionality in the Acumatica Framework Development Guide anywhere. The first link I reference below even gives a page number (95) in the Framework Development Guide, but I don’t see PXSubstitute anywhere in the development guide, including page 95. Can anyone point me to a reference for PXSubstitute? Latest customization guide...https://acumatica-builds.s3.amazonaws.com/builds/

Hello,The scheduler could schedule a production order late if either materials are unavailable or if needed capacity does not exist.Is there any audit GI or report available so you can check why a production order was not scheduled when it was needed?Thanks,Larry

I have a GI that seems to keep defaulting to a value when i have no default value set. The report works however its just annoying to have to change the value every time We really dont use the “stocked” class for much.  This is what I want This is what I get every time ..  Here are my ParamsAnd Conditions As you can see I don’t store anything as a “default” value.

Can I customize the following print action in this screen ? If yes then how can I do it. Please help. I cannot find any view or DAC in this page.   

I am trying to fetch value from DB in FieldDefaulting event but the value is not reflected in the UI.This my code in graph extension.protected void SOShipment_UsrPickListPrintNumber_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e) { var row = (SOShipment)e.Row; SOPickingWorksheetReview tempGraph = PXGraph.CreateInstance<SOPickingWorksheetReview>(); SOPickingWorksheet txsetup = PXSetup<SOPickingWorksheet>.Select(tempGraph); SOPickingWorksheetExt rowExt = PXCache<SOPickingWorksheet>.GetExtension<SOPickingWorksheetExt>(txsetup); e.NewValue = 100; }DACExtension#region Virtual fields [PXInt()] [PXUIField(DisplayName = "# of times Pick list printed", Required = false, Enabled = false)] public int? UsrPickListPrintNumber { get; set; } public abstract class usrPickListPrintNumber : PX.Data.BQL.BqlInt.Field<usrPickListPrintNumber> { } #endregion 

HiLooking to figure out which REST API I can use to update/amend the substitution lists.The swagger.json at the top level isn’t showing me much helpI can subaccounts but not substitutionsIdeas?  

Hi guys, I wonder if there’s a way to set view restriction on project tasks? Like for some employees, they could only see part of the tasks in a project; but the others could see all the tasks. Anyone has any idea? Thanks a lot!

2021R2 version.  We receive an EDI 850 from our customer.  Through True Commerce APIs, we create a sales order in Acumatica.  Later, we receive an EDI 860 change order from our customer.  Our business does not want this change order to be automatically applied to the existing sales order in Acumatica.Instead, our business wants us to generate an exception report that lists the content of the 860 (e.g. header info, line item data) and generate exception messages where the 860 change order is different than the sales order on Acumatica.  For example, provide exception message that the line item quantity changed, or that a new line item was being added to the sales order.  This exception report would go to the customer service rep., who would review the changes and manually enter them on the Acumatica sales order if accepted.  Has anyone already built functionality that creates custom change order tables (header, lines, notes), and then matches this to the sales order already existing on

Hi, I am doing a GI to show the GL accounts for NonStock Items.The NS Items are tied to a posting class. The posting class can use the default of Inventory Item (I) or Posting Class (P) I am trying to get the GL account to be in one column. My data field looks like this: =iif ( [INPostClass.InvtAcctDefault]='I', [InventoryItem.InvtAcctID], [INPostClass.InvtAcctID])The GI is returning 2037 instead of the GL#, 11302. Is there a function or a way to get the 11302( The GL from the chart of accounts) to display? Thank you, Bill 

I have a request from a client to delete all “Canceled” Service ContractsI tried adding a delete button to the Service Contracts GI.This resulted with: Error: The record cannot be deleted. Different approach: I tested using a SQL DELETE in my local Acumatica instance database.to bulk delete all existing Service Contracts that have a status of “Canceled”                  DELETE FROM [FSServiceContract] WHERE Status = 'X'This appears to have deleted all the Service Contracts that have a Status of “Canceled”, which is what the customer wants. Note: This SQL approach does bypass business rules in this module. Question: Is there a better (preferred) approach to deleting Service Contracts that have a Status of “Canceled”?My customer requests:Bulk delete all of the Service Contracts that have a status of “Canceled”. Give them the ability to delete Service Contracts that have a status of “Canceled” on their own.Thank you in advance.Ken Severud   

We would like to be able to restrict users to a single warehouse.So the user would only be able to ship and receive in their assigned warehouse.Is this possible?Thanks!

We are experiencing integration error regarding Tax Detail ID’s between Celigo and Acumatica.  It seems that Acumatica cannot find a match for the Tax Detail ID being passed from Celigo which is causing the errors.  This has been working fine for the past 2 years and the issues started in early to mid April.  Celigo and Acumatica claim that there have been no changes made on either side to cause this to stop working.Is anyone experiencing this as well?

Can the ATTRIBUTES section of the Item Classes screen be extended downwards to fill the screen.

Hello,I have a SOLine custom field with PXSelector, how can I rename the column Customer Price Class to Price Code inside the selector?   In Sales Price screen (not customized), its name was Price Code. I already tried using ARSalesPrice.priceCode in the code, but it shows empty value. Here’s my code, 

I was wondering if there’s a way to create a matrix of Environmental Handling Fee being added to the Sales Order (or Sales Invoice) when certain Stock Items are selected based on the State value of the Shipping Address.Tried with fixed tax (doesn’t work for Qty other than 1) without a success.Pointing to a certain direction in setting such functionality would be gratly appreciated. Mike 

 This user access to support has been granted, but when I login as this user I still can’t create activity to reply the customer case. 

Is there a way to reset the cash account beginning balance when there are existing transactions already in the system for that cash account?If so, could it be reset without posting to the GL?Thank you

While trying to clean-up books, cannot get journal transactions booked to cash account with different subaccounts than defined on cash account. Read that cash account is one-to-one relationship with subaccount, so saw that solution may be to create new cash accounts with the not defined subaccount to clean-up, but concerned that cash account configuration has not changed yet we have transactions that are said to be impossible and are now erroring after upgrade to 2021R2. How could this have happened?

I am looking for a report that can show all union deductions and hours for all union employees for a specific time period(normally by month) to generate for employee dues payments.Wondering if anyone has created such report.  I have three different unions that I need to report employee hrs and deductions/contributions per month.  Is this something I can create with a GI?would want totals by employee and by deduction/contribution. 

I want to set up a notification that for a group of users that MRP successfully completed. What is the best way? by best I  mean easiest.

Hi everyone. It seems we get a decent amount of orders where the ship-to addresses are incomplete. That causes to notify CS. Then CS digs around by either finding a previous order or reaching out to the customer.Then we'll be sure to edit the customer account in acu/bigc. Just slows the process down in general.It's been discovered these only have a street number.We think it has to do with the customer using an autofill feature (browsers unknown), but not selecting the full address choice. Maybe just hitting Enter and moving on quickly. Just a theory.Any thoughts?Thank you.

When doing a labor transaction in the “Employee ID” field can I create or have a labor group instead of recording time for individual employees ? I

The Email Notification Template for Sales Orders that is being pulled is not the one we have setup in our system. It was working fine around 2 months ago and no known changes were made. I have verified that the Report Settings under Sales Order Preferences is set to the correct notification template and is “Active”. None of the notification templates that we have setup regarding Sales Orders use the wording that is pulling up now. It is not a customer specific issue - it is happening across the board. Any other ideas of where I can look to get this fixed?