Discussion Forums

Client recently added Bank Feeds (Acumatica 24R1) and set up a feed via Plaid to their operating account. The feed pulled part of 1 day’s transactions from the middle of the prior month (both in test mode and live), then received an error: The bank feed service (path: 0/plaid/transactions/get) returned the following server error: the requested product is not yet ready. please provide a webhook or try the request again later. Client then deleted the feed and connected with the same error after trying to pull from the following month. Attempts to retrieve additional transactions gets the same error.I have confirmed via the bank statement that there are many transactions over the last month and a half. Where are they?

Hi,I would appreciate assistance with requirement below.The system picks the vendor price based on sequence shown in the image below. if any pricing set are not available, the system picks the last cost. I’m looking for a way to avoid picking the vendor price automatically and ask to key in manually always.  Thanks,Dulanjana

I have an issue on the QMS Module,  For stock items that we need to do inspections/samples/tests/etc, I know that we can apply a QC plan and some QC Tests to the stock item, and check the Receiving checkbox. That will generate a QC order whenever that item gets received, and it is all automatic.  However, this only appears to work if the item is received under a Purchase Receipt and not just an ordinary Inventory Receipt. Which is my problem. Now, I know that I can also check the box for Adhoc QC which will allow me to essentially create a manual QC Order but I have to go in and select the Inventory ID, the Location, The Quantity, the plan, and everything which is quite a hassel. Is there any way that I can get the system to generate a QC order for inventory that is received under an inventory receipt as well? I know there are a couple more boxes of options in the Stock Items screen, but I don’t know what most of them do. Any Help on this would be greatly appreciated.

I am struggling to get my automation to open GL Periods on a specific day of the month. This is the current schedule and conditions that I have,However I do not understand how to do relative values with the relative checkbox.I cannot use equations in these condition fields, so I am stuck.Can anyone help me with this? 

The ones i have in mind areCreate Purchase Orders - POFixedDemandApprovals - EPApprovalProcess.EPOwnedThis is for dashboard purposes

In my GI, I have multiple columns using the same schema field to format into whole numbers with commas. However, on the Total Aggregate Function, one maintains that format, while the other two do not.    The only difference in these fields that I can think of is, the one that is working is a calculated field from this GI, where the other two were calculated on another GI and then brought in as a data source, but I am not allowed to bring over extra schema fields/formatting if I use a GI as a data source.   Does anyone know if there is some way for me to do this? I really wish the total aggregate function just matched the same schema field since it is on the same results grid row….  

I have been searching for a way to get tigher Acumatica UI Integration with third-party systems. The webhook feature seems to get us a lot closer to this possibility, where we can receive a JSON payload from a third party system on demand and then process that payload with Acumatica framework.Is it possible to target a specific user session for a UI update with Acumatica framework? The idea, for example, would be to push a sales order line to an existing order, and then update the UI for any user who is currently working with that Sales Order.Has anyone done anything similar to this in the past?

Wondering how everyone is handling the tariffs?  It’s easy enough when a vendor issues a price increase that I can just pass through.  My issue is when I am getting hit with tariff lines on invoices from vendors.  Not sure how to accurately absorb those lines on incoming PO’s and pass them along on a Sales Order without a ton of manual work.

On our purchase orders for outwork/subcontract work we want the PO to show the production order number.  Our production order number is alpha numeric.I have tried using the following in the visableExpr field but they all cause errors: [AMProdOper.ProdOrdID]=0 [AMProdOper.ProdOrdID]=’’ IIF statement  (this is my first time using the community for help so im hoping ive done it correctly :-) )  

Hii, i want to ask about the import scenario, can we add directly “Remove Hold” for Fixed Asset that we want to Import to Active Asset? so we don’t need to do it manually, is it possible to do it?Please help me to solve about this, thank you, i really appreciate😄 

Hi,I need to clarify how to find out which endpoint version corresponds to Acumatica 2025R2 version ?Is it 24.200.001 ?

 SM208000 - Generic InquiryAt Generic Inquiry screen we have field “Row Style” which helps us creating GI styles due to our template.  I want to create a similar field that, instead of affecting the GI, applies to my custom table. I’ve managed to copy the field and its smart panel, and I even made it possible to select fields from my table. However, when I click OK, the style is not applied to the table.Is it possible to implement this functionality? If so, how can I do it?More details on what I have done: The field and smart panel are similar to those on the Generic Inquiry screen. I copied the DAC field, its definition in the ASPX file, and also added my own method in the ASPX.cs file. DAC field: #region RowStyleFormula public abstract class rowStyleFormula : BqlType<IBqlString, string>.Field<rowStyleFormula> {} [PXDBString] [PXUIField(DisplayName = "Row Style")] public string RowStyleFormula { get; set; } #endregionAspx:<pxa:P

 Row-Level Security (RLS for short in this article) is an Acumatica feature that allows users to configure visibility of information on a row-to-row level for each login (according to their role). Feature explanationRow visibility is configured using *restriction groups*. There are different types of restriction groups, which also differ in their way of handling cross-group relations.  To understand how this works, I suggest you read official Row-Level Security manual (first 6 chapters are general use; the rest are explaining individual module configurations, which might not be needed in your task).  Types of restriction groups and rules on how they interact with each other are explained in the Types of Restriction Groups chapter. It also has some examples with useful diagrams, which make it easier to understand.   Implement your custom row level security setupHere's the checklist of what you need to enable RLS for your DAC:Implement PX.SM.IRestricted and PX.SM.IIncludable in your DAC;

We want to use scrap as a way to track raw material loss when getting non conforming product.  The problem we discovered is that we backflush boxes and pallets in the BOM.  When we scrap product, we do not use a box or pallet.  How do we stop the system from adding those in a material backflush issue on scrap moves?  

We need to capture the mileage travel on an appointment as an expense to the Service orders.  Our customer does not want to create a expense claim for the mileage but want to be able to capture the distance as an expense on the appointment.The only methods visible to capture an expense on Appointments is with Expense claim/Vendor bill/employee time cardWill this be possible ? Any suggestions?

Hi,I created a custom Payment/Receipt report, but the Payment Reference Number parameter is not working. I’ve attached the report .rpx file and a screenshot for reference.Could someone please advise what might be causing this and how to resolve it?   Thanks 

Can anyone explain to me why the description can’t be edited after a document is released? It’s only a text field. There’s zero impact on financial numbers. What could be the logical reason why not? I know this subject has been asked about in this community group before. Yet somehow the threads have disappeared. It does show up in the ideas section, but it’s been left hanging for 10 years. What am I missing? Is there a way to make simple text edits and I just haven’t figured it out? It is this specific field I would like to be able to edit. Thanks!  

I am having a problem when I print an AIA Proforma Invoice for a project that has a change order with a cancelled status.  The change order does not show on the second page of the report, but it shows in the cancelled change order value in the Change Order Summary area.  In the screenshot below, the additions should be $80,219.25.  There was is a cancelled change order in the value of $25,645 being included that shouldn’t be.  Is this a known issue or how could I customize the report to eliminate the cancelled change orders from the change order summary? 

When we bill a customer account, for some reason its showing as Bill 3rd Party on the label and a vendor just reached out letting us know they are getting hit with fees.We've talked with Fedex multiple times. Fedex said it's some type of configuration in the back end of Acumatica causing this issue. We are sending to the responsible party. FedEx Support said it's being sent over as 3rd Party. FedEx support is unable to change it, said it has to be changed on the backend of the system: "The payment type is coming in the transaction and Acumatica needs to work with the Web Service hotline – 8773392774.   Thank you. We've also had one of our devs look at it. His analysis:From review of Acumatica source code, it looks like when the shipment Use Customer Account endorsement is set and the carrier billing type for the customer is Receiver, then the integration adds 'RECEIVER' as an attribute.  I don't have view into the Acumatica FedEX api, so I can't see exactly how everything is fed into t

Hello, We’re experiencing an issue in Acumatica...When i go to Receivables > Customer Statements > Run Report., the PDF toolbar used to show Print, Send, and Export buttons. But now the Send button is missing. Has anyone else run into this or know a quick way to fix this? Been trying to figure this out for hours 

When using the Device Hub, what user do you use when is installed on a Server? Do you create a standard user, user it support or create one?

I have a dashboard with a scorecard tile that gives an invoice total for the current year. It is set up with parameters for date so that if the user onlys want to see the invoices for February, they can choose the appropriate dates on the dashboard. Then there is another scorecard that gives the invoice total for the previous year to date. It also has parameters so that the user can choose the dates and compare invoice total to to the same month last year for example. I have added a trend tile and it updates based on the salesperson selected, but does not update based on the dates selected, so that if the dashboard user selects February of 2022 and February of 2023, the trend tile still displays the trend for all of 2022 to all of 2023. Is there a way to configure the trend tile to also consider the dates selected by the user of the dashboard and give a trend for February 2022 to February 2023 if that is what the user has selected? I have selected last year as the period to compare.  

After the update my GI is not found. Can get help. I try locating it in the site map but It,s not there.  

We use the realtime sync to push new sales orders from Shopify into Acumatica when they are placed. We do not export sales orders from Acumatica back to Shopify.This works great, but the Shopify connector is also syncing orders back into Acumatica whenever the order is updated in Shopify.This is a big issue because the re-sync of orders overriding our changes to sales orders made during order processing in Acumatica.Here's an example:An order was placed and sent to Acumatica at ~8:40am Our rep processed the order in Acumatica and made changes to the order. After, they merged the account on the order in Shopify with a dupe. This change to the Shopify order made the connector see that the order was updated in Shopify and re-synced the order at 11:59 AM. This re-sync of  the order wiped out the changes that we made to the order in Acumatica after it had already been shipped.We need the connector to do the initial sync of new Shopify orders, but NEVER update the order in Acumatica again.I’

Hi, We have a client that uses Amex@work for their users. As of the current release 2022 R1, Plaid does not integrate with the Amex@work platform only individual Amex Accounts. Our client has over 100 Amex Accounts that they would have to purchase bank feeds for since Acumatica and Plaid do not work with Amex@work. Does anyone know if the new service called MX is compatible with Amex@work in the newest release 2022 R2? Also, if not is there an efficient workaround to make Acumatica and Amex@work integrate together. Any suggestions would be appreciated.  Thank you,Frances Pantelidakis