The Cost of Sales module is a Reporting module where Users can see the Costs linked to any Sales Order or Work Order. This includes all the cascading costs that are linked to a transaction. E.g., 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.

Discover Cost of Sales

• Get Started
• Cost of Sales Interface

Get Started

• The Cost of Sales module is a fixed module that needs to be added to the Main Menu or/and to the Tile menu using Main Menu > Setup > Menu Manager. For more about the Menu Manager, click here.
• User Access needs to be granted to access the Cost of Sales module. Navigate to Main Menu > Setup > Settings > Users > Accounting Group > Cost of Sales Module - Access Allowed.

Cost of Sales Interface

Navigation

Main Menu > Reporting (Customisable Menu Title) > Cost of Sales > View

The Cost of Sales module's Menu button provides the following functionality:

• Reset Data Filter - This will reset all the applied data filters.
• Rebuild - This will Rebuild the Cost of Sales module to ensuring all records are current and accurate.
• Show Filter Row - This will make the Filter Row visible, allowing you to add filters to the records displayed in the data grid. See image below:

• Conditional Formatting - This allows you to add Excel-inspired Conditional Formatting parameters. The Conditional formatting is set at runtime and will persist if the grid is saved. Formatting includes colour highlights, bars and icons based on the cell value. You are able to add Conditional Formats to specific fields.
• Export/Save/Restore Grid - This allows you to export, save and restore the data grid.
• The Menu button provides the following Cost of Sales Views:
  1. Items View (see below)
  2. Transactions View
  3. Detailed Ledger View
  4. Setup View

1. Items View

The Items View displays all costs linked at an Item level. See image below:

1. Trans/Invoice Date Filter - This allows Users to explicitly select whether to filter on Trans Date or Invoice Date. If the Invoice Transaction type is not identified in the Costing Rules, the Invoice Date option is disabled.
2. Date Filter - This allows you to filter the records displayed in the data grid by date period.
3. Transaction - This allows you to filter the records displayed in the data grid by Transaction Type.
   • Sales Orders - The date selected (2) is used to filter by the Invoiced date.
   • Work Orders - The date selected (2) is used to filter by the Work Order date.
4. Status - This allows you to filter the records displayed in the data grid by Status.
5. Transaction - The Transaction band displays the basic Transaction information of the records listed in the data grid. This band displays the following fields: Transaction Type, Transaction No., Status, Date of creation, Entity, Customer, Customer Category, Job Category and Reference.
6. Item - The Item band displays the basic Item information of the records listed in the data grid. This band displays the following fields: Type, Item No., Description, Code, Category, Sub Category, Resolve and Adjustment %.
7. Qty - The Quantity band displays the Estimated Qty, Actual Qty, and Variance Qty. When filtering on Invoiced Date, the Invoiced Total is used in the Summary.
8. Costs - The Costs band displays the basic Costing information of the records listed in the data grid. This band displays the following Cost fields: Stock Issued, Stock Returned, Purchases and Services.
9. Summary - The Summary band displays the Estimated Value, Actual Value, Variance and Variance percentage. An additional Markup percentage (MU%) field can be added from the Field Chooser.
   • When the Transactions filter on Invoice Date set in the Trans/Invoice Date Filter (1), the Invoiced column is displayed in the Summary band (9), and the profit is calculated on the Invoiced amount. Unlinked Invoice Items will also display when filtering on Invoice Date. See image below:

10. By right-clicking on a record (or by clicking on the Ellipsis) will make the following additional functionality available:

• Open Transaction - This will open the selected Transaction.
• View Job Summary - This will open the Job Summary of the selected record.
• View Linked Transactions - This will open the Linked Transactions module in the side-panel displaying all the Transactions linked to the selected Transaction.
• View Items Summary - This will open the Item Summary of the selected record.
• View Stock Issued - This will open a list of linked Stock that has been Issued. This function is only available if applicable.
• View Stock Returns - This will open a list of linked Stock that has been Returned. This function is only available if applicable.
• View Purchases - This will open a list of linked Purchases. This function is only available if applicable.
• View Services - This will open a list of linked Services. This function is only available if applicable.

11. All negative values will be marked red for easy identification.

2. Transactions View

The Transactions View displays all costs linked at a Transaction level. See image below:

The Transactions View displays similar data to the Items View, however the Summary band is different. The Transactions View's 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;

3. Detailed Ledger View

This shows the Ledger Transactions along with Debit / Credit Accounts, Currencies etc, for the selected Account. See image below:

Use the Account Filter to filter the records displayed in the data grid by Account. The Account Filter's drop-down list will populate with all the Accounts created in Main Menu > Setup > Accounting > Accounts. For more about Accounting Setups, click here.

4. Setup View

The Setup View displays a list of Transaction Types linked to the Transactions that populate the Cost Types. See image below: