Solved

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

We have lots of cases where we have parts which are used together, for example an enclosure and its backpan each with seperate part numbers. When we buy these items does acumatica have a way to tie these numbers together so that if either of those items are ordered it would also know to order the other item so that we can make sure we have the matching parts. Thanks

Hello Community,I am facing an issue related to creating a POOrder from a Service Order using the standard POCreate process screen.Scenario:Service Order Type: InternalFor this type, the Customer field is not mandatory by design.The requirement is to create a POOrder from such a Service Order.Problem:When attempting to create the POOrder via the POCreate screen, the system throws an error indicating that the Customer field in the Service Order is required.In standard functionality, the required validation for the Customer field is removed dynamically in RowSelected depending on the Service Order Type. However, when the Service Order is updated from the POOrder creation process, RowSelected does not appear to be triggered. As a result, the Customer field remains required and the validation error is raised.Additionally, I noticed that the Service Order is being overwritten during the attempt to save the POOrder, which seems to reapply the required attribute logic and leads to the validat

I want to create a PDF from a report in code and then send it to print. How can I do it?

We recently implemented using a weight scale and connected to the device hub and we are now noticing the scale is creating 3-6X the ERP transactions in the database.  The user is simply putting box on top of scale and selecting “capture weight” then removing the box but Acumatica is seeing this as 5X the transactions instead of 1 time.  Anyone else going through this dilema?  We are seeing the SCALE try to poll every two seconds in some cases.  Thanks,Nirav S.

I have a new customer based in Canada and we need a FastTrack Snapshot but with Canadian Localization, I attempted to restore a regular FT Distribution Snapshot, but everything was in USD and no matter how much I deleted I couldn’t change the base currency.  Can anyone provide a snapshot for a Canadian localization?

 We recently received a Purchase Order. It was split in receipt due to one container coming in November and the other in January. The first receipt for the items that were received pushed through correctly. Now the second receipt that we received today is not showing up correctly in our Inventory storage details. we have receipted the remainder of the soccer ball and have pushed the Bill - on hold as you can see below. However, the soccer balls received in the second and third receipt are showing in QTY available and not on QTY on hand. Which it should show on both columns. This is not allowing us to push any sales orders through to shipment because it shows that there is 0 in inventory.  Please help.       

Is is possible to link SO to an already existing PO? if so then what’s the process

Hello dear Acumatica community,we want to trigger automatic (email) notifications as soon as a responsible person has been assigned to a task.Currently I tried to solve this via the following business event (in German)Unfortunately, it is not possible to query the direct input screen for tasks (cr306020), nor the task overview screen (ep404000) for business events.Therefore I tried to find a solution via the general query "Tasks" (GI000024); namely this can be queried for business events. The problem with this query is that it does not trigger the business event in the default.After research in existing threads here in the community I found out that in the general query the conditions should be deleted to allow an error free triggering of the business event.But then the problem is that the query "Tasks" (GI000024) queries the activities in general. So if you remove the condition that only tasks should be displayed, then also mails, remarks, etc. will be displayed. So the First problem

Hello, we are wondering if there is a way to restrict time entered through time activities to only be entered in 6-minute increments or to round any time that is not entered in 6-minute increments to the nearest multiple of 6. Based on the clients we serve; this is the required way time must be tracked.