Solved

Changing the Availalbilty setting for Big Commerce to exclude negative available

  • 10 February 2022
  • 16 replies
  • 88 views

Userlevel 4
Badge +1

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.

 

 

 

icon

Best answer by smarenich 2 March 2022, 04:32

View original

16 replies

Userlevel 6
Badge +2

Hi @dgodsill97 could you please check if the Available with deductions on Sales Order Prepared can work for you?

 

Userlevel 4
Badge +1

They have multiple warehouse and the negative availability in one warehouse should be ignored. BC currently cannot show available by warehouse.

Userlevel 6
Badge +2

@dgodsill97 

To be able to help you I need a bit more information to fully understand the problem. Could you please give me an example with some numbers, or reproduction steps?

Userlevel 4
Badge +1

This is an example I set up and tested with the store setting for Availability Mode for Available and Available for Shipping. According to the client, the available calc should be 10 for there are 10 units available in WHOLESALE.

  • When set to Available the store shows a qty of 8
  • When set to Available for Shipping it shows 20

 

 

 

Userlevel 4
Badge +1

Sorry, it keeps throwing away the screen shot.

 

Userlevel 4
Badge +1

Same example but allocating the sale order.  This is better and may work for the client.

 

Userlevel 6
Badge +2

@dgodsill97 

The problem is that many customers do now want to oversell items, so we trying to keep availability as accurate as possible.

What your client would do if someone buys 10 items and then you ship all of 12. Would you cancel the order for the rest 2 items?

 

Userlevel 4
Badge +1

For this client, each customer is fulfilled by a regional warehouse using client trucks to deliver the goods.  So if you are a AZ customer on the Thursday route your orders are fulfilled by the AZ warehouse and delivered by client truck.  How difficult is it to customize the connector to allow export mapping and/or filtering for the Product Availability?  Export mapping  would the ideal situation because you can write a formula to change the stock level in BC. We often find that clients want to manipulate the stock level they show to customers - very common when sending the EDI 846 to a trading partner.

@smarenich @josh.fischer  Any thoughts on how to help this client? Dennis and I are on the same team working on the same issue. 

Userlevel 6
Badge +2

@kmcalister58 I understand the problem and will create an internal ticket to elaborate this functionality in the future versions.

However, right now the only think I can suggest is to customize the availability sync.

Userlevel 4
Badge +1

Does the availability sync use a GI?

Userlevel 6
Badge +2

@dgodsill97 in versions below 2022r1 yes, Availability is based on the GI. However, I highly do not recommend to modify the GI. In case of modifications, any changes done by Acumatica team as part of bugfixes would result in problems with modified GI. in 2022r1 the GI is not used anymore.

Userlevel 4
Badge +1

I will request a customization from our team.  But will that work with 2021Rxx or will the GI. BC_StorageDetails be used regardless?

Userlevel 6
Badge +2

@dgodsill97 as I said, modifications in BCStorageDetails will lead to the major problems with upgrades and updates. We have seed this before.

It will be safer to customize the Availability processor with code.

Userlevel 4
Badge +1

Understood, thanks

Userlevel 7
Badge

Hi @dgodsill97 were you able to resolve this issue? Thank you!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved