Discussion Forums

How do we send an automated email to our customers AP email address that includes the ship confirmation and the delivery image(s)? 

Has anyone ever ran into this issue?When using an email template to send out notifications to customers and the receiver’s preview window for the email does not read the body of the email, but instead lists, “Constants loaded at”? I read that it could be the email provider’s formatting is reading open characters first instead of the characters it is supposed to catch first, however I didn’t seem to find a solution. Any thoughts?

A prospect is interested in a membership Management system where its new prospects can create accounts and apply for membership, old members can apply for renewals, download membership certificates, upload receipts of payment and their ongoing project profiles etc. Please recommend an ISV for this solution that integrates with Acumatica receivables.

When I add manual document discount to Po Order ,discount amount don't reduce automatically. I want to auto reduce at AP bill . Is this possible ? How solve?

For those new to ASP.NET, (like me) this is a good explanation of the process and hopefully demystifies the delays. Here is the step-by-step process:1. The compilation of C# code into a DLLAn ASP.NET project's C# code, including the "code-behind" files (e.g., MyPage.aspx.cs), is compiled into a Dynamic-Link Library (.dll

Acumatica allows displaying the endpoint schema with a REST call. This is an example of the Customer endpoint schema.localhost/acumaticadb/entity/Default/24.200.001/Customer/$adHocSchemaI put the output on my server as it too large to display in a post.https://johnspikowski.com/acumatica/customer_schema.txtThe Web Services Endpoint screen is another asset for endpoint definitions.http://localhost/acumaticadb/Main?CompanyID=Demo&ScreenId=SM2070PL 

We are relatively new to Acumatica so I am trying to find out if it is possible to create a generic inquiry that uses a Data Provider to an external MS SQL database to pull data and create dashboards. That is the high level question.DETAILSWe are running Acumatica version 22 R1. I have a Data Provider using the MS SQL Provider type that connects to an external MS SQL database that runs a specialty manufacturing application that we use. The Data Provider is working and I am using that data provider to power some import scenarios that bring new customers and invoices from the manufacturing application into Acumatica on a daily basis. This has been working great so I know I can connect and pull data using an import scenario.OBJECTIVEWhat I would like to do is create a dashboard in Acumatica that shows any accounts that have been closed in our manufacturing application that are still open in Acumatica. This would be

Hi All,I know that the system will create demand based on historical data, but how far back will that go?If I have a client that has been using Acumatica for a year and they turn on replenishment now, do we turn on the moving average and update to 12 months and it will calculate the last year of transactions?Thanks!

Hi,What is last Acumatica supported version?Second moment, which I need to clarify, how to find out which endpoint version corresponds to Acumatica version ? Does any endpoint version can be imported for any Acumatica version or there are some rules and logic, which must be followed for correct work ?

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Drew Nisley - Acumatica Community Featured Member for August 2025Meet Drew Nisley our Acumatica Community Featured Member for August 2025. It’s great to have you as part of the Acumatica Community ​@DrewNisley! 

Hello,I am importing Sales Orders.  Following the exact steps and data of my import scenario, I can manually enter the Sales Order via the standard interface.  However, my import scenario fails for any stock item that is set as a Make To Order item.  I have added a line to uncheck the Mark For Production box on the sales order line in my scenario since that is what the error message says. “The Free Stock inventory source cannot be selected because the line is marked for production or purchasing.”As a more specific test, I changed the stock item to “No Default” for “Dflt Mark For”, but left the MTO box checked.  I still get the same error.  So it must be the check box on the stock item for “Make to Order”If I uncheck the Make To Order Item box on the stock item, the sales order imports properly.I am unsure how to move

As Payment method and Cash account not required in Credit memo. If added that, its crating Payment record.   

I am working with Acumatica 2024 R2 in Reconciliation Statements screen. I need to add totals of receipts and disbursement in detail section as a footer. I am supposed to make those updates in the detail grid of the Customization Project Editor, but there is no detail grid available. I am new to this kind of configuration. Please show me a detailed method.  Regards,Nisha

Hello, Has anyone encountered this issue before?I recently un-installed and re-installed the Acumatica app on 2 Zebra devices due to personnel changes. Ever since then, the devices are not allowing the picker to scan/manually enter the pick list number (which happens to be our shipment number). As seen in the attached example, the picker would normally enter pick, pack and ship, then scan (or manually enter) the barcode/shipment number at the top of the page.When the 2 devices scan this barcode/enter the shipment number, the device errors out and says “SHP007767 is not valid.”When I try the exact same steps on another device, then it works as it should, and the picker is able to scan the barcode. We currently have a workaround where these 2 devices select “Next List” and follow the prompts to pick and pack. It is very odd to me that this issue is only occurring on these 2 devices where the app was recently re-installed. Any hel

Is there a way to set Retained Earnings to close to one singular subaccount instead of each one individually? And, if not, what is the workaround most people would recommend? Make a journal entry? The only issue I could see with that is that it will have to be done for any transactions that need back-posted to the previous year after closing. 

Acumatica Commerce Connector does not allow mapping of the custom fields for the Sales Order Lines using Entity mapping screen, however, you can use customization engine and include custom fields.To do so, you can create an extension for the Sales Order Processor and include the SO Line custom fields in the API Object.//BCSalesOrderProcessor is the main class that does synchronization of the Sales Orderspublic class BCSalesOrderProcessorExt : PXGraphExtension<BCSalesOrderProcessor>{ public delegate void MapBucketImportDelegate(BCSalesOrderBucket bucket, IMappedEntity existing); //MapBucketImport is mapping the eCommerce API object to Acumatica API Object. [PXOverride] public void MapBucketImport(BCSalesOrderBucket bucket, IMappedEntity existing, MapBucketImportDelegate baseMethod) { baseMethod(bucket, existing); foreach (var detrow in (IEnume

Good day,Does anyone have a GI or a proposal on how to print multiple purchase orders at that same time.  We have a project that requires print outs of the a certain type of purchase.  Or does the user need to print them one at the time.  Mass print does not work on the GI.  Also, PO print/email process is not set up the same as the Sales orders.Any suggestions? 

Hi AllIs there any feature or solution in Acumatica that allows for entry of an invoice amount before releasing it?Maybe similar to how control quantites work in the shipments screen? The cashier would enter the amount on the invoice as a required action before the invoice can be released.Also just a step futher, maybe enter the amount that the customer is paying with and calculate the change due as well? For example the invoice is $81 and the customer pays with $100, the cashier would enter the $100 and another field would automatically calculate the change due.I know the last inquiry is pushing it and we may need to go down the customization road for all of it. But if there is anything out there for the basics of the inquiry, it’ll be a start.ThanksAmit 

We are wanting to upgrade from 2020 R2 to 2021 R1.   We are on premise so we need to move the a snapshot to a test environment.  We have been on acumatica  for just over a year and our snapshot is already to large to import with the default settings.  We have adjusted the webconfig to allow for our snapshot size of 1.5 Gb (we are just over the limit with our snahot being 1.1Gb).We now get the error “Error: The file is not found, or you don't have enough rights to see the file”   I have tried importing from the server directly with the snapshot right in the c drive.  I have tried creating other snapshots, thinking the first one was corrupt.We do have custom fields created and need a way to bring the snapshot over for proper testing.  What would the official way of doing this be?

I added a smartpanel to the Sales Order screen.  It functions exactly the way I want it to.  The problem is that it only opens 1 time.  If I refresh the page, it works again, but only once.This is my aspx code:<px:PXSmartPanel runat="server" ID="icsPrintSOInvoices" Caption="Print SO Invoices" CaptionVisible="True" Height="220px" AutoRepaint="True" LoadOnDemand="True" Width="400px" ShowAfterLoad="True" Key="SOInvoicesVw" AutoCallBack-Target="icsSOInvoiceList" AutoCallBack-Command="Refresh"> <px:PXGrid runat="server" ID="icsSOInvoiceList" SkinID="Details" Width="100%" DataSourceID="ds" KeepPosition="False" AllowPaging="True" Height="100px"> <Levels> <px:PXGridLevel DataMember="SOInvoicesVw"> <Columns> <px:PXGridColumn DataField="

I am trying to make credit memo numbers return a negative amount and leave the all other doc types positive. This is the code I wrote and I cannot figure out how to get this to work correctly. Any help is appreciated. =IIf([ARInvoice.DocType]='Credit Memo',(IIf([ARTaxTran.CuryTaxableAmt]<>Null Or [ARTaxTran.CuryTaxableAmt]<>0,-([ARInvoice.CuryDetailExtPriceTotal]-[ARTaxTran.CuryTaxableAmt]),0))),(IIf([ARTaxTran.CuryTaxableAmt]<>Null Or [ARTaxTran.CuryTaxableAmt]<>0,([ARInvoice.CuryDetailExtPriceTotal]-[ARTaxTran.CuryTaxableAmt]),0)) 

Hi, Please check out this website. https://www.realwear.com/devices/navigator-520Has anyone come across this product and/or know of a customer who is using these glasses integrated to Acumatica for field services, equipment maintenance?With RealWear Navigator 520, users can log real-time inspection data based on situational hazards and issues – all while remaining hands-free and maintaining situational awareness.Or do you know of anything similar?If yes please advise thanks. 

       Currently, in the liability section of our balance sheet, "Purchase Accrual" and "Accounts Payable" are displayed separately. Our company’s accountant has requested that the values of these two items be combined and shown as a single line item on the balance sheet.After checking, I noticed that it seems I could simply change the account class of "Purchase Accrual" from "othcurliab" to "AP" to achieve this. However, would this cause any issues? Is this the most recommended approach? Are there any better alternative solutions?

Good day,I want to update the BOM Warehouse.  Some of my BOMs are missing the Warehouse.The item warehouse details are correct with the default BOM.  We are using 2023R2Thank you.Evan   

Hello all,I'm reaching out today to see how to recognize revenue for fixed fee billing projects in Acumatica. When I run billing for a fixed fee/percent complete project, it will immediately recognize the entire amount billed as revenue, even if it is a downpayment before work on the project even starts. I've been trying to build an allocation rule that will move that amount to deferred revenue and move the balance back into revenue as we put time and materials into the project, but I haven't had much success with it. I'm curious as to how some of you go about this and any ideas would be greatly appreciated.Thank you,