Perform Bulk Update of Payment Terms and Invoice Status on Multiple Invoices
One of your high-value customers negotiated better payment terms, along with changes to a few other contractual terms, on their purchases. Your user wants to update the payment terms on an invoice and set multiple invoices to Incomplete so that your Finance supervisor can review the invoices for other updates.
Use the POST operation of the Receivables Invoices REST resource to update the payment terms on an invoice and set multiple invoices to Incomplete.
Example URL
Here's an example of the resource URL:
POST
fscmRestApi/resources/11.13.18.05/cURL Command
curl --user <username>:<password> -X POST -H "Content-Type: application/vnd.oracle.adf.batch+jsonExample Request
Here's an example of the request body in JSON format:
{
"parts": [
{
"id": "part1",
"path": "/receivablesInvoices/300100541530598",
"operation": "update",
"payload": {
"InvoiceStatus": "Incomplete"
}
},
{
"id": "part2",
"path": "/receivablesInvoices/300100541530600",
"operation": "update",
"payload": {
"PaymentTerms": "30/60/90",
"InvoiceStatus": "Incomplete"
}
}
]
}
Example Response
Here's an example of the response body in JSON format:
{
"parts": [
{
"id": "part1",
"path": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598",
"operation": "update",
"payload": {
"CustomerTransactionId": 300100541530598,
"DueDate": "2020-12-19",
"ConversionDate": null,
"ConversionRate": null,
"InvoiceCurrencyCode": "USD",
"SpecialInstructions": null,
"CrossReference": null,
"DocumentNumber": null,
"TransactionNumber": "2345",
"TransactionDate": "2020-11-19",
"TransactionType": "Invoice_35",
"TransactionSource": "Manual",
"BillToCustomerNumber": "CDRM_3197",
"BillToSite": "CDRM_1274",
"Comments": null,
"InternalNotes": null,
"PaymentTerms": "30 Net",
"LegalEntityIdentifier": "USSYS12030",
"ConversionRateType": null,
"PurchaseOrder": null,
"PurchaseOrderDate": null,
"PurchaseOrderRevision": null,
"FirstPartyRegistrationNumber": "4567890",
"ThirdPartyRegistrationNumber": null,
"InvoicingRule": null,
"ShipToCustomerName": "B2CA_Customer01",
"ShipToCustomerNumber": "CDRM_68995",
"BillingDate": null,
"BusinessUnit": "Vision Operations",
"InvoiceStatus": "Incomplete",
"AccountingDate": "2020-11-19",
"ShipToSite": "CDRM_27424",
"PayingCustomerName": "B2CA_Customer01",
"PayingCustomerSite": "CDRM_1274",
"BillToCustomerName": "B2CA_Customer01",
"FreightAmount": null,
"Carrier": null,
"ShipDate": null,
"ShippingReference": null,
"BillToContact": null,
"ShipToContact": null,
"PrintOption": "Yes",
"CreatedBy": "FIN_USER1",
"CreationDate": "2020-12-21T02:55:36.001+00:00",
"LastUpdatedBy": "FIN_USER1",
"LastUpdateDate": "2020-12-21T02:56:24+00:00",
"PayingCustomerAccount": "CDRM_3197",
"SoldToPartyNumber": "CDRM_68995",
"RemitToAddress": "ZD, Park Avenue St",
"DefaultTaxationCountry": "US",
"EnteredAmount": null,
"InvoiceBalanceAmount": null,
"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/300100541530598",
"name": "receivablesInvoices",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000378"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598",
"name": "receivablesInvoices",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/transactionSources",
"name": "transactionSources",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/businessUnits",
"name": "businessUnits",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/PaymentTermsVA",
"name": "PaymentTermsVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/thirdPartyTaxRegistrationNumbers",
"name": "thirdPartyTaxRegistrationNumbers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/invoiceStatuses",
"name": "invoiceStatuses",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/shipToCustomers",
"name": "shipToCustomers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/billToCustomers",
"name": "billToCustomers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/legalEntities",
"name": "legalEntities",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/invoicingRules",
"name": "invoicingRules",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/billToSites",
"name": "billToSites",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/taxationCountries",
"name": "taxationCountries",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/firstPartyTaxRegistrationNumbers",
"name": "firstPartyTaxRegistrationNumbers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/lov/transactionTypes",
"name": "transactionTypes",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/child/notes",
"name": "notes",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/child/receivablesInvoiceDFF",
"name": "receivablesInvoiceDFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/child/receivablesInvoiceDistributions",
"name": "receivablesInvoiceDistributions",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/child/receivablesInvoiceGdf",
"name": "receivablesInvoiceGdf",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/child/receivablesInvoiceInstallments",
"name": "receivablesInvoiceInstallments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/child/receivablesInvoiceLines",
"name": "receivablesInvoiceLines",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530598/child/receivablesInvoiceTransactionDFF",
"name": "receivablesInvoiceTransactionDFF",
"kind": "collection"
}
]
}
},
{
"id": "part2",
"path": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600",
"operation": "update",
"payload": {
"CustomerTransactionId": 300100541530600,
"DueDate": "2020-12-19",
"ConversionDate": null,
"ConversionRate": null,
"InvoiceCurrencyCode": "USD",
"SpecialInstructions": null,
"CrossReference": null,
"DocumentNumber": null,
"TransactionNumber": "2346",
"TransactionDate": "2020-11-19",
"TransactionType": "Invoice_35",
"TransactionSource": "Manual",
"BillToCustomerNumber": "CDRM_3197",
"BillToSite": "CDRM_1274",
"Comments": null,
"InternalNotes": null,
"PaymentTerms": "30/60/90",
"LegalEntityIdentifier": "USSYS12030",
"ConversionRateType": null,
"PurchaseOrder": null,
"PurchaseOrderDate": null,
"PurchaseOrderRevision": null,
"FirstPartyRegistrationNumber": "4567890",
"ThirdPartyRegistrationNumber": null,
"InvoicingRule": null,
"ShipToCustomerName": "B2CA_Customer01",
"ShipToCustomerNumber": "CDRM_68995",
"BillingDate": null,
"BusinessUnit": "Vision Operations",
"InvoiceStatus": "Incomplete",
"AccountingDate": "2020-11-19",
"ShipToSite": "CDRM_27424",
"PayingCustomerName": "B2CA_Customer01",
"PayingCustomerSite": "CDRM_1274",
"BillToCustomerName": "B2CA_Customer01",
"FreightAmount": null,
"Carrier": null,
"ShipDate": null,
"ShippingReference": null,
"BillToContact": null,
"ShipToContact": null,
"PrintOption": "Yes",
"CreatedBy": "FIN_USER1",
"CreationDate": "2020-12-21T02:55:55.001+00:00",
"LastUpdatedBy": "FIN_USER1",
"LastUpdateDate": "2020-12-21T02:56:24.374+00:00",
"PayingCustomerAccount": "CDRM_3197",
"SoldToPartyNumber": "CDRM_68995",
"RemitToAddress": "ZD, Park Avenue St",
"DefaultTaxationCountry": "US",
"EnteredAmount": null,
"InvoiceBalanceAmount": null,
"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/300100541530600",
"name": "receivablesInvoices",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000378"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600",
"name": "receivablesInvoices",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/transactionSources",
"name": "transactionSources",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/businessUnits",
"name": "businessUnits",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/PaymentTermsVA",
"name": "PaymentTermsVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/thirdPartyTaxRegistrationNumbers",
"name": "thirdPartyTaxRegistrationNumbers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/invoiceStatuses",
"name": "invoiceStatuses",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/shipToCustomers",
"name": "shipToCustomers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/billToCustomers",
"name": "billToCustomers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/legalEntities",
"name": "legalEntities",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/invoicingRules",
"name": "invoicingRules",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/billToSites",
"name": "billToSites",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/taxationCountries",
"name": "taxationCountries",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/firstPartyTaxRegistrationNumbers",
"name": "firstPartyTaxRegistrationNumbers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/lov/transactionTypes",
"name": "transactionTypes",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/child/notes",
"name": "notes",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/child/receivablesInvoiceDFF",
"name": "receivablesInvoiceDFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/child/receivablesInvoiceDistributions",
"name": "receivablesInvoiceDistributions",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/child/receivablesInvoiceGdf",
"name": "receivablesInvoiceGdf",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/child/receivablesInvoiceInstallments",
"name": "receivablesInvoiceInstallments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/child/receivablesInvoiceLines",
"name": "receivablesInvoiceLines",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100541530600/child/receivablesInvoiceTransactionDFF",
"name": "receivablesInvoiceTransactionDFF",
"kind": "collection"
}
]
}
}
]
}