Discussion Forums

Hello all, we have a client that currently heavily deals with kits within kits. Is this something that Acumatica can handle without modifying it?

For eg:-FY 2023-2024 —> should remain Apr 1st 2023 to 31st Mar 2024 (No change)FY 2024-2025 —> Currently set as Apr 1st 2024 —> 31st Mar 2025,But we want it to end on Jun 30th 2025 instead of March 31 2025.Can you help me how to resolve this issue.We want FY 2024-2025 to become a 15 month financial year (Apr 2024 to Jun-2025)Thanks in advance

Hello all,Does anyone know why a report would be missing from our menu even though it is in the site map AND I can access it with report designer? See below.  

Hi,I have a situation regarding the release sequence of pro forma invoices and would appreciate some clarification.Here is the scenario: Pro Forma 1: Large lump-sum amount(Progressive) (still pending client acceptance) Pro Forma 2: Extra work (T&M) currently under discussion with the client Pro Forma 3: Large extra T&M amount that has just been accepted by the client Pro Forma 4: Newly created All of them are currently on Hold.Since Pro Forma 3 has now been approved by the client, I would like to release it so we can proceed with invoicing. However, Pro Forma 1 and 2 are still under discussion and cannot be released yet.Is it mandatory to release pro forma invoices strictly in the order they were created?If so, what would be the recommended approach in this type of situation where earlier pro formas are still pending client approval but a later one is ready to bill?Thank you for your guidance.

Has anyone run into this problem?We’re doing the normal billing on a service appointment in the Service Management Module. On this appointment when we “Run Billing”, we are given the error code “Object reference not set to an instance of an object”. I’ve tried to trace it but have run out of ideas. 

I would like to inquire whether someone could advise me on how to use an existing Generic Inquiry so that the results can be sent automatically on a daily basis to specific email addresses.I have attempted to configure this using Automation Schedules and an Email Template; however, I have not been successful.Thank you in advance for your assistance.

The acumatica/company logo stopped showing on our Portal.I was wondering what accessrights do I need to have to see the logo? 

Publish fails on sandbox for modern UI 25R2. I tried using modern UI editor, but error is still blank. This package works on staging and dev environment.  

Does anyone perhaps have an idea how to set up a Generic Inquiry that would be sent automatically on a daily basis to specific recipients via email and would include information about Sales Orders—specifically when the ship date was changed, what the previous ship date was, what the updated ship date is, and who made the change?Please note that Audit History is enabled for Sales Orders.

Hello Community,How can I add my custom JavaScript code to a Modern UI screen? Regards,Vard

When making a transaction with API - is it possible to have it be created with Pending Approval status?When I add Hold= false to the request, it does that but it creates it without lines. With Hold = true it creates it with all the lines but status is on hold.Can it be created with status Pending Approval but with lines? Or is not possible because adding Hold=false prevents it from being editable and adding lines?

Where can you find live, hands-on training for GIs and dashboards?

I have a pivot table that shows units sold and sales $. When I click the hyperlink value for units or dollars, I get an error message saying ‘Invalid Column Name’ and it then references one of the columns in my data source - which is a Generic Inquiry.What I’m trying to see is if I can customize where these hyperlinks link to - and create my own drilldown tab. I’ve looked around on this community and prior questions like this have either no answer or mentioned you can’t customize the hyperlinks.Hoping things have changed since and maybe there’s a solution?thanks all!Joseph

Hi all,I created a GI with pivots for my company that shows unit sales, $ and margin by period as in the past it was done by calendar month.All totals line up and even individual amounts add up as well. There is just one particular set of months from 2 fiscals ago where the units don’t show up same as the calendar date report but instead show up 2 periods later. I was wondering if this would go away if I used TranPeriodID? only thing is the TranPeriodID is formatted differently which causes the reports to show up as “20-2602” instead of “02-2026”. when I try to format it it then messes up the internal comparisons and none of the unit sales line up properly anymore. in short, is it fine to stick with FinPeriodID from ARTRAN? Joseph

Hello Experts                      Until now (2025R2) or before, is there a way to set the sales Price for FIFO item based on its layer cost.  Like for item A, we are having 3 cost layers on hand.   Like $10,$11, $9. Can we set fixed markup like $3. When the $10 stocks are sold out, the system will change the price from (10+3) to (9+3)?

  I have tried to login to Report Designer but get below error message. I have download ERP from below which match with Acumatica cloud login.Online VersionDownload Builder VersionRole enabled Report Designererror messagelogin, Copied URL when login in online and delete the ScreenID, User name is my USername@tenantname 

 Hi, there is a custom field in Invoices and Memos screen called ‘Rental Agreement Nbr’ and this is also added in Application History tab of Payments and Applications screen. When sorting this column, I get the error: Unknown column 'ARRegister.UsrRANbr' in 'order clause' even though I have set the AllowSort to True. How do I allow sorting on this column?  

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!

Hi Community,I have two configuration- related questions regarding Production Order behavior1.Default Status when creating a New Production Order: when creating a new Production Order, it automatically goes to Planned Status. Is there a way to make it default to Hold status first?2. In the Production Order Maintenance – Reference tab- when using an Inventory ID that already has a BOM assigned, should the system automatically pull the BOM ID and Revision? Is there any way both BOM ID and BOM Revision can be left blank by default? I’m trying to understand if this is standard system behavior or controlled by configuration.

We were eagerly awaiting 2025R1 to be able to cancel/correct purchase receipts without having to go through AP to get the process completed.  We were hoping for a simple reversal feature that could make things easier when a mistake was made.I’m just now learning that if we want to use the purchase receipt cancel/correct functionality, the Manufacturing or Service Management functionality cannot be enabled in the Enable/Disable Features. Does anyone know the reason why this feature is not available if you use the Manufacturing or Service Management functions?

Hi there,We need to add the Address Line 1, 2 and Postal Code fields to the “Select Parent Account” popup screen. Usually if a field is not available to add (via the Gear icon) I can edit the underlying GI to make the field avaialble but I can’t seem to track that down. Does anyone know the name of the GI for this screen? Or would adding those fields require a customization project? Thank you!Jon HunsickerJones School Supply

I know you can add a link to a form in Acumatica to a dashboard but is it possible to add a link to a pdf file that is stored on sharepoint. We have templates that the sales dept uses on a regular basis.  Occasionally they use an outdated form so it would be great to put a link to the correct pdf form on their dashboard then they would know they are always grabbing the most up to date version.

Hi Everyone, I’m trying to add the Bank Deposit (CA305000) to a custom endpoint, however I’m struggling with getting the payment details to populate.I have no issue with adding the Header or the charges, but I’ve tried a bunch of different ways of adding the payments without any success.Below is how I have the endpoint at the moment however I have tried it with the AddPaymentDetail not being nested within AddPayment as well as trying to add the payments directly through Payments.When I submit a request the record will create however the payment detail will be emptyThe closest I can got to having it look like it is trying to add the payments is if I omit the DocModule property of $.AddPayment.Payments[*] then I receive the following error.Any help here would be greatly appreciated.

Hi,I am implementing my first Bank Feed using the “From File” (CSV) option for a corporate credit card.The objective is to: Generate Expense Receipts Ensure proper bank reconciliation Maintain clean matching between the corporate card and the cash account Since this is my first implementation, I would appreciate guidance on best practices and common pitfalls.1️⃣ Transactions to Include in the File (For Expense Receipts + Reconciliation)I need to code my parserTo ensure proper reconciliation, should the CSV file include: Only purchase transactions? Or both purchases and payments? What about interest charges, fees, or adjustments? Example of the file structure I am working with: If the goal is: Automatic Expense Receipt creation Proper Cash Account reconciliation Is it considered best practice to: Include all transactions (purchases, payments, fees) for reconciliation accuracy? Or split logic between expense-related transactions and payment-related transactions? 2️⃣ Account N

Hello CRM Users, The CRM Product Management team had a fantastic time last month at Acumatica Summit 2026, and we truly appreciated the opportunity to share new CRM capabilities and connect with many of you in person. Your engagement, questions, and candid feedback are invaluable as we continue to evolve Acumatica CRM.  Whether or not you were able to attend Summit, we would love your input. Please take a few minutes to complete our post-Summit CRM survey. Your responses will help us:  Prioritize and shape the future CRM roadmap   Partner with current users to validate designs and enhancements to specific features   Identify high-value improvements and new capabilities   Strengthen how we collaborate and communicate with the CRM user community   Thank you again for your time, insights, and partnership.  We look forward to building the next generation of Acumatica CRM together!   -Tara and Michael Acumatica CRM Product Managers