CST Item Standard Cost Upload  Help

CST Item Standard Cost Upload loads or revises item standard costs in an updateable, non-frozen standard cost type, from Excel. It stages the elemental costs and runs Oracle’s standard Import Item Costs program, and can optionally run a cost rollup afterwards. It loads this-level elemental costs.

When to use it

• Load brand-new item costs into a standard, updateable cost type.
• Download current costs, amend them in Excel, and re-upload.
• Copy costs from one cost type to another.
• Mass-update resource or sub-element rates across many items.
• Trigger a cost rollup automatically after loading costs.

Before you start

• Blitz Report is installed and you are signed in to a responsibility with access to the inventory organization.
• The target cost type uses standard costing, is updateable and not frozen.
• The items are costing-enabled, and any resources, departments and operations you reference exist.

Step 1 – Set the parameters and download

In Blitz Report, open CST Item Standard Cost Upload and set the parameters:

Run the upload to download and open the Excel file.

Step 2 – Enter the costs

Each row is one elemental cost line of an item. The Organization Code, Item and Cost Element identify the line; enter the Usage Rate or Amount and, where they apply, the Sub Element (resource), Basis, and the routing Operation Seq Num and Department. The item-level controls Inventory Asset, Based on Rollup, Lot Size and Shrinkage Rate apply to the whole item.

Step 3 – Validate and Save

Click Validate and Save. This checks for missing required values and runs any extra validation the upload defines, then saves the file. Correct anything it flags before continuing.

Step 4 – Upload and view the result

Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which stages the costs and runs Oracle’s Import Item Costs program (and a cost rollup if you chose one). When it finishes, a result report opens showing each row as success or error.

What’s produced

• Item standard costs loaded into the chosen cost type, optionally rolled up.
• A result report listing every row with a status (success or error) and a message.

Common questions

Which cost types can I upload to?
Only standard-costing cost types that are updateable, not frozen and not disabled, and within your organization access.

What’s the difference between Remove and replace and Insert new cost information only?
Remove and replace overwrites the existing costs for the items being imported; Insert adds costs only where none currently exist. The default is Remove and replace.

I edited only some rows – will the unchanged ones upload?
It depends on Auto Populate Upload Columns. If Yes (the default), all downloaded rows upload; if left blank, only rows you edit upload – and for a multi-element item you must edit every element row.

Can I upload rolled-up (lower-level) costs?
No. Oracle’s interface supports this-level costs only. Use the rollup option to derive lower-level costs.

How do I roll up costs after uploading?
Set Rollup Costs? to Yes and choose the Rollup Type and Rollup Option. The rollup runs only after a successful import.

Troubleshooting