Discussion Forums

One of client has below requirement.For easy stock movement and selling purposes they keep some items as 12 piece pack. During their sales operations, sometimes they sell the items as 12 piece packs as well as individual pieces. They have some scenario where they provide 1 individual piece as a free item when selling 12 piece pack. they are not keeping seperate item stock to provide as free item and they take individual units from 12 packs. How can we handle this.

Hi,Can anyone explain how to use LLike and RLike in Acumatica Report Designer?Do you need to put percentage symbol after the text or not?Thanks in advance!

Hello, I work for a company that has many employees that work on projects at various points of the project timeline. We have a date where we start to capitalize cost which is called the Cap Date. Any work done before that Cap Date is considered Work In Progress (WIP). We also have an internal project that we bill when we are not working on an actual project. Those cost need to hit Allocated WIP. With Acumatica’s current structure, you can only assign a labor item to one of these accounts which makes it tough because our employees then need to be aware of the Cap Date when billing. Is there a way to automate the reclassification of these labor items from COGS to WIP or vice versa based on the Cap Date and Project Status? Do Project task have the ability to define how labor gets posted? 

When I press prepare in Import by scenario I get this error message .What could be the reason I have used this import scenario before , I just added new items on the excel file and its giving this error:Exception occurred at Load The specified key does not exist. NoSuchKey SRY3C9KMQE320XV4I am getting this error on both importing Stock Items and Non Stock items.

How can I customize the system to not allow a user to change the Branch if certain conditions are met?  

I’m working on a utility that can bulk test the configuration mapping software we’ve written, which converts a design from our design tool to an Acumatica configuration. Right now the only way I’ve been able to test is by adding a line item to a sales order with the proper SKU, and then reviewing the generated configuration on that line item once our software runs. This becomes very time consuming when I’m testing in bulk, and it would be much simpler if I could pull down only the blank configuration template by SKU and revision number, and let our software fill that out. I saw that there is a “Test Configuration” tool when editing a configuration from the Configuration Maintenence screen, but I don’t see an API endpoint that can give me that data. Any help to point me in the right direction would be greatly appreciated.

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.

Summit 2026 Breakout Session Presentations - DistributionAttached are PDF versions of the PPT presentations from our breakout sessions. B2B Connector: Breakthroughs with Acumatica and BigCommerceConnected Distribution: Boosting Efficiency Through Integrated SolutionsCounter Sales: Enhancing Walk-in Sales Efficiency with Acumatica POSInventory Management: Smart Allocation Tools to Optimize Inventory Across Every OrderInventory Strategy: Smarter Planning and Replenishment with AcumaticaNavigating Tariffs: Adapting Strategies with Acumatica ToolsOptimizing ERP Value: Realigning ERP Solutions for Distribution SuccessDistribution Strategy: Solving Real World Problems with AcumaticaWarehouse Management: Best Practices and What’s New in Acumatica WMSAI/ML for Distributors: Exploring Intelligent OpportunitiesDashboards and KPIs: Gaining Smarter Insights and Stronger Growth Through Data Visibility

Summit 2026 Breakout Session Presentations - Core PlatformAttached are PDF versions of the PPT presentations from our breakout sessions. Accounts Payable: Streamlining Accounts Payable with AIAcumatica Payments: Speed Meets SimplicityCRM 101: From Login to Leverage—Unlocking CRM PowerCRM Opportunity Management: Strategic Sales Pipeline Management in ActionFinancials: Detecting Risks Before They Become ProblemsMonth-End Close: Practical Tools to Speed Up and Strengthen Your CloseInsights from SMB Leaders: Practical Steps for Driving GrowthOperational Leadership: Panel Discussion on Driving Excellence in a New EraPayroll: Managing Costs and Achieving Clarity with Payroll PrecisionProduct Roadmap: Give Input, Ask Questions, and Vote on Acumatica’s Next Great FeaturesReporting: Modifying Financial Reports with ARM …and ExcelAcumatica Retail Edition: Ask the Experts Connector Forum

Summit 2026 Breakout Session Presentations - ConstructionAttached are PDF versions of the PPT presentations from our breakout sessions. AI & Machine Learning in ConstructionBuilding the Future with New InnovationsConnected Construction: Driving Efficiency and Awareness Between the Jobsite and Back OfficeConstruction Payroll: From Jobsite to Paystub—Powering Construction Success with the Payroll RoadmapConstruction in Action: Real-World Demopalooza for Streamlined OperationsAcumatica Construction and Services: Experts Take Your QuestionsField Services: Update on What's New and What's NextThe Future of Field ServicesProject Billing: Bill Smarter, Close Faster with New Reports and Interactive WIPProject Configuration and Performance Tracking: Mastering Professional Service Project HealthProfessional Services Edition: The PSE Journey and What’s AheadUsability Best Practices: Reduce Cl

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.  

Hello all,How can one create task situated under Activities tab in PM301000. I came across Task templates screen, so I mapped the values and then setup the biz event that should be triggered when the Project status changes to Active. But it is not firing off. Can anyone guide me on this?

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: 

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

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.