About Purchase Cost Analyst report
The Purchase Cost Analysis Report shows you how each transaction has impacted the landed cost. You can use this page to view and analyze how a product's landed price has changed over time. To run a report, simply select the product that you want to view and press Run. You can access the Costing Analysis report via Reports | Purchases | Costing Analysis Report.
Only Receipted/Completed orders affect the product's landed costs. You can also access this report for a product by selecting the 'Average Landed Costs' in the Price screen for a product.
Product Code: Filter used to select a specific product by code.
Description: Filter used to select a specific product by description.
Transaction Date: Filter used to display the date the transaction was made.
Product Code: Filter used to display a unique product code for a specified transaction.
Product Description: Filter used to display the product description for the specified transaction.
Transaction Type: Filter used to display the transaction type ( Purchase Order, Stock Adjustment, Assembly and Supplier Return).
Transaction Ref: Filter used to display a unique transaction reference for the specified transaction.
Transaction Qty: Filter used to display the transaction quantity for the specified transaction.
Stock On Hand: Filter used to display the stock on hand for the specified transaction.
Trans Unit Cost: Filter used to display the transaction unit costs for the specified transaction.
Pre Avg Cost: Filter used to display the pre-average costs for the specified transaction.
Post Avg Cost: Filter used to display the post average costs for the specified transaction.
In this instance, the following columns are hidden from view. However, depending on your requirements, you can customize your columns to hide or make columns available as required. You can do this by selecting SHOW TOOL BAR on the grid.
Purchase Cost Analysis: Filter used to display the purchase cost analysis for the specified transaction.
Using the custom grid
Depending on what sort of information you require, you can enter the relevant criteria and then click Run at the top on the banner.
You can also export what you see to several different formats such as pdf, xls and .xlsx using the Export button on the banner.
Using the tool bar above the grid, you can do several other things to the information shown in the grid.
These are described as follows:
- Group By Column(s):
To group by a desired column you simply need to drag and drop it into toolbar above the grid. As soon as you drop it the grid will group everything based on that column. You can group by as many columns as you like and expand all or collapse all the groups under the More menu.
- Create Multiple Views:
To set up multiple views of this report you just need to click New on the toolbar and give it a name after making any customizations. You can create as many views as you like and also choose a default which will be displayed when you first click on the report.
- Customize Columns Shown:
Using the Hidden Columns button you can choose what columns are shown on the grid and where. To add or remove a column, simply drag and drop the columns you like to and from the Hidden columns box.
Filtering your purchase costs
- Select a filter you want to use from the top of the Costing Analysis page, this could be from filters options available.
You can select from;
- Product Code: Filter used to select a specific product by code.
- Description: Filter used to select a specific product by description.
- Click Run
- Your results appear on the page.