Discussion Forums

In this topic, I’d like to share with the community an approach I used to filter data by multiple values.It’s nothing groundbreaking, but I thought it might be useful for someone who runs into a similar scenario.Let’s say we need to create a new screen that displays all employees, where we can filter results by Department and Labor Item (with the ability to select multiple values).The final result looks like this:Modern UIClassic UIImplementationTo implement this, we need to declare the filter fields as follows:using PX.Data;using PX.Data.BQL;using P

I have a simple GI that displays custom, Commission Paystub records for the logged in user. I created shared filters for “This Week”, “Last Week”, etc. to filter those by date range.I exposed the GI to mobile.It works as expected, on web and on mobile.However, I created a dashboard with a KPI widget that uses the “This Week” shared filter from the above-mentioned GI to sum and display the total commission for the current week.I exposed this dashboard to mobile and it also works as expected until the user taps on the KPI to open the supporting GI. The data for the “This Week” filter displays as expected but when the user switches to a different tab the GI data does not refresh. For example, if the “This Week” filter displayed 10 records, then the “This Month” filter will display the same 10 records, but no more. Any other filter that has a date range that encompasses the records initially displayed on KPI, will display those reco

We have a few prepayments stuck in “Pending Processing.” They can’t be voided or validated.I’ve already tried disabling the “Enable Integrated CC Processing” box and then attempting to void, but no luck.We’re on Acumatica 24R1, so official support won’t assist. Furthermore, the transactions originated in Authorize.net, and the Acumatica team says they no longer support auth.net. Has anyone found a way to void or clear these transactions?Hopefully once we upgrade in a couple of months, Acumatica support will be more flexible — but I need to get these cleaned up in the meantime.Thanks in advance! Error when trying to validate: 

after NPM Build Command on Extension Screen Changes are not reflected on UI

I went through the process of creating the customization project and then added AP.APAdjust.  I clicked on Selector Columns and then added APAdjust__vendorID and APPayment__extRefNbr.I saved the changes and published the customization but when viewing the selector within the detail grid of AP503000 I did not see the columns that I added.Just in case, I also replaced the attributes of the APAdjust VendorID column from[Vendor(Visibility = PXUIVisibility.Visible, Visible = false)][PXDBDefault(typeof(APPayment.vendorID))]to[Vendor(Visibility = PXUIVisibility.Visible, Visible = true)][PXDBDefault(typeof(APPayment.vendorID))]but that didn’t have the desired effect.What did I miss?

I’m trying to make this report portrait, however, this report always seems to produce landscape. It seems like there may be extra stuff to the right. What can I do to change the layout of the report?

Hi All. I have a report that I exported in Excel, but the pageHeaders/groupHeaders sections are cut off. They should be extended far right up to the last column. How it looks in:  Excel exported (not OK) - How to extend to the right?: Report designer (OK): System generated report (OK): 

For security reasons, I need to export a specifically formatted .csv file to a bank via sftp. I have a GI that populates when the payments are generated with a specific payment method (but before release). I then have automation schedules that process the export scenario to populate the file, then a separate one on the File Synchronization screen to synch the file(s).This process works and the bank gets the file. BUT, the synch is set on a schedule and submits empty files when no payables are run and I can’t seem to get the business event to trigger export when the file is updated with new/incremental data.Any ideas?

Hello -Has anyone had experience changing an origination value for a Fixed Asset after it has been in service for months? We have an asset that was entered with the wrong origination value and need to be changed, but has also already been depreciating. What would be the best way to go about changing this? Thanks

Hi, I created a new tax zone for specific location. All seems to be ok except orders are showing error message -Tax not up to date and tax is not calculating. Rate is not transfering to order section under TAXES, even though each tax is properly configured with proper %. It happens to exempt and taxable customers. items are set up as taxable. Any ideas? 

This might be a long shot, but I am trying to create an Import Scenario to mass update stock items with Quality Control Plans. Which is part of the QMS Module.  I keep getting an error message because the system says it needs a Test or else it can’t save. When manually adding a Plan to a stock item, once the plan is selected, all tests are added as well, automatically.  It seems, either that automation does not exist when using an import scenario, or the system is trying to validate before that test loads and throws up the error.  So I added more steps to manually add the Test right after adding the Plan. But I get an even bigger error: Error: 'Item Class' cannot be empty. Error: 'Tax Category' cannot be empty. Error: 'Base Unit' cannot be empty. Error: 'Sales Unit' cannot be empty. Error: 'Purchase Unit' cannot be empty. Error: 'Posting Class' cannot be empty. Error: 'Lot/Serial Class' cannot be empty.

We noticed that in Acumatica, the Customer field on a Project can still be changed even after the project is active and has existing transactions or invoices.From an accounting and audit standpoint, this appears risky because the existing AR invoices remain linked to the original customer, while new invoices would go to the updated customer — which can lead to inconsistent reporting and billing.I just wanted to confirm — is there a specific business scenario or setup where this behavior is intentional, or am I missing something in the configuration that should prevent changing the customer once transactions exist?If it is intentional, could you please clarify Acumatica’s recommended best practice for handling situations where a project’s customer needs to be changed after billing has started (for example, whether the preferred approach is to close the old project and create a new one under the new customer)?

I am working on a customization and need assistance with automatically fetching custom field values from BOM Material AM208000 (AMBomMatl) records to Production Material (AMProdMatl) records when creating production material lines from a BOM in the Production Details AM209000 (ProdDetail) screen.Goal: Value from Materials tab in AM208000 to Materials tab in AM209000 the customfields are made without code. I tried adding a new graph extension for ProdDetail:but thats not working.

Has anyone encounter this issue before? We are using EasyPost as the connector and the shipment is going international. I cant seem to find the fix spot. 

Does anyone know how to get past the below? I had a customization, removed it and tried another feature I wanted to add but am getting the error below. I am unsure where to navigate to find the problem to correct it. Thanks   

Is there any way to call the PrintInvoice action on an SO Invoice and specify the printer to get a paper copy?  I’ve made an entry in our custom endpoint to call the PrintInvoice action on an invoice, but when I submit the PUT, I’m getting an error “Invalid URI structure”.I’m supplying this JSON in the body of the call:{ "entity": { "DocType":{"value":"Invoice"}, "ReferenceNbr":{"value":"AR006006"} }, "parameters":null}Any ideas on how to accomplish this?

 Hi CommunityI have a requirement in the Payments and Applications screen where I have added a custom Load Records From File upload button to upload an Excel file and map the invoices from the file to the Documents To Apply grid, without saving the document.The issue is that only existing invoices in Acumatica are displayed, while unmatched (not found) records from the Excel file do not appear in the grid. During debugging, these unmatched records throw an error:“Error: 'Reference Nbr.' cannot be found in the system.”I have attempted to override the RefNbr field to insert the unmatched records and display an appropriate error message in the grid, but no luck.I want to display those unmatc

Good day,I created an import sceanrio that is working when the inter branch map does not exist in Acumatica. I am getting an error “The system failed to commit the MapFrom row.”, which is an update instead of inserting new records will show. I did play with the Commit for all of the items below, but not look.  Works great if new, but not if updating. Thank you in advance. 

Hii, i want to save and remove hold the Bill and Adjustment form i create. But when i try to save there is an error (you can see the capture below).Every time i wan to create Bill form it always like this. There is step or configurations that i miss? Please help us to solve about this, thank you😔 

Hi Team,ChatGPT said:I was working on an import scenario to create stock items and encountered the following error during processing:“Account 400100 is a control account for PO, and posting to it is prohibited. Please select a non-control account.”To resolve this, I updated the Chart of Accounts by adding the PO module for account 400100 and enabling Manual Entry.After making these changes, the import processed further but displayed the following warning:“Account 400100 is a control account for PO. Although posting to this account is allowed, we recommend that you select a non-control account.”I’ve attached a screenshot for reference.Could you please help me resolve this issue or suggest

We are trying to link three Sales Order to one Purchase Order. We were able to get one SO linked to the PO, however, the other two cannot link. There’s not even an option to see them. Both are using the same Source and vendor, and part. Any guidance on how to solve this would be greatly appreciated.Purchase OrderOne of the Sales Order 

I’m trying to modify the behaviour of the PrepareImportRow method in the INPIEntry graph to handle a custom field during import. The original method signature looks like this: public bool PrepareImportRow(string viewName, IDictionary keys, IDictionary values)  I attempted to use a PXOverride as follows: public delegate bool PrepareImportRowDelegate( string viewName, IDictionary keys, IDictionary values); [PXOverride] public bool PrepareImportRow( string viewName, IDictionary keys, IDictionary values, PrepareImportRowDelegate baseMethod) { // custom logic here }  However, I’m getting the following error:Declaration referenced in a method implementation cannot be a final method. Type: 'Wrapper.PX.Objects.IN.Cst_INPIReview'. Assembly: 'INPIReview_Container, Version=0.0.0.0, Culture=neutral, PublicKeyToken=n

I also tried to do it manually, and although it lets me add it, the screen shows an “ID does not exist” error and doesn’t display correctly.

I have tried to install 24R1 many times but always get the error below.Does anyone have any tips on how to resolve this? I have tried clicking Retry, but it doesn’t resolve.If I click Ignore and go through the rest of the installation, here is the error I get when I try to launch the instance:  

Hi,I’m building a report in Acumatica Report Designer where I want to show headings like “Smoking Tobacco” and “Moist Snuff” only once, followed by all the detail lines for that category.Right now, the group header (e.g., Smoking Tobacco) is repeating for every single record. I only want the heading to appear once, then all detail rows for that group, and then the next heading (e.g., Moist Snuff) with its details.I tried using an expression like: =IIf([InventoryItem.ItemClassID] = 'PIPETOB' OR [InventoryItem.ItemClassID] = 'HOOKAHTOB' OR [InventoryItem.ItemClassID] = 'RYO' OR [InventoryItem.ItemClassID] = 'WRAPAPRTUB')…but this still causes the header to repeat for each record instead of grouping properly.How can I set up grouping in Acumatica Report Designer so that the header prints only once per group, with all the records underneath it?I a