Retail

The question is regarding taxation of digital goods sales.In BigCommerce, you’re not required to provide your shipping address if you’re only purchasing a digital good (eBook, for instance). Therefore, your order looks like this:You may notice that Avalara still calculates the tax, based on the billing address (which is correct).However, when this order comes into Acumatica, there is no shipping address, the Ship Via is set to Will Call, and the tax is calculated based on the Warehouse location (which is WA, in this case).What is the best approach to manage these cases?Thank you!

when I preparing the sales order it showing the following errorInserting 'CA Transaction' record raised at least one error. Please review the errors. FinPeriodID: 'Post Period' cannot be empty. 

Hi. Any thoughts why Customer/Company Payment Method was setup as Purchase Order but in the Acumatica the payment was tagged as Prepayment?  We’re using B2B Bigcommerce. Thank you. 

I’m curious if there is any direct documentation about utilizing the commerce connector and various entity settings at different Acumatica structure levels, primarily Tenant vs Company. Most of the existing documentation appears to center around configuring a single BigCommerce or Shopify store to a single tenant but, for example, what are the options/limitations around connecting store 1 to company 1 and store 2 to company 2, within a single tenant?If anyone has explored this configuration or is using it currently, I’d be interested to understand how it’s working for you and any issues encountered. 

I have recently upgraded a client that was running big commerce connection in 2020R2 with no issues after the upgrade some of orders get this error message but i have not been able to narrow down what causes this problem it seam random to me.“An error occurred during processing of the field Applied To Order value 759.04 Incorrect value. The value to be entered must be less than or equal to 0.0000”i have no idea what field is trying to be updated. any help would be much appreciated. 

i am getting error when i process sales order ERROR:The sales order could not be imported because the combination of the New York State store shipping zone and the None store shipping method is not mapped to a Ship Via or the mapping is inactive in the store settings. 

The following error i has getting when do process step prepare data formError: The order currency (USD) does not match the customer currency (), and currency override is not allowed in the customer settings. 

We have a client with multiple locations/warehouses.  They use Big Commerce as a B2B site where the customer needs to be setup first.  They are running into a couple issues I could use some guidance.Is there a way to display inventory availability by warehouse instead of just one specific warehouse or all warehouses? When a customer places an order the customer needs to have the all the items on the sales order assigned to the customer default warehouse, but it appears the integration changes the sales order line warehouse depending on availability.  Is there anyway to force the sale order line warehouse to be assigned to the customer warehouse only?Currently the client is on 20R1, but we are looking to upgrade them to 20R2.Thanks,Kurt

Hello,We are trying to understand the how the refund integration works in Shopify and why we are getting “voided payments” created instead of “customer refunds.”Our Shopify website is setup to capture payments at the sale. When we go to refund an order, we start the process through Shopify and hit the refund button (picture attached) and then we let the integration build the refund. Instead of creating a “customer refund” (which we think we want), the integration has been creating voided payments. What is the logic for how this integration is supposed to work and is there something we can do to have the integration create customer refunds instead?  

Hello Acumatica Community! Check out the latest joint case studies with BigCommerce & Acumatica:https://www.bigcommerce.com/case-study/van-cafe/ (119% growth in revenue) https://www.bigcommerce.com/case-study/ink-custom-tees/ (186% growth in revenue)  Cheers!Colleen Sheacolleen.shea@bigcommerce.com Manager, Strategic Partnerships

Shopify is hosting a webinar with Acumatica, Shopify and our customer Clive Coffee.I can’t wait for our community to see this!Registration links are below and please be sure to share with your network. Really appreciate everyone’s support and interest in what our team is building. It’s literally changing the lives of these business owners!Josh How Clive Coffee met demand after a year of record-breaking growthWhen:

Hi.Does anyone here knows:1. API to get template items attributes (color and size, with its options/values)2. API to get how the SKU was generated for product matrix Thank you.

We need to delete some ship-to locations that are attached to a specific customer but I keep getting told that I don’t have permission to delete them. What do I do?

Upgraded to 2021R2 and running through full resync of relevant entities - Sales Category → Stock Item → Non Stock Item → Template Item. Got to Product Availability, and encountered a new error I’ve not previously seen: Error: Specified argument was out of the range of valid values.Parameter name: IdentifyNoteIDSteps: Ran a ‘Full’ Prepare request for Product Availability Entity (previous automation schedules inactive since just prior to cutover to new release). Attempt to Process records. Encountered error above. The records do not appear to fail (ie, do not move to a failed or aborted status in Sync History), but just remain in the ready to process queue. I’ve approached this from both the prepare/process screens and from the sync history screen, and keep encountering the same error. Acumatica Trace from this screen:

We are having problems with exporting template items that have never been synchronised before. e.g. The item on Acumatica is called C-A892:MD with a : between the Template ID (C-A892) and the SKU code (MD). When it gets created in BigCommerce it is created as C-A892-MD which doesn’t match and gives an error on the export sync ( "The synchronization could not be completed because variant items do not match the 7386 product in BigCommerce.")Is there any way to get around this other than manually going into BigCommerce after the sync fails and changing it before resyncing?Thanks for any advice, even if it’s just that we have to manually do it and there is no way around it.Phil

There are only 2 choices to show available  for the web store.  My client would prefer that negative available is ignored and factored into the calculations. In the example below, they want to see 10.This is an example I set up and tested with the store setting for Availability Mode for Available and Available for Shipping.When set to Available the store shows a qty of 8 When set to Available for Shipping it shows 20  If I allocate the sales order for the 10 pieces it changes to either 8 or 10.  Generally, we do not set the sales orders to allocate because it ties up inventory you could use for orders with earlier ship dates.  Unfortunately, there is no way to allocate orders based on date.   

We are looking for a Customer Service Sales trainer for an E-commerce team. In case you have a referral,...

Hello,We are in the midst of implementing the Commerce Connector from Acumatica(build 21.208.0032) to an existing BigCommerce store. We are implementing in phases, with the first phase being stock and non-stock items, and inventory levels. We have a custom built integration that imports orders from BigCommerce. Most of our products need to be Matrix items with only 1 variant. I have followed the steps outlined here:With the exception of importing the items as we already have the items created in Acumatica. When trying to update a stock item to be tied to a template item, I get the following error:I have been able to use that attribute to create new matrix items following our part number format. I wou

AcuPOS  (April 2022) has just released new builds along with updated User Guides and Release Notes.  They can be found on the Acumatica AcuPOS Community PageRelease Versions:21R1 Build 104 R45 21R2 Build 207 R04 22R1 Build 100 R01Improvements:POS Orders forming PS sales orders with wrong taxEnhancements:Smart Scanning Receipts for Returns Receipt Format - Short & Regular Item Buttons Load from Stock Item Screen

Is there a way to make the customer pop-up note appear every time you go into the customers order and/or when a shipment is created?  It appears when you first create the sales order but never again.

I am trying to mass import Item Sales Categories for a commerce deployment. I was able to write an import utility to import the first tier but cannot import any child sub categories.I set the folder path using this syntax: Company/Level1/Level2/Level3 etc I then set the Category Description with using the final segmentIt seems that if the path category does not exist, then it will simply import the path string as the category name.What is the proper approach and syntax to get this to work? 

Has anyone configured the BigCommerce connector to work with an existing BigCommerce store? Our client has a well established store and wants to connect to their new Acumatica install. We started testing the syncs in a sandbox to see how it would work and have run into errors. With the stock item sync, we can only export from Acumatica to BC, but the items already exist in BC. When we try to sync anyways, the error says the item already exists. Is there a way to somehow map the two together to resolve the sync issue? Any other gotchas we need to look for in configuring the connector for an existing store? Thanks for your help!

Dimension Creation in AcuPOS:AcuPOS requires the DimensionCreation customization package to be published(only once for the instance) and then the AcuPOS build to be published to the Acumatica ERP  instance. The DimensionCreation customization package creates "WORKSTATION - POS Workstation" segmented key record in the Segmented Keys(CS202000). It is required to create a "WORKSTATION - POS Workstation" segmented key before the AcuPOS publishing. This operation can be done either manually or by the DimensionCreation customization package. In the case of creating a new tenant occurs a situation when in the new-created tenant the workstation segmented key is not created but the User Profile has a Workstation ID field to be selected. PROBLEM:For this reason if you try to create a new tenant while the

This is the Example ERROR: Export of the Stock Item record cannot be completed. The Stock Item with the same field or fields (<<item description>>) already exists.The first item has been exported to BigCommerce but others with the same description field didn’t. How can I export all items even if they have the same description field? 

HiI want to use my own Substitution Lists in my Commerce setup when exporting the Item entity.The formula function SubstitutionList and SubstitutionAll is available but during Process of data it fails with error SubstitutionList function unknown.Is this a bug?