Get Specific Details for Invoices and Installments
Your Accounts
Payable Supervisor or Manager would like to view a limited set of
information from both invoice header and installments. They are:
- Invoices:
- Invoice ID
- Invoice Number
- Pay Group
- Invoice Installments:
- Unpaid Amount
- Payment Method
Example URL
Here's an example of the resource URL to display data from the invoices and invoice installments resources:
GET
/fscmRestApi/resources/11.13.18.05/invoices?expand=invoiceInstallments&fields=InvoiceId,InvoiceNumber,PayGroup;invoiceInstallments:UnpaidAmount,PaymentMethod&onlyData=true
cURL Command
curl -i -u "<username>:<password>" -H "Content-Type: application/json" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices?expand=invoiceInstallments&fields=InvoiceId,InvoiceNumber,PayGroup;invoiceInstallments:UnpaidAmount,PaymentMethod&onlyData=true
Example Response
Here's an example of the response body in JSON format:
{
"items": [
{
"InvoiceId": 338908,
"InvoiceNumber": "Withholding tax - 300100151967070-2",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 50,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 339908,
"InvoiceNumber": "Withholding tax - 300100152264186-2",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 80,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 338909,
"InvoiceNumber": "Withholding tax - 300100152264179-2",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 200,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 338910,
"InvoiceNumber": "Withholding tax - 300100152264183-2",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 30,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 339909,
"InvoiceNumber": "Withholding tax - 300100152264213-2",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 150,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 300100152264213,
"InvoiceNumber": "TH_05",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 0,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 300100152264186,
"InvoiceNumber": "TH_04",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 0,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 300100152264179,
"InvoiceNumber": "TH_02",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 0,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 300100151967070,
"InvoiceNumber": "TH_01",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 0,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 300100152264183,
"InvoiceNumber": "TH_03",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 0,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 361908,
"InvoiceNumber": "Withholding tax - 300100171617230-4",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 5,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 361909,
"InvoiceNumber": "Withholding tax - 300100171617230-6",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 1,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 361910,
"InvoiceNumber": "Withholding tax - 300100171617230-5",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 10,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 300100171617230,
"InvoiceNumber": "WHT_181016_1",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 0,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 300100023308217,
"InvoiceNumber": "Test1",
"PayGroup": "Priority",
"invoiceInstallments": [
{
"UnpaidAmount": 1000,
"PaymentMethod": "Check"
}
]
},
{
"InvoiceId": 189097,
"InvoiceNumber": "AP_RRF_CCU_I637",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 2925,
"PaymentMethod": "Electronic"
}
]
},
{
"InvoiceId": 189098,
"InvoiceNumber": "AP_RRF_CCU_I647",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 3175,
"PaymentMethod": "Electronic"
}
]
},
{
"InvoiceId": 189099,
"InvoiceNumber": "AP_RRF_CCU_I648",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 3200,
"PaymentMethod": "Electronic"
}
]
},
{
"InvoiceId": 189100,
"InvoiceNumber": "AP_RRF_CCU_I650",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 3250,
"PaymentMethod": "Electronic"
}
]
},
{
"InvoiceId": 189101,
"InvoiceNumber": "AP_RRF_CCU_I656",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 3400,
"PaymentMethod": "Electronic"
}
]
},
{
"InvoiceId": 189102,
"InvoiceNumber": "AP_RRF_CCU_I657",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 3425,
"PaymentMethod": "Electronic"
}
]
},
{
"InvoiceId": 189103,
"InvoiceNumber": "AP_RRF_CCU_I659",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 3475,
"PaymentMethod": "Electronic"
}
]
},
{
"InvoiceId": 189104,
"InvoiceNumber": "AP_RRF_CCU_I666",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 3650,
"PaymentMethod": "Electronic"
}
]
},
{
"InvoiceId": 189105,
"InvoiceNumber": "AP_RRF_CCU_I668",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 3700,
"PaymentMethod": "Electronic"
}
]
},
{
"InvoiceId": 189106,
"InvoiceNumber": "AP_RRF_CCU_I675",
"PayGroup": null,
"invoiceInstallments": [
{
"UnpaidAmount": 3875,
"PaymentMethod": "Electronic"
}
]
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices",
"name": "invoices",
"kind": "collection"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/cancelInvoice",
"name": "cancelInvoice",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/cancelLine",
"name": "cancelLine",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/validateInvoice",
"name": "validateInvoice",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/calculateTax",
"name": "calculateTax",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/generateDistributions",
"name": "generateDistributions",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/applyPrepayments",
"name": "applyPrepayments",
"kind": "other"
}
]
}