Discussion Forums

Hello everyone! Acumatica Project&Construction team is planning to implement a new functionality - Prepayment for projects. I saw it was discussed and requested on the community several times:Prepayments to show on a project | CommunityConstruction Customer Prepayment | Community Could you please share with me how do you need to recognize the taxes for AR deposit on project? and when do you need recognize taxes? What is your setup for taxes for deposit on project? Could you please describe your business case when you need deposit on project? How do you request deposit for project? How do you process deposit got for project?  What is important for you when you work with prepayments on project?Thank you in advance for your answers!Have a good day!

Below is the import scenario I am trying to use to get our fixed assets into Acumatica.  When I run the import by scenario, it shows that the records processed, but nothing appears in the fixed assets form. 

In my case, I’m customizing SO301000 and enabling the import button on the Detail grid with the following:@gridConfig({ actionsConfig: { import: {hidden: false}, }})But, this seems to replace the settings that the base screen is using including: syncPosition: trueHow to I merge my configuration instead of replacing the existing gridConfig settings?

I'm looking for a way to manage a tenant's configuration as code — declarative files in a git repo I can review in a pull request, version, and re-apply to rebuild a tenant reproducibly.By "configuration" I mean setup data, not customization code: enabled features, company/branch structure, chart of accounts, ledgers, GL preferences, currencies, credit terms, financial calendars, and the like.The workflow I want is basically infrastructure-as-code — capture a tenant's setup into source files, edit them in git, apply to another tenant, then diff to catch drift.Customization Projects cover code but not this setup data. Snapshots are reproducible but are whole-database blobs — not human-readable or diffable in a PR. The REST API can push data, but it's a building block, not a desired-state workflow.Is there an existing tool or established pattern for this — a community tool, an ISV product, or something people have built in-house? Curious how others handle it.Thanks!

Hello,I am currently working on the integration between Acumatica and Microsoft Teams, and I would like to know how to configure a Business Event to automatically mention a specific user or group in Teams. The goal is for the notification to appear in a Teams channel with the the specific user or groups being tagged (e.g., @username), for example the new owner of a Ticket.Is there a way to set this up using the native Teams integration in Acumatica? If so, could you provide the steps or any relevant examples?Thank you for your help!

Please confirm - when using a Trigger by Schedule you can NOT select screen by shared filter as you can By Record Change ???   

I’m trying to programatically created Sales Shipments: given a despatch message from the third-party warehouse, I locate the sales order and then use CreateShipmentIssue to construct the shipment.This works fine when I run the action as a user. But fails every time when running as a Process via the automation scheduler.My code simplifies to:orderGraph.Clear();orderGraph.Document.Current = PXSelect<SOOrder,Where<SOOrder.orderNbr,Equal<Required<SOOrder.orderNbr>>>>.Select(orderGraph, orderNbr);PXAdapter adapter = new PXAdapter(PXView.Dummy.For<SOOrder>(orderGraph)) { AllowRedirect = false, MassProcess = false };var orders = orderGraph.CreateShipmentIssue(adapter, receivedItem.ShippedDate, siteID, DateTime.UtcNow);The error is:PX.Data.PXRowPersistingException: Error: 'CuryID' cannot be empty.   at PX.Data.PXDefaultAttribute.RowPersisting(PXCache sender, PXRowPersistingEventArgs e)   at PX.Data.PXCache.AttributeHandlersSquasher`1.<>c__DisplayClass2_0`1.&

hello,I am using Resource owner password flow to get Acumatica token.I am encountering an intermittent issue across all environments, including Production.When we receive an application for processing, we call the Acumatica Get Customer endpoint using a valid authentication token. Occasionally (approximately once a day or every other day), the request fails because the response cannot be deserialized. Our application expects a JSON response, but instead receives an HTML page, as shown below. We cache the authentication token and validate it each time it is retrieved from the cache. Token validation is based on the Date header returned in the token generation response to ensure the token has not expired. Could you help us determine why the API is intermittently returning HTML instead of the expected JSON response, despite the token being valid?Tokens:return html response : LqGoqJP-MvG2Q44kKI_QEq0PqziBlrWXnInucaZS9w0return Json (Valid): IPLN2zlT8ui3GzGoySRC2M5nyz0Xa-StJ3cup25MAncif (resp

Hi,I’m getting an error on my import scenario to import purchase orders. It will import the first order but then I get the error ‘The system failed to commit the transaction row. Any help would be greatly appreciated 

In Report Designer or Generic Inquiries, we can specify which values to include or exclude. Is there a similar feature available in Report Definitions? For example, I'd like to include accounts 100 and 500 while excluding account 200. 

I’m at a lost keep getting a “Failed to Commit to Adjustment Row” XML attached. The intermediate save is not the issue. 

Here’s my scenario: on Acumatica 26.100.0175.3, I have an environment with two tenants, let’s call them Tenant A and Tenant B. Tenant B is configured as a Test Tenant.I have a simple customization project that includes both custom fields to extend existing DACs (in this case, the CR.BAccount, SO.SOOrder and SO.SOLine DACs), as well as a new custom action button on SOOrderEntry. Both Tenants have the same Customization Projects loaded (via Export / Import). When I publish the projects in Tenant A, the custom action appears in both Tenant A and Tenant B, but the custom fields only appear in Tenant A. When I publish the project in Tenant B, the inverse happens (fields disappear from Tenant A, appear in Tenant B, and the new custom action still appears on both).I can’t make the custom fields appear in both Tenants at the same time for some reason. I’ve never had this issue in any other environment. I’m at a loss to explain what is going on here...

How to Calculate  Landed Cost for  items in Drop-Ship Order . In Normal Practice Yes its Not Possible since drop-ship orders are shipped directly from the supplier to the customer without passing through your warehouse

Hello,Really struggling with this one. Customer uses Crystal reports for a year on year analysis so can do full sql etc. I’m trying to reproduce this below in a GI and this is for a specific customer Where is becomes difficult is that when they go live there is no last year data although we will have a legacy dac and that is challenge when there is no option to do union, has anyone else achieved this ?

We know that Acumatica supports two entry points to create Credit Memo, I refer to them as SO Credit Memo and AR Credit Memo for short. Is there a way to restrict most users to only create SO Credit Memo from the SO Invoice entry, while only specific people have the permission to directly create AR Credit Memo in "Invoices and Memos"?The difficulties I encountered:Although the entry points of these credit memos are different, they seem to be essentially the same entity. SO Credit Memo will be converted into AR Credit Memo. I only want specific people to be able to create AR Credit Memo, but I also want other users to have permission to create AR Invoice. They are on the same screen and are different types of the same document, so I cannot directly restrict the "+" button on the "Invoices and Memos" screen.  

Hello,  I have a scenario where my company is based on UK and I have warehouses in Netherlands and Spain (Also in few other countries) Also, I have an EU customer whom I shall deliver goods from either Netherlands or Spain.On a sales order when I select the warehouse considering the country of it (If the country can be taken from branch that is also an option), and country of the customer, it should update the correct Tax Zone. In simple terms, my tax zone needs to be updated not solely based on the customer country but also considering the order origin country.  Is there a way to get this done?

I’d love to visit with someone who is using DRP for imports. We import textiles from India and Turkey so we have purchase orders placed, receive goods to an ITR warehouse when we put a container on an ocean shipment, then transfer goods to our main warehouse to fulfill sales orders. Our goal is for DRP to keep the inventory in our main warehouse to a minimum while keeping supply flowing in the purchase orders and containers in the ITR warehouse. Obviously DRP generates a lot of data with the requirement plans, safety stock, planned transfer demand, forecasts, etc. I’d like to hear with anyone who is using DRP and importing goods from overseas using container shipments (no preference on what you use to track containers - just interested in the bulk nature of transfers instead of being able to transfer at any time to meet demand). What tips/tricks do you have to keep this user-friendly for purchasing and inventory management staff? How did you set up safety stocks in each warehouse? 

I am using an import scenario to migrate my client’s open purchase orders.  I am testing it to ensure it works for go-live and it is only bringing in the first line of the purchase orders and the remainder error.  I have tried adding the @@LineNbr, but it still errors.  What am I missing? 

We have a weekly report of order cancellations/adjustments which we send out to customers. I have been able to set up a Generic Inquiry to identify the Customers who need notifying with a scheduled Business Event to send an Email Notification with a report attached to those customers. However, we have a customer that would like that report sent to multiple email addresses each week. I have set up the email template as a Mailing in the Account Receivable Preferences, added it to their Customer Class, and added the additional Recipients on the Mailing & Printing tab of that Customer record. Yet, when I generate the email via the business event, those additional recipients are not added to the email. Am I missing something in the setup, or is this functionality just not compatible with a custom GI/report like this? Is there a different way the Email Template has to be set up so it can have those additional recipients added, like a special placeholder or something? Testing Event Setup

 In December, I identified discrepancies in my historical inventory valuation report. I was able to isolate the specific transactions causing the issue; however, I require guidance on how to properly resolve it.The issue appears to have originated from the following sequence of events:A purchase order was created, and the items were subsequently received into inventory in November. Upon receipt, the Inventory account was debited and the Inventory Purchase Accrual account was credited. The customer was then billed in December, resulting in a debit to Accounts Receivable and a credit to Revenue. After billing, the inventory was allocated to the job, at which point Inventory was credited and Cost of Sales was debited.For this particular item, the historical inventory valuation report reflects a beginning cost, which is the correct value, followed by a sale amount that is double the beginning value, ultimately resulting in a negative inventory balance.  I don’t understand why the sale colu

Hello! I have made a few filters and want to show our “Default Salesperson” employees how to filter only their name. This is easy to do on desktop However, when I go to the mobile app, the filter doesn’t show up correctly. When I click on their filter, it’s blank.My initial guess is because there is no sort option for the salesperson on the app. Is this the case? If so, how do I add this as an option so our remote salespeople can see their sales more easily when they are travelling?

Hi good day.On the customer contracts screen, when adding a file to a contract with already existing files, i received this error message.Did anyone encountered the same? Thank you.

Hi everyone,We’ve recently upgraded from 24R2 to 25R2 and have encountered a strange issue with Employee Timecard/Summary/Summary Activity.In 24R2, users can enter their time spent per day of the week directly in the Summary Activity section (see left screenshot). However, in 25R2, this entire section appears to be missing, even without any customization published (right screenshot).This prevents users from entering their daily hours as they normally would.Has anyone else experienced this behavior after upgrading to 25R2?Thanks  

We’ve created an export scenario using a GI as the source. We need to add a trailer record to the end to sum up the number of payments and the total payment amount. Does anyone know how to do this?

Hi all,I know there is an existing discussion regarding adding @FinPeriodID as the default value for Period schema fields in Generic Inquiries:Add @FinPeriodID as Default Value for Period schema fields in Generic Inquiry | Community   However, I haven't been able to find the workaround that others have used. Would anyone be able to share some insight?My goal is to have the Generic Inquiry default to the current financial period, as it currently loads all periods by default, resulting in performance issues and, in some cases, errors. Thanks for your time.