Performing Cost Accounting

This chapter provides an overview of cost accounting and discusses how:

Click to jump to parent topicUnderstanding Cost Accounting

After you close operations or periodically, you should update accounting information. As you close operations, the system creates transactions for the operations. You can then create journal entries to capture costs as operations change the composition of wine and move costs between accounts.

When you set up the winery, you specified which accounting method, standard or operational, the winery uses. Doing so determines the basis that the system uses when creating journal entries. When you use operational costing, the system calculates the lot costs and uses them as the basis for creating journal entries. The costs of the Before lot plus the costs of the operation become the costs of the After lot. When you use standard costing, the system uses the EUR standard cost as the basis for the journal entries. For example, a 100 gallon lot of wine has 100.00 USD of operational costs and belongs to the CABSAV EUR with a standard cost of 5.00 USD per gallon. Using standard costing, the journal entries are for 500.00 USD (5.00 USD per gallon × 100 gallons). Using operational costing, the journal entries are for 100.00 USD.

Additionally, as operations remove material from the JD Edwards Blend Management system, (sale of bulk wine or bottling) and consume dry goods (additives and consumables) the system records this in the Item Ledger (F4111) and Item Location (F41021) tables. You can access the item ledger transactions by selecting Item Ledger from the Blend Advanced Operations (G31B05) menu.

See Selected JD Edwards EnterpriseOne Inventory Management Reports.

Creating journal entries is the first step of a three-tier process. This process is used throughout all of the JD Edwards EnterpriseOne programs and includes these steps:

Click to jump to parent topicEntering Lot Costs

This section provides an overview of lot costs and discusses how to enter lot costs.

Click to jump to top of pageClick to jump to parent topicUnderstanding Lot Costs

Occasionally, you might have to add or change costs of a lot of wine. For example, if overhead rates change, you can add these additional costs to a lot. You do this by adding an error administrative operation to an existing operation for the vessel. When you configure the error operation, you must select Allow Changes to Lot Costs on the Cost tab.

The system stores lot costs in the Blend Lot Costs (F31B31C) table.

Click to jump to top of pageClick to jump to parent topicForms Used to Enter Lot Costs

Form Name

FormID

Navigation

Usage

Edit Lot Costs

W31B31CA

Blend Operations (G31B03), Operation Search

Select an operation on Search for Operations and click the Edit button

Click the Instruct Lot Attributesbutton on the Edit Operation Detail form.

Select a record in the Vessel Selection area on the Instruct Lot Attributes form, and select the Lot Costs option.

Enter lot costs.

Click to jump to top of pageClick to jump to parent topicEntering Lot Costs

Access the Edit Lot Costs form.

Cost Override

Clear to indicate that this is not a cost override. The system selects this field when you change any of the fields on this form. The system does not recalculate overridden costs; however, the system does recalculate other costs each time you save the operation.

Unit Cost

Enter the unit cost.

Amount

Enter the amount.

Click to jump to parent topicEntering Global Administration Costs

This section provides an overview of global administration costs, lists prerequisites, and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Global Administration Costs

Periodically, you might have to update time-based costs for lots that are attached to vessels. For example, you might need to update costs, such as depreciation, overhead, or other expenses. You use the Global Administration program (R31B88) to add the costs to a lot or multiple lots by selecting the appropriate vessels and lot attributes. You add cost groups for these costs to the vessels and the global administration operation updates the lot costs by running the Global Administration program. The program creates a single operation for each vessel.

Click to jump to top of pageClick to jump to parent topicPrerequisites

To complete this task, you must:

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Create Admin Operations (R31B88)

These processing options control default processing for the Create Admin Operation program.

Defaults

Use these processing options to enter default information.

1. Configured Operation

Enter the name of the configured operation.

3. Instructed Start Date

Enter the starting date of the instructed operation. If you leave this processing option blank, the system uses the current date.

Click to jump to top of pageClick to jump to parent topicEntering Global Administration Costs

Select Blend Advanced Operations (G31B05), Global Admin Ops.

Click to jump to parent topicSpreading Expenses

This section provides an overview of expense spreading, lists a prerequisite, and discusses how to spread expenses.

Click to jump to top of pageClick to jump to parent topicUnderstanding Expense Spreading

Periodically, you will need to review and revise costs for the winery. For example, you might have accumulated depreciation that is not reflected in the lot costs. You can use the Inventory by Vessel View (P31B81) program to locate vessels and lots and then select the appropriate vessels and lots for which to spread expenses. You use error correction operations to spread expenses. The system creates a single operation per vessel and spreads expenses proportionately by volume. Expense spreading overrides the existing cost components to ensure that no new amounts are calculated on these cost components.

Note. It is recommended not to attach a cost group to the error operation because it would add new costs.

If you locate vessels and lots using the EUR field, the system displays costs by the portion of the cost attributed to the EUR. Costs spread by EUR are spread proportionately to the EUR volume, not lot volume.

Click to jump to top of pageClick to jump to parent topicPrerequisite

Set the Enable Expense Spreading processing option on the Defaults tab for the Inventory by Vessel View (P31B81) program.

Click to jump to top of pageClick to jump to parent topicForms Used to Spread Expenses

Form Name

FormID

Navigation

Usage

Inventory by Vessel View

W31B81B

Blend Operations (G31B03), Inventory by Vessel View

Locate a vessel using the available filters.

Review lot costs by cost component for the select vessel.

Operation/WO Template Selection

W31B78C

Select Spread Expense from the Action dropdown box on the Inventory by Vessel View form.

Create an error operation for expense spreading.

Click to jump to top of pageClick to jump to parent topicSpreading Expenses

Access the Operation/WO Template Selection form.

Specify the winery and the workflow status for the configured operation.

Configured Operation

Enter a an error correction operation based on the Error base operation. Error operations allow changes to lot costs.

Work Order Type

After you enter the configured operation code, the system displays this. You can select a work order type from the Work Order Type UDC table (31B/TW) or leave this field blank. Values are:

BAR: Barrel.

CDP: Crush Drain Press.

CLN: Cleaning.

CQA: Crush QA Additive.

ISP: Inspection.

PDR: Prod - Red Wine.

PDS: Prod - Spirits.

PDW: Prod - White Wine.

QAT: QA Test.

REC: Receipt Operations.

Start Date

Enter the instructed start date and time of the operation.

End Date

Enter the instructed end date and time of the operation.

From Vessel

For error correction operations, the system automatically displays this option as active.

Click to jump to parent topicProcessing Blend Transactions

This section provides an overview of blend transaction processing and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Blend Transaction Processing

You create journal entries, detailed or summarized, periodically to account for transactions when you close an operation. Operational transactions can include:

As you close operations, the system stores transactions in the Blend Transactions (F31B66) table. Blend automatic accounting instructions (AAIs) contain the accounts to which journal entries are written. The system creates journal entries for inventory, if the operation includes consumables or additives. To create journal entries for Before and After lot costs, you run the Blend Cost Accounting Journal Entries program (R31B802)/

If you use operational costing, the systems captures lot costs in the journal entries. When the system creates journal entries for After lot amounts, it reverses the journal entries, not the costs, of the Before lot amounts. If you use standard costing, the system multiplies the lot quantity with the EUR standard cost in the journal entries.

After you create journal entries, you must review the journal entry batch, approve the batch, and then post the batch to the general ledger. When you run the General Ledger Post program (R09801), it updates all account balances in the Account Balances table (F0902). After posting, the system provides several reports that you can use to review the posted journal entries. You can run only one post at a time. You must ensure that all post menu selections are routed to the same job queue and that the job queue allows only one job to process at a time.

Note. It is strongly recommended that you do not configure the post program. You should not change the accounts, AAIs, constants, or processing options when you run the post.

See Posting Financial Transactions.

Detail Journal Entries

You can have the system create detailed journal entries for similar accounts. You might create detail journal entries if you want a detailed audit trail. Choosing detailed journal entries can create more records when you post entries.

Summarized Journal Entries

You use summarized journal entries to summarize the cost components into a single journal entry. You can set processing options for the Blend Cost Accounting Journal Entries program to summarize all journal entries by account number. When the system creates journal entries, it summarizes the transactions and creates one entry for the batch for each account before writing them to the general ledger. The entry is the sum of all transactions for each account by document type. In summarized journal entry mode, only the net changes to the accounts are recorded. You can also set the processing options to print a summarized accounting transaction report.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Blend Cost Accounting Journal Entries (R31B802)

These processing options control default processing for the Blend Cost Accounting Journal Entries program.

Select

These processing options control the selection of transactions by date.

1. From Process Date

Enter the beginning date for the date range of the transactions that you want to include in the process. If you leave this processing option blank, the system excludes the date from the data selection.

2. Through Process Date

Enter the ending date for the date range of the transactions that you want to include in the process. If you leave this processing option blank, the system excludes the date from the data selection.

Process

These processing options control the type of processing and the processing mode.

1. Process Mode

If you leave this processing option blank, this program runs in proof mode and does not create the journal entries. Enter 1 to run in final mode and create journal entries for blend transactions.

2. Journal Entries Mode

If you leave this processing option blank, the system creates detailed journal entries. Enter 1 to summarize all journal entries by account.

Default

These processing options control default settings.

1. G/L Date

Specify the G/L date for the journal entries. If you leave this field blank, the system uses today’s date.

2. Blend Costing Document Type

Enter a user-defined code (00/DT) for the document type to use to create the journal entries if no document type is specified in the configured operations setup.

Print

These processing options control the print settings.

1. Journal Entry Report

Leave this processing option blank to print the journal entry report. Enter 1 and the system does not print the journal entry report.

2. Print Mode

Enter 1 to summarize all journal entries by account on the report. This processing option does not affect the number of journal entries that the program creates. You can summarize the journal entries on the report regardless of whether you summarize the actual journal entries.

If you leave this processing option blank, the system prints detailed journal entries.

3. Subtotal by Document Type

Enter 1 to print the subtotal by document type on the journal entry report. If you leave this processing option blank, the system does not print the subtotal by document type on the journal entry report.

Click to jump to top of pageClick to jump to parent topicCreating Journal Entries for Blend Cost Accounting

Select Blend Advanced Operations (G31B05), Blend Cost Accounting Journal Entries.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for General Ledger Post (R09801)

These processing options control default processing for the General Ledger Post program.

Print

These processing options specify which account format prints on the report and whether the report includes error messages.

1. Account Format

Specify the account format that you want to print on the General Ledger Post report.

2. Print Error Messages

Specify whether to print error messages on the General Ledger Post report. If you leave this processing option blank, the system does not print error messages, but an error message does print in the work center when an error message is detected. Enter 1 to print error messages.

Edits

This processing option specifies whether the system updates the specific fields on the transaction.

1. Update Transaction

Use this processing option to update the, Company, Fiscal Year, Period Number, Century, and Fiscal Quarter fields on unposted records in the Account Ledger table (F0911). You might need to update these fields if you have records in the Account Ledger table that were created by a custom program and may not contain the correct values in these fields.

The system uses the value in the G/L Account Number field of the unposted record in the Account Ledger table to update the Account ID and Company fields.

The system calculates the correct values for the Fiscal Year, Period Number, and Century fields using the value in the G/L date field of the unposted record in the Account Ledger table.

The system will update the Fiscal Quarter field on the unposted record in the Account Ledger table to blank.

Leave this processing option blank and the system does not edit transactions. Enter 1 to update transactions.

Click to jump to top of pageClick to jump to parent topicPosting Journal Entries to the General Ledger

Select Blend Advanced Operations (G31B05), General Ledger Post.