Import Revenue Lines
Use the Import Revenue Lines scheduled process to transfer Accounts Receivable revenue recognition events related to shipments from inventory for sales orders. This is a prerequisite process for the Create Cost Accounting Distributions scheduled process.
Deferred cost of goods sold entries are created when the sales order issue is processed while the recognized cost of goods sold accounting entries are created in proportion to recognized revenue. Revenue lines are also linked with cost of goods sold for gross margin reporting and analytics.
When to Use
The Import Revenue Lines scheduled process is a prerequisite process which should be coordinated to complete just prior to the Create Cost Accounting Distributions process. You should schedule it to run at least once per day to ensure cost accounting is up to date with timely revenue recognition information. This process can also be run more often than once per day depending on business needs such as prior to decision points, at end of day, after peak activity in shipping and customer invoicing. You can use process sets to coordinate this scheduled process with parallel and downstream processes.
Privileges Required
- Submit COGS to Revenue Matching Process (AR_SUBMIT_COGS_TO_REVENUE_MATCHING_PROCESS)
Specifications
| Specification | Description |
|---|---|
| Job Type | Scheduled or as needed. |
| Frequency | Daily or more than once per day. |
| Time of Day | Any time. |
| Duration | Runtime of this process will vary based on the number of transactions. |
| Compatibility | There are no incompatibilities. This process is a prerequisite process and should be coordinated with the other scheduled processes that rely on this process to complete. |
Parameters
| Parameter | Optional or Required | Description | Parameter Value | Special Combinations Required | Notes |
|---|---|---|---|---|---|
| Business Unit | Required | An Accounts Receivable business unit. | Business Unit name | N/A | N/A |
| Import As-of Date | Required | If you want to control the amount of data transferred, you can enter an as-of date. Otherwise, you can enter the current date, a period end date, or a future date. If you are planning to schedule the Import Revenue Lines, schedule the job with an As-of date in the future. | Date | N/A | N/A |
| Start Date | Optional | You can enter a start date to control the volume of transactions to be processed. If you don't set the start date, then the revenue lines with accounting date between the start of the previous or current open general ledger period and the import as of date are transferred. To import revenue recognition events from prior periods, you must set the appropriate start date. | Date | N/A | N/A |
Troubleshooting Information
-
If Import Revenue Lines is unable to interface older records, run the process with an as-of-date well in the past to ensure that the job picks up older un-interfaced transactions.