As applied credit memos are created using a specific Credit Memo API, many of the sections and data fields do not require completion as the Oracle API ignores them; the majority of the data is derived from the original invoice being credited. This will be detailed further in the respective Invoice Header & Invoice Lines parts of this section.
All transactions including Applied Credit Memos can be uploaded on the same sheet in one upload.
All data entered in the Wizard is validated, regardless if it will be ignored by the API. This is highlighted with the use of green background shading in each validated cell. Before upload the columns revert to blue, then when the transaction is uploaded, blue shading is used again to highlight what columns have been used by the API. If the data is ignored the cell background shading will revert to blue.
The AR Invoice API Wizard worksheet is separated into Invoice Header, Header Attachments, Invoice Lines, Sales Credit Details, Distribution Lines and Line Attachment sections. To enter an Applied Credit Memo, you need to enter only the Invoice Header and Lines in the worksheet before uploading the invoices.
This Oracle API ignores Sales Credit, Distributions information and Line Description for Applied Credit Memos.
When uploading an Applied Credit Memo, the ‘Create Request API’ is called to create the Credit Request; then a Header Status of ‘Credit Request Created’ and a Credit Request ID will be returned to the sheet on successful upload. On selecting ‘Credit Status’ from the ribbon the ‘Get Request API’ is called and the Credit Request ID will be used to check the workflow process (if applicable) and the status of the credit request application will be returned to the sheet with the Invoice number (if successful).
Note - The Credit Request ID does not exist in Oracle Receivables.
