Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

URL format for Report Designer with multiple tenants

Ok, this is a stupid question. We recently implemented a new tenant on our Production system and I have a need to connect to the site using Report Designer.HOWEVER, because now we have multiple tenants the old URL format of “https://acumatica.xyz.com” does not work. I know with OData you have provide the tenant name at the end of the URL like this, “https://acumatica.xyz.com/odata/tenant%20name”. I thought the format for the Report Designer would be similar such as“https://acumatica.xyz.com/tenant%20name”But that throws an error when I try to load reports. So, what is the correct URL format for Report Designer to connect to each tenant individually?Sorry again for such a stupid question

42 minutes ago

aaghaeiCaptain II

ISV Solutions

josh.fischerAcumatica Product Manager

Retail

Commerce 21R2 - Selling Made-to-Order, personalized products in Shopify or BigCommerce is now supported

In 21R2 the Retail-Commerce team has added support for selling personalized items on BigCommerce and Shopify then passing the personalization instructions into the Sales Order. This feature was requested by several existing customers and prospects. It was possible to accomplish in the past versions with customizations, but now it is much easier.Here is how it works:On the eCommerce site you must configure the Made to Order item. Within the ERP you must add a field within the Sales Order to accept this information. This requires a customization package. Below we are sharing a template to help you get started. You must use the entities window to map the eCommerce field to the Sales Order field you must use the entities window to map the fieldsMore details about each step are below. Customization Package TemplateAttached here is a template customization package. The template, when installed in 21R2, will add a column to the line items within the Sales Order window. The column header is "

67515

1 hour ago

KarthikGajendranAcumatica Moderator

Retail

How to prevent Acumatica ERP Sales Orders and Invoices from recalculating the taxes imported from external systems such as BigCommerce, Shopify, Amazon etc.,

In 2023R1, a new checkbox called “Disable Automatic Tax Calculation” is introduced in the Order Types(SO201000) form. When this checkbox is selected, the system will refrain from recalculating the taxes for the Sales Orders and Invoices. The Commerce connector will import the Taxes from external systems such as BigCommerce, Shopify, Amazon etc., if the “Tax Synchronization” checkbox is selected in the Stores form. If the “Tax Synchronization” checkbox is selected in the Stores form and if the selected Order Type in Order Type for Import selector has “Disable Automatic Tax Calculation” unchecked then a warning is shown to the user as “ The Disable Automatic Tax Calculation check box is cleared for the EO order type on the Order Types (SO201000) form. Taxes in sales orders imported from the BigCommerce store will be recalculated on invoice creation.” Once these taxes are imported, then it stays as the same even if the Sales Order or Invoice is modified. This “Disable Automatic Tax Ca

1 hour ago

abhijit

Reports and Generic Inquires

How do I locate the SQL behind the Pivot Table?

Is there any way to get the SQL running behind the Pivot table? Also, if I have a SQL Script, how can I get the PIVOT to be created from that SQL?

2 hours ago

sd79Freshman II

Distribution

How to resolve : "An error occurred during processing of the field Location value MAIN Error: Location 'MAIN ' cannot be found in the system.

We are getting this error while creating shipment from SO

2 hours ago

travislawson

Import and Export Scenarios

Create Transfer Receipt - IMPT error

I’m using a business event based on a GI to trigger an import scenario. The import scenario gives an error of “Handler of type IMPT is not exists” I’m trying to have a PO transfer receipt created, add the transfer, select the shipment number that matches the GI. Where am I going wrong here?

4 hours ago

sweta68Semi-Pro III

Develop Customizations

Customer Pricing Add-on

Hi Experts,We are currently exploring the development of an add-on for customer-specific pricing in Acumatica. While Acumatica offers robust pricing capabilities, it does not provide native functionality for pricing based on specific customers. After reviewing other ERP software, such as Sage 300, we noticed that they have dedicated screens for managing contract pricing specific to individual customers.Considering this, we believe it would be a valuable idea to develop an add-on that extends Acumatica's pricing capabilities to include customer-specific pricing.Your insights and suggestions are highly appreciated. Regards,Sweta

4 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1724 topics
5731 Replies

Distribution

1666 topics
6454 Replies

Manufacturing

591 topics
2221 Replies

Construction

566 topics
1912 Replies

CRM

153 topics
449 Replies

Field Service

272 topics
911 Replies

Retail

450 topics
1975 Replies

Payroll

211 topics
695 Replies

Low Code | No Code Customizations or Integrations

218 topics
784 Replies

Develop Customizations

2358 topics
9584 Replies

Develop Integrations with Web Services | APIs

558 topics
2287 Replies

ISV Solutions

120 topics
488 Replies

Configuration and Installation

744 topics
2705 Replies

Reports and Generic Inquires

1715 topics
6676 Replies

Import and Export Scenarios

660 topics
2719 Replies

System Health and Performance

131 topics
478 Replies

Community site discussions

225 topics
420 Replies

Community Introductions

95 topics
281 Replies

Everything Else

709 topics
2355 Replies

News & Announcements

Acumatica News & Updates

110 topics
154 Replies

Events & Meet-ups

132 topics
83 Replies

Developer Newsletter

19 topics
0 Replies

43 topics
0 Replies

BrendanL

CRM

Generic Inquiry for dashboard but not usable by end user

1 hour ago

abhijit

Reports and Generic Inquires

How do I locate the SQL behind the Pivot Table?

Is there any way to get the SQL running behind the Pivot table? Also, if I have a SQL Script, how can I get the PIVOT to be created from that SQL?

2 hours ago

sd79Freshman II

Distribution

How to resolve : "An error occurred during processing of the field Location value MAIN Error: Location 'MAIN ' cannot be found in the system.

We are getting this error while creating shipment from SO

2 hours ago

travislawson

Import and Export Scenarios

Create Transfer Receipt - IMPT error

4 hours ago

rcreasyVarsity I

Configuration and Installation

Limit Access rights on specific branches

I need to allow limited access to a branch outside a user’s home branch.One specific example - Our production managers need to see inventory levels at branches other than their own. This ability lets them find stock items they need to order from a sister branch. I don’t want to give the production manger the same rights they have on their own branch.Is there a way to do this?Also, this is just an example. There are other similar situations.

4 hours ago

aiwanJr Varsity III

Low Code | No Code Customizations or Integrations

CROpportunityProducts: Custom field lengths changing between DAC & DAC Declaration

Hi Guys,I have encountered an issue where in the customisation project editor, I am writing an extension for CROpportunityProducts and below is the declaration: #region UsrCloser [PXDBString(2)] [PXStringList(new string[] {"T4", "T2", "NA"}, new string[] {"TS4000", "TS2000", "N/A"})] [PXUIField(DisplayName="Closer")] public virtual string UsrCloser { get; set; } public abstract class usrCloser : PX.Data.BQL.BqlString.Field<usrCloser> { } #endregion #region UsrDoorHanding [PXDBString(3)] [PXStringList(new string[] {"LHH", "RHH", "LHA", "RHA", "BHA"}, new string[] {"Left Hand Hung", "Right Hand Hung", "Left Hand Active", " Right Hand Active", "Both Hands Active"})] [PXUIField(DisplayName="Door Handing")] public virtual string UsrDoorHanding { get; set; } public abstract class usrDoorHanding : PX.Data.BQL.BqlString.Field<usrDoorHanding> { } #endregion #region UsrVPSpec [PXDBString(512)] [PXUIField(DisplayName="VP Specification (D

6 hours ago

bmccauley13

Distribution

Ship warranty replacement before receiving return

When a customer makes a warranty claim, we replace the item for free. We want to ship the replacement out immediately and don’t want to wait to receive the defective product. I am using the RR (return with replacement) order type but am unable to Create Shipment without first running the Create Receipt process and confirming that the return shipment has been received. Am I not able to use the Return with Replacement order type to ship out a replacement product before receiving the defective product? If not, what is the best process for handling this scenario? Process:Create new RR order In the details section, use the Add Invoice button to select the invoice containing the item that needs replaced Click the Create Shipment button to send out the replacement itemThis results in the error “Order RR does not contain any items planned for shipment”.

17 hours ago

epanJr Varsity II

Everything Else

open period report for companies in the same tenant

Hi There,We have many companies in the same tenant with different financial year ends. Just wondering if there’s a report to view the current opening period/close period for all the companies. Just wanted to double check if all the periods are closed across all the companies at month end. Thank you.

19 hours ago

tahayabaliFreshman I

Develop Integrations with Web Services | APIs

Connection of Zapier or MS PowerAutomate with Acumatica

Hi all, I am planning and checking to find if there is a way to connect Acumatica with Zapier or MS Power automate to perform some tasks for eg if new customer added in acumatica so it should raise notification on teams to me and my Manager. Note: This is just an example but I am planning to connect it for others tasks as well. Any guide will be appreciated. Thanks

19 hours ago

sean21Jr Varsity III

Import and Export Scenarios

Error: Items have not been processed success. View Name: Schedule.

I am trying to create an import scenario that deletes all Transaction line items in the Deferral Schedule. I keep getting the following error. I tested several different ways and I don’t know why this error is coming up. My ultimate goal is to delete all transaction table line items in the deferral schedule, then add 1 new line item, but I just want to test deleting first. Can anyone spot something obvious that I am missing? Note: The deferral schedule is Open and the transactions are editable.

20 hours ago

New to the community?

Get Started HERE and be sure toIntroduce Yourself

Acumatica User Groups

Educational Resources

Community Library

Blogs

What you may have missed in the Acumatica Community! March, 2024

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

raphrfhas earned the badge Construction expert
philr75has earned the badge Easy talker

Show all badges

Acumatica Community

New to the community?

User leaderboard

Acumatica employee leaderboard

Badge winners

Events Calendar

Latest Articles

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded