Discussion Forums

Can someone give advice on creating a GI that would allow a user to search a finished good lot number and see the raw material used to create that lot? Currently we do this by using a different GI to find the production order number and move transaction associated with the lot, then going to the Events tab of the production order, finding the move transaction, then opening the material transaction that was created at the exact same time. I see the move number listed on the Material transaction under ‘Orig Batch Nbr’ so I’ve tried to creating various GIs using AMBatch, AMProdEvnt, AMMTran to at least create a simplified path to the information we need, but I was unable to get a material transaction to show up for every finished good lot even though I can find them manually by the process described above. Our VAR sent us a GI linking AMProdItem to INTran and INTran to INTranSplit, but that still didn’t do what we needed it to. Does anyone know how to either get a GI to display all move t

We have a logo built to 300px x 100px. I called it into our statement. It looks fine on screen in Acumatica but Pixelates when we export. Is there a fix?  Is there a recommended resolution that is different than the 300 x 100 pixel size?

The Acumatica-AI-Resources repository continues to grow—with new resources for Acumatica 2026 R2, two skills from an external contributor, and a documentation branch for 2025 R2 requested by the community. Here’s what’s new and where to find it.New Acumatica release, new repository branchWith the release of Acumatica 2026 R2, we’ve added the 2026R2 branch with documentation and AI resources aligned to the new product version. This is now the repository’s default branch.Choose the branch that matches your Acumatica version to give your AI tools the relevant release-specific context.Two new skills contributed by the communityWe’ve added two skills that help to: acumatica-wiki-authoring: Create, review, update, and troubleshoot custom Acumatica wiki articles and form help. acumatica-classic-to-modern-ui-conversion: Convert Acumatica screens and customizations from the Classic UI to the Modern UI. A big thank-you to our external contributor for sharing these skills with the community!202

Is there any table in Acumatica which stores Average cost history against a stock item.

Hi, I exported a report in Acumatica to excel with 1yr worth of data, when opening up the exported report in excel, it gives me the below error and if I hit yes, I will lose some of the data in the report. When running it in batch, say 1 month worth of data, I have all the data. Do you have any thoughts on this please? Thanks 

We are using an Export Scenario in MYOB Acumatica to export inventory item barcode values maintained under the Cross-Reference section of the Inventory Items screen to a CSV file.When the barcode contains more than 12 digits, the exported CSV file displays the value in scientific notation instead of the exact barcode number. For example: Expected value: 9312554401266 Actual value displayed: 9.31E+12 We are planning to integrate MYOB Acumatica with a third-party portal, where the CSV file generated by the Export Scenario will be automatically transferred to the portal without any manual intervention.Therefore, we need the barcode values to be exported as their exact digits in the CSV file, rather than in scientific notation, without requiring users to manually change the file format after downloading or exporting the file.Could you please advise if there is a way to configure the Export Scenario or apply any other standard functionality in MYOB Acumatica to ensure that barcode values

I cannot add a target equipment on Travel Lines.  Why is this not available?  

Meet Cindy Whitner our Acumatica Community Featured Member for October 2026. It’s great to have you as part of the Acumatica Community ​@cindywhitner76!I’m honored to be recognized as this month’s Community Featured Member. I’m Cindy Whitner, Senior Product Manager at Acumatica, focused on Field Service Management. In January 2027, I’ll celebrate six years with Acumatica.My career began in finance, where teaching financial education courses sparked a passion for training. That interest led me into software training and implementation consulting, followed by development team leadership and eventually product management. Throughout my career, listening to and learning from customers and partners has shaped my work, allowing me to build the expertise and knowledge I use every day.  These interactions fuel my passion for creating intuitive software that helps people work efficiently and enables their businesses to improve productivity and profitability.My husband and I live in a small town

When using the REST API to get ProjectTransaction data, the detail items don’t seem to have a line number, where as the detail for JournalTransaction does have a line number. Does anyone know a good way to determine the unique key for the detail items of a project transaction as obtained using the REST API client?  I’m trying to determine a unique key based on the key of the parent transaction (Module, ReferenceNbr) and information from the detail items. I’m assuming that the GUID value of the detail items is not persistent in the same manner as for top-level entities.I would prefer not to develop a customization for this; having sufficient key fields in the API data should be part of the system already.

Hi Everyone,Can you please help me with the sample code to override the Quick Process Action in the Sales Orders screen?

During our Go-Live several months ago we made the decision to bring in our existing sales prices as “Promotional” with an expiration 6 months out (end of April) as shown in the screenshot below: Recently our sales team ask for me update all of our sales prices to remove the promotional flag and the expiration dates.   I have worked through the process of creating a Generic Inquirey,  and building the Import scenario.  I have tested the import scenario, which reads the existinging sales price entry and then creates a duplicate entry for the same break qty and price,  but leaves the promotion flag and expiration date fields blank. Shown below is the result after running the import scenario: While the import works fine,  our sales team has requested that I remove the original entries so that we don’t have the “clutter” of the original import from Go-Live.   Additionally they have asked that I completely remove the sales prices for a certain item class and not to bring those in at all.   I

I’m building a custom Modern UI screen that uses the Bryntum Calendar component uses. The screen is a view-only month calendar.Error when publishing the customizationModule not found: Error: Can't resolve '@bryntum/calendar' in …TS2307: Cannot find module '@bryntum/calendar' or its corresponding type declarations.package-lock.json shows that @bryntum/calendar is linked locally, not downloaded from npm:"node_modules/@bryntum/calendar": {  "resolved": "node_modules/ext-packages/bryntum-calendar",  "link": true},"client-controls": {  "version": "file:..\\dist\\packages\\client-controls.tgz",  "requires": {    "@bryntum/calendar": "file:../ext-packages/bryntum-calendar"  }}

Hi, how do I get the last date of the attached signature file? Attached is the rpx. 

Hi All, have another stupid question and if this is covered already, please direct me to it.  But we have a custom built ‘Import Scenario’ which take a CSV file and creates customers/supplier/invoices/payments etc.  For a certain import type, I want to change a logic of certain data so how it ends up in MYOB eventually?  Is this possible to do by my own, without MYOB support?  If I try Customisation button it says to ‘Select Project’ or ‘Edit Project’ and then I am prompted to enter the project name which I do not know.  So thought to check here for help.

My company has certain service parts that can be refurbished and reused on the next call. Is there a way to receive these items back, refurbish them, and then add to stock as a refurbished item? My initial thought would be to RMA the item, receive, disassemble to a “core” item, then assemble the refurbished item with a tag to call it out (XXXXX-RFB). I feel there is a step missing in this thought. Does anyone have any experience with this scenario?

Hello,I have a unique scenario that I am trying to figure out. We have a product that packages pills for pharmacies. It comes with up to 480 pill canisters that dispense the pills. We stock these items by their unique identifier, but have a general code for quotes as to not have a 500 line item quote. The additional challenge is that we will not know the mix of canisters until after the sales order is created. We currently have to go back to the sales order and add these codes manually in order to take the correct amount out of stock. Are there any ideas on how to automate this or make is less tedious? I have looked into Matrix items, but that scenario sems just as tedious. Any thoughts would help a lot.

Hello all,I have been working on an automation to place the SO in BackOrder status if the order isnt completely shipped. The scenario is for Drop Shipments.I created a GI:  If I disable the last 2 conditions, the biz event automation works perfectly fine. However if any one of the last 2 conditions or both of them are enabled the biz event doesnt work at all.My condition to display the orders whose Shipped Qty >0 & <> Order Qty. Reason being the Unshipped qty is a nonexistent field in DB: Is there anything I’m missing or doing wrong? Any help would be appreciated. Also attaching the XML of the GI.

Hi,One of our automation schedules failed before the scheduled screen could initialize. The only exception available in System Monitor is:PX.Data.PXInvalidOperationException:The initialization of the form failed due to an unexpected error.The execution of the schedule was canceled.at PX.Data.Process.ScheduleProcessor.SetCurrentScheduleAndCollectScrenInfo(...)at PX.Data.Process.ScheduleProcessor.ProcessSchedule(...)at PX.Data.Process.ScheduleProcessor.TryProcessSchedule(...)There is no inner exception showing the actual cause. Acumatica continued retrying the overdue schedule. Later, the website restarted automatically, and the schedule ran successfully after the restart without any configuration changes.Has anyone encountered this behavior?Specifically:Where can we find the underlying exception when System Monitor only shows this wrapper? Are additional server-side scheduler or application logs available? Could stale screen/customization cache cause initialization to fail until the web

In continuation with the below article, the current article explains how the same can be done in 23R1 and the difference between 22R2 and 23R1. Like in 22R2, in 23R1 there are out of box import scenarios for Template Item(Import Template Items), Matrix Item (Import Matrix Items). The Edit Template ID checkbox in the Item Class form which enabled the Template Item ID field in the Stock/Non-stock form is removed.  The Is a Kit checkbox is enabled in the Matrix Item which allows the Matrix Item to be created as a Product Kit. Check    All the above is done out of the box. Now to make the Template ID field editable in the Matrix item screen, the user has to publish the attached customization(“ImportMatrixItems2023R100.zip”) to this article. This customization package must be used only with 2023R1 and above.  There is a customization package for users who do not have commerce module as well. Check the attachment: “ERPImportMatrixItems2023R1002.zip” For 22R2, check    If the selected Templ

Hi community,I'm in the IT department at my company and currently handle system maintenance and oversight: I make sure everything runs smoothly, create dashboards, write Generic Inquiries, and modify reports in Report Designer. I understand our business processes and already manage several modules well.I would like to specialize further and strengthen my skills, so I’m looking for guidance on where to take courses. Some time ago, I started an interactive quiz-style course that covered the fundamentals of Acumatica and its modules, but when I try to access it now, it shows as no longer available.Could you recommend courses, learning paths, or resources I should look into for my IT profile? Also, for administration and lightweight customizations, which key certifications or badges are worth pursuing for someone in IT?Thanks in advance for your help!

Folks, I’m the Acumatica product manager responsible for defining the advanced planning and scheduling (APS) features for the manufacturing edition. If you’re an Acumatica user, VAR, or OEM partner: Looking for the system to offer a better way to plan and schedule, Want to be notified of updates, and Want to affect the direction of our feature developmentThen join the APS group by emailing me at john.brown@acumatica.com.We’ll meet to discuss your planning and scheduling needs, and you’ll have opportunities to test and share your input on upcoming designs. I value your point of view. We have already started testing designs and gathering requirements from VARs and customers. If you’re interested, don’t miss out. Shoot me an email and let me know 😊

In APS is there way we can change the Production Schedule Horizon? Because by Default Acumatica providing 120 days for scheduling but can we change this?

After upgrading to Acumatica 2025R2, some of my users started experiencing random slowdowns. Each week, one or two users report performance issues, but when I check the PCs and the server, neither is running at full capacity. I’m not sure what’s causing it

Is there anyone that has come up with a way to split a production order after production has started, manually, that allows for the order to be tied back to the original order for quality compliance?If so, how are you doing it?We are trying to use Acumatica 2026.Example: 100 pc are put into production 7 steps into production we need to split the order due to some issue. 50 will be completed as originally planned and 50 will go through some other process before being shipped to the customer.We need to maintain the history of the entire production order for quality purposes. Even if it requires a custom report and some way to flag the orders to put them together.Using Lots or serial numbers are not an option.

The below has been submitted to our support partner.Issue: A PXLockViolation error is thrown when attempting to save a change to the production order warehouse for a production order with a linked sales order, when the "Yes" option is selected in the popup dialogue to also change the warehouse on the line of the related sales order.This error is present when no customizations are published and the sales demo data is loaded, so it is very simple to reproduce.  Confirmed Affected Versions:26.100.0175.2 26.100.0175.5 26.200.0334   Steps to Reproduce:  Create a production order from a sales order, or link an existing sales order and production order. Ensure the Production order is in the Planned status.  Change the production order warehouse.  In the popup dialogue box that asks, "Do you want to update the warehouse in the <1> line of the <SO> <SO009312> sales order?" click "Yes".  Attempt to save the production order.  The error message "Error: Another process ha