Discussion Forums

I want to bulk print the official receiprts (Receivable). Is there any such function? 

Hi,I been looking at all the possible DAC in my system and could not figure this out. I am trying to add CRActivity.Type into a screen to only show one of the activity type ‘BOC’ or empty. However, when I connected the tables, it is not filtering properly. As you see from the screen shot above, the system is posting all the different entry that is on the customer profile. Below screen shot is a reference to the 22 entries that is listed as ‘BOC’.What I hope to achieve is the system about to read the order type and order number that the Activity is connect to the specific Sales Order. I am able to find the fields I need with Element Inspector.Unfortunately CRActivity.Source is not a field available in Relations and I do not know how I can build a table to connect to that DAC.Does anyone have an idea on how to build the correct relationship and conditions if needed?Thank you,Calvin

We are learning the CRM Module.  We are trying to find a Mail Merge function in CRM Leads.  Does this CRM Module have a Mail Merge funciton for sending letters?

Is there any way to prevent customer discounts from affecting credit memos? We want to create credit memos without the discounts.

Is there a way to clear all translations of an PXDBLocalizableString field in a DAC row?I see no suitable function in PXDBLocalizableStringAttribute.

Remittance Tab Bill pay section has numbers defaulted in it which is not allowing me to change. Trying to delete or use backspace not numbers won't change. This is the cash account. 

I need to include the name of the last approver in a report as per the customer's requirement. To achieve this, I am using the EPApproval DAC. I sort the records in descending order of the ApprovalID field, which ensures the first record corresponds to the last approver. From this record, I need to retrieve the approver's name and display it in the report. Could you guide me on how to fetch the approver's name effectively and ensure it appears correctly in the report? 

Is it possible to use google file storage bucks for external file storage in Acumatica SaaS like Amazon S3 or Microsoft Azure Blob storage.

Hello. I’ve googled quite a bit and could for the life of me not figure out how to pass values fromCROpportunity → CR Quote         I                           I Sales Order         Sales OrderI found this code https://stackoverflow.com/questions/36156112/how-to-pass-custom-field-vales-from-opportunity-to-sales-order to copy fields from CR Opportunity to Sales Order but if i try this i get a error message.'CROpportunity' is an ambiguous reference between 'PX.Objects.CR.CROpportunity' and 'PX.Objects.CR.Standalone.CROpportunity'I'm not sure if this code is functional for my needs. We added several fields on a new Tab in the Opportunity screen that we would need to transfer.Although I've successfully created a method to transfer fields from Sales Order to Shipment and Invoice, I haven't been able to locate any code examples for the task at hand.

Hi,I’m trying to import BOMs with multiple operations and my import scenario does not update multiple operation IDs. It picks only the first operation and the materials with it. Could you please someone help me with the import scenario and steps that I need to follow?I have attached my import scenario below.Thanks,Dulanjana

Has anybody had success creation an OData connection to Google AppSheet? I’m getting an error around metadata.   

Looking for tips to get our final “Release Retention” to create only a single final invoice.  Right now the system is looking at the Unreleased Retention on all previous Project Invoices and creating an Invoice for each one.  Wondering if this is a setting issue or a process issue?  Here you see it creates two separate invoices  

What user role is needed to create templates in Payroll?My employee is receiving an error message that says You have insufficient rights to access the object (AUTemplateController)I understand where to add them but I am not sure which role . Their current roles are AR-Accounts Receivable, AR Clerk-Access to AR functions, AR Viewer-Read only access to AR Functions and Viewer  

Hello Community,I’m looking for a trial Acumatica Cloud instance, can anyone help with this?I tried downloading the trial instance but facing issues while connecting with SQL server, therefore if there is any way by which I can directly access the Acumatica trial account without downloading and setting up with the long process, it would be helpful.Your insights and experiences would be invaluable in helping me get started. Thank you in advance for your assistance!

My report is not showing the attribute fields i have added in the detail section but it shows up in the page footer. is there any way to overcome this? removing the visibility expression did not solve my problem: 

Hi everyone,I’m working on reconciling a bank transaction in Acumatica and encountered a scenario I’m not sure how to handle. I have a single bank deposit (e.g., $96) that needs to be matched to payments or invoices across multiple Business Accounts (customers).Currently, the Match to Multiple Documents functionality seems to only work within one Business Account. However, in this case, the deposit covers payments for multiple Business Accounts, and I need to reconcile this in the Process Bank Transactions screen.Is there a way to adjust the settings or configure Acumatica to allow this kind of matching? Alternatively, is there a workaround or best practice to handle this scenario? Any insights or suggestions would be greatly appreciated!Thanks in advance!

Does anyone have a GI or thoughts on how to create a GI that will display the following:Customer account ID Default Salesperson assigned to the customer account The most recent activity related to this customer account performed by this salesperson The date of this activity

Our client started testing the DocuSign integration in a testing sandbox with 23.117.021 and a DocuSign developer account this summer and everything worked. Now, they are currently testing their 24.110.0017 upgrade and the DocuSign 24R1 package using their DocuSign Business Pro account. Everything is the same for them from creating the file in the Sales Order screen, moving through to File Maintenance and then ESIGN. However, now when they press send, an error appears “ An item with the same key has already been added.” After reviewing the code, it appears to be using the DocuSign API to send, and we can’t see anywhere else on the Acumatica side that could be generating the error.   Does anyone know how to resolve this error? 

Our team is trying to create a business event, however, along the way, we have found that one of the fields we need to check isn’t appearing in the Field Name Box. We know for a fact we have picked right Table Name, but we don’t see the required field. Is there a way to add more fields into the business event?

Hi everyone,I’m working on a Time & Material billing rule in Acumatica, and I want to implement a condition where a different rule or formula is applied if a Purchase Order (PO) is linked to a Change Order (CO). Specifically, I’d like to adjust the Line Amount Formula to account for this condition.Here’s what I’ve tried so far:My current formula is:=[PMTran.Amount]*CDbl([PMProject.A3_Attributes]) However, I’m unsure if Acumatica natively supports detecting whether a PO is tied to a CO within the billing rule logic.Can Acumatica dynamically identify this linkage during billing rule execution, or do I need to implement a customization (e.g., adding a custom field to flag linked transactions)? If anyone has experience with similar scenarios or can suggest the best approach, I’d greatly appreciate it!Thank you in advance! 😊

Hi Team,I just want to confirm is there a possible way to add a vertical line between data in ARM Report? 

We have a GI for contracts that just links the SO and SOLine tables. Earlier this week we were able to see file attachments alongside each line item, but now it has totally disappeared. I have found that when I disable grouping the attachments show again. It only started doing this today and I have no idea what is causing it. 

Hi, Wondering if Anyone has a Single 1" x 3" Report Template (in619200) to Print Inventory Labels with Brother or Zebra Thermal Printer - to replace the in619200 default report in Acumatica.Thanks so much anyone :)

Is external file storage can be enabled if you are using Acumatica SaaS?I’m planning to use it this year?