VisionCore How To
Home Search Support Forum Knowledge Base Print

Back Order tracking ability directly in Sales Order form

This will show you how to track back orders without creating multiple invoices from one sales order.

 

I.  Company Preference Setup

 

Enable Back Orders checkbox must be DISABLED and Enable Allocated and transfer Qty from Order to Invoice using: “Allocated Qty” must be ENABLED.

 

Disabling the Enable Back Orders checkbox will also disable the Automatically Create and Build Assembly when processing Orders checkbox.

bo_01

 

II.  Sales Order form

 

Create new sales order.  When one of the items Allocate qty is less than the Ordered qty(or the Available qty is not enough to cover the Ordered qty), this order is said to be a Back Order type.  The Transaction Type field will automatically show Back Order.

 

Example: Back Order tracking ability directly in Sales Order form

 

This will show you how to track back orders without creating multiple invoices from one sales order.

 

I.  Company Preference Setup

 

Enable Back Orders checkbox must be DISABLED and Enable Allocated and transfer Qty from Order to Invoice using: “Allocated Qty” must be ENABLED.

 

Disabling the Enable Back Orders checkbox will also disable the Automatically Create and Build Assembly when processing Orders checkbox.

bo_02

 

II.  Sales Order form

 

Create new sales order.  When one of the items Allocate qty is less than the Ordered qty(or the Available qty is not enough to cover the Ordered qty), this order is said to be a Back Order type.  The Transaction Type field will automatically show Back Order.

 

Example:

bo_03

 

bo_04

 

For items that have no enough stock to cover the order, saving the order will update the Available, Back Order and   stocksbo_05

 

bo_06

 

For items that have no enough stock to cover the order, saving the order will update the Available, Back Order and   stocks

bo_07

 

 

Before Saving the Order

After Saving the Order

Effect

 

In Stock

15

15

No Change

 

Committed

0

20

Increased

by the ordered qty

Allocated

0

15

Increased

by the allocated qty

Available

15

0

Decreased

by the allocated qty

Back Order

0

5

increased

difference of the ordered qty and the allocated qty

On Order (PO)

0

0

No change

 

 

For items that have no stock at all, saving the order will update the Available, Back Order and   stocks

bo_08

 

 

Before saving the order

After saving the order

Effect

 

In Stock

0

0

No Change

 

Committed

0

5

Increased

by the ordered qty

Allocated

0

0

No Change

since there is nothing to allocate

Available

0

0

No Change

 

Back Order

0

5

increased

difference of the ordered qty and the allocated qty

On Order (PO)

0

0

No change

 

 

Info Note that you can use the ellipse button in the Committed, Allocated, Back Order and On Order (PO) fields to see a preview of what transactions comprise that number.

 

Process the Order to Invoice to ship what is currently available.  When processing an order to invoice, you can choose to process zero shipped quantity items from an Order to an Invoice. To do this, enable the Process zero shipped quantity items from an Order to an Invoice checkbox in the Company Preferences form > Sales tab.

bo_09

 

Now let’s proceed with the example when the said option is enabled and you process the order to invoice. Notice that the item with zero shipped qty is carried over from order to invoice.

bo_10

 

Posting the invoice will show the unshipped qty in both the Committed and Back Order fields.

bo_11

 

bo_12

 

Go back to the Order transaction and you will see that the Transaction Type is still Back Order and the order Status is now Pending.

 

Say you will create an order for this back order, you can use the Purchase Order Wizard form by enabling the Formula (On Back Order) checkbox and click Refresh button.  This will filter all items that have back ordered quantities.

bo_13

 

Now enter the purchase order qty in the PO qty field and click Create PO button to create purchase order.

bo_14  

 

This message will be shown letting you know that the purchase order is created plus its transaction ID.  Click OK.

bo_15

 

Open the Purchase Order, process the purchase order to Purchase Receipt and receive the items. bo_16

 

bo_17

 

At this point that there are available stocks for the items that have back order, you can use the Fill Back Order form (can be opened from Sales menu > Fill Back Order) to allocate orders.  All items that have back orders are listed in this form.  Select the item/s that you are to allocate the available item to.

bo_18

 

Notice as you enter a number in the Allocate field, Available field is deducted by that same number.

bo_19

 

Click Allocate Order button and this message will be shown.  Click OK.

bo_20

 

Since the 2 items do not anymore have a back order qty, then those will be removed from the list.

bo_21

Go back to the order and you will see that it is no longer a Back Order type of transaction.  It will now show Order since you already have filled in the back ordered items.

 

The Shipped field here shows the qty that was already shipped giving you idea how many are still pending for shipment.

bo_22

 

Process the Order to Invoice. Then post the Invoice.  Notice the Remain field, it shows zero since all items were all shipped.

bo_23