Solved

Hi, We wanted to create a GI to get the inventory in and out details for a given time period hence we created a GI joining PX.Objects.IN.INTranSplit and PX.Objects.IN.INTran tables. Inquiry title is Inventory Transaction History Inquiry.Then we gave start date and end date parameters using the release date in InTran table.The end date parameter seems not working properly. For example, if we give the end date as 3/31/2022 the data shows only up to 3/30/2022. Is there any reason behind this behavior or have I not set the GI in a correct manner? Please assist me. Best Regards Amanda  

Hello Gang, I was wondering is there any way to freeze a few columns of the DATA ENTRY grids on the left to always have them visible to the user when scrolling to right/left and we have many columns? I tried through Css but couldnlt find “Frozen” or similar property for it.Something like as Excel freez pane I’m looking to simulate in Acumatica

In order to get the volume discount from the Vendor we have to place a single PO with max Qty . In the case of Purchase Requisitions system is treating it as a separate channel for creating a PO. Is there any option to add the  Purchase Requisitions to Include in MRP so that PO will be created with max Qty to get max volume discount ?Please correct me if I missed anything ?  

Is it mandatory to get ISV Partnered in order to start any development/customisation in Acumatica?Thanks.

Hello,I am attempting to Release a Pro Forma Invoice and I am receiving the following error message “This document is already released” which seems to be incorrect because if it is released it should have the closed status. Has anyone seen this similar issue? currently using Acumatica version 2021R2. Thank you,KT

We would like the warning dialog when changing the customer class to default to No rather than Yes.  I have looked at the code and found where it is defined:protected virtual void Customer_CustomerClassID_FieldVerifying(PXCache cache, PXFieldVerifyingEventArgs e) { Customer row = (Customer)e.Row; CustomerClass cc = (CustomerClass)PXSelectorAttribute.Select<Customer.customerClassID>(cache, row, e.NewValue); this.doCopyClassSettings = false; if (cc != null) { this.doCopyClassSettings = true; if (cache.GetStatus(row) != PXEntryStatus.Inserted) { if (BAccount.Ask(Messages.Warning, Messages.CustomerClassChangeWarning, MessageButtons.YesNo) == WebDialogResult.No) { this.doCopyClassSettings = false; } } } }Is there a way to specify which button (Yes/No) should be the default? Thanks,Phil

Hi EveryoneI have created ServiceContractInqExt graph like below: public class SSPServiceContractInqExt : PXGraphExtension<ServiceContractInq>    {…      //How can I call base functionality of process or processALL      // Need to execute custom logic here..}  

Using v2021 R2.  I’ve configured DeviceHub and Acumatica for the label printer.  The user profile has the printer as the default printer.I’ve set the “Print Shipment Labels Automatically” flag in SO preferences.I don’t know if it is required, but I set the User Settings in Pick, Pack, and Ship to Print Shipment Labels Automatically.  We’re not using Pick, Pack and Ship.When I click on Confirm Shipment, labels don’t automatically print.  Is there another setting I’m missing?

How does one deal with 2 uom’s where the conversion is not constant?Example Steel industryA pallet of sheets never weights the same. 100 sheets might weigh a ton with one PO Receipts and then next week 1.01 tons.Also, what would be a solution where I Order in kg’s, I sell in Kg’s but I stock count in Sheets/each. what would be a good option for the base UOM? Remember I have variable UOM Conversion factor.  

I’ve been struggling with creating business events to trigger an email, and I’ve come to the conclusion that building a GI specific to the email is probably my best bet, but unfortunately it is not working for me.I created the GI and have all of the fields I need  and the GI works fine.In email notifications, I click INSERT > DATAFIELDS, find a field, then select it into the document. Adding any field results in the following error code “Object reference not set to an instance of an object.”   

I have an import scenario for Trial Balance and an export scenario to process/release all the entries.  My question is, has anyone ever made an export or import scenario that works across entitles?  When you process/release a trial balance entry it takes to you a journal entry which breaks the import/export scenario.  I am looking for a way to automate the whole process. 

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?