COGS-Projects
This reports on Inventory costs by GL Account Number, Inventory Code and Part Types. It can be filtered by Date Range, and in the Advanced Criteria by Inventory Code, and Part Type. Per GL Account it sums the Standard, Current and Average Costs, then breaks down the GL Account according to Inventory Code, Part Type, Item Numbers with their Actual Quantities and Costs.
Here is a screenshot example of this report:
COGS-SalesOrderShipping
This reports on Sales Order Shipping Totals by GLAcctNums, with BOM Breakdowns. This reports on the costs for what you've shipped. Per GL Account, it gives you Standard, Current, and Average Costs, and Cost totals per BOM Item and the component breakdown. It also shows the SO# (Sales Order), PS# (Project Phase) and Inv# (Invoice) source of the shippings. This report can be further filtered by Date Range, and in the Advanced Selection Criteria by Customer, Part Number, and Sales Order number.
Here is a screenshot example of this report:
COGS-SalesOrderShipping Parts <Top>
This reports on Sales Order Shipping Totals by GLAcctNum without BOM Breakdowns. This reports on the Cost breakdowns for what you've shipped. Per GL Account, it gives you Standard, Current, and Average Costs, and Cost totals per top level Item. It also shows the SO# (Sales Order), PS# (Project Phase) and Inv# (Invoice) source of the shippings. This report can be further filtered by Date Range, and in the Advanced Selection Criteria by Customer, Part Number, and Sales Order number.
Here is a screenshot example of this report:
Current Inventory Avg Cost
Current Inventory Cost/Value by Avg Cost in Partmaster sorted by Inventory Code. You can go to the Advanced Selection Screen to filter this report by Stock Items (Yes or No), Inventory Code, Cycle Count, and Inventory Location. The report lists the Inventory Code first with its description, then gives you the InternalPart#, the UOM, Cost, Part Type, Inventory Quantity and Total Cost of that Inventory.
Note: This Costed Current Inventory Report will differ from the Costed Inventory History Report in Total Average Cost because it accounts for WIP.
Here is a screenshot example of this report:
Current Inventory Current Cost <Top>
Current Inventory Cost/Value by Current Cost in Partmaster sorted by Inventory Code. You can go to the Advanced Selection Screen to filter this report by Stock Items (Yes or No), Inventory Code, Cycle Count, and Inventory Location. The report lists the Inventory Code first with its description, then gives you the InternalPart#, the UOM, Cost, Part Type, Inventory Quantity and Total Current Cost of that Inventory.
Note: This Costed Current Inventory Report will differ from the Costed Inventory History Report in Total Current Cost because it accounts for WIP.
Here is a screenshot example of this report:
Current Inventory Std Cost <Top>
Current Inventory Cost/Value by Standard Cost in Partmaster sorted by Inventory Code. You can go to the Advanced Selection Screen to filter this report by Stock Items (Yes or No), Inventory Code, Cycle Count, and Inventory Location. The report lists the Inventory Code first with its description, then gives you the InternalPart#, the UOM, Cost, Part Type, Inventory Quantity and Total Standard Cost of that Inventory.
Note: This Costed Current Inventory Report will differ from the Costed Inventory History Report in Total Standard Cost because it accounts for WIP.
Here is a screenshot example of this report:
Current Inventory Below Safety Stock <Top>
This report serves to reveal any Items in Inventory that are Below their Safety Stock levels. Safety Stock is based on the Item Safety Stock entries in the ItemMaster. It breaks down by Inventory Code then Priority Vendor. Then it lists the Item Numbers, with the Unit of Measure, Part Type, Inventory Location, Safety Stock Quantity and Current Iventory Quantity for each Item. The can be further filtered in the Advanced Criteria by Inventory Code, Part Type, Inventory Location, Item Number, and Product Code.
Update: This report now breaks down by Priority Vendor within the Inventory Code breakdown. This is to help when purchasing your stock items.
Here is a screenshot example of this report:
Current Inventory Qty <Top>
Current Inventory without Cost/Value sorted by Inventory Code. You can go to the Advanced Selection Screen to filter this report by Stock Items (Yes or No), Inventory Code, Cycle Count, and Inventory Location. The report lists the Inventory Code first with its description, then gives you the InternalPart#, the UOM, Cost, Part Type, and Inventory Quantity.
Here is a screenshot example of this report:
Inventory History <Top>
Inventory History of Transactions. You can filter this report by Date Ranges, and go to the Advanced Selection Screen to filter by Stock Items (Yes or No), Product Code, Inventory Code, Internal Part Number, and Inventory Location. The report lists the Internal Part Number first with its description, then shows the transaction dates, the quantity, running quantity, the source of the transactions, and the transaction details.
Here is a screenshot example of this report:
Inventory History Costed <Top>
Inventory History of Transactions with Std/Avg/Current Cost Values. You can filter this report by Date Ranges, and go to the Advanced Selection Screen to filter by Stock Items (Yes or No), Product Code, Inventory Code, Internal Part Number, and Inventory Location. The report lists the Internal Part Number first with its description, then shows the transaction dates, the quantity, running quantity, the source of the transactions, and the transaction details. The costs are given in unit cost and total cost for all units in inventory.
Note: This Costed Inventory History Report will differ from the Costed Current Inventory Reports (Avg, Current, Std) in total costs because it does not account for WIP.
Here is a screenshot example of this report:
Parts by Primary Vendor <Top>
This report serves as a way to group your parts by Primary Vendor. It breaks down first by the Vendor (Vendor ID and Name), then Inventory Code , and then Item Numbers. For the item, it lists the Unit of Measure, Part Type, and Safety Stock Quantity. Then it provides a New Price box. This report can be used to obtain new pricing for parts from your vendors. Then you could fax a vendor a list of all that vendors parts that you keep in stock. The report can be further filtered in the Advanced Criteria by Inventory Code, Part Type, Inventory Location, Item Number, and Product Code.
Here is a screenshot example of this report:
Physical Inventory Worksheet <Top>
Worksheet for Physical Inventory. You can filter this report by Stock Items (Yes or No), Inventory Code, and Cycle Count Code. The report lists the Inventory Code first, with its description, then lists the Inventory items by part#, unit, type, and Qty. The quantity field is boxed so you can write in your physical quantities, which can then be used to update you inventory in the system via the Physical Inventory Manager.
Here is a screenshot example of this report:
Receiving History <Top>
This is the uncosted Receiving Details History Report. It breaks down your receivings first by Product Code, then by Part Number and Receiving Date. It gives you a total cost for items in Inventory with that Product Code. Then it lists the Part#'s with Date, Quantity Received, PO# and Notes. You can further filter this report by Stock Items (Yes or No), Product Codes, Inventory Codes, and/or Internal Part#'s.
Here is a screenshot example of this report:
Receiving History Costed <Top>
Receiving Details History with Cost. You can filter this report by Stock Items (Yes or No), Product Code, Inventory Code, and/or Internal Part#. It will report by Product Code first with it's description, then list the Part # with Date, Quantity Received, PO#, Notes, then Price information. It gives you the price you paid per unit, and the line total.
Here is a screenshot example of this report:
Receiving Performance <Top>
Receiving Details History with Cost. You can filter this report by Stock Items (Yes or No), Product Code, Inventory Code, Internal Part# and/or Vendor. By default it lists Vendors alphabetically, reporting the Vendors Avg Late delivery, then Part#'s for the Vendor and the PO history for that Vendor with Costing information.
Here is a screenshot example of this report:
WIP Inventory-Costed
Inventory History of Transactions with Std/Avg/Current Cost Values. This report requires that WIP Start and End Stages be set first in the Preferences. Once you have set up these WIP stages, this report can be used to show you WIP Inventory based on Production Work Orders, and Project Department production. The report shows you Standard, Current and Average Costs on all WIP Inventory at the top. It breaks down each Inventory WIP Item showing the total WIP Inventory Quantity and Costs for the item, then quantities per the (Source) Work Orders and Project Phases associated with the WIP Item. When the source is Production Work Orders, the Work Order Lot number will be in the Source Details. When the source is a Project, the Project Phase Number will be in the source details. This report can be filtered by Date Range, and in the Advanced Criteria by Stock Items (Yes or No), Product Code, Inventory Code, Item Number, and/or Inventory Location.
Here is a screenshot example of this report:
Note: Whenever you run a report, if you get an error, check the criteria for that report. Locate the criteria that is always listed at the top of the report you are looking at. Then go back and make sure there are entries in the data for all that criteria. Here is an example of the Listed Criteria for a Report (The criteria's here are JobPhase, Dept, Started, Complete, and Production Started):
