RKL eSolutionsBlogs

Blocking Back-to-Back Orders

Have you ever wanted to be able to enter an Order but not have the Back-to-Back Order generate? One reason for this may be that there is an issue with the Customer or Supplier and you don’t want to take the chance on having merchandise delivered and then face a non-payment.

This will show you how you can have the Order (this works for Sales and Purchase Orders) on your books but NOT be able to create the Back-to-Back order until a HOLD is released.

First let’s make sure your set-up allows Back-to-Back orders.

Common Data > Products > Products, then select your product, in the Sales Section make sure Back-to-Back order is checked.

Back-to-Back Orders-1

Back-to-Back Orders-2

Back-to-Back Orders-3

Go to Common Data > Common Data > Miscellaneous table. Select table 204. This is where you want to select or create a Reason code to Block Back-to-Back Orders. On the Line of the reason code you select, choose Yes in the Back-to-Back Order Column. This will BLOCK the creation of Back-to-Back Orders.

Back-to-Back Orders-4

Now enter a Sales Order using the product you chose from above and in Product Source, make sure Work Order is chosen.

Back-to-Back Orders-5
After creating this Sales Order you will notice that there are No holds

Back-to-Back Orders-6

Now on the right menu click on Work Order

Back-to-Back Orders-7
You can see that the Work Order is created. Now let’s try one with the Manual Hold selected……..

Back-to-Back Orders-8
Enter a new Sales Order the same as the previous one.

Back-to-Back Orders-9
Now click on the padlock beside Hold

Back-to-Back Orders-10

Select Manual for your hold reason since that is one that has Back-To-Back Order set to Yes

Back-to-Back Orders-11

Now your Sales Order has a Hold of Manual

Back-to-Back Orders-12

Click on the Work Order button in the Right Menu

Back-to-Back Orders-13

This is the first message that pops up

Back-to-Back Orders-14

Then you will get this, just click on OK

Back-to-Back Orders-15

And finally here is the log telling you why the Work Order was not created.

Now you know how you can Block Back-to-Back Orders from being created in SX3 while still having your Sales Order created.

Back-to-Back Orders-16

Tagged With: Sage X3, How-To
Debbie Ivill

Written by Debbie Ivill

Questions? Need Support?
Get in Touch