Discussion Forums

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!

Hi!I noticed that the General Subaccount on the Branch Locations preferences screen is not a required field, we are able to save this with no issues: The reason for us leaving it blank is to force users to specify the subaccount (division in the client’s case) on the service order, i.e. roofing, painting, etc. depending on the type of service order is.Fast forward to the create AP bill functionality on the Service Order details tab.this functionality only brings in the related svc. doc type and related svc. doc. number but it appears to have a connection to the branch location general subaccount field because upon filling in the details, we get this error which on the service doesn’t seem correct because the subaccount is in fact NOT blank: taking a look at the trace log, this is where we figured out it was connecting on the backend: tested this theory out by filling in the subaccount on the branch locations screen and followed the same workflow and was able to save with no errors.  th

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?

 Hello Community, Background:For some reason Acumatica database design team instead of adding DailyFieldReportId field to PMTimeActivity and EPEquipmentDetail has decided to add two dedicated tables that only holds references to the Key fields of these two tables and DailyFieldReport.1) The DailyFieldReportEquipment has only 4 fields as follows:DailyFieldReportEquipmentId which is an auto incremental Identity field and doesn’t really add any values. DailyFieldReportId which holds a reference to [DailyFieldReport.DailyFieldReportId] EquipmentTimeCardCd which holds a reference to [EPEquipmentDetail.TimeCardCD] and EquipmentDetailLineNumber which holds a reference to [EPEquipmentDetail.LineNbr] The three reference fields are also set to be the Key Fields of the DAC. 2) The DailyFieldReportEmployeeActivity has only 3 fields as follows:DailyFieldReportEmployeeActivityId which is an auto incremental Identity field like the DailyFieldReportEquipmentId and doesn’t really add any value. DailyFi

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