Solved

Is there a way to automatically load each individual sales order line ship date based on the stock item or manufacturing lead time? We have thousands of parts, and most items are made to order. We have estimated lead times for each part (based on BOM routing and some Manufacturing Lead Time) so we manually have to select the estimated date on each line item when lead times differ drastically.

Is there any way to only trigger awaiting approval notification once not multiple times after the document is approved, placed on hold, make some changes, then removed on hold?The changes that are made have nothing to do with conditions that triggered the approval.Ex:Approval map is setup in SO when an item is discounted 100%, approval is triggered. An SO is created and has the above condition met, approval is triggered, notification is sent, then approved by the approver. Then the sales user places the order on hold and make changes such as mark a line for PO, add description, etc but discount% remains the same. But when the order is removed from hold, approval notification is sent again. This is not a bit anoying especially the approver has approved the order and it’s necessary to make some changes to the order again.

Here is my import scenario, it feeds off a GI that JUST created the invoice, so I KNOW it has a customer ID on it…  My business event history says: 0 records of 1 have been processed. The last error was 'CustomerID' cannot be empty.These are all fully built and simply need to have “release” clicked. When I open any of the error’ed out invoices, I just hit RELEASE and it’s done, but this should be done by the import scenario, so any help is greatly appreciated since I’m clearly missing something here.

Hello,Does anyone know the setup in the Commerce module to allow for the tracking number to be sent back to BC from Acumatica? I am unsure if this setup is the correct setup, but I know we not currently having tracking IDs sent back to BC.  

Is there a way to set up a default task in acumatica that has preset sub tasks? For example if we want to create a task to process a customer refund and what some of the bigger steps associated with that task as sub tasks, is there a way to have that pre-programmed in Acumatica?Thanks!

Good day everyone,ShopifyxAcumatica connector only allows mapping of Company to only fields Name or Notes. Now, I am encountering issue with syncing using Attribute to the Notes field. It always provide an empty value.I mapped the attribute with Customer entity to a Shopify Customer tag - it worked, has value.I mapped another field in Company entity to a Shopify Company Notes - it worked, has value.But when I mapped the same attribute with Company entity to a Shopify Company Notes - it is empty. Does anyone encounter the same? I am using 23 R2 - Build 23.209.0023 

Anyone else seen/have this issue on their efile where your compnay headers are printing this A 1234568ABCDEF info instead of the correct info needed to correctly efile? The IRS is obviously rejecting it  

Hello,  Hope you are doing well.  We have a Generic Inquiry with multiple lines, which require to be taken to an email body. The Email will be triggered by an Automation Schedule connected to a Business Event.   Also, we tried taking the results values to the mail body by adding Data Fields, but it requires defining as much as lines to cater all the lines on the Generic Inquiry results. Hence that did not work on us too. Is there any method that we can use to add the results to the mail body? Thank You 

Hi everyone. I have encounter. on my server every time I run the screen ID with PL. e.g. “SO.30.10.PL”. I got this error and continuous loading almost 30 mins but no result and try to stop it.I hope you can help me. 2025R2Build 25.200.0248 

Can anyone explain me apply to order calculation. I know the highlight amount is for next reserve order but how to it calculate it.

PrompTax is an electronic filing and payment program that's mandatory for certain businesses in the state of New York. One condition is if the tax liability for the June 1 through May 31 period immediately preceding the previous June 1 through May 31 is more than $500,000.  A taxpayer must pay in sales tax no later than 3 business days after the 22nd day of each month.  Sales tax is paid in for the 1st – 22nd of the current month, and for the 23rd – end of the previous month. Here’s the problem: The Tax Periods can only be configured as Half Month, Month, Two Months, Quarter, Half a Year, Year, Financial Period. There is no way to create a tax report for 23rd month 1 through 22nd month 2. Anyone else face this and solve it?

Hey All,Is there a way to run or trigger multiple Export Scenarios using a single Automation Schedule in Acumatica?I attempted adding multiple conditions to the schedule, but it didn’t behave as expected.

Hello, I am creating a Business Event to update the External Ref Number field on the “Import Bank Transactions” form.  I have created an Import Scenario as the subscriber, and the mapping is as below.  For the testing purpose, I entered an action on the screen and perform the action manually. But it gives me the below error. But the scenario works and update the external number when I execute it manually. Is there’s a way that I can, correct?Thank You

Hi Team,We have implemented the functionality of the Line Details button across multiple tabs and grids in Classic UI, and it is working as expected there. However, in Modern UI, the button is not functioning.Could anyone please help us resolve this issue?An early response would be greatly appreciated.Regards,Subodh 

We are using version 2025 R2. Whenever a GI or Pivot table is named (not shared), the same name appears on multiple and non-related screens. Refer attached screenshot. This happens with just about any GI or Pivot table filter. None of these are shared and yet these filters appear on non-related screens also. Clicking on them obviously displays an error message.How to fix this in such a way that these filters are available on related GI and Pivot table screens only? We don’t have direct access to the on-premise hosted application.

Hi, we have a GI that shows Won opportunities per period. Beside the $ value, there is a value that counts how many documents consists of it. However, it adds 1 count to in pivot tables. I’ve used all aggregate functions in Pivot table and Count Distinct is the best option which is still not correct as the value is still one off. If this is not a limitation, how do I correct this?There is no won in opportunities $50-100k (AUD), but it is showing 1 in the count column beside itUsed Count Distinct as the best option to show the ‘closest’ correct option 

I’m wanting to show the qty available in two different warehouses as two columns.  The records should all still come through, regardless of whether there is qty available or not.  For this reason I used a left join: But this left join should only be for records from a specific warehouse, so I added the following condition:  I would expect to see all inventory records, but only some are being returned.Do I have to use a subquery?  What is wrong with my condition that can be improved?

In Acumatica Manufacturing, is it possible to configure variable overhead GL postings to use the same WIP subaccount as the related Production Order, instead of the subaccount defined on the Overhead Code?

We have a brand new instance of 25R2 using the Modern UIThere seems to be a issue with the Phone Types not properly displaying on the Account Contact When the screen is refreshed the types will flash on and then disappearThis occurs on new blank records and new imported recordsMy guess is this a browser issue but have not found a known issueHas anyone seen this ?    

Which setting should I configure to enable this scenario?A service has estimated duration of 30 hours but staff available working time is 8 hours a day. When assigning appointment system split that appointment into 4 days, either as the same appointment number of multiple appointment number that is fine but I want to avoid cloning the appointment as this seems to be manual task.Choosing Work Calendar with 8 hrs working time a day in Service Preferences doesn't seem to affect the service duration.

We are having an issue with the paycheck assigning separate workers’ comp codes to different work locations. As you can see, we have 2 work locations on this paycheck. We want separate workers’ comp codes for each work location. However, currently, the system uses the same code with different deduction codes because of the 2 different states involved.I understand that there are 2 separate deduction codes, but when we go to report these wages, we have to use 1 rate per WORKERS COMP code. When we report it to our insurance, they do not care about our deductions codes--just their WORKERS’ COMP code. Does anyone know how to fix this? I want to be able to pull the workers’ comp report and use the numbers in Acumatica to report to our insurance. I can’t find a way to do it currently.

Hi everyone,Has anyone successfully added an external URL (for example a Power BI report) to the Acumatica Site Map so users can open it from the menu?I created a Site Map entry pointing to the Power BI report URL, but when clicking it Acumatica tries to display it inside the page (iframe) and I get an error like: “app.powerbi.com refused to connect”. Is there a recommended way to handle external links like this from Site Map? Can Site Map be configured to open the URL in a new tab/window instead of embedding it? Or is the best practice to use the Power BI reportEmbed URL / another approach (tile, dashboard link, custom screen)?

In Acumatica, on screen AR302000, I have a Closed payment that I want to change to Voided Payment using the APIs. In the UI, the process is simple: we click VOID, then REMOVE HOLD, and the document becomes voided.The VOID button triggers the action /24.200.001/Payment/VoidCheck, and the REMOVE HOLD button triggers /24.200.001/Payment/ReleaseFromHold.I called these two APIs sequentially. The first one returned 204, but the second one failed because the payment is not placed on hold after running VoidCheck, meaning Acumatica does not allow ReleaseFromHold.Here is the payload I’m sending for the first API call:json{ "entity": { "ReferenceNbr": { "value": "000025" } }}And here is the payload I’m sending for the second API call:json{ "entity": { "id": "eed4ab6d-ccd5-f011-a83a-6045bd6d244f", "ReferenceNbr": { "value": "000025" }, "Hold": { "value": true // I also have tried false }, "Type": {

I am using REST API to insert a record. Normally, when you manually insert the record from the UI screen, we have custom logic to throw a warning by using e.Cache.RaiseExceptionHandling and PXSetPropertyException and PXErrorLevel.Warning. This allows the user to insert the record with no issues and then later on when they click a “Validate” button in the workflow of that screen our logic will decide what to do.The problem is that when inserting this same record using REST API we do not see that warning reflected back in the JSON response. It seems that the only way to see the error reflected back is to actually have an error be thrown rather than just a warning.It would be pretty simple to just save this warning to a field and then add that field to our endpoint.BUT I would like to know if there are any better ways to do this? 

I need to add a custom field to the Applications tab on AP302000 - Cheques and Payments. I’ve followed the instruction elsewhere to append my field as the last column of the grid, but I need to put it somewhere that users will see it :-)So I have a TypeScript file containing export interface APPost_MyProject_generated extends APPost {}export class APPost_MyProject_generated {  APAdjust2__UsrPartPaymentAmt: PXFieldState;  APAdjust2__UsrPartPaymentPct: PXFieldState;} And HTML<template><field id="APAUsrPPPct" name="APAdjust2__UsrPartPaymentPct" after="#gridApplicationHistory"></field><field id="APAUsrPPAmt" name="APAdjust2__UsrPartPaymentAmt" after="#APAUsrPPPct"></field></template>And while that works, it means that the field is the final column in the table.(I found that having added the first field after=’#gridApplicationHistory’, I can’t add any others to that id, so all my fields have id value that are referenced by the next.) But. I need something