How to Set Up and Use the Requisition Worksheet in Business Central

The Requisition Worksheet is a planning tool that consolidates purchase demand before creating POs. Set up worksheet names, configure vendors and item references, then use Calculate Plan or manual entry to populate lines.

Step-by-step guide

1

Create a worksheet name

Search for 'Requisition Worksheet Names' and create a new entry. Give it a code (e.g., 'PURCH') and description. This groups related requisition lines together.

2

Open the Requisition Worksheet

Search for 'Requisition Worksheets' and select your worksheet name from the batch dropdown.

3

Populate with demand

Use 'Calculate Plan' to automatically pull demand from sales orders and production orders. Or manually add lines for ad-hoc purchases.

4

Review and assign vendors

Each line should have a vendor assigned. Verify item references, quantities, and unit prices. BC uses your item reference table to suggest the correct vendor and price.

5

Carry out action messages

Click 'Carry Out Action Messages' to convert the worksheet lines into Purchase Orders. BC groups lines by vendor automatically.

The faster way with Zentriq

Zentriq PunchOut creates Requisition Worksheet lines directly from e-commerce cart data. Instead of manually typing items, just capture a supplier cart and the lines appear in your worksheet with vendor, item reference, and pricing pre-filled.

Related Zentriq products: Zentriq PunchOut

Try Zentriq free →

More guides

Related resources

GlossaryRequisition WorksheetUse CaseAI Assistant for Business CentralUse CaseAutomate Requisition Worksheets in Business CentralHow-toHow to Create a Purchase Order in Business CentralHow-toHow to Process a Purchase Invoice in Business Central