RKL eSolutions Blog Trends and Insights

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

Tags: Sage X3, How-To
RKL Team

Written by RKL Team

Since 2001, RKL eSolutions has helped growing companies maximize their technology resources and investment. Over the years, we have helped hundreds of small and medium sized businesses as their strategic business partner. We specialize in the needs of Entertainment, Software & SaaS, Professional Services, Manufacturing, and Non Profit organizations. Our experienced consultants have a passion for making every facet of your business successful and are intent on building a long-term relationship with every client.