Discussion Forums

Hi,I created one Processing screen with List of Vendors..After Processed selected records(3), All records(10) got vanished from the screen.If I refresh the grid/screen, then unprocessed records(7) are showing in the screen.How can I get unprocessed records automatically  without refresh after processing??Thanks.

Early this year, we added the Expense Management Module.  We have not been able to go live due to multiple usability issues - we have not been able to begin testing and mapping due to the fact that the Plaid/MX feeds for our credit card accounts do not bring over account owner information. That information is essential for a corporate card account with 20-30+ users. It is also essential for the functionality of pro-actively prompting employees to enter receipts for charges and matching those charges to the correct receipts. We need employees to proactively to see what charges are remaining to submit receipts on vs a manual receipt upload where after a month at reconciliation, accounting realizes they are missing multiple receipts and cannot complete the statement reconciliation.Is anyone using any third party/Acumatica friendly expense management apps that connect directly to Acumatica existing projects & GL Accounts as well as the ability easy approval mapping? If so, can you plea

Hi everyone,I’m working on integrating Outlook emails into Acumatica and want to send emails into a custom screen.I see a few possible approaches and would like advice on best practice:Use Acumatica Outlook Add-in — can it be extended with custom logic, or is it closed? Build a custom Outlook Add-in and send emails to Acumatica via REST API Pull emails from Acumatica using Microsoft Graph API (scheduled process)What is the recommended approach for this kind of integration?Is extending the existing Acumatica Outlook integration possible?Or are there any built-in Acumatica features that could help with this use case?

Hello experts, i have created access right by role for sales user and have restricted user to create shipment but when i am creating sales order create shipment button gets enables and allow to create shipment. please check the screen shot for access right by role and please let me know what am i missing. 

Hi everyone,Our team is ramping up on the new Acumatica UI and we're gathering training material to get everyone up to speed. We've already found the T290 course, which has been helpful.We're now looking for additional sources to round out our learning — anything that covers the new UI in depth. A few things we'd love pointers to:DevCon / Acumatica Summit sessions or recordings on the new UI Blog posts or article series YouTube channels or playlists Any other official or community-made content you'd recommendPlease let me know if you have something!

Hi, we have a set up of promotions by item class but need setup mixed promotions. Eg. Item Price Class 1 QPD 120ML (24) has 24 products in it. There is a promotion that is Buy 4 get 1 FREE (the products can be any of the 24 in the item price class). Currently Acumatica will only apply the discount if the customer buys Qty 4 of the one item – not mixed.Any thoughts on setting up mixed promotions?

Hi, Is there a configuration that allows revenue to be recognized as sales income at the time of shipment confirmation? Thanks,

Hello, I am trying to customize the screen SP401000 which only appears in the modern portal. I created a typescript and html extension for that screen, and published via the project editor in the main instance. Once I go into the portal of that main instance, those fields don’t show up. Is there a different process for adding custom fields to the portal? When I did ctr+alt in that screen, the view uses the same CRCase database which those custom fields are located in.

We are setting up the native connector with Shopify B2B.In Acumatica, we have customers set up with multiple Locations — for example, a company with several office branches, each with its own address.How do we configure the connector so that when a B2B order is placed from a specific company location in Shopify:- The Ship-To address on the Sales Order becomes the address of that location (the office that placed the order)- The Bill-To address remains the address of the parent company

I have my custom form.DAC: [Serializable][PXCacheName(Messages.CustomerStandingPOs)][PXPrimaryGraph(typeof(ABCustomerPOsMaint))]public class ABCustomerPOs : PXBqlTable, IBqlTable{    #region CustomerID    public abstract class customerID : PX.Data.BQL.BqlInt.Field<customerID> { }    [CustomerActive(Visibility = PXUIVisibility.SelectorVisible, DescriptionField = typeof(Customer.acctName), Filterable = true, Required = true)]    [PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)]    public virtual Int32? CustomerID { get; set; }    #endregion    #region EffectiveDate    public abstract class effectiveDate : PX.Data.BQL.BqlDateTime.Field<effectiveDate> { }    [PXDBDate]    [PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)]    [PXUIField(DisplayName = Messages.EffectiveDate, Required = true, Visibility = PXUIVisibility.SelectorVisible)]    public virtual DateTime? EffectiveDate { get; set; }    #endregion    #region ExpiryDate    public abstract class expiryD

Good day all,Working on trying to make a sales order for a project specific inventory item, a lot sale, and when i go to create the sales order i get the error saying the quantity is negative if i go through with it. In my inventory allocation details it shows I have one on hand. So how do i fix this? Trying to record the sale of the lot/inventory to my project. I also cannot select in the top part of the sales order anything but Project X.  How do i fix this? Please help. Thanks in advance.

I want to get the payments details of a specific customer reagarding the payments he did for this year from Jan 2025 to Current and the invoice details that were set off thorugh those payments.It can be a report or anything.Thank you

  We have started taking photos of the goods that get shipped from every order we send.  We use a tablet with the Acumatica app on it to take and upload the photos.  Is there an option or customization that can be done to send out the photos in batches much like invoices that we run at the end of the day and are all sent out as a batch?  We don’t want the photos to be sent to the same email address invoices get sent to.  We are really hoping that we could send all the photos as batches to the email addresses we  send the sales order confirmations to.  Is this something that is possible or just wishful thinking?  

The mobile App updated on May 14th. Ever since the update was pushed, we have been getting error uploading file. We have had the error in three different parts of the app: 1. capturing the appointment signature, 2: uploading appointment photos, 3: capturing expense receipts. We are using Samsung XCover Pro 7’s with latest Android version. Verizon is our cell carrier. Saw there was a similar bug 2 years ago after update. Any ideas how to fix this issue?

How can I enter a credit and a rebill when we are charged the wrong amount for materials.  It really isn’t a return and as of now, I cannot figure out how to do this.

"In Acumatica 25R1 GI, ARAdjust fields adjgRefNbr, adjgDocType, adjdRefNbr and adjdDocType all return 'could not be bound' error. What fields are available on ARAdjust table for joining to ARPayment in a Generic Inquiry?"

Hello all,How can we have 2 different valuation methods for an item?So if I am procuring one material and my if I am producing that material, how it holds these 2 separate valuations?And what will be the COGS based on my valuation?Thanks.

Hi All, I am struggling with an import for the configurator maintenance screen. The last topics were years ago and those xml files error when i try them.  Am I right in my understanding that you need to have an import per feature for the options. So for each feature and that features options you would need to have a separate import or is this possible on one import. Any help or examples would be appreciated

Does anybody have an import scenario for the product configurator?

=IIf([Customer.AcctCD] = 'A123', 'John Smith', [ShippingContact.Salutation])All, we’ve had an issue bugging us for over a year. Long story short -- for customer ‘A123’, we have contact ‘Jane Doe’ appearing as the shipping contact on the invoices. Jane Doe left A123 years ago but still appears on the invoices. I’ve hunted her down in contacts, leads, business/customer accounts, shipping tabs etc and can not find a trace of her.So I’m trying to “hard code” our invoice -- if Customer = A123, then display value is John Smith (the correct contact); otherwise, just use the usual [ShippingContact.Salutation].This works for A123 invoices… John Smith now appears! Great!Now the issue is all non-A123 invoices leaves a <blank> Shipping Contact. :/Do I need to use a visible expression instead? 

Is there an existing report in Acumatica that calculates the Average Days to Pay for Customers?   Needing a report that shows the metrics of payments for our Net 30 accounts.    

Hi everyone,I'm currently working with Acumatica Cloud ERP 2024 R1 and using the REST API to manage file attachments on various documents (e.g., Sales Orders, Invoices, etc.).What I can already do:I’m successfully attaching files to entities using the files endpoint like this:PUT /entity/Default/24.200.001/files/PX.Objects.AR.CustomerMaint/BAccount/{entityID}/{filename}This works well — the file is successfully attached and visible under the Files tab on the customer screen.What I want to do next:I would like to add a comment to this file — just like you can do manually in the UI by entering a comment when attaching a file.My assumption so far:From what I understand, this may require two separate REST calls: PUT — attach the file (already working ✅) Some second request to update the file record and add a comment (❓) But I haven't found a working REST example for that.My Questions: Is it possible to attach a comment to a file via REST API in Acumatica 2024 R1? If yes — what is the r

I wanted to pick peoples brains on methods to track our Event/Conference ROI with related expenses. Currently, I do not see a way to link an Expense Claim to a Marketing Campaign. I am creating a marketing campaign for each of our future attending conferences and will have Leads/Opportunity linked via Source to track sales, but tracking related expenses to a specific conference has been a manual process. 

I was hoping I could pick your brain about modifying a Generic Inquiry where the results can be grouped together based on a specific string or text pattern. For example, values such as “COMPANY1”, “COMPANY2”, and “COMPANYABC” would be grouped under “COMPANY,” while “SELLERA” and “SELLERB” would be grouped under “SELLER.” I was hoping to manipulate it in the Group By tab but was getting an error: Operand data type datetime is invalid for sum operator. 

trying to use a contact for invoices and a different contact for statements. I thought that using the mailing & printing feature within the customer profile would solve this. However, after updating and saving, it does not seem to work. I did generate the statement on demand to test out; not sure if this is the issue. It is the same screen ID of AR641500 that the generated statement is on. It still uses the account email in the general tab, however. That is the one I want for invoices only.