Making It Happen
Accounting and Information Technology Assistance and Support
Purchase Ordering - Back to Back ordering Sage 50

We have developed several back to back and automated ordering systems for Sage 50 

These applications can be altered to suit your needs.

Automated Ordering

This system looks at the stock requirement needed to fulfil all the outstanding Sales orders and to raise stock levels to their minimum level taking into account items already on order.

You can run this for a specific supplier, a range of suppliers or for all suppliers.

It can generate a report (in csv/excel format) of all the items that are required to fulfill the SOP requirement and/or below the minimum stock level.

This file can be edited or altered before being used to create purchase orders.

We use this system to generate purchase orders and pair it with our "miniman" tool to make a simple manufacturing system

Back To Back Ordering (one SOP to many POP delivery to customer)

This application creates purchase orders based on sales orders, each sales order will generate one ( or more) purchase orders, each purchase order will have the customers address as the delivery address for the goods.

On each item in the purchase order will be stored the sales order number it relates to, on each item on the sales order the corresponding sales order is stored.This enables reports on orders to give information about the related orders, for example you can report on profitability using the cost price from the purchase order. 

This is used by companies acting as agents where their suppliers fulfil directly to the customer. (we have done variants where certain lines are despatch from stock)

Back to Back Ordering (many SOP Consolidated)

This application creates one purchase order to each supplier for all the products needed to supply the requirements on SOP.  

On each item in the purchase order will be stored the sales order number it relates to, on each item on the sales order the corresponding sales order is stored. This enables reports on orders to give information about the related orders, for example you can report on profitability using the cost price from the purchase order, you can report on which orders goods arriving belong to which customer, you can report on what purchase orders are outstanding for sales orders

Optional enhancements to above.

We can exclude some stock from the process.
We can add in extra stock from that supplier to meet minimum stock levels
We can make this into a list in excel, that you can revise, add to before making the order.

For all these we use the sales order module and purchase order module which are only available in some variants.  

Sales orders can be entered manually, imported from the website, other third party integrations or EDI including third party EDI system..  

Purchase orders once created in Sage 50 can be sent via all the usual methods including third party EDI system.