Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

Shipstation Integration - Connection Error 23R1

Has anyone run into the following vague error when trying to connect Shipstation. I have followed the Shipstaion documentation here: https://help.shipstation.com/hc/en-us/articles/360026140871-Acumatica#UUID-8a29acb6-2284-4383-9cd4-9d8042e2a078_UUID-5a36552f-1c4a-47ff-a8e5-3a9c8e296fd4 But get the following error shown below. Any ideas on what the issue maybe?

16 minutes ago

jionymacabuhayVarsity I

Everything Else

Intercompany Warehouse Defaults in Sales Order Creation

We need your input on this matter. The company has started using the Intercompany process, which is functioning well. However, we are encountering an issue when the sales order is generated from the other company. Here's a sample scenario:Create a Sales Order in ‘Company A’ for ‘Customer X’ - In this scenario Items are not available to ‘Company A’ so a PO will be created to order the items to Company BCreate the Purchase Order from the Sales Order in Company A. In the Vendor select Company B. Purchase Order was generated from Company A to purchase the item to Company B. From here It’s still looks fine.Then next step is to generate the Sales Order to Company B from Company A. (PO Screen > … > Intercompany > Generate Sales Order ). Sales Order is generated then switch companies to Company B.Here is the issue: instead of defaulting to Warehouse 20 for Company B, the sales order is still defaulting to Warehouse 30 for Company A.I've already checked the community, and it was menti

48 minutes ago

OlgaTrifonova24Acumatica Employee

Configuration and Installation

Multiple screens with the same ID in site map - Need your input!

Hi, Everyone!As part of our efforts to enhance the overall consistency of the system, we are planning to prohibit having multiple screens with the same ID in the site map.We understand that some customers may currently have such duplicates. To prevent any potential issues following system upgrades, we request your assistance in gathering the following information:If the duplicate screen IDs were created intentionally - the scenario resolved by this configuration? If these duplicates appeared accidentally - any thoughts on how that could happen :) To identify duplicating screens, follow the steps below.On the Generic Inquiries (SM208000) form, import the generic inquiry attached to the article and click View Inquiry. For each of the result lines shown, open Site Map side panel to see duplicated screens.

53 minutes ago

wmatthews1877Jr Varsity III

Reports and Generic Inquires

Generic Inquiry Row Style

We would like to add a row style to a Generic Inquiry where if the SOOrder.OrderDate within 3 days of shipping AND SOShipment.ShipDate <= 3 days from the SOOrderDate show the row as ‘green40’ else show as ‘red40’. Unfortunately using Is Between can’t be used for the row style.

1 hour ago

cstefanache

Develop Integrations with Web Services | APIs

What is the difference between default and MANUFACTURING endpoint for OData?

Does anyone know the difference between default and MANUFACTURING endpoint in Acumatica OData?

1 hour ago

jcox43Freshman I

Low Code | No Code Customizations or Integrations

DAC created from SQL view returns empty fields in GI

We have a customization project that creates a SQL view, DAC, and GI But since upgrading from 2021 R2 to 2023 R2 the GI is empty but looking on the SQL server the fields are not empty.I’ve tried to recreate the DAC, GI, and View with no change. Attached are images for reference as well as the customization project. Can anybody help shed some light as to why these are coming back empty? Thanks,

1 hour ago

jwarrenVarsity I

Reports and Generic Inquires

Need help joining Inventory table with InUnit table

Building a GI that will display Inventory items along with the data from the InUnit table (conversions).Ex. My GI keeps giving me duplicate records such as below:I’m not sure where the conversion factor of 1 is coming from in this case. Here are the joins:

1 hour ago

estebanperalta54Captain II

Distribution

Receipt type SO shipment with Pacejet

Hi community! I have a customer that does a lot of customer consignment. They basically need to receive items into Acumatica and integrate with Pacejet because of the high number of inbound shipments. Acumatica told me receipt type SO shipment is not supported with Pacejet so I’m wondering if anyone out there has experienced something similar.

1 hour ago

lukef55Freshman I

Distribution

Default Warehouse by Selling Company/Branch

Hello Everyone,We have a multi-company client that makes intercompany sales/purchases for the same items between multiple different companies. Intercompany Sales Order generation requires a default warehouse for the creation of the Sales Order. Customer and Stock Item default warehouses do not work becuase the same stock item could be sold to multiple different intercompany customers.Is there a way to default the warehouse by the selling branch? Thank you!Luke

1 hour ago

HarshitaCaptain II

Develop Customizations

How to make Document & Line level notes mandatory?

Hello Community,i have been wondering if we can mark the Document or Line-level Notes as required? if yes then how? Can we achieve it via low-code/No-code customization? Thanks in advance.

2 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1755 topics
5789 Replies

Distribution

1697 topics
6520 Replies

Manufacturing

594 topics
2237 Replies

Construction

571 topics
1927 Replies

CRM

158 topics
454 Replies

Field Service

279 topics
922 Replies

Retail

453 topics
1993 Replies

Payroll

213 topics
710 Replies

Low Code | No Code Customizations or Integrations

220 topics
798 Replies

Develop Customizations

2376 topics
9637 Replies

Develop Integrations with Web Services | APIs

577 topics
2333 Replies

ISV Solutions

120 topics
490 Replies

Configuration and Installation

753 topics
2747 Replies

Reports and Generic Inquires

1747 topics
6779 Replies

Import and Export Scenarios

667 topics
2757 Replies

System Health and Performance

132 topics
480 Replies

Community site discussions

228 topics
420 Replies

Community Introductions

95 topics
281 Replies

Everything Else

716 topics
2372 Replies

News & Announcements

Acumatica News & Updates

110 topics
158 Replies

Events & Meet-ups

136 topics
83 Replies

Developer Newsletter

19 topics
0 Replies

43 topics
0 Replies

StevenRatnerVarsity I

ISV Solutions

jcox43Freshman I

Low Code | No Code Customizations or Integrations

DAC created from SQL view returns empty fields in GI

1 hour ago

jwarrenVarsity I

Reports and Generic Inquires

Need help joining Inventory table with InUnit table

1 hour ago

estebanperalta54Captain II

Distribution

Receipt type SO shipment with Pacejet

1 hour ago

HarshitaCaptain II

Develop Customizations

How to make Document & Line level notes mandatory?

Hello Community,i have been wondering if we can mark the Document or Line-level Notes as required? if yes then how? Can we achieve it via low-code/No-code customization? Thanks in advance.

2 hours ago

jionymacabuhayVarsity I

Distribution

Intercompany Warehouse Defaults in Sales Order

2 hours ago

MichaelhSemi-Pro I

Power BI and Images

Can we display images from Stock Items in Power BI? I have an OData feed that sends me the image URL, but all I get are the broken image tile symbols in my Power BI Reports.I am sending over links like: https://<MY INSTANCE NAME>/Frames/GetFile.ashx?fileID=668331C4-23A0-423F-A394-FD01CC97E868I’d love to have some fancy inventory reports come out of here if possible. I’m reading some stuff about images needing to be public, but I’m passing credentials already with OData, so I’m not quite sure where to go from here or if this isn’t an option at all with Acumatica.Hopefully someone else has had success wtih drawing an image from Acumatica into Power BI.Here is my column format: Here is my broken output: Thank you for your time and assistance!

2 hours ago

tahayabaliFreshman I

Develop Integrations with Web Services | APIs

Adding records deletes old one

Hello everyone. I am currently working on customizing an API to add customer data one by one into a new screen. I have created the necessary table in the database and the screen to display the data. Everything seems to be functioning correctly. However, I have encountered an issue where adding a new record results using PUT API in the deletion of the old record from both the database and the screen. What steps should I take to address this issue? I have attached a screenshot below for reference.This is screen.

2 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

AdrianaFloreshas earned the badge Easy talker
keithschmhas 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