Miscellaneous Cash Receipt Creation with Multiple Distributions Using a SOAP Service

Create miscellaneous cash receipts along with distributions using the CreateMiscellaneousReceipt SOAP service. Use the service to specify a set of account combinations directly in the payload to allocate miscellaneous cash receipts to multiple accounts representing  multiple funds, fund types or departments. 

Public Sector companies use Miscellaneous Receipts to spread charges directly across different funds or departments using multiple accounting distributions determined and imported from cashier or treasury feeder systems. Commercial companies also use customer payments to directly account charges or expenses where regular O2C invoicing flow is not applicable.

Enter distribution amounts in the Payload or dynamically calculate distribution amounts using entered percentage rates.

Include Descriptive Flexfield information for distribution lines to reflect company internal attributes to reconcile related funds, departments or cost centers.

Sample Payload with Multiple Distributions

Business Benefits include:

• Reduced accounting process for receipts imported from feeder systems using the SOAP service with multiple accounting distributions.
• Shorten reconciliation and audit process when integrating with cashier and treasury feeder systems.
• Automate Miscellaneous Receipts creation with distributions across different funds, departments or cost types represented by multiple charge accounts.
• Speed up liquidation positioning where funds under Budget Cash Control are actualized using daily miscellaneous receipts with dynamically calculated multiple distribution amounts.
• Improve efficiency by eliminating the time-consuming activities to manually update distribution account combinations for Miscellaneous Cash Receipts created using the SOAP Service.
• Automate processing of bank statement reconciliation with Miscellaneous Cash receipts including charges across multiple departments or cost types.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

• Receipt Currency Code must be a valid Currency with the effective conversion rate to the ledger currency.
• Accounting Date must be within an open or future enabled period.
• Receipt method must be valid for the Business Unit.
• All segment values must pass value set security policies.
• Percentage across all distributions must equal 100% and MiscCashDistributions Amounts must equal the receipt total amount.
• All distributions must have a valid accounting code combination and must not be null.
• Receivable Activity must have the GL Account or Value Set defined when <MiscellaneousReceiptDistributionsService> section is empty.
• For distribution amounts without percentages assigned, percentage will be calculated accordingly based on entered amounts and receipt total amount.
• Duplicate Receipt Numbers are not allowed.
• Mixed Percentages and amount in the distributions are not supported. If percentages are provided, then distribution amounts will be calculated accordingly.
• When payload file does not contain Tax details then Receivable Activity Setup must include Tax Rate code, Tax Rate and Amount configured.
• Valid Cost Center must be entered in the payload.
• Delimiter must be correctly passed in the payload, for example when "-" is changed to a dot, 01.000.1110.0000.000 then miscellaneous receipt will not be created due to account structure.violation.
• Recommended maximum number of distributions per single receipt is 500.

Key Resources

• Review the Receivables Miscellaneous Receipt  SOAP Web Service definition in the SOAP Web Services for Financials document.
• Based on Ideas 68851, 533013, 610089 from the Receivables and Collections Idea Lab on Oracle Cloud Customer Connect.

Access Requirements

No additional security access or roles are required to run the CreateMiscellaneousReceipt SOAP service and enter Miscellaneous Receipt distributions manually.

See SOAP Web Services for Financials for details.