calc_working_capital
Calculate DSO, DPO, DSI, and CCC from open receivables, payables, sales, and inventory to assess working capital efficiency.
Instructions
Working capital efficiency metrics: DSO (Days Sales Outstanding), DPO (Days Payable Outstanding), DSI (Days Sales of Inventory), and CCC (Cash Conversion Cycle = DSI + DSO − DPO). Pulls open AR, open AP, sales, and inventory from SAP B1.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| periodDays | No | Period to calculate revenue/COGS rate from (default 90) |