Inventory - Backorders - MYOB doesn't work

Hi brunob 

Thanks for the reply.

The website is a rebuild of an old webcart that builds a product from components in stock - way too complex to use MYOB build.

The old website is losing money as pricing is not dynamic and a number of other reason.

Simply - the new website builds a product security doors - windows from measurements and add-ons provided by tradies.

i.e. 1800 x 1200   security window with stainless mesh, this security lock, this colour etc. - very complex build.

The components that make up the build are not displayed - just the product build.

The new web ( goes live 1 Jul) - with a complex build matrix in its code - selects the MYOB items from inventory (perpetual inventory and we don't feed qty into the picture - we didn't want qty as a factor in the build). The pricing for the build is dynamic and up to date.

The price for the build is shown - and the build price is paid for on the web.

My software integrates the web to MYOB - it takes the order and posts a sales (order) for just the product to the clients account ( or if not account - guest csutomer) as an order 

Order A -   1 x Product X ( 1800 x 1200  ...... ) @ $1831 incl

The build components come in from an order table that breaks the build into current MYOB items 

2 x item 1

1.4  x item 2

5 x item 3 

Order B comes in an hour later

1 x Product X (1200 x 1200)

1 x item 1

1.0  x item 2

3 x item 3 

If I now do an update of current items stock levels and find item 3 has only 3 items in stock then (keeping this order together)  - it gets posted as an Order ( an invoice will be spat back by the API as 'insufficient stock')

It was decided by management ( and occurs on the old web that Orders for builds must run in order of received).

At present there is a staff member who reviews stock levels each day and orders and fills orders in time-order

However, Order B comes in a day later - and if we aren't worried about progressing orders in time sequence it will be able to go into production taking the current available stock of item 3 - ( we back-ordered 2 of item 3 for that order but now because Order B has now taken the rest of item 3 - another back-order has to be sent and Order A gets forced further back in the queue).

So management said - Orders must be done in time sequence - no product order can jump the queue - noting they don't run their stock at such a low level as to have a stop/start/stop process going on.

Since my post we have decided to add some more code to my integrator and Orders will be posted as follows.

Order A comes in 

2 x item 1

1.4  x item 2

5 x item 3 

It will be split - and items in stock will be grabbed by Order A will an invoice post.

Item 3 (will be split  - 3 x item 3 - on the invoice thereby nailing this stock and preventing queue jumping) .

A backorder will be sent through for Order A of 2 x item 3.

Order B comes in 

1 x Product X (1200 x 1200)

1 x item 1

1.0  x item 2

3 x item 3 

Now - there are no Item 3 in stock - so All of Order Bs item 3 goes on a backorder and there is no queue jumping.

However, so that management no longer wants to pay for a staff member to monitor orders in time sequence - my software will look at all Backroders in MYOB - and try and fill them in time sequence - at 10 PM every night or thereafter.

So it downloads BackOrder Order A - 2 x item 3 - and checks if enough stock - there are now 3 instock - so it completes Order A - 1st then moves on to see if the next order's backorder can be completed.

No we do not want to run quantity into the web - we have 2 other web carts and do so in another webcart - so I have the code to do this but the web cart then becomes way to complex if it starts maanging Orders/BackOrders - it was decided not to.

The initial desing didn't even have dynamic pricing - it was designed with static pricing - I convinced themm dynamic was possible - and it has this.

Complex - not really - it is just that MYOB just doesn't have the granularity of ORders to prevent queue jumping.

The Doc