Purchase Order Lines

The data model encompasses purchase order line details, including original quantity ordered and quantities received, outstanding products, costs, expected arrival, current and late amounts in transaction, home, and reporting currencies. It also includes overdue amounts categorized into different time ranges for both currencies. The model provides insights into project-based purchase orders, late deliveries, aging of costs in transaction and home currencies, individual purchase order lines, and overall status of purchased items.

Benefits of This Data Model

• Enhanced Purchase Order Visibility: Providing detailed insights into project-based purchase orders, associated costs, and status of purchased items helps in better tracking and monitoring of purchase order lines.
• Improved Analysis of Late Deliveries: The model enables a focused analysis of purchase orders with delayed delivery schedules, aiding in prompt identification and resolution of late delivery issues.
• Efficient Cost Tracking: Tracking the aging of purchase orders' total costs in both transaction and home currencies facilitates better cost management and forecasting.
• Granular Overview of Overdue Amounts: Categorizing overdue amounts into different time ranges for transaction and home currencies allows for a detailed analysis of outstanding payments, assisting in timely action and financial planning.

Key Performance Indicators (KPIs)

• Orig. Qty. Ordered: The original quantity ordered for a purchase order line.
• Qty. Received: The quantity of products received for a purchase order line.
• Outstanding Qty.: The quantity of products that are yet to be received for a purchase order line.
• Outstanding Cost: The total cost of outstanding products for a purchase order line.
• Expected Arrival In Days: The expected number of days until the arrival of outstanding products for a purchase order line.
• Transaction Currency Current Amount: The current amount in the transaction currency for a purchase order line.
• Transaction Currency Total Amount Late: The total amount late in the transaction currency for a purchase order line.
• Amount Late TC 1-14 Days: The amount late in the transaction currency for 1-14 days overdue for a purchase order line.
• Amount Late TC 15-30 Days: The amount late in the transaction currency for 15-30 days overdue for a purchase order line.
• Amount Late TC 31-60 Days: The amount late in the transaction currency for 31-60 days overdue for a purchase order line.
• Amount Late TC 61-90 Days: The amount late in the transaction currency for 61-90 days overdue for a purchase order line.
• Amount Late TC 90+ Days: The amount late in the transaction currency for over 90 days overdue for a purchase order line.
• Home Currency Current Amount: The current amount in the home currency for a purchase order line.
• Home Currency Total Amount Late: The total amount late in the home currency for a purchase order line.
• Amount Late HC 1-14 Days: The amount late in the home currency for 1-14 days overdue for a purchase order line.
• Amount Late HC 15-30 Days: The amount late in the home currency for 15-30 days overdue for a purchase order line.
• Amount Late HC 31-60 Days: The amount late in the home currency for 31-60 days overdue for a purchase order line.
• Amount Late HC 61-90 Days: The amount late in the home currency for 61-90 days overdue for a purchase order line.
• Amount Late HC 90+ Days: The amount late in the home currency for over 90 days overdue for a purchase order line.
• Reporting Currency Current Amount: The current amount in the reporting currency for a purchase order line.
• Reporting Currency Total Amount Late: The total amount late in the reporting currency for a purchase order line.
• Reporting Currency Outstanding Cost: The outstanding cost in the reporting currency for a purchase order line.

Available Visualizations

View Name	Description
PJC Purchase Order Lines	Insights into project-based purchase orders and associated costs.
Late Purchase Orders	Analysis of purchase orders with delayed delivery schedules.
Purchase Orders Aging TC	Tracking the aging of purchase orders' total costs.
Purchase Order Lines	Detailed view of individual purchase order lines.
Purchased Items Status	Status overview of purchased items in various stages.
Purchase Orders Aging HC	Monitoring the aging of purchase orders based on header information.