Inquiring About Branch Costs

You can view branch cost updates and related cost and quantity data for a product within a branch. You can determine how average cost or landed average cost changed over time. Transactions that can affect average or landed average cost include the following:

Returns, if the Should Credit Sales Order Update Avg/Last Cost control maintenance record is set to Yes.

Received transfers.

Purchase orders.

Manual changes in Product Maintenance.

Inventory adjustments.

You must have the BR.COST.ACTIVITY.VIEW authorization key assigned to you to access the Branch Cost Inquiry screen.

To inquire about branch costs:

Access the Branch Costs Inquiry window in one of the following ways:

From the Orders > Inquiries menu, select Branch Cost Inquiry. The Branch field defaults to your home branch, and the cursor displays in the Reference column.

From the Maintenance > Product Maintenance window, enter a product, and then select Pricing > Product Price Maintenance. Then select Pricing > Branch Costs to display the Branch Costs dialog box. Then select Edit > Branch Cost Inquiry.

View or edit the following fields:

Field

Description

Branch

Your home branch, by default, or if accessing this dialog box from Product Pricing, the branch selected on the previous dialog box.

Your authorization level determines whether you can access this field.

Product

If accessing from order inquiry, enter the description of the product whose costs are displayed, otherwise the dialog box displays the description of the product you accessed in Product Maintenance.

Your authorization level determines whether you can access this field.

The list sorts in either ascending or descending order. You can change the sort order by selecting View > Change View if accessing the dialog box from order inquiry.

As Of Date

Displays the as-of date for the product. You can change this date.

Cost Type

Select between the landed average cost and average cost. The currently displayed cost type displays in the lower part of the window.

The selected cost type and settings display the next time you access the window.

Click the Update button to update the columns according to your selections.

Select the options as needed.

Column	Description
Reference	The order transaction number that affected the average cost.
Date	Date of the change to average cost.
Prev. On Hand	Quantity on hand before change.
Prev. Cost	Average cost before change.
Qty	The quantity of the item on the order that the system factored into the new average cost calculation.
Cost	The actual cost on order.
On Hand	Quantity of the product on hand after change.
On Hand Cost	Average cost of product after change.
Customer/Vendor	The customer or vendor associated with the sales or purchase order. Select View > Change View > Customer/Vendor to display this field.

To...	Select this menu option...
display the order for the selected transaction in view-only mode.	File > View Reference
display the last Branch Cost Inquiry Print report run for this item.	File > View Report
display the Product Activity Log Viewing screen for the product and branch.	File > Product Change Log
displays a product's availability and inventory information.	Inquiries > Inventory Inquiry
displays information about future commitments for the product and branch if you are fully authorized.	Inquiries > Future Ledger
displays all transactions for the product and branch if you are fully authorized.	Inquiries > Inventory History Ledger
displays the product record for the selected product.	Inquiries > Product Maintenance
toggles between the Customer/Vendor view, and the basic view.	View > Change View > Customer/Vendor or View > Change View >Basic View