Discussion Forums

We are using the  native Amazon Connector (BC201020), importing seller-fulfilled orders.I originally set up an item as a stock item and added its ASIN as an Alternate ID (Global type) on the Cross-Reference tab. We later decided the item should be a non-stock item instead. I created the non-stock item, removed the cross-reference row from the stock item (and saved), and added the same ASIN as a Global cross-reference on the non-stock item.When the Amazon Connector imports an order containing that ASIN, it errors out saying the cross-reference exists on two items — both the original stock item and the new non-stock item.**What I've checked:**- Reopened the stock item (IN202500) — the cross-reference row is not visible on the Cross-Reference tab.- The non-stock item (IN202000) shows exactly one row for the ASIN, Alternate Type = Global.- Only one UOM row exists per item; no duplicates within either item.**Questions:**1. Is there a place other than the item's Cross-Reference tab (e.g., a

It would greatly improve the ease of getting all costs onto our service orders if we could link an AP bill directly to a service order.  We do use the PO system for most of this, but still have expenses come in that we have to manually add to our service orders because there is not currently a way to link the bill in AP to the service order where we want the cost to show.

We need to the ability to have negative quantities on service orders so we can return items from a customer and back into inventory, while giving the customer credit for that return.

If you have a Dashboard widget with a GI and in that widget you have a parameter options set, when you PIN it as a KPI and open it, none of the inquiry parameters are preserved on the mobile app.Below is a screenshot - by default this is not checked. I had to edit the GI itself to preload this as the default. 

I’m looking to confirm that the following business event and subscriber should indeed trigger the “prepare invoice” button on a sales order. This business event is based on a generic inquiry that only shows sales orders with a specific ship zone and a status of open (so once the sales order is invoiced it will no longer be shown on the GI)XML To the GI is attached Action Execution: I can’t seem to get the business event to trigger for all of the records that already exist. I’m not sure when a new record will be added. Business event XML is added as well.Note I have tried the Raise Event: be “For Each Record” as well and wasn’t able to get it to initially run. Another thing I tried was counter filtering my GI so there were no records and then remove the counter filters so records would appear and that did not trigger the business event either. 

Hi all,Happy Mothers Day!I needed a way to connect Claude to our Acumatica 2025 R2 instance right now, and the official Acumatica integration looks like it's still some time away. So I built one (entirely using Claude Code), ran it in production against our own ERP for a few weeks, and have now open-sourced it under Apache 2.0:Repo: https://github.com/hallboys/MCP4AcumaticaMCP4Acumatica is  a remote MCP (Model Context Protocol) server that runs on Cloudflare Workers. Each user logs in with their own Acumatica credentials — the server holds nothing centrally beyond an encrypted refresh token, and a user's normal Acumatica role governs what records they can read. Any MCP client (Claude.ai, Claude Desktop, Claude Code, ChatGPT) can talk to it.What's in the box (v0.31.1):38 read-only entity tools — Customer, Vendor, Sales Order, Invoice, Bill, Payment, Stock Item, Project, Case, Service Order, Shipment, Employee, and most of the common screens. 6 utility/discovery tools — generic-inquiry l

Hello everyone, I want to ask about module fixed asset. So our customer want to know if in Acumatica we can see a journal preview before we process “Depreciation” in menu Calculate Depreciation. Do you guys have any suggestion for this? or in Acumatica have menu to accommodate our customer request?I really appreciate your help. Thank you.  

Hi everyone!With the rollout of Acumatica 2026 R1, many of us are starting to move clients or internal teams into the Modern UI. While the look is great, we are seeing some functional differences compared to the Classic UI, for example, there are reported challenges with how hyperlinks and redirects behave in custom screens or moving several JS functionality from Classic UI to Modern UI.I’m curious to hear from other partners and customers: What is one thing about the Modern UI that surprised you (good or bad) during a rollout?Is there a specific training tip or a configuration you’ve found that makes the transition smoother for end-users? I'd love to gather some 'best practices' to share as we all get used to the 2026 release!Thanks,Shushanna

Hello everyone,  so our customer request to custom Asset ID. So, the Asset ID can be more specific from their asset class.Here is the example of their customized Asset ID:FA-EQ-01 FA-VHC-01For now we set the Asset ID using Asset Numbering Sequence. Do we need to use customization Project to create the UDF or etc? Do you guys have any suggestion? if we need to use customization Project please share the step that we can implied to our database. I really appreciate your help.Thank you. 

Hi Team,I have noticed that in sales price worksheets once it is released, we are not able to make adjustments to it. However, when we click on ignore automatic line discount (Which is selectable though the worksheet is released) the entire worksheet is put back on hold for edits. Can anyone please explain to me what the intended functionality of this check box? I have tested with this and if we delete the worksheet and it doesn't remove the released prices in the sales prices form but this seems problematic for traceability. Thank you in advance on any thoughts. Warm regards,Yasali

Example :Inventory ID : B001How to i create 3 Barcode for B001 - BH, B001 - BOX, B001 - KARTON ?so, i can scan according the barcode,if i need 72 BH i can scan 1 - B001 - KARTON and 2 - B001 - BOX 

Hello,I have a scenario where when the user navigates to Customers » Print statement and click on ‘send’ the email activity pop up is generated with the default email template configured in the Report designer Template ID.  However when the user clicks on select template » replacing email body the fields mentioned with ((XXX.XXX)) such as ((CustomerDefaultBillingContact.EMail)) in the email template is not getting populated.  This is the header of the email template the user selects when changing the default template to the custom one  however, only the text is appearing on the email  I had tried to add this template to the report designer to see if the fields are populating and they do appear properly. it doesn't work only when the template is changed. Appreciate if anyone could help me in identifying the issue here and how to resolve it.  Thank you so much in advance.

Since Thursday August 6, we are seeing our Amazon FBM orders not sync into the system consistently. Results are sporadic at best, some come over right away, others come over 6 hours later and this is not sustainable. Anyone know if anything has changed on how Amazon is sending sales orders over for FBM? Most orders I cannot even see in the sync history if there is an error, they just do not populateNo one knows what to do to fix

The AP Bill is generating a warning stating that some bill lines differ from the corresponding lines of the related Purchase Order. We have verified that the PO, Purchase Receipt, and AP Bill values are consistent, including the quantity, UOM, unit cost, amount, and PO line linkage. However, the detailed warning for the related PO line shows an Unbilled Quantity of 0.00 KG and an Unbilled Amount of 0.00 CAD, with a unit cost of 4.2000 CAD per KG. What else could be the reason for this. ?

We have a workflow in which once a Subcontract has been fullly Billed, we create an invoice in our system to release the retainage.  There is usually no progress billing on that bill, and we are looking to release all retainage for that contract.It appears that there is a way to release retainage for a single bill at a time, but if I have a scenario like this:Subcontract total value: $10000Bill 1: $5000, with $500 retainageBill 2: $2500, with $250 retainageBill 3: $2500, with $250 retainageOnce that last bill is out, we create a ‘Retainage Release’ of $1000.  Is there any way to do this efficiently in the Acumatica API, other than finding all the Bills against a subcontract and looping through, releasing against each Bill?Or can I somehow release the full $1000 against the Subcontract in a single call?

All, I have an issue/question very similar to the one below, posted a few years back: As it stands now, any sales or cs rep can view any note or email activity attached to a business account or customer. This is a good thing as reps will often fill in for others when they’re afk or on vacation etc.But we now have a particular Business Account that’s being developed by our C suite where sensitive information is being shared. We could take this off channel, so to speak, but it’s easier to track by keeping it in Acumatica. But as it stands now, any sales or cs rep could view the activities attached to the BAccount. We would like (for now) to have this limited to only our CEO, COO and CFO.Is there way to lock this down? Once the BAccount is converted to a full Customer it won’t be an issue. As it stands now we would like to have some sort of role-based viewing but I don’t think it would be possible without heavy customization. Thanks!

Hello, We’re evaluating our end of month financials and noticed that labor hours booked without pieces/yield the burden isn’t booked. We’re using variable by labor hours overheard type. We’ve looked over the existing documentation and are still unsure what overhead would be appropriate for booking the burdened rate with labor hours and no pieces. 

Exciting News: BigCommerce Integration Coming to Acumatica 2025 R1 and Newer!Acumatica is thrilled to announce that the BigCommerce integration will soon be available for Acumatica versions 2025 R1 and newer launching in early 2026!This new integration allows Acumatica customers to seamlessly connect their BigCommerce storefront with Acumatica’s ERP platform. This means more automation, faster order processing, and real-time inventory and customer data sync between your ecommerce operations and your back-office workflows.What does this mean for you?Effortless order, inventory, and customer data flow between BigCommerce and Acumatica Fewer manual entry errors and time spent on double data input The ability to scale your online business with the latest and greatest from both platforms Remove the need for additional gateway fees and integrationsA note on paymentsAcumatica Payments is still the recommended option for the most streamlined, end-to-end payment experience. However, for custome

We are a small manufacturing company but use projects to track both our shop jobs and field jobs.  Currently the process to allocate materials to a field job is prohibitive.  We will do the following steps 30-60 days prior to the job being on the schedule.  Project inventory is turned on.  1) a transfer has to be created to move the materials from free stock to project stock (this then removes items from availability.)  Then the items are added to a PR Sales Order for shipping.  PR sales order does not update inventory or GL.  Then an inventory issue is processed when the materials leave the shop relieving the inventory from the Project Stock location and costing it to the job.How can we issue the materials (reserve) them for the project in the inventory so that the items don’t show available for other orders but would still be shown as in the warehouse until it is shipped to the project.  If we do an issue up front, it removes the items from available inventory, however the stock is s

I just created this KPI, and I’m trying to pull the OrigOrdeNbr to know the Original Owner. NOT the new ownerAll the records are pulling the OrderNbr Owner.Like the records below its showing 2 different OwnersI need help in finding out how to get to the OrigOrderNbr Owners.

We recently upgraded to 2025 R2, and I attempted to export data to Excel. Although the system indicates that the operation completed successfully, the downloaded file does not appear on the screen. I also checked my Downloads folder, but the file is not there.  

Dear All,  How to display two currencies in a single report, such as the BS (Balance Sheet) and PL (Profit & Loss)? How to set up a Chart of account so that it can accommodate all currencies? and how to configure it if a specific currency is required for the Chart of account linked to a cash account?

Hi all! I’m new to Acumatica; we just converted on 12/1 from Quickbooks.  How can I show an invoice marked as paid for my customers?  They ask for a paid invoice all the time for their records.  We sell high end products that many people need this for insurance purposes. Sometimes a customer will make a partial payment.  Example, a customer has an invoice for $100,000 worth of goods for which he paid $80,000.  I need the invoice to show: Total:  $100,000Amount Paid: $80,000Balance Due: $20,000 Or if it’s paid in full, it would be marked as such and balance due would be zero.  How can I do this?

We need to be able to generate time cards for all hourly employees for the year and have them in the “On Hold” status, without all the manual effort.We currently use the generate time card feature in the employee setup screen and generate a year’s worth of time cards for each needed employee.  This however creates the time cards in the “RELEASED” status and we have to then go into every single one of them and manually change them back to “On Hold” so time can be added to them.  This is a HUGE waste of time and it sems like this process should be easier.

Hi, I have a field to display PO#, and I’m trying to make its size dynamic, but despite trying all possible properties, it still only displays as much as fits in the original field size.I tried CanGrow first, then also ticked WordWrap, CanSplit, and Multiline, and as a last attempt, I also ticked CanShrink—none of them worked.The Report Designer version matches the Acumatica version, and the text field is not inside any other panel.I know I can manually increase the field size, but I’m trying to understand if these properties are actually functional. Any insights?Thanks!