Purchase Order

Overview

Direction: Business Central → Zudello
Sync Type: Incremental sync
Entity: Purchase orders with line items

Purchase order data flows from Business Central to Zudello to provide reference information for invoice matching and procurement tracking.

Purchase Order Features

• Invoice Matching - Reference data for invoice validation
• Line Item Detail - Complete line-by-line order information
• Automatic Relationships - Link suppliers, items, and accounts
• Procurement Tracking - Monitor order fulfillment status

Field Mappings

Header Fields

Zudello Field	Business Central Field	Data Type	Notes
module	N/A	String	Always "PURCHASING"
submodule	N/A	String	Always "ORDER"
document_type	N/A	String	Always "PURCHASE_ORDER"
supplier.external_id	vendorId	GUID	Reference to supplier
company_name	vendorName	String	Supplier company name
document_number	number	String	Purchase order number
date_issued	orderDate	Date	Order creation date
date_due	requestedReceiptDate	Date	Requested delivery date
subtotal	totalAmountExcludingTax	Decimal	Net amount before tax
total	totalAmountIncludingTax	Decimal	Total amount including tax
status	N/A	String	Always set to "COMPLETE"

Line Item Fields

Zudello Field	Business Central Field	Data Type	Notes
description	description	String	Line item description
line_number	sequence	Integer	Line sequence number
quantity	quantity	Decimal	Ordered quantity
unit_price	directUnitCost	Decimal	Unit cost excluding tax
total	amountIncludingTax	Decimal	Line total including tax
item.external_id	itemId	GUID	Reference to item (if applicable)
account.external_id	accountId	GUID	Reference to account (if applicable)

Processing Logic

Data Expansion

• Complete Data: The integration retrieves all necessary purchase order data, including header details, line items, and dimensions, in a single operation for efficiency.
• Line Processing: Each line from a Business Central purchase order is created as a separate line item in Zudello.
• Relationship Mapping: The integration automatically links purchase orders to the corresponding suppliers, items, and accounts in Zudello.

Status Management

• Fixed Status: All purchase orders brought into Zudello are automatically given a COMPLETE status.
• Classification: Orders are categorized under the "PURCHASING" module and "ORDER" submodule in Zudello.

Troubleshooting

Issue	Cause	Solution
Missing PO data	Sync not running	Check incremental sync process
Line items missing	Expansion not working	Verify API expand parameters
Supplier not linked	Missing vendor sync	Ensure supplier sync completed first
Item references broken	Item sync incomplete	Verify item master data sync
Amount discrepancies	Currency/tax differences	Check currency and tax rate sync