Commerce Edition QnA
- 293 Topics
- 1,125 Replies
Cannot create new tenant when AcuPOS packages are published
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 AcuPOS packages are still published you will receive the following error: Unable to cast object of type 'IGFS.DAC.IGFSUsersExt' to type 'PX.Objects.FS.FSxUser'. at memberwiseCloneExtensions(U
Double charging the Customer
Hi everyone.We encountered this issue. In the Bigcommerce, If a Customer uses a Credit Card during the checkout process, we have to Override their "Default Payment" method on the sales order. It needs to be overwritten with "AUTH NET." I just conducted a test transaction. The Customer in question has a default payment method of "ACH." But, during the checkout process I used a Credit Card. When the order synced to Acumatica, the Sales Order pulled the default payment method of "ACH." This issue gets even worse when a Customer has a Default Payment Method of "CREDITCARD" in our system. In that scenario a Customer could pay with a credit card during Checkout and then Acumatica will run their card again when the order is invoiced. Double charging the Customer.
What is the best procedure to sync Acumatica and Big Commerce?
We have been using the “Fetch” and then “Sync” method in “Commerce / Processes”. Using this approach we were finding that hundred of items would show as “Pending” even after we Fetched and Synced. We were told to change our procedure and first “Fetch” in Processes, and then sync using the “Sync Status” process ( and not the “Sync” in the Processes area). Is this method the prefered way sync? Should we stop using the “Sync” button in the “Commerce / Processes” area?
Pricing Mechanisms - BigCommerce & Bundle B2B
Using the BigCommerce/Bundle B2B connector, is there any way to handle the following business need? We would like to create a specific Sales Price Worksheet for approximately 600 of our customers. In Acumatica, this is feasible in the Sales Price Worksheet module by attributing the worksheet to a specific Customer Price Class and then assigning that Customer Price Class to the 600 customers. There doesn’t seem to be a way for BigCommerce and Bundle B2B to read that information in the hierarchy we are looking for. Any suggestions?
Deleting Customer in Acumatica and Sync to BigCommerce
We just want to confirm if this is what we expect for the connector when a customer was deleted in Acumatica. Please consider the ff:1. A customer was created in Acumatica2. It was synced to BigCommerce3. Customer now exists in BC4. Customer was deleted in Acu5. Synced the customer in AC sync history6. Customer still exists in BCIs it what we are expecting? Do we have some indication in BC if a Customer was deleted from it's Acu source? Can we forbid them to log-in and place order in BC? Thank you
Confirm Shipment API call
I am trying to figure out a way to update Fulfillment status and Confirm a shipment in one call instead of doing 2 separate calls, to get this approach working would it be difficult to extend the web service endpoints?Do y’all have any better option or the best way to go is make multiple calls?
Question about Commerce Connector and Tenant vs Company vs Branch Configuration
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.
Can we execute sync restrictions on already synchronized items?
We have built-in functionality, that sets items to ‘invalid’ status if that item have some parameters preventing it’s synchronization (i.e. sales order has wrong status in external or internal system, customer is a guest in store settings, etc.). Ideally, we would want to be able to execute those settings on all entities, even those that already synchronized. Unfortunately, currently this restrictions can only be executed on new items, that have not been synchronized to other system.The current design of the restrictions would cause a problems for an item status resolution if we would allow restricting of items existing in both systems. Since fetch procedure is initiated from internal or external system, for bidirectional entities the same item could go to ‘invalid’ or ‘pending’ status - based on the direction of the fetch procedure. If the item is modified externally, and in external system object has a status preventing sync process, it will go ‘invalid’ and will have an error messag
Duplicate Sales Order Created
Hello, We have noticed after creating a sales order that a duplicate is now showing up. It has all the exact same information. Same Reference number, same shipment number, same payment information. I added a note to one of the orders and it showed up on both orders, so they are linked together somehow. Therefore, I don’t want to try and just delete one, since it will most likely delete both. However, when I look at the customer account, only one order shows up. Does anyone have any ideas on how to address this duplicate order issue? Thank you!
Entity Usage Types 2022 R1 to mapping to customers in BigCommerce
We would like to map the Acumatica Entity Usage Type field in a Customer Profile to the analogous field in BigCommerce’s Customer table, so that we can set whether a customer is tax-exempt or taxable from Acumatica. We use Taxjar as our tax solution, and to set a customer as taxable such that the Tax integration between BigCommerce and Taxjar will work properly to recognize the tax status of a customer, we need to either leave the field blank or fill it with “TAXABLE”. Any value other than Taxable in the BigCommerce field will send a customer tax-exempt value when Bigcommerce does an API call to Taxjar for that customer.If we sync the field as it stands now, the value for taxable in Acumatica in the Entity Usage Type is “Default”, which if entered in the BigCommerce field will make that customer exempt (opposite of what we want). Is there a way to either update the pick-list for entity usage types in Aculatica to add “TAXABLE”, or for us to use some sort of substitution in the connecto
B2B additional user and creating account for B2C
Hi all,I tested creating a new user from the website and it failed to sync into Acumatica until that user was added to a B2B company.Any changes made on the B2B side of the company are now over-written by the Acumatica values (tested on addresses and price lists). I see the sync on this is bidirectional, can I use other option on this?Another thing, I have B2C and I was able to use the "Trade Application Application" to signup a new account that created a customer in BigCommerce and a Company in BundleB2B that was able to sync without issues after I approved the company. If we have all new customers sign up for accounts this way instead of the native BigCommerce account sign up this may be the way to do it? There are some limitations on B2C business. any advise? Thank you.
BigCommerce Syncing Error
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?
How to import Shopify order that is missing shipping address
We have non-physical items that are sold on our Shopify store (software downloads). These are set up with the “This is a physical product” box unchecked in Shopify: However, this means that customers will not be prompted to enter a shipping address. Because of this, it seems we are getting a sync error: “Taxes cannot be calculated via the external tax provider because the address is missing”.We can go into the Shopify order and manually add the billing address as the shipping address and resync the order which works, but is there a way for us to still sync the order even without a shipping address?
Status of Open but not approved in Acumatica mapping in BigCommerce to Manual Verification Required
When sales orders are pushed into Acumatica and are in a status of Open but the Sales Order has not been approved in Acumatica, the BigCommerce Connector pushes back a status update to the order in BigCommerce and changes the order status to “Manual Verification Required”. Is there a way we can change that mapping and/or ignore that in the connector?
"level price" of item sync between Acumatica and Shopify
Hello, Can anyone familiar with Acumatica and Shopify connector help confirm whether the below need is mission impossible at present. We are using customer price class to set item price for different customers/customer classes. And since we are planning to use shopify to receive customer’s orders. Can these prices be sync up to shopify and displayed to customers?
Exporting Customer Account and Shipping Addresses using Export Scenario
I have an export scenario set up to export using the Customer screen layout to an excel file. I am trying to export the following records from the Customer screen and want to use a Source restriction to restrict the export to a couple particular customer classes.When I run it using the source filter (and not setting the customer id to ‘=every’, the address field data for the account and shipping addresses that are exported are all the same as the first customer, although other fields do export correctly.Any thoughts on what I can do to make this right so I can use source restrictions? My testing of using the =’every’ for customer ID and a source restriction results in no data being prepared all all. The example below has the =every, but removing it is what gives me the same data in the address fields for all records.Any thoughts are greatly appreciated!
AcuPOS Latest Build Releases- April 2022
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
Already have an account? Login
Social LoginLogin with your Acumatica account
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.