Discussion Forums

Hi All, I have a scenario where GL journals have to be exported and imported in another ERP system. after the export we would like to mark these lines as being imported so they can be obvious on a GI. I can’t work out how to get the import scenario work using the same key module, batchnumber and line numbers. any hint would be much appreciated. What am I missing here ? error is not telling me muchThank you 

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: 

Hi all,I recently created 2 separate Generic Inquiries for my company. One is Inventory with Sales/Margin/Margin % info. The other is inventory with units by location by warehouse.My goal is to combine these 2 GIs into one master GI to avoid having to switch between different reports when viewing sales and inventory information.Below are the data sources for the FIRST Generic Inquiry: Inventory Units & Cost by Warehouse.When I use this GI as a data source for a new GI, NO fields show up even after selecting them in the results field. I have not joined anything to this in the new GI yet, so I doubt it’s a data relation mapping issue.Conversely, when I use the other GI - Inventory by Sales/Margin/Margin % - as a data source, all records populate when I show them in the results field. Both individual data source tabs are shown below.thanks all!Joseph

Hi all,I’m currently trying to receive the owner data of a shipment using the REST API.The response of GET /entity/Default/24.200.001/Shipment/<ShipmentNbr> contains the contact ID:... "OverrideFreightPrice": { "value": false }, "Owner": { "value": "56" }, "PackageCount": { "value": 4 }...However, I can’t request more information about the contact.The owner of a shipment is an employee. But the REST endpoint /entity/Default/24.200.001/Employee does not contain the ContactID.Is there any other endpoint that can be used?Thanks in advance!

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  

Hi All, I am struggling with an import for the configurator maintenance screen. The last topics were years ago and those xml files error when i try them.  Am I right in my understanding that you need to have an import per feature for the options. So for each feature and that features options you would need to have a separate import or is this possible on one import. Any help or examples would be appreciated

Hi,How can I make an OData call to a Generic Inquiry with multiple values for a filter?  For example, OrderID is 1001, 1003, or 1004.I know OData v3 does not support the “IN” filter clause.  But can I user parameters or OData v4 to retrieve multiple records based on an array of filter values?Thanks!

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.

I want to know the flow of Audit History for every page1. How the histories are maintained for every Page?2. What is the database flow for the tables used? Below is the query I have created according to my understanding for the Sales Order Screen (SO301000). Is it correct to check the history for every OrderNbr.Select Distinct u.username,sl.OrderNbr,au.ScreenID,au.UserID,au.ChangeDate,sl.LastModifiedDateTime,au.ChangeID,au.BatchID,au.Tablename,au.ModifiedFieldsFromSOLineSplit slInner JoinAuditHistory auON sl.LastModifiedByID = au.USerIDInner Join Users uON au.UserID = u.PKIDWHERE sl.OrderNbr = `ordernbr`and au.ScreenID = 'SO301000' and sl.LastModifiedByID = `userid`

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. 

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， happy 2026.  I noticed that Acumatica officially released AI Studio with their 2025 R2 version, but it's not a true AI agent yet—it can't create detailed order information. I'm wondering if anyone has used AI agents (like Manus and similar ones) to operate Acumatica. How was the experience? Could you share your feedback?

 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 EquipmentDetai

Wondering if anyone has any customizations/add-ons used for container management in Acumatica that does not involve PC Bennett or IIG container modules? Looking for ideas on how others are handling.

Advanced Kitting Boost your sales with bundles!Acumatica’s Advanced Sales Order Kitting capability is designed to streamline and optimize your sales bundles. This feature improves visibility into non-stock kit components and inventory availability, and significantly boosts profitability by enabling better control over pricing and margins. It streamlines the order entry process, allowing customer service representatives to customize sales orders and packing lists, which leads to increased operational efficiency and a superior customer experience.  Additional highlights of this solution can be found below.Be a part of our Acumatica Labs Program to implement this innovative solution and help shape the future of sales order kitting! 

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?