Retail Edition QnA
Recently active
We are on 2021 R2 with the Big Commerce connector. Can we configure Acumatica to limit which warehouse the customers can shop from when the customer is shopping in our connected Big Commerce website?
Hi, Is it possible to create a customization that would allow users to have a better calendar experience for scheduling appointments, somewhat like Google Calendar.
I am getting the following error with an order syncing from Big Commerce to Acumatica. Any ideas on how I can fix this and get the order to sync? Updating the 'SOOrder' record failed because data in some field is too long. String or binary data would be truncated.The statement has been terminated.
My BigCommerce sandbox demo site got messed up and I created a new one. I was able to test the connection satisfactorily, however when I try to do a FULL Prepare and Process for items, sales categories, etc. it doesn’t show any items to export to the new BC site. I am assuming that there is sync data that needs to be cleared out on all the records. Is there a SQL script to reinitialize the data used by the entities so that they will publish to the new BC site? Or can this be done within Acumatica? Best, David Eichner, CPA
Here’s an easy one! There are a couple tables I’ve found in the sample database that I cannot find in the Code Repository. I’m wondering if they are legacy tables that are no longer used.For example, EPEquipmentTimeSheetDetail and EPTimeSheetDetail. The only place I find them when searching the entire solution is in a file “Settings except Attachmments.esc” <Exclude table="EPTimeSheetDetail" /> <Exclude table="EPEquipmentTimeSheetDetail" /> Are these “dead” files?
For some reason the pricing sync for Big Commerce when you have multiple units of measure enabled is to use the base unit and not the sales unit. This is a major problem because customers build pricing based on the sales unit and not the base/stocking unit. How do we go about getting this changed? This is a critical issue for one of our clients. https://help-2021r1.acumatica.com/Help?ScreenId=ShowWiki&pageid=994bc074-79eb-403b-81c4-9545d470a01dLimitations of Sales Price SynchronizationUOM-specific prices: In Acumatica ERP, if the Multiple Units of Measure feature is enabled on the Enable/Disable Features (CS100000) form, you can define a sales price of an item for each of the units of measure in which your company sells this item. However, only prices defined for the base UOM can be exported to BigCommerce.
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.
I’d like to make a processing screen that will allow me to add items to the grid of items to process.I’m basically trying to make a grid that you can run processing on that I can add/delete items. The only filter I have is at the top of the form that is a checkbox that changes the grid from “Show Posted”, “Show Unposted”. The filter checkbox pulls data from a custom table, so it is a “real filter” I want to be able to add items to the grid, and THEN process them. I also want to be able to import items into the grid.From all the things I can see, processing screens are designed to pull data for the grid that already exists in the system and are not editable. I’ve tried a plethora of things to try to get the grid on my processing screen editable with no luck.At this point, I created a Form/Grid screen and put “manual” processing buttons on it to process my grid items, but I want to be able to show the typical processing screen where it shows the Successful, Warnings, Failed etc. I
Hi. Anyone knows the needed mapping rules for Acumatica to sync Correctly in B2B Bigcommerce?
Our ecommerce connectivity from Acumatica Ecommerce to Shopify is working fine except for Inventory On-hand qty in ACM into Shopify Available qty. Any idea why this is?
Hello Everyone, Today we have some out of the box dashboards provided in the commerce module. You can check those from Commerce Sync Monitoring(BC409010) form in the Commerce workspace(attached screenshot).We would like to know if this is useful? Also, would like to have more out of the box dashboards? If yes, what are the dashboards or KPIs you would like to see? Please let us know. We are planning to add different Dashboards that are related to Sync & Error Handling and also that are related to Commerce Sales with respect to Orders, Returns & Refunds, Products, Revenue, Customers. We would love to get your opinion on that. Please let us know what do you think. Thank you so much!
Hello,I work for an Acumatica VAR and currently studying for Shopify installation. However, when trying to implement the connector it is asking for a public address and I’ve only got a local install, any workaround for that ? Thanks
in the image under the internal tab there is nothing. For the other entities pages it works just fine but for shipments it doesn’t. Anyone know why this is and how I could fix it?
Why does the RC function in sales orders have a create shipment button if it's just a credit?
Recently updated to the build 21.216.0034. It would appear there has either been some change to what triggers a ‘Product Availability’ sync request, or otherwise a related bug. In previous builds, ‘Product Availability’ record prepared of course based on update to the given inventory ID (Template, Stock, Non Stock). Expected and documented functionality. Since our update to this build last week, it appears that nearly all Inventory ID records are entering the prepare/process queue, even though the majority of those records have not been modified by any expected action (ie, sales order created, PO received, inventory adjustment, etc). Is this a known situation? Have changes to what triggers a product availability request been meaningfully changed in this build? Why this matters in our integration: We override the ‘track inventory’ setting for BigCommerce products that we want to allow backorder on (ie, take an order for something not in stock). For items with low velocity, the Invento
I have encountered a lot of errors while syncing sales orders from bc, I fixed some but this one I don’t know how to fix. Can anyone help me to figure this out?
Hi ,Requirement: map the fields from acumatica to Big Commerce in Entities screen. In the above screenshot I changed “source field” values. I want to get details from Export mapping tab .where will I get this information and where can I write the code for this.
Today in Acumatica, when Sales Orders are processed into Shipments, the system will by default process based on a limited set of available filters at the Sales Order document level. This method involves the assignment of inventory (SKU’s) generally based on the date ordered. SKU’s that are not available may be back ordered and processed into a separate shipment at a later date. This method appears to assume that all SKU’s on any given order are available or will be available in the short term to fill all open orders. It also appears to assume that companies who wish to capture payment prior to shipment would process the payment on the Sales Order regardless of which items may have been shipped or back ordered. Example scenarios where the current process may fall short.Companies engaged in B2B and B2C sales where priority may be given to one customer type over the other based on a variety of variables. Companies selling limited availability items which need to be distributed across the
Does Acumatica support to automatically import files from my vendors (on daily/hourly frequency) with tracking details for the our POs, and based of that to create a shipment to the associated SalesOrders dropshipped line items? I guess this is very important for anyone that has BigCommerce connector and/or Amazon connector for FBM orders, in order to get the tracking out to the SalesChannel. Also this should add the real shipping cost for that line item, to calculate accurate profit analysis. The tracking file from our vendors contains:PO Number, VendorSku, Shipped Qty, Tracking #, Carrier, ServiceLevel, Fright Cost @smarenich @josh.fischer
