Discussion Forums

Good morning everyone. I am trying to create a new bom with a business event using a GI and an import scenario on a schedule. I am getting the error “The last error was Cannot generate the next number for the BOM sequence.”. To diagnose it easier, I exported the GI to excel and made a data provider, new import scenario, and used import by scenario to upload. i used the community post below to find a solution that worked. This post used option 1 in the below screenshot. It worked fine and created a new bom with the next autonumber with everything correct on it. I then made the change to the business event subscriber import scenario and I got the “cannot generate next number” error. I then tried option 2 below and the business event history shows that it ran successfully with no errors but it didnt actually create the bom. I saw another post where someone could only get the header to get created and had to add materials later so I tried making the GI as simple as possible and use only th

Is it possible to change the transaction description that is automatically generated by intercompany transactions?Currently the transaction description is “Balancing entry for: BRANCH” but the branch is the same branch that the transaction posts to.  It would be more helpful to people reviewing the general ledger transactions to know what branch that the balancing entry was from.  These two descriptions should be swapped to be useful:It is not helpful to see PRODWHOLE has a transaction that is a balancing entry for PRODWHOLE.  It would be more useful to the person reviewing the transaction to know that the branch PRODWHOLE has a balancing entry that came from PRODRETAIL. This issue is sort of related to these:Change the transaction description of invoices created with multiple installment credit terms (Build 2024.2) | CommunityPosting meaningful description for journal entries | CommunityDoes anyone have the code to update the Intercompany transactions? 

Hi, client has several Operation .Is there a way to restrict certain users from entering a Move trx for certain Operations or Workcenters? I tried RowData Security, no option for WorkCenters;  but I tried to use the Warehouse linked to the WorkCenter;  but it did not work. Business Case.  Op worker entering movement for the WC he is working and not a different workcenter.ie,  Assembly vs Packing vs Quality Control.

Hello  Is it possible to populate the Description (Image alt text) field in BigCommerce when uploading images from Acumatica using the Acumatica connector.  Thanks  Matt

Hi everyone,I would like to have a visual on the margin of my transports. Why can't I click on PO linked? I do click on Mark for PO, I add my PO, and it's impossible. Any solutions?Thank you.

We are a retail business using Acumatica in UK and currently have the Stripe integration switched on and working to accept payments in Acumatica, to do this we can manually type the card details into Acumatica & then the payment detail is sent to Stripe via the OOTB integration to authorise / take payment. We would like to be able to use card terminals within our showrooms so customers can insert their card into the terminal to pay but are struggling to work out what we need to do / what integration is required to allow the payment detail to get to the card terminal, the card terminal sorts the payment and then updates Acumatica when the payment has went through. Is anyone else using Stripe card readers with Acumatica and if so what extra steps / integration are you using to get it working?

We offer installation, removal and storage services to our customers. When we sell a project, the stock item is on the sales order and “Shipped” once it has been installed. We are able to track that inventory up until this point. Then the product gets removed and stored in our warehouse, but we do not have a way of tracking it since it is now customer - owned product and not our own inventory. Does anyone have any suggestions on how to go about this? 

I have two buttons that open the same dialog window. I need to set the visibility of the dialog fields depending on which button is clicked.

Hi, I’m setting up a automation schedule for recalculate customer balances. I have about 1000 customers, but the schedule only run for two customers all the time. I have tried the same schedule setup in a local environment which runs for all customers without any issues. Below is the schedule I have added. Trying to figure out why it is limited to two customers all the time. No conditions are available and here are the other settings. Thank you,Dulanjana

Instead of going to each cash purchase and releasing one by one , is it possible to release several cash purchases at once ?

I had tried not activating the EI taxes on the Employee Payroll Settings but get an error when calculating the paycheck.  How do I set up this employee so EI insurable earnings & premiums are not calculated for this employee and that their T4 will show that they are EI exempt?

I’ve setup up purchase order appovals with email notifications, but I’m only able to send the notification to the purchase order owner using ((Document.OwnerID.EMail));. I’m trying to use ((Approval.ApprovedByID.EMail)); to send the notification to the approver, but the ((Approval.ApprovedByID.EMail)) value is returning an empty string. What is the correct value to use to send the notification to the assigned approver for the purchase order. I’m not using approval workgroups, just a single defined approver. This is on version 2024 R2.

Hello, our business has a requirement to upload the Scanned printed copies of Sales Order to Acumatica that is completed and highlighted with picking & packing information by warehouse employees. Currently, we bulk upload the copies in OneDrive, but we want a solution where the scanned copies lies next to the respective Sales Order in the Acumatica screen. The scanned copies can have a different tab or can be uploaded in the activities tab. This definetly requires customisation, our acumatica team is novice and has very little experience with this software. Has anyone in the community established this type of system, if so, then please do share the feedback and the steps of implementation.Thank you  

Many of our customers have the Amount field on their AP Bill entry screen, like this: On my instance this field is not showing up.  I’m trying to debug why things aren’t matching up and need to get this to display on my test server.  Any advice would be GREATLY appreciated.I’ve looked in Enable/Disable Features, and didn’t see anything.I have generally only worked with the API directly, and am not very familiar with the UI customization. 

Using the ARM report for the Balance Sheet - I am having trouble with the turnover formula. I have a consolidated column and a Prior Year column but my turnover Consolidated- Prior Year is not calculating correctly. Any insight would be appreciated.  

When trying to create return labels via “use customer account”, I receive error: “UPS: 121526 The payment method specified for Transportation charges is invalid for return service.” Any solution on how to solve this?

I see that a couple of years ago there was discussion about per unit discount.  We are building our Acumatica instance and stuck because we need a way to discount per gallon.  Fuel customers focus on the list price and offering a .20 discount is needed.  Sale price worksheets do not work for what we need.  Has there been any further development on this concept?  Any other ideas besides custom developing a solution?

I have production orders that span multiple months, but the Qty to Produce is just 1 unit (e.g., large machinery or equipment). Since Acumatica only posts overhead at the time of the final move, all overhead gets booked in a single month — even though the production activity and costs are spread across multiple months.This creates challenges in monthly financial reporting, as it overstates costs in one month and understates them in the others.

Is it possible to change the Transaction Description (ARTran.TranDesc) for the invoices created when using Credit Terms with the Multiple Installment Type?Currently it generates the invoices with “Multiple Installment Split” as the description. Ideally, we’d like it to either copy the transaction description from the original invoice or not automatically post the invoice so that we have the opportunity to manually adjust the description (i.e. maybe we’d write 1st Installment/2nd Installment/etc., or Installment for Dec-2025/Installment for Jan-2026/etc.).I reviewed the discussion on an earlier thread, but as that was a previous version I was asked to start a new thread. Change the transaction description of Invoices created with multiple installment credit terms | Community 

Using an ARM report, is it possible to create a Cash Flow Statement with a column for the period and a column for YTD?

We have a home brewed web app that handles some of our system's more unique and customized functions, and it needs to make various API calls, especially to the SalesOrder endpoint.We have a push notification setup to send a notice whenever a line changes on SOLine and that sends to the web app, which then makes an API call to grab order information to update the order in its system. For each call it logs in, does its thing, and logs out. We started getting the error "Sign-in limit exceeded LoginLimit:50", and at first couldn't figure out what was going on - we thought potentially we were getting so many calls that it was logging in 10 times in a row and hitting the user limit before the previous run had finished and queuing in more than 10 logins at once. Here is the flow:     Web app gets an 'OrderChanges' Push Notification from Acumatica (We have set this up so we can track various changes and then update the shipping message in our eCommerce platform). Because we need the full ord

With the new Lot Serial Attributes feature in 25R1, what is the best way to retrieve the value of the attribute for the lot serial number?My expectation was to be able to pass the lot serial number and attribute ID (with “Attribute” prepended) to GetValueExt, but I’m not consistently getting the return data that I’m expecting.I’m specifically looking at numeric attributes, so I’m looking for the ValueNumeric column from INItemLotSerialAttributesHeaderKvExt where the RecordID matches the NoteID of the INItemLotSerialAttributesHeader of the record passed to GetValueExt along with matching the AttributeID value. Thanks in advance.

I created a new screen that has workflow code on it. i followed the T270 series to make it. I am having issues with disabling an action conditionally. I want the “Remove Hold” button to be disabled whenever a line item is added that has a “Stock Replenishment Type” of “Manufacture” and the Bar ID is null. In the below picture, the removed hold button should be disabled because line 1 and 3 are empty in the bar id. i have the field conditionally required, but it will still put it on hold even though an error will pop up saying that the field has to be filled out. i tried adding it in a row selected event. i also tried to do it in the workflow. but it doesnt ever get disabled. can someone tell me what i am doing wrong?protected void _(Events.RowSelected<ProtoCutLine> e, PXCache cache){    ProtoCutLine row = e.Row;    ProtoCut lineitems = SelectFrom<ProtoCut>.Where<ProtoCut.orderID.IsEqual<ProtoCutLine.orderID.FromCurrent>>.View.Select(this);    if (lineitems.Statu

The system was unable to connect to RabbitMQ on the current server. Try the Connect to an existing RabbitMQ instance option; thesystem will attempt to connect using the connection settings you provide.

Hi all, I have a case that I apply and reverse the bill which already applied to prepayment, but I cant find this bill to apply againStep 1: I go to prepayment APP001349 to apply a bill APB00286Step 2: I reverse that billNow  I want to apply that bill again but I cant find this bill in document to apply tab Do you have any idea? Please advice me.