The Cost of Sales Module is a Reporting module where you can see the Costs linked to any Sales Order or Work Order. This includes all the cascading costs that are linked to a transaction. eg. The costs for a Sales Order will include costs that are directly linked to the Sales Order as well as Costs that are linked to Work Orders which were created from the Sales Order.

Cost of Sales Interface

Navigation

Main Menu > Accounting > Cost of Sales > View

Main Menu > Reports > Cost of Sales > View

1. Data Filter - This allows you to filter the data displayed in the data grid by the following parameters:
   • Set - This allows you to filter the data by Date. You can move between dates by using the Arrow buttons.
   • Trans - The Transaction filter allows you to filter between Sales Orders and Work Orders.
   • Status - This allows you to filter the data by their Statuses.
   • Branch - This allows you to filter the data by a specific Branch.
2. Menu - The menu provides the following additional functionality:
   • Items View - The Items View displays, all costs linked at an Item level. Costs that are not linked to Items are also displayed here. In the Items View, the data grid is divided into four bands: Transaction, Item, Costs and Summary. The Transaction View is similar, but does not have the Item band.
   • Transaction View - The Transaction View displays, all Costs linked at a Transaction level.
   • Rebuild - This re-calculates the Cost of Sales if changes have been made to Transactions.
3. Summary - The Summary band displays the Total, Cost and Profit as well as the Gross Profit and the Markup as a percent. These are calculated as follows:
   • Gross Profit (GP %) - Profit / Total * 100;
   • Markup (MU %) - Profit / Cost * 100;

Drill-down functionality is provided by right-clicking on an Item/Transaction to open the popup menu which includes:

• Open Transaction - This will open the Transaction.
• Open Job Summary - This will open the Job Summary side-panel.
• View Linked Transactions - This will open any Transactions linked to the selected Transaction.
• View Material Summary - This will open the Material Summary side-panel. This function is only be available if Materials is liked to the selected Transaction.
• View Stock Issued - Opens a list of linked Stock Issues. This function will only be a available if Stock has been Issued.
• View Stock Returns - Opens a list of linked Stock Returns. This function will only be a available if Stock has been Returned.
• View Purchases - Opens a list of linked Purchases. This function will only be a available if a Purchase has been made.
• View Services - Opens a list of linked Timekeeping records. Services are based on Timekeeping which is linked to the Item/Transaction or to a Service Item on the linked Estimate. This function will only be a available if a service is linked to the Transaction.