Planning replenishment with Requisition Worksheet

Requisition Worksheet is used to calculate
1) What items to be ordered
2) When to order
3) How many to order.

How to use Requisition Worksheet ?
1) To open the Requisition Worksheet window, go to Purchase --> Planning --> Requisition Worksheets.
2) Click Function --> Calculate Plan to orepn the request form.
3) You can set filter at the Item tab and Options tab or just accept the default value to calculate for all. However, the Order Date and Ending Date in the Option tab are a mandatory fields. The replenishment order will be proposed from Order Date onwards while the any demands after the Ending date will not be calculated.
4) Navision will calculate and list out order proposal lines.
5) You can edity the proposed lines if you are not happy with the proposed lines.
6) If you are OK with the proposed lines, click on Function --> Carry Out Action Message to open the Message box.
7) Click on the OK button create Purchase Orders.

Please note that the proposed due date in the Requisition Worksheet will depends on when the item is required by the company. To illustrate this clearer, consider the following scenario:

Item A requires 2 weeks lead time to be purchased and the reorder point has been set to 130. Reorder Quantity for Item A has been set to 150.

On 14 October 2007, a salesperson has created a sales order for an important customer with 100 units of Item A. By the time the salesperson created the sales order, Navision has prompted him that there are only 20 units of Item A available in the warehouse. Therefore, the sales person calls the purchaser immediately to replenish the item.

The purchaser run the Calculate Plan in the Requisition Worksheet for Item A. Navision proposed 2 replenishment orders with different due date. The first replenishment order has the due date on 14th October 2007 with the Order quantity of 80 to fulfill the sales order requirement. This can fullfill the quanitity required by the sales order although it is not possible to deliver the item to customer on 14th October 2007. After minus out 100 units for the sales order, there are 0 units remain in inventory, which is lower than the reorder point of 130 units. This will trigger Navision to propose the 2nd replenishment order of 150 units. But this time, the due date is set to 28th October 2007, which is 2 weeks later than the order date.

Change Qty. to Receive field in Purchase Line

When you change the Qty. to Receive field in the Purchase Line, the following field will be updated as well:

• Qty. to Invoice
• Qty. to Receive (Base)
• Qty. to Invoice (Base)

The Qty. to Invoice field will copy the value from the Qty. to Receive field.

Create Purchase Order

Have you ever wondered what will happen to Navision database when we create a PO. The following steps explains what will happens to the database when we create and post a PO.

In the Purchase Order window, Press F3 and then hit the Enter button to create a new Purchase Order. The following fields are updated when the record is created

• Document Type
• No.
• Ship-to Name
• Ship-to Address
• Ship-to City
• Order Date
• Posting Date
• Posting Description
• Applies-to Doc. Type
• Ship-to PostCode
• Bal. Account Type
• Document Date
• No. Series
• Posting No. Series
• Receiving No. Series
• Status
• Invoice Discount Calculation
• Doc. No. Occurence

Enter 10000 in the Vendor No. field. This will caused Table 38 - Purchase Header and Table 357 - Dimension to be updated.

Table 38 - Purchase Header

• Buy-from Vendor No.
• Pay-to Vendor No.
• Pay-to Name
• Pay-to Address
• Pay-to City
• Pay-to Contact
• Payment Terms Code
• Due Date
• Pmt. Discount Date
• Shipment Method Code
• Vendor Posting Group
• Invoice Disc. Code
• Language Code
• Purchaser Code
• SST Registration No.
• Gen. Bus. Posting Group
• SST Country Code
• Buy-from Vendor Name
• Buy-from Address
• Buy-from City
• Buy-from Contact
• Pay-to Post Code
• Pay-to Country Code
• Buy-from Post Code
• Buy-from Country Code
• SST Bus. Posting Group
• Buy-from Contact No.
• Pay-to Contact No.
• Responsibility Center
  

Table 38 - Purchase Header

• Table ID
• Document type
• Document No.
• Line No.
• Dimension Code
• Dimension Value Code

When we post the Purchase Order as Receive, 16 tables will be updated. Tables updated when we post PO are:

1. Table 309: No. Series Line
2. Table 38: Purchase Header
3. Table 39: Purchase Line
4. Table 6224: SynchMgt. Message Queue
5. Table 120: Purch. Rcpt. Header
6. Table 359: Posted Document Dimension
7. Table 28003: Address ID
8. Table355: Ledger Entry Dimension
9. Table 32: Item Ledger Entry
10. Table 46: Item Register
11. Table 339: Item Application Entry
12. Table 5802: Value Entry
13. Table 27: Item
14. Table 121: Purch. Rcpt. Line
15. Table 7152: ItemAnalysis View
16. Table 7154: Item Analysis View Entry
    

Post Item Purchase

You can post an item purchase from
1) Purchase Order
OR
2) Item Journal

If you post from Purchase Order, the purchase line will first transferred to item journal line and then post from there.

How to enter opening balance for vendors

If you want to migrate to Navision from other accounting system, you may need to migrate over the opening balance of vendors to Navision. In Navision, there is no specific screen or function for you to maintain opening balance for vendors. Opening balance for vendors can be entered through General Journal. In General Journal, you can select Invoice or Credit Memo document type. Please take note that if you select Invoice as the document type, the amount value must be negative. If you select Credit Memo, the amount value must be positive. Otherwise, you will not be able to post the journal entries to ledger.

Vendor Dimension Code Mandatory

If you set Dimension Value = Code Mandatorythen, then this dimension must have value when doing posting, but any dimension value is acceptable.

If you set Dimension value = code mandatory at Vendor card, you must specify a dimension value at purchase order header. If you specify at the purchase line but not at the header, you still not able to do posting.