Anyone know how to prevent note synching between Shopify <> Acumatica? I assumed it was possible through the Sales Order entity > Import Mapping, but that doesn’t seem to be working.I’ve tried both of these options to no avail: We use the Notes field in Acumatica extensively and we have instances where the order resyncs with Shopify and the Notes are overridden, so we are trying to prevent that from happening.
We are trying to set up our Authorize.net sandbox account as a processing center on our Acumatica sandbox tenant, however we’re getting the below error message. I created a brand new Signature Key and Transaction Key and still when I try to test credentials I get this error.Any ideas how to get around this? I’ve played around with TESTMODE and VALIDATION parameters and that hasn’t helped.
We’ve been using Power BI to connect to Generic Inquiries via OData for the past year. All of the sudden in the past few days we’ve received the following error message in Power BI: Anyone know what might be causing this and how to resolve the issue?I found this article that references a similar issue, but none of our GIs have a period (.) in the name so the solve offered in the article isn’t helpful in this case.
I’d like to be able to create a GI that displays product Inventory IDs and their corresponding Shopify Product ID. I know that data is stored somewhere in Acumatica because it is available in the Sync History (BC301000) screen and actually hyperlinks to the product in the Shopify admin.Does anyone know what table stores this External ID data in Acumatica? And how it can be related to the InventoryItem table?
Hi: I'm trying to create a GI of Invoiced Items, but I want to separate the items by an attribute. The GI is going to be summarized by Sales Rep and the Sales would be in 3 Columns. Attribute1 Value1, Attribute1 Value2 and Attribute1 Value 3. I create a formula like: =IIf( [InventoryItem.COMI_Attributes]='VO5', [ARTran.ExtPrice], 0.00), it validates. but when I run the GI I got this error. Error: The virtual field COMI_Attributes cannot be used in a condition expression. How can I get my GI to work. Thanks Jesus.
I have an export scenario created of a GI results screen that includes the default price, cost, and qty available of stock items. However, when the export scenario is run, the CSV file that it produces includes a bunch of trailing zeroes. (Example: A default price of $1349.00 turns into 1349.000000)Is there any way to remove all of the trailing zeroes from being included in these results? The actual GI results don’t display any trailing zeroes, it only shows up in the Export Scenario. GI results: Export scenario:
Currently on 21R1, in the process of upgrading to 22R2 - is it possible in 22R2 to map product Sales Categories to a product/variant metafield in Shopify?
I have several hundred products where the Alternate Type should be set to Vendor Part Number but it is incorrectly set to Barcode. I’m trying to create an Import Scenario to correct these in bulk but when I attempt to import it is adding a new line instead of altering the line: Here’s a screenshot of my Import Scenario: Any suggestions how to fix this so it doesn’t add a new line?
Does anyone have a good way to calculate the weeks of supply based on the current available inventory? I’m trying to add this to a GI and my thought was to base it on the qty sold over the past 60 days; taking that qty divided by 8.57 (the approximate # of weeks that are in 60 days) would give me the qty sold per week. Then I’d need to divide the qty available by the qty sold per week to get the # of weeks supply. But I can’t figure out how to make that work in a formula.
I’m trying to create an import scenario that replaces the current default salesperson on the customer account with a new salesperson, sets the new salesperson as the default, and still works even if there is no current default salesperson assigned.This is what I have so far, but it currently only adds the new salesperson and sets them as default; I’m not sure how to remove the original default salesperson if there is one:
I need to change the SO line SalespersonID on multiple sales orders via import scenario. However, I’m not sure where to affect that field in the import scenario under “Line Details” as I would expect.I have a list of order numbers and their order types along with the new salesperson ID. Any thoughts on how to set this up via import scenario?
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.