How to Create a Purchase Order in iDempiere for Retail

Learn how to configure Purchase Order in iDempiere for retail procurement, vendor selection, PO lines, taxes, and downstream integration.

Introduction

The Purchase Order window in iDempiere is the primary procurement document used to order products and services from vendors. In retail operations, it drives inventory replenishment by linking vendor selection, warehouse destination, and procurement pricing in a single transaction.

Once completed, the Purchase Order becomes the source document for Material Receipt and Vendor Invoice, directly impacting stock levels and vendor settlement.

Prerequisites

Ensure the following configurations are completed before creating a Purchase Order in iDempiere:

  • Business Partner configured with the Vendor flag enabled.
  • Purchase-enabled Product Master records configured.
  • Warehouse and Locator setup completed.
  • Purchase Price List configured and assigned.
  • Tax Category and Tax Rate configuration.
  • Payment Term configured for vendor settlement.
  • UOM and UOM Conversion configured, if alternate purchase units are used.

Business Rules

  • Vendor selection is mandatory before creating a Purchase Order.
  • Promise Date cannot be earlier than Date Ordered.
  • Only active, purchase-enabled products can be added to PO Lines.
  • Inactive or deactivated products are unavailable for procurement transactions.
  • Product pricing is automatically derived from the assigned Purchase Price List.
  • Tax is calculated automatically based on Product Tax Category and vendor location.
  • Warehouse selection determines the inventory destination during goods receipt.
  • A Purchase Order must be completed before Material Receipt or Vendor Invoice can be generated.
  • Completed Purchase Orders become read-only unless reactivated.
  • UOM Conversion supports procurement in carton, case, or bulk units.
  • Payment Rule and Payment Term control the vendor settlement schedule.

Navigation

Menu → Requisition-to-Invoice (Purchasing) → Purchase Order

The window displays all existing Purchase Order records.

Step-by-Step Configuration

Step 1: Open the Purchase Order Window

Provides the entry point for creating a new procurement transaction.

  • Navigate to the Purchase Order window from the Purchasing menu.
  • Review existing records, then click the New Record button (+) to open a blank Purchase Order form.

Step 2: Create the Purchase Order Header

The header captures the organization, document type, and dates that define the scope of the transaction.

  • Select the Organization and Target Document Type, then enter Date Ordered and Date Promised.
  • Document No is generated automatically based on the configured Document Sequence.
FieldSample ValueMandatoryDescription
OrganizationChennai StoreYesBusiness unit responsible for the transaction
Target Document TypePurchase OrderYesControls the procurement document type
Document NoPO2026_800012AutoAuto-generated from Document Sequence
Date Ordered12-Jun-2026YesDate the order is raised
Date Promised18-Jun-2026YesDelivery date committed by the vendor

Step 3: Configure Vendor Information

Vendor selection determines pricing, location, and invoice defaults for the order.

  • Select the Business Partner acting as vendor. iDempiere automatically populates Partner Location and contact defaults.
  • Verify the location if the vendor supplies from multiple addresses.
FieldSample ValueMandatoryDescription
Business PartnerChennai SuppliersYesIdentifies the supplier for the order
Partner LocationChennaiYesVendor address used for procurement and invoicing
User / ContactMuruganNoVendor contact for procurement coordination

Step 4: Configure Delivery Information

Delivery settings control where goods are received and how they are handled.

  • Select the destination Warehouse and Delivery Via method.
  • Set Priority if needed, and enable Drop Shipment only when the vendor ships directly to a customer.
FieldSample ValueMandatoryDescription
WarehouseChennai Selling FloorYesDestination warehouse for received goods
Delivery ViaPickupNoDelivery method used for the order
PriorityMediumNoIndicates procurement urgency
Drop ShipmentUncheckedNoEnable only for direct-to-customer shipments

Step 5: Configure Vendor Settlement Information

This section drives automatic price derivation and the vendor payment cycle.

  • Assign the Purchase Price List for automatic pricing, then set Payment Rule, Payment Term, and Currency to define how the vendor will be settled.
FieldSample ValueMandatoryDescription
Purchase Price ListPurchase Price ListYesProcurement pricing structure for automatic price derivation.
Company AgentAjay Narayan (Buyer)NoProcurement user or buyer responsible for the transaction.
Payment RuleOn CreditYesVendor settlement method (Cash, Credit Card, Direct Deposit, On Credit).
Payment TermWeekly SettlementYesVendor settlement schedule and payment due calculation.
CurrencyINRYesProcurement transaction currency.

Step 6: Add Products in PO Line

Line items capture the actual procurement quantities, pricing, and amounts.

  • Open the PO Line tab and click New Record (+).
  • Select the Product; UOM, pricing, discount, and tax are derived automatically from Product Master and the Purchase Price List.
FieldSample ValueMandatoryDescription
Line No10AutoSequence number for the PO line.
ProductBritannia Good Day Butter Cookies — 200gYesProcurement item being ordered from the vendor.
Quantity10YesProcurement quantity in selected UOM.
UOMEachYesUnit of measure for procurement (Each, Case, Box).
Price55.00YesProcurement price per unit, auto-derived from Price List.
Discount %8.33NoDiscount percentage applied to procurement price.
Tax8.33YesTax derived from Product Tax Category and vendor setup.
Line Amount550.00AutoCalculated value based on quantity, price, and discount.

Step 7: Configure UOM Conversion (If Applicable)

Allows purchasing in carton, case, or bulk units while inventory is maintained in a different base unit.

  • Verify UOM Conversion in Product Master before selecting an alternate purchase unit. iDempiere recalculates quantity, price, and line amount automatically when the UOM changes.

UOM Conversion Example

Purchase UOMInventory UOMConversion FactorExample
CaseEach121 Case = 12 Each
BoxEach61 Box = 6 Each
CartonEach241 Carton = 24 Each

When the procurement UOM changes, iDempiere automatically recalculates procurement quantity, pricing, and line amount. Verify UOM Conversion configuration in Product Master before using alternate units.

Step 8: Review Pricing and Tax

Ensures GST compliance and pricing accuracy before completing the document.

  • Check List Price, Price, Discount %, and Line Amount on each PO Line.
  • Confirm CGST, SGST, or IGST is applied correctly based on vendor location.

Pricing Fields

FieldDescription
List PriceStandard price from the Purchase Price List.
PriceActual procurement price (may differ from List Price).
Unit PricePrice per unit after UOM conversion.
Discount %Automatically calculated when procurement price differs from list price.
Line AmountFinal value: (Quantity × Price) × (1 − Discount%).

Tax Fields

Tax TypeApplicability
CGSTCentral GST — intra-state procurement.
SGSTState GST — intra-state procurement.
IGSTIntegrated GST — inter-state procurement.

Step 9: Review Important Tabs

The Purchase Order window includes additional tabs for procurement validation, costing, and payment tracking. Review these tabs before completing the document.

TabPurpose
Order TaxDisplays calculated procurement tax details: tax type, tax amount, tax base amount, and GST compliance summary.
MatchingStores document matching references between Purchase Order, Material Receipt, and Vendor Invoice for audit traceability.
Payment ScheduleTracks payment due dates, discount dates, and validation status generated from Payment Terms.
Estimated Landed CostCaptures additional procurement expenses (freight, customs, loading). Optional for standard retail procurement.
Landed Cost AllocationAllocates landed costs across PO lines by Quantity, Amount, Weight, or Volume. Used in advanced costing scenarios.

Step 10: Complete the Purchase Order

After validating all procurement information, process the Purchase Order using Document Actions. Click the Document Action button and select Complete.

Document ActionWhen to Use
CompleteFinalises the Purchase Order. Enables Material Receipt and Vendor Invoice generation.
ReactivateReopens a Completed Purchase Order for corrections.
VoidCancels the Purchase Order permanently. Cannot be reversed.
CloseCloses the Purchase Order after receipt is partially or fully completed.

Important: Once a Purchase Order is Completed, the document becomes read-only. Use Reactivate only when corrections are required. Voided documents cannot be recovered.

Configuration Summary

Configuration ItemTypePurpose
Purchase Order HeaderProcurement DocumentCaptures vendor, warehouse, payment, and procurement control information.
Vendor (Business Partner)Master DataIdentifies the supplier and derives location, invoice, and payment defaults.
Purchase Price ListPricing MasterAuto-derives product procurement prices in PO Lines.
PO LineTransaction LineStores product, quantity, UOM, pricing, discount, and tax per procurement item.
UOM ConversionMaster DataSupports carton, case, and bulk procurement with automatic recalculation.
Tax ConfigurationTax MasterAuto-calculates CGST, SGST, and IGST based on product and vendor setup.
Payment TermsMaster DataControls vendor settlement schedule and due date calculation.
Document ActionsWorkflow ControlComplete, Reactivate, Void, and Close manage the procurement lifecycle.

Downstream Integration

Material Receipt Integration

After Purchase Order completion, the Material Receipt (GRN) can be generated to record physical receipt of products into the warehouse. This process updates inventory stock, warehouse quantity, and procurement receipt tracking.

Vendor Invoice Integration

Vendor Invoice can be generated from the completed Purchase Order for supplier billing and payment processing. This supports vendor billing, procurement payment tracking, invoice validation, and financial processing.

Common Issues and Resolutions

IssueCauseResolution
Product not visible in PO LineProduct is inactive or not purchase-enabledActivate the product and enable the Purchase flag in Product Master.
Pricing not derived automaticallyPurchase Price List missing or not assignedVerify Price List configuration and vendor assignment.
Tax not calculatedProduct Tax Category or Tax Rate not configuredSet Tax Category in Product Master and verify Tax Rate setup.
Unable to complete Purchase OrderMandatory fields missing or no PO Lines addedCheck mandatory header fields and ensure at least one valid line exists.
Vendor not listed in Business Partner fieldVendor checkbox not enabledEnable the Vendor flag in Business Partner master.
Incorrect UOM conversion resultConversion factor misconfiguredVerify UOM Conversion setup in Product Master.
Material Receipt not generatingPurchase Order status is not CompletedComplete the Purchase Order before generating the Material Receipt.
Payment schedule missingPayment Term not assignedAssign Payment Term in the Purchase Order header.

Next Steps

After completing the Purchase Order configuration in iDempiere, proceed with:

  • Generate Material Receipt (GRN) for goods received.
  • Generate Vendor Invoice for supplier billing.
  • Process vendor payment against the invoice.
  • Configure Estimated Landed Cost for freight-heavy procurement.
  • Track procurement status using Purchasing Reports.

Leave a Reply

Your email address will not be published. Required fields are marked *