Requisition Worksheets

In our ERP solution, you have the option to create purchase orders either manually or automate the process through the requisition worksheet. The requisition worksheet plays a central role in the automation of routine activities when determining and covering demands. Based on these determined demands, the requisition worksheet automatically generates purchase order lines that can be transferred to a purchase order or request after checking. All relevant information on working with requisition worksheets can be found on this page. For details on the manual creation of purchase orders, please click here. For details on the creation of purchase orders as drop shipment, please click here. This chapter is divided into the following sections:

• Creating Purchase Order via Requisition Worksheet
• Setting up Automatic Requisition Worksheets
• Setting up Order Type Mapping for Requisition Worksheets
• Adding Lead Time for Purchase Orders created via Req. Worksheets to Vendors

Creating Purchase Order via Requisition Worksheet

To create purchase order via the requisition worksheet, please proceed as follows:

• Use the quick search (ALT+Q) to find the page Requisition Worksheets.
• Select the right requisition worksheet from the Name field.

• Click Start > Calculate Plan in the menu bar.
• Fill in the fields in the Options FastTab according to the following table:

• Optional In the Filter: Items FastTab, add filters as needed.
• Check all information and click OK to calculate the demands.
• The items that need to be ordered will be written as different lines into the requisition worksheet.

• To create purchase orders for these lines, click on Start > Carry Out Action Message.
• Activate the Print Orders toggle switch if new purchase orders should be printed after creation.
• Activate the Show Open Orders Req. Worksheet toggle switch if the requisition worksheet for open documents should be opened after the report has been executed.
• If needed, enter a responsibility center in the Resp. Center for New Purchase Orders field. The responsibility center will then be transferred to newly created purchase orders.
• Confirm the dialog with OK.
• If you have activated the Show Open Orders Req. Worksheet toggle switch, the page Open Req. Worksheet Orders will be displayed. If you haven't activated this toggle switch, the purchase orders will be created in the background.
• To open a purchase order, click on Open Order in the menu bar.
• You can now further process the purchase order.

Setting up Automatic Requisition Worksheets

In our ERP solution, you have the option of automating the execution of the Calculate Plan function in requisition worksheets so that the process is carried out automatically in the background in form of a job queue. This process automatically generates purchase order lines for purchase orders based on a set schedule, sparing users from the need to manually execute the function or await the completion of the report - a process that can take some time depending on the size of the business. To set up automatic requisition worksheets, please proceed as follows:

• Use the quick search (ALT+Q) to find the page Calc. Plan Background Setup.
• In the menu bar, click on New to define a new process for the automatic generation of purchase order lines.
• Complete the columns according to the table below.

• In the menu bar, click on Actions > Setup Calc. Plan Paramters for the newly created line.
• Fill in the required fields as needed.
• To save your entries, click OK. This will not execute the report directly. Instead, the new request page saves the entered parameters and filter options for the user data. If the user later uses the Calculate Plan... function in the requisition worksheet and an existing setup is available, the fields will automatically be prefilled with the previously saved values.
• To now set up the automatic creation of purchase order lines via a job queue, click on Actions > Create Job Queue Entry in the menu bar.

You have successfully set up the automatic creation of purchase order lines via a job queue.

Setting up Order Type Mapping for Requisition Worksheets

In our ERP solution, you have the option to map sales order types and purchase order types individually for each vendor. This way, orders created via sales orders, service orders, or requisition worksheets automatically trigger the creation of corresponding purchase orders – provided that the corresponding mappings are stored for the vendor. Additionally, the automatic reservation of items for the set up order type mapping can be activated and the lead time for orders can be specified. This chapter provides all important information regarding order type mapping for orders and requisition worksheets. Please proceed as follows to set up an order type mapping for requisition worksheets:

• Use the quick search (ALT+Q) to find the Order Type Mapping for Requisition Worksheets page.
• Click on New in the menu bar.
• Complete the columns according to the table below.

You have successfully set up an order type mapping for requisition worksheets.

Adding Lead Time for Purchase Orders created via Req. Worksheets to Vendors

In our ERP solution, you can store lead times for specific order types at the vendor. The lead time will be used to calculate the Expected Receipt Date on the purchase order. This functionality proves valuable in scenarios where certain vendors ship from distant locations, resulting in longer delivery times. You can also specify whether items should be reserved automatically during the procurement process. To add a lead time for purchase orders that are automatically created via the req. worksheets to a vendor, please proceed as follows:

• Use the quick search (ALT+Q) to find the page Vendors in the ERP solution.
• A list containing all vendors is displayed.
• Open the vendor you would like to add a specific lead time to.
• The vendor card of the selected vendor is displayed.
• In the menu bar, click on Related > Vendor > Order Type Mapping for Req. Worksheets.
• The Order Type Mapping for Req. Worksheets is displayed.
• Complete the columns according to the table below.

You have successfully set up a lead time for a vendor. If a Purchase order is created via a Req. Worksheet based on the chosen order types, the Expected Receipt Date on the purchase order will be calculated using the workdate and the lead time.