Solved

Hi everyone,  We try to attached pdf report to an email notification.But every try system failed with Object reference not set to an instance of an object.=> I try many other report = same error=> I try the invoice report but in html format = It works=> When I retry to sent the email with business event history resume and rexecute, it works totally. We aren’t currently using the last version of Acumatica but have you face this king of error ?Thnak for your help.Regards.  

Hello, I currently have a GI set up to display an amount with a decimal that is two digits in so we can display it as 1111.00. Does anyone have any tricks for getting the value to add commas in after the hundredths place? Below is my current config.=iif([ComplianceDocument.LienWaiverAmount]=null,'-',left(cstr([ComplianceDocument.LienWaiverAmount]),instr(cstr([ComplianceDocument.LienWaiverAmount]),'.')+2)) Thank you,Justin Long 

Hi, I need to build query which will extract ‘Landed Cost Nbr‘ field value from “Landed Costs” in Purchase Receipt entity,I guess the query must look something like that :  https://acum2025r1.arts.com/AcumaticaERP/entity/Default/24.200.001/PurchaseReceipt?$filter=ReceiptNbr eq '020305' and Type eq 'Receipt'&$expand=LandedCosts but I am not sure how to properly add “Landed Cost” field to endpointI tried to add LandedCosts group for purchase receipt same as I added ‘details’ group, It created separate entityHot to extract landed cost nbr properly ?

Hi All,I want to change the Freight Price and Amount on SO303000. I tried few different way but can’t make it. My most current request.I send PUT request to endpoint SalesInvoicewith body:{  "ReferenceNbr": { "value": "INVSP212099" },  "Type": { "value": "Invoice" },  "FreightDetails": [            {   "OrderNbr":{                    "value":"SP219039"                },                "OrderType":{                    "value":"SP"                },                "ShipmentNbr": {                    "value": "SHP297504"                },                "ShipmentType": {                    "value": "Shipment"                },                "FreightAmount": {                    "value": 0                }            }        ]}This will add a new line not update the current data. Do anyone have been done this before? Thank you.

I’m experiencing an issue in Modern UI where a link in a grid column is not opening target screen when clicking on the field.Here is the TS:@columnConfig({ editorConfig: { linkCommand: "ViewBills" }, width: 70,})BillID: PXFieldState<PXFieldOptions.CommitChanges>;When I click on the BillID field, nothing happens. I also tried adding allowEdit: true, but it did not resolve the issue. What’s confusing is that in another screen I have a very similar configuration, and it works correctly the link opens as expected:@columnConfig({ editorConfig: { linkCommand: "ViewInvoice" }, width: 90})InvoiceId: PXFieldState; 

Hello. When we create a new item in acumatica, we fill in the Default Warehouse, Default Issue From, and Default Receipt To fields within the Stock Items screen.However, on the first use of the item the system creates an entry in the Item Warehouse Details and populates it from the warehouse settings instead of the item settings, which is just a broad catchall location instead of the specific location on the item. This would be fine if the material was coming/going from the non-default warehouse, but it shouldn’t be the case when using the default warehouse.Once this entry has been made, the system seems to entirely ignore the defaults in the Stock Items screen. How can i get the system to initially populate using the Stock Item settings instead of the Warehouse settings?Stock Item:Initial population after putting initial items into location 913-A-1 in an adjustment (adjustment did not default to 913-A-1 either): 

Hi all,I wanted to check the feasibility of a customization in Acumatica for Production Orders.Currently, once the Production Order moves to In-Process status, the BOM ID and Revision are locked by design, based on the Acumatica Community response, it appears a customization may be possible to alter the behavior.Our requirement is to evaluate whether the system can allow updating the BOM ID and Revision on a Production Order even after it reaches In-Process status, ideally until the final Move transaction i.e. Production order Status completed.Please review whether this is technically feasible and advise on the possible approach, impact and limitations.Attached is the Community thread for reference.How to handle BOM revision changes after a Production Order is in In-Process status? | Community

Hi everyone,We were having issue with the MRP,We have two separate projects, and each project has one Production order. Both production orders use the same BOM and the same material item. Both Projects are configured with inventory tracking = Track by Project quantity and cost.Scenario details: Projects ID Production Order Nbr Start Date BOM ID Purchase Order PROJ-VK-45 ORDER41326 5/11/26 BOM1 008815 JB-007 ORDER2 4/27/26 BOM1    Test steps:Created both production orders under two different projects. Since ORDER2 had the earlier start date, I placed ORDER2 on hold for testing purposes. Ran Regenerate Inventory Planning. Based on the demand from ORDER41326, the system created the supply suggestion, and we created a Purchase Order 008815 Then I removed ORDER2 from hold Ran MRP again Reviewed Inventory Planning Results by Item.Issue observed: After the second MRP run, the s

We are currently Drop-Ship Purchase Orders in Acumatica for Items that are shipped directly from the Vendor/Manufacturer to the job site/customer site. Is there any way to track these drop-ship Purchase Orders in Acumatica once the vendor ship them? we are looking to understand whether there is any standard integration or a third-party plug-in available to track shipment and delivery status for drop-ship orders.Any input or best practices would be appreciated.

Hello Acumatica Team,We have a requirement to add a custom field in the Application History tab of the Payments and Applications screen. This field should be populated from the Blanket Sales Order CustomerOrderNbr and must be updated during Payment Release and Payment Capture.I attempted to override the Release action. When updating the value before the baseMethod call, the Application History (ARTranPostBal) View Details is not loading. When updating after the baseMethod call, the view loads correctly, but the value is not persisting. However, updating the value using PXDatabase.Update works as expected.I also tried using row events, but observed the same behavior with no success.Could you please clarify:Where the default logic for updating Application History during Release and Capture is implemented? What is the correct extension point to reliably update this custom field?Version: 25R1Thanks in Advance!

Can we create a GI directly from a report. I want to make changes in the report and it is very hard with the report designer to do that. 

Hello - I’m having some issues with the Global Tax Settings tab of the Tax Maintenance form. Our client has recently updated to 25R2 and the modern UI, and when we update taxes, the Global Tax Settings tab seems to be missing all sorts of entries that used to be visible to us. For example, we used to be able to maintain the basic personal amounts for each province tied to our work locations, and those fields are now missing. They would be the Total Claim Amount fields for each province.I’ve searched the update notes and don't see anything related to this. I also thought that perhaps this was missing because I was setting up a tenant for production with no employees loaded yet, but our UAT tenant that has prior payroll data is also missing all of the field that we previously were using.I also went in and looked at the individual Employee Payroll Settings, and all prior values we had updated are still there, however the ‘Use Default’ checkbox that used to exist for some values (like the

Hi,Has anyone successfully removed prepayment and payment amounts from the calculation of the aging buckets on the AR Aging report. I have the report filtering out the prepayment and payment transactions so they do not show up on the report but those prepayment and payment amount are still showing up in the aging balances. I need to remove the prepayment and payment amounts from the aging balances. Thanks! 

Hi all,I want my customer statement does not include transaction with prepayment type. I have created a parameter doctype and filter conditions type does not equal ‘PPM’ but it does not work. Thanks in advanced.

We have a specific use case regarding Equipment Time Cards: currently, when a time card is submitted, the system automatically generates transactions that post to both the General Ledger (GL) and the respective Projects. We would like to capture these costs within the Project module for tracking purposes only, without triggering a post to the GL. Is there a standard configuration or a workaround to achieve this?

Recently we have discovered a couple of automation schedules that use the new Email Notifications functionality on the report screen have stopped sending the emails in the last week.  they were working previously.  The automation schedule history shows that the schedule fired and was successful.  The attached report in question does not have any parameters, and runs without errors when run separately.  The email addresses are hard coded into the Email Template.  There is no record of the email on the All Emails screen.Has anyone else seen this issue?Thanks,Laura

Even after rebooting my machine, every single time that I try to create a new instance of 26R1, I get these errors and the installer stops:Even if I press OK, I get more log errors:If I press ignore, I just get more of these errors about the other log files that the installer created.Question: how to get past these log errors so I can create a new instance?Here’s the full error:Cant't create the site 26R1 -------------------------------------- Inner Exception: Exception occurred while deploying the site files.  --------------------------------------  Inner Exception:  Exception occurred while backing up the files from 'C:\deployment\sites\26R1\' directory. Try to do it manually.   --------------------------------------   Inner Exception:      WARNING: The process cannot access the file because it is being used by another process.   C:\deployment\sites\26R1\Logs\log_prepare_2026-04-09_11-11-53.txt         WARNING: The process cannot access the file because it is being used by another pr

Every single time that I try to create a new instance of 26R1 (even after rebooting my machine), I get these errors right away and the installer stops:Even if I press OK, I get more log errors:If I press ignore, I just get more of these errors about the other log files that the installer created.I’ve deleted the log files and restarted the install but the log files just get recreated with the same access errors.Question: how to get past these log errors so I can create a new instance? Here’s the full error:Cant't create the site 26R1 -------------------------------------- Inner Exception: Exception occurred while deploying the site files.  --------------------------------------  Inner Exception:  Exception occurred while backing up the files from 'C:\deployment\sites\26R1\' directory. Try to do it manually.   --------------------------------------   Inner Exception:      WARNING: The process cannot access the file because it is being used by another process.   C:\deployment\sites\26R1\

Hi,We are using the Receive and Put Away function in Acumatica.When we scan in the Regular Acumatica Application (on our desktop), there are three distinct sounds for:Correctly scanned barcode Scanning error Release actionProblemWhen we scan in the Acumatica mobile app, there is only sound for correctly scanned barcodes. There is no sound at all for the other two (scanning error and Release action). Is there a setting in the Acumatica mobile app to enable these two sounds?

I’m attempting to add a parameter to a Dashboard for the Branch.  I will then use that parameter in the widgets for that dashboard.  (Goal is to get a branch-specific dashboard.) When I went to add the parameter, I’m not sure which Schema Object to use to find a field for the branch to use in the parameter.  Ideally, I’d like to have the parameter populated with a value for the Current Branch. Any ideas on this would be greatly appreciated!

I have the multicurrency accounting enabled. My loan account is in USD, but the funds went into my CAD account. I have exchange rates going into the system daily. It will not let me post to my CAD bank account. Or any other bank account.  I need help on a Sunday of course. I’m hoping someone sees this and can answer me.  I attached a screenshot 

I am trying to create a dashboard widget for unassigned opportunities from the Opportunities generic inquiry.The filter would be:    Opportunities having a status of open or new    Owner ID is empty.However when creating this filter, there is no option under the Ownder ID for ‘Is Empty’. Nether is there one for assignment date. Whe creating a chart using the AI Assistant on the above criteria, I see on the filter for the widget, the filter shows as follows:How does one replicate this on a widget such as the one I have tried to create form a dsshboard?

Hello all,I have been trying to fetch the GIs from Acumatica and push to Power BI. I installed the Power BI desktop version, created a new API user in Acumatica with admin and OData roles assigned.Selected Get Data → OData option in Power BI:  Entered in the URL:https://Application site domain/odataFYI, Its a multi tenant site. and then clicked on connect, after entering in the password:I tried to login using the “Basic” menu in the left pane also, but triggers the same error. Can anyone guide me on this how can I get this connected?The PowerBI username being used here is of UserType=API in Acumatica.Thanks.

First, I’m not even sure what I want here is possible, but seems like if it is this is the place.I’ve got a completely custom form that shows information about a linked products record. I’d like to have a grid that lists the notes, but have an option for a split screen that shows the detail of one field (aka the content of the note) adjacent to it and is displaying the note content for the selected row.Is this a possible thing? Desired content detail would display in the box with the arrow. 

I’ve got a custom field that is Int64. It’s holding a key value from another application. It’s correctly stored in the DB as 16 digits, but the UI only displays 14. This was the same in Classic UI, but I could force it to use display as a string and all was well (it’s rarely if ever entered by anything than the integration code or an Admin, so digit checking not important.)I was *hoping* that modern UI would ditch the 14 char limits, but seems like no. How do I make modern UI display all the digits?Thanks in Advance!