Steps: Set Up Accounting for Inventory
You can set up inventory costing and accounting, accounting treatment, posting rules, and accounting options for inventory. You can view current inventory valuations and generate accounting entries with each inventory transaction. Workday derives ledger transaction records based on your worktag and account posting rule configurations.
- Edit Business ProcessesDefine theInventory Cost Adjustmentbusiness process related to inventory accounting.
- (Optional) You can change how Workday calculates transaction accounting dates based on the time zone configured at the inventory site (current period), instead of Pacific Standard Time. Access theMaintain Feature Opt-Instask.Select theOpt In To Featureoption for theSupport Inventory Site Time Zone for Inventory Accounting Datefeature.Workday recommends enabling this feature to ensure your operational transaction accounting dates are captured in the current period. If you choose not to enable this feature, this could result in transactions being recorded in past or future periods.
- Access theMaintain Worktag Usagereport.Define worktags for:
- Inventory Location: Assign worktags used in accounting entries for transactions in the inventory location.
- Inventory Issue: Assign worktags to enter on the issue transaction and for debit accounting entries on goods issued.
- Inventory Ad-Hoc Put-Away: Assign worktags to enter on the ad hoc put-away transaction and for credit accounting entries on ad hoc put-aways.
Security:Set Up: Enable Worktagsdomain in the Common Financial Management and Worktags functional areas. - Access theCreate Account Posting Rule Settask.Configure these account posting rules:
- Inventory Adjustment
- Inventory Cost Adjustment
- Inventory Markup
- Inventory Markup Expense
- Spend
Security:- Set Up: Accounting Rulesdomain in the Common Financial Management functional area.
- Set Up: Company Accountingdomain in the Common Financial Management functional area.
- Access theEdit Inventory Accounting Optionstask.Select how to account for excess variance:OptionDescriptionExcess variance is written offWhen the on-hand quantity is less than the invoice quantity, Workday only applies the price difference to the on-hand quantity, and writes off the remainder. To calculate the new average cost, Workday takes the ((Unit Cost Variancemultiplied by theQuantity On Hand) plus the (On-Hand Quantitymultiplied by theAverage Unit Cost)) divided by theOn-Hand Quantity.Excess variance is applied to current on-hand quantityTo calculate the new average cost, Workday takes the (Total Varianceplus the (On-Hand Quantitymultiplied by theAverage Unit Cost)) divided by theOn-Hand Quantity.Allow Invoice Receipt Accrual Write Off - Final Invoice and Put-away VarianceSelect this option to:
- Perform an additional check for receipt accrual variances.
- Automatically write off any remaining accrual balances to your configured account after the final invoice submission for the purchase order.
Example: Use this option to write off any remaining receipt accrual balances for purchase order (PO) lines that have a change in unit price after any quantity of items are put-away at the original cost of the PO, and an invoice is created after the entire PO is fully put-away.Use theInventory Cost Adjustmentaccount posting rule to define the general ledger account that captures receipt accrual variances during final invoice posting.Set theInventory Count Default Accounting Dateoption. Workday uses this option as the accounting date for the count sheet. Select either the adjustment date or the date that a worker starts the count (Count Start Date). When you have an open count transaction, you can't edit these settings. When you select theAllow Override of Inventory Accounting Datecheck box, Workday displays anInventory Accounting Dateprompt on inventory count sheets. You can change the accounting date for your cycle count adjustments.Select theAllow Intercompany Issuecheck box to use issue transactions to move goods between companies and track the associated transfer of cost. When you select this option, aRequester Companyprompt is configurable on theQuick Inventory Issuetask.Security:Set up: Inventory Accountingdomain in the Inventory functional area.
Workday generates inventory accounting journal entries when the inventory transaction business process completes. Workday enters accounting dates on the transaction when the journal entry posts to the ledger.
Perform inventory transactions that have an impact on accounting for inventory, such as cost adjustments, moving inventory, or issuing inventory.