Find Invoices that are Overdue
You want to check on a customer's invoices to view how many are overdue and the months in which they become overdue.
Example URL
Here's an example of the resource URL:
GET
fscmRestApi/resources/11.13.18.05/receivablesInvoices?finder=invoiceSearch;ShipToCustomerName=Total Internet,InvoiceStatus=Complete,DueDate=2018-02-20cURL Command
curl --user <username>:<password> -X GET -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" https://<host>:<port>/fscmRestApi/resources/<version>/receivablesInvoices?finder=invoiceSearch;ShipToCustomerName=Total Internet,InvoiceStatus=Complete,DueDate=2018-02-20
Example Response
Here's an example of the response body in JSON format:
{
"items": [
{
"CustomerTransactionId": 300100170996427,
"DueDate": "2018-02-20",
"ConversionDate": null,
"ConversionRate": null,
"InvoiceCurrencyCode": "USD",
"SpecialInstructions": null,
"CrossReference": null,
"DocumentNumber": null,
"TransactionNumber": "1007",
"TransactionDate": "2018-02-20",
"TransactionType": "Invoice",
"TransactionSource": "Manual-NES",
"BillToCustomerNumber": "1008",
"BillToSite": "Foster City (OPS)",
"Comments": "New Laptop Promotion",
"InternalNotes": "Best Priced item",
"PaymentTerms": "30 Net",
"LegalEntityIdentifier": "USSYS12030",
"ConversionRateType": null,
"PurchaseOrder": null,
"PurchaseOrderDate": null,
"PurchaseOrderRevision": null,
"FirstPartyRegistrationNumber": "4567890",
"ThirdPartyRegistrationNumber": null,
"InvoicingRule": null,
"ShipToCustomerName": "Total Internet",
"ShipToCustomerNumber": "1008",
"BillingDate": "2018-02-20",
"BusinessUnit": "Vision Operations",
"InvoiceStatus": "Complete",
"AccountingDate": "2018-02-20",
"ShipToSite": "1042",
"PayingCustomerName": "Total Internet",
"PayingCustomerSite": "Foster City (OPS)",
"BillToCustomerName": "Total Internet",
"FreightAmount": null,
"Carrier": null,
"ShipDate": null,
"ShippingReference": null,
"BillToContact": null,
"ShipToContact": null,
"PrintOption": "Yes",
"CreatedBy": "AR_MGR_OPERATIONS",
"CreationDate": "2018-12-19T05:30:04.003+00:00",
"LastUpdatedBy": "AR_MGR_OPERATIONS",
"LastUpdateDate": "2018-12-19T05:30:04.841+00:00",
"PayingCustomerAccount": "1008",
"SoldToPartyNumber": "1008",
"RemitToAddress": "ZD, Park Avenue St",
"DefaultTaxationCountry": "US",
"EnteredAmount": 3066.08,
"InvoiceBalanceAmount": 3066.08,
"Prepayment": "No",
"Intercompany": "No",
"DocumentFiscalClassification": null,
"BankAccountNumber": null,
"CreditCardAuthorizationRequestIdentifier": null,
"CreditCardExpirationDate": null,
"CreditCardIssuerCode": null,
"CreditCardTokenNumber": null,
"CreditCardVoiceAuthorizationCode": null,
"CreditCardErrorCode": null,
"CreditCardErrorText": null,
"CardHolderLastName": null,
"CardHolderFirstName": null,
"ReceiptMethod": null,
"SalesPersonNumber": null,
"StructuredPaymentReference": null,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427",
"name": "receivablesInvoices",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000017704000000017372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C78"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427",
"name": "receivablesInvoices",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/transactionSources",
"name": "transactionSources",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/businessUnits",
"name": "businessUnits",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/PaymentTermsVA",
"name": "PaymentTermsVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/thirdPartyTaxRegistrationNumbers",
"name": "thirdPartyTaxRegistrationNumbers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/invoiceStatuses",
"name": "invoiceStatuses",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/shipToCustomers",
"name": "shipToCustomers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/billToCustomers",
"name": "billToCustomers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/legalEntities",
"name": "legalEntities",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/invoicingRules",
"name": "invoicingRules",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/billToSites",
"name": "billToSites",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/taxationCountries",
"name": "taxationCountries",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/firstPartyTaxRegistrationNumbers",
"name": "firstPartyTaxRegistrationNumbers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/transactionTypes",
"name": "transactionTypes",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/receivablesInvoiceLines",
"name": "receivablesInvoiceLines",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/receivablesInvoiceTransactionDFF",
"name": "receivablesInvoiceTransactionDFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/receivablesInvoiceGdf",
"name": "receivablesInvoiceGdf",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/receivablesInvoiceInstallments",
"name": "receivablesInvoiceInstallments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/receivablesInvoiceDFF",
"name": "receivablesInvoiceDFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/notes",
"name": "notes",
"kind": "collection"
}
]
}
],
"count": 1,
"hasMore": false,
"limit": 25,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices",
"name": "receivablesInvoices",
"kind": "collection"
}
]
}