Solved

This is what I’ve been able to build but I want to make section that gives me a final number of how many I can build. Not have it show me what the lowest number in stock that I have. I want to see a section that says I can only build 6. 

Our process is Engineering creates BOM, Production Planning creates the Production Order under the Project, and the BOM is linked to the Production Order to generate material demand. Purchasing then procures material based on that demand.Our challenge is with ECO driven BOM revisions. If the Production order is still in Planning status, we can update the order with the new BOM revision and regenerate the demand successfully. However, after the Production Order is Released and material has been Issued, the status moves to In-Process, and we are no longer able to update the Production Order with the latest BOM revision.In this situation, the only option we currently see is to reverse the material issues, delete the existing Production Order, recreate a new Production order with the updated BOM revision, and then proceed again. This is operationally heavy and inefficient.I would like to know whether Acumatica provides any standard functionality, recommended process, or best practice for h

Invoice, click print.  There is a green email button.  For some users it is greyed out.  Where is the security setting for that button?

Hello, I have a user that needs access to the Side Bar in Sales orders. See Here. She needs access to the ‘Invoices and Memos’ button. I was pretty sure they were run by GIs but I’ve given permissions to the invoices one and that didn’t help. Any ideas?Thanks!

In Modern UI Trying to save a new card in the Sales Order with the Prepament option. But card entering option is non editable. Does anyone experienced this issue.  

We are building a remittance automation tool that needs to create an AR Payment and apply it to multiple invoices (1,300+ lines) via the REST API in Acumatica 25.200.001.What we've tried:PUT to /entity/Default/25.200.001/Payment with DocumentsToApply array containing AdjdDocType, AdjdRefNbr, and CuryAdjgAmt — returns HTTP 200 and updates LastModifiedDateTime but AppliedToDocuments stays 0. Documents are not applied. Import Scenario via the UI with a CSV provider mapping to the Payments and Applications screen (AR302000) — fails with "The system failed to commit the Adjustments row." Screen-based API POST to AR302000 — modern Acumatica 25.x loads the screen via JavaScript so DataSourceSessionID and DataSourceLoginID are not present in the initial HTML response. REST API /entity/Default/25.200.001/ImportScenario — returns 404, endpoint does not exist.Question:What is the correct method to programmatically create an AR Payment and apply it to multiple invoices in version 25.200.001? Is th

Hi Acumatica CommunityI created a Sales Order (TR) and Transfer Shipments.to Process Shipments, I used Pick, Pack and Ship functionality.But when I tried to receive this using Receive and Put away. I didn’t find what process do I need to scan.Do we have a documentation for this process?Thank you!

Hello,I am trying to process application in Acumatica to create invoice. I used Resource Owner Password to generate the tokenHTTPPOST<Acumatica ERP Instance URL>/identity/connect/tokenvar request = new HttpRequestMessage(HttpMethod.Post, configuration["Acumatica:TokenUrl"]);var collection = new List<KeyValuePair<string, string>>{ new("grant_type", "password"), new("client_id", configuration["Acumatica:ClientId"]), new("client_secret", configuration["Acumatica:ClientSecret"]), new("username", configuration["Acumatica:Username"]), new("password", configuration["Acumatica:Password"]), new("scope", configuration["Acumatica:scope"])};var content = new FormUrlEncodedContent(collection);request.Content = content;var response = await client.SendAsync(request);response.EnsureSuccessStatusCode();I am getting error API Login Limitfor the first time call. any help would be appreciated. 

How to override Receipt Nbr in adjustment for stock without receipt 

Hello, I was wondering if Acumatica had an email response time tracking feature where we could pull data on how quickly customer service reps our emailing clients. The system it would tie into is outlook. Does anyone know if Acumatica has a feature like this?

Hi, how do I change this Inventory ID selector to Location ID instead? Thanks 

Is that possible to integrate Azure maps in address provider of 2024 R1 Acumatica?

I need to display Purchase Order approved and the last person who approved the PO.In a GI or SQL it is simple to return the data for this as an Aggregated value Max on the ApproveDate. The table relationships: EPApproval Table and link it to POOrder using RefNoteID = POOrder.NoteID.How can this be achieved on the Report designer? Where will the Filter be applied?Retha

I 'm working on a customization where I need to allow users to select a DAC (for example Vendor, Contact, Location, etc.) and then dynamically display the list of available fields for that DAC so the selected field can be saved for later processing (similar to a generic Inquiry screen). The DAC is resolved dynamically at runtime, and the requirement is to list all usable fields (including standard DAC fields and extension Usr* fields) without hardcoding them. I tried to find a way by investigating Generic Inquiry screen, but I was unable to find working solution #region FullDACName [PXDBString(255, IsFixed = true, InputMask = "")] [PXUIField(DisplayName = "Full DACName")] [PXStringList( new[] { "PX.Objects.AP.VendorR", "PX.Objects.CR.Location", "PX.Objects.CR.Contact", "PX.Objects.AP.BAccount" }, new[] { "Vendor", "Location", "Contact", "BAccount" } )] public virtual string FullDACName { get; se

Hello everyone,We are encountering an issue with the Shopify connector for Acumatica24R1 regarding the synchronization of Business Customers (B2B). Both Company and Customer entities are active and both in bi-direction. Here’s the scenario:A business customer categorized as an organization is set up in Acumatica, with several contacts and locations. When this business customer was synced to Shopify, a Company was created using the same name as the business customer in Acumatica. All contacts were synced in Shopify as Customers associated with the newly created Company. The locations were also synced successfully, which looks good. During the next sync (in the aforementioned bi-directional direction), several new records were synced under the Customer entity. Upon reviewing the synced customer records, we discovered that the connector had created new Acumatica Customers, categorized as Individuals—one for each contact of the existing Business Customer (Company). This resulted in the dup

Good day,Is there an easy way to change the CRM Activity Email body from HTML to plain text.  I have tried a number of formulas (Html2PlainText) that are not supported by Acumatica. I have all the required fields but they want to body of the email included on the GI.Thoughts?Thank you.​@evangrill 

We created a Purchase Order and tagged it to a Project. A prepayment was then created against the Purchase order and processed completely through check printing. however, the prepayment amount paid to the vendor is not reflecting in the Project Balances or in the Cost Budget.At the moment, the Full PO value is showing as the committed amount in the Cost Budget, which is expected. however, the Prepayment amount itself is not appearing anywhere in the Project balances.I think the Prepayment amount is reflecting to the Project “X”.Could you please confirm, whether any configuration is required, or am I missing any process step to make the prepayment amount reflect correctly in the Project balance or cost budget? 

I have a processing screen with PXFilteredProcessingJoin where the main DAC is Customer with LeftJoin<CustomTable> and LeftJoin<Location>.In the grid I display Location__CPriceClassID field from the joined Location DAC.Problem: When I click the Selected checkbox on a row, the value in Location__CPriceClassID column disappears. It comes back when I click the checkbox again.Here is my view[PXFilterable]public PXFilteredProcessingJoin<Customer, CustomFilter,     LeftJoin<Location, On<Location.locationID, Equal<Customer.defLocationID>>,    LeftJoin<CustomTable, On<CustomTable.customerID, Equal<Customer.bAccountID>>>>,    Where<CustomTable.example, Equal<Current<CustomFilter.example>>,    And<Where<Customer.lastModifiedDateTime, GreaterEqual<CustomTable.LastUpdatedDate>,     Or<CustomTable.LastUpdatedDate, IsNull>>>>> Customers;and delegatepublic virtual IEnumerable customers(){ List<PXResu

One of my clients receives a payroll file with no header records. They can import into Quickbooks by mapping the data field to the column in the excel file. Does Acumatica allow this type of mapping? For example, Column A = Date, Column B = Amount...In the Data Provider or Import Scenario can I specify Column A = Date?

Hi Acumatica, I created a Sales Order with an Order Type of TR, and my requirements is to hide some of my transfer documents to specific users. Is there a way to configure this requirements? Thank you!

Hi,We would like to extend the user inactivity timeout to 8 hours, and we have already updated the setting accordingly.However, users are still being logged out before the expected time. Could you please advise how we can resolve this issue?Thank you.

We have instances where we are issued a credit from a vendor (which is a debit adjustment in Acumatica). We may not use them for future purchases for a long time, so we request a check be issued to us for the outstanding credit. When we receive that check,  can I apply it to the debit adjustment?  

I am probably missing something simple here, but we are struggling with inventory items be auto marked for PO on appointments when when the tech has the item along and there is plenty of inventory available. Only some items do this. Is there a setting in the inventory Item that is affecting this? 

Hi there, I have received a PO and now want to do the putaway but it keeps giving me this error:Put Away mode in use.Error: Inserting  'Receipt' record raised at least one error. Please review the errors.Document is out of balance.Scan the destination location. Im assuming this is because i havent been prompted to enter the quantity that i am putting away.Is there a setting i am missing?  

 ​@lauraj46 Looking for assistance with placement of the attached sub-report within the main report so that all the fields line up within the main report. Still trying to navigate all the data fields accurately, so always welcome to better ideas. I could whip this out easier in even an older version of SSRS.