Rental Dated Item Reservations

Overview and Process

To ensure inventory is available for the period of time the customer is requesting the material for rent,  Ascent ERP now allows a user to reserve rental line quantities against inventory  during order creation as well as after the order has been created.

Quantities against one or more lots can be allocated to either fully or partially satisfy the quantities needed in the rental order line.

Important note: serial numbers cannot be reserved!  Dated Item Reservations are serial number agnostic, and only deal with quantities.

Definition: Dated Item Reservation records are ones which provide detailed information about the reservation action that was taken upon the system’s attempt at reserving inventory for a rental as well as activities that occur during packing and returning a rental item.

DIR record will look like this : 

Dated Item Reservation Name will be [item number] + [line name] + [sales order name of the record it came from] 

Sales Order Example: 

SO-0000001 for ITEM-X for Sales order Line Name: 000241 

Dated Item Reservation Name : ITEM-X_000241_SO-0000001 

DIR record Fields : 

1. Customer 
2. Item
3. Dated Item Reservation Name
4. Sales Order
5. Sales Order Line 
6. Opportunity
7. Opportunity Line
8. Reserved Date
9. Start Date 
10. End Date 
11. Item Number
12. Requested Quantity 
13. Reserved Quantity 
14. Reserved Date
15. Quantity Fulfilled (Quantity Packed ) 
16. Staged Quantity 
17. Quantity to be Returned
18. Returned Quantity 
19. Status (Open, Partially Fulfilled,Fulfilled,Partially Returned,Returned,Closed,Partially reserved,Reserved, Partially Staged, Staged, Partially Packed, Packed, Awaiting Return, Canceled)
20. Return
21. Offset Start Date
22. Offset End Date
23. ATP Fulfillment Offset # of Days
24. ATP Return Offset # of Days

Custom Settings of Importance: 

Use Dated Item Reservations (DIR) – this custom setting dictates whether or not Dated Item Reservations are used.  If selected, all rules pertaining to Dated Item Reservations for rental lines are used.  When a user enters a rental sales order line item, it automatically creates a DIR with details like requested quantity, reserved quantity, and the like (discussed later in this document).

Creating Sales Order: Please refer to the document called Rental Sales Orders for instructions on how to create a rental sales order.   

First, let’s look at the inventory for the item i1.   There are 10 on hand in a rental location:

Let’s add a rental order header with this rental information:

Now, let’s add a rental line for a quantity of 11:

Looking at the Dated Item Reservations record, we see that Ascent Rentals has only reserved 10 of them, since there were only 10 on hand:

Packing a quantity of 10 would result in this (to review how to pack a rental order, please review Ascent Rentals – Pack Order).  The Quantity Fulfilled is incremented by the packed quantity, and the Quantity to be Returned is incremented by the same amount:

Upon returning the material, the DIR is affected as follows.  The Quantity to be Returned is decremented by the return quantity, an the Returned Quantity is incremented by the same amount:

Let’s go to a different item that has no inventory:

Let’s add a rental order and try to pack out the quantity:

We have no inventory, so we can’t pack it.  The DIR has been created, but it is unreserved:

Now, let’s add some inventory:

Pack Order, at this point, is still unsuccessful:

The reason why we can’t pack it is because the inventory has not been reserved to this rental order.  To do so, you must go to the rental line and click “Refresh DIR”, which will attempt to reserve the inventory:

The DIR will be updated (assuming it is a successful Refresh DIR) as follows:

Let’s try to pack it again:

 

Was this article helpful?

0 out Of 5 Stars

5 Stars		0%
4 Stars		0%
3 Stars		0%
2 Stars		0%
1 Stars		0%

How can we improve this article?

Please submit the reason for your vote so that we can improve the article.

Name

Email

Submit