Discussion Forums

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. Chat GPT says that this error means the system is trying to add a New Stock Item at

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 unmatched records in the grid so users can review, edit, or correct them manually before saving and releasing the payment.Any suggestions on how to handle or skip the RefNbr validation and show all Excel records in the grid Thanks, 

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 any configuration changes needed?

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=null'. PrepareImportRow in INPIEntry is not declared as virtual, which could be preventing the override.Has anyone successfully extended or replaced this method or something similar whic

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 am trying to populate for example smoking tobacco transaction uder its heading and other data under another one. Report is based on the Report for

Hi all, I update Project task Status completion from our builder software. Sometime the Project number gets entered incorrectly into that app.  Whe I run a put to the ProjectTask endpoint and the project does not exist it give a 500 error with "exceptionMessage": "Object reference not set to an instance of an object."I am logging these, but it is not a very friendly message. I do not want to hit the API first to see if the project exisits. We are going to automate the Project creation so they are all in Sync, but not till next year. My questions is how are you dealing with this type of issue?  My concern is the generic Error my not always mean the project does not exists.

I’m trying to create a report that displays a shipment’s Return Label and I believe this is the field, however, using it produces inconsistent results. Sometimes, it produces the return label, and other times produces the shipping label. Is there a way to ensure only the return label is displayed?

Hi, i want to create budget for Grant Budget Entry. I am already create the Grant and activate, but when i try to insert the budget, there is not list of the Grant ID. Can somebody help me to solve this. I really appreciate, thank you.  

I’ve built a report that pulls shipped item information from shipments for forecasting purposes.  I’m trying to link my existing tables to POOrder through POLine (ShipLineSplit to POLine on InventoryID) but am receiving grossly inflated shipped numbers.  Any ideas on how to solve this?  I’ve pasted a snapshot of my current relationships. Without the PO tables, the report works like a charm but I’m trying to exclude certain PO quantities (bulk / special orders) from a field that displays InSiteStatus.QtyPOOrders.  Thanks.  

I have vendor Id field and I must set text ,,split” for some condition. How I can do this ? 

We are in the processe of implmentation and I am exploring the Blanket Sales Order functionality and have run into what I belive is an issue related to the “Requested On Date” on the Blanket Order Type.When creating a blanket order you can define the “Requested on Date” for the line item in the Details table (had to add this column),  however when you go to Line Details,  you can only define the “Sched Shipment Date” for each line, not the Requested On Date.      Additionally I have discovered that when creating Child Orders from the Blanket order,  the “Requested On Date” on the Child Sales Order defaults to the Current Date regardless of what is set on the Blanket Order.  I have also observed that the “Scheduled Shipment Date” on the Child Sales Order defaults to the “Scheduled Ship Date” minus the defined number of Lead Time days set on the customer record, which is how I would expect it to behave.My conclusion is that setting the “Requested On Date” and “Scheduled Ship Date” in the

Hey All - I have seen the topics of issues with reports not filling up the page and leaving blank space, but unable to get mine to work - anyone have any tips? I had to Zip the file to load it.I tried:Changing to false on landscapeChange to Letter vs A4Print Empty on sections to False