Finished Goods Analysis Report

This report shows the number of finished goods with their costs split by the components/services used in the assembled product. Use this report to analyse finished goods yield quantity, production cost, and cost of component products and services for a selected reporting period. 


By default, the report shows all finished goods that have been completed, authorized or are currently in progress. To narrow down the results, you can filter the report by either status = Authorized or status = In progress or status = Completed.


Users need the Inventory Reporting permission to access this report.


Prerequisite:


Table of Contents


Data from this report can be exported in Excel, PDF or RTF format. 


Input:

Reporting PeriodAllow user to select the reporting period from a list of options or set a custom date range
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets layout to the default layout or selected saved layout.


Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters. 


Output:

The following output fields are available for this report. You may have to open the More Fields dropdown menu to add some of them to your report. 


Fields
Assembly #
The assembly number
Completion Date
The actual completion date for Authorised tasks and expected completion date for In Progress tasks
Status
Finished Goods tas status. By default, Authorised and In Progress tasks are displayed regardless of the specified date range
Component SKU
The SKU/s of the material/s used in production
Component
The name/s of the material/s used in production
Component Unit
The unit/s of measure of the material/s used in production
Location
Location of the assembly
Component Batch #
The batch or serial number/s of the material/s used in production
Assembled Batch #
The batch or serial number of the assembly
Assembled Product
The name of the assembled product
Type
The type of component used in production, i.e. Service or Material
Assembled SKU
The SKU of the assembled product
Assembled Tags
The tags associated with the assembled product
Assembled Unit
The unit of measure for the assembled product
Assembled Category
The category of the assembled product
Assembled Brand
The brand of the assembled product
Assembled Family
The family name of the assembled product
Year
The year of the assembly completion date
Quarter
The quarter of the assembly completion date
Month
The month of the assembly completion date
Product Additional Attribute 1-10
The values of the product's additional attributes
Data Headers
Yield
The actual yield quantity of the assembled product (in multiples of SKU unit of measure).
Production Cost
The total cost, in base currency, of the assembled product, based on the quantity specified in Yield. Production Cost value is generated upon assembly completion.
Component Quantity
The total quantity of the component used in production of the assembled product
Component Cost
The total cost of the component used in production of the assembled product


FAQs

[back to top]


The average cost for a component was tracking correctly up until the FG-0193. What could have caused this abrupt change?

The reason for the component having incorrect cost on the FG-0193 is that this component was received as a result of disassembly FG-0192. DEAR distributed the cost evenly among the product lines by default. You can undo this FG after you undo FG-0193 as well and change the costs distribution manually (see Disassembly Costs). It is also possible to set these rules in the bill of materials


Can I see a unit cost on this report?

You will have to refer to the Production Cost column and divide it by the Yield. As of now, this is the only simplest method to do so. This can be raised as a feature request on our forum


This report seems to cover everything except for the expiry date. Is there a reason for this?

Unfortunately this feature is not currently available. As a workaround, you can try running 2 reports, Finished Goods Analysis Report and Lot Expiry Report, then export these to Excel and use VLOOKUP to get the information you require. This can be raised as a feature request on our forum


Is it possible to filter Finished Goods Assembly by the effective date of in Progress?  

Unfortunately this feature is not currently available. This can be raised as a feature request on our forum



Still no answer to your question? Please do not hesitate to get in touch with DEAR support.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.