The WMS provides a standard set of reports that assist with Stock Management and Inventory Tracking. The WMS enhances the existing MYOB Item Inventory reports by providing additional detail on location, batch, serial numbers and expiry dates. Each report has a filters dialog which allows you to narrow the scope of the data being reported on or adjust row sorts and ordering.
There are three report groups; General, Stock, and Sales Reports. Each group and its reports are detailed in the following sections.
The general reports group provides overall summary information pertaining to your warehouse management operations.
The following General reports are provided;
Purpose: This report shows total stock count by location and bin.
Filters: All locations or just a single location can be selected for review. There is also a checkbox to Show Bins with zero quantities.
Uses: To obtain a summary stock list by location without the Batch/Serial/Lot number details. Good for managing Bin Names and organising capacity/stock distribution.
Reports can be created as PDF or HTML, a reports archive/audit trail is kept by the system. Browse to the Reports folder to see all transactions recorded.
Other General Reports:
Report Name | Purpose
Managers Report | Lists daily Sales and Warehouse activity.
APPLIES TO: Warehouse Management System - Professional and Enterprise
DESCRIPTION: This Document explains how to run the Sales Reconciliation Report and Reconcile your Sales between WMS and MYOB
1. From the reports menu, select “Sales” then “Reconciliation” The report criteria form will appear.
2. Select the Dates range you wish to check. The earliest date range you should select is your “Go Live” date.
3. Select your Match Date on: Setting. This setting is determined by the setting in your Preferences under the Replication Tab “Use Shipped Date on Invoice” when ticked the Ship date is sent as the invoice date, if unticked the Order date will be sent.
4. Select the “Show” option. MYOB Invoices Not reconciled with WMS Sales or WMS Sales Not Reconciled with MYOB Invoices (Both should be run to ensure all sales are checked).
5. You can then choose to hide matching invoices (the preferred option) or show them.
6. You can also choose whether to show/hide negative sales.
7. Select generate report. Report time may vary due to amount of sales and date range, please wait up to 1 minute.
Analysing the Reports
The report shows a list of Invoices without a match in either MYOB or WMS, Invoices where the totals differ and invoices that have duplicates.
Missing transactions are highlighted in the “Match Found” Column, Differences in totals are highlighted in the “Totals Match” column and duplicates are highlighted by listing the duplicate invoices.
Invoices that show on the report should be viewed in MYOB and WMS and investigated and corrected.
Rerunning the reports after correcting the invoices should result in blank reports.
If you use MYOB to invoice out service or professional sales, these will be ignored.
The stock reports group provides both summary and detailed information typically required to manage stock particulars and facilitate better inventory control.
For example print the Stock History Report, this report details stock movement over time. Select Reports, Stock, History.
You must first select appropriate filters as per this example. The following report is then displayed.
The following Stock reports are provided;
Name: Stock List
Purpose: This report shows Stock detail by Batch Serial Numbers, Expiry Dates, grouped by Location and Bin.
Filters: All locations or just a single location can be selected for review. Other filters include Flags, Item Number as partial search and Bin.
Uses: To obtain a detailed stock list by location with Batch/Serial/Lot number and Flag details. This report is primarily used to show stock available in a particular location/bin and to assist with stock transfers. It can also be used as a workflow tool to list stock by flag, identifying items that may require actions to be undertaken or initiated.
Using PDF Reader reports can be MARKED UP using highlighting tools available within the Adobe Acrobat product or have electronic sticky notes attached. The final report can be either saved or DIRECTLY emailed from the WMS.
Purpose: This report shows Stock Cost Details by Batch Serial Numbers grouped by Item then Location and Bin. You can choose the valuation method based on your typical accounting processes, this includes; MYOB Based Last Cost, Average Cost, FIFO, LIFO stock costing.
Filters: All locations or just a single location can be selected for review. Other filters include Item Number as partial search and Bin.
Uses: To obtain a warehouse valuation by location and by item. This report can be used when valuing stock for End-Of-Financial year accounting processes.
It is recommended that before producing reports a Normal or Maintenance REPLICATION be undertaken to ensure inventory data is up-to-date with your accounting system.
Name: Stock History
Purpose: This report shows every stock movement action for each item over time and is a critical report for tracing stock origins and identifying stock handling history.
Filters: All locations or just a single location can be selected for review. Other filters include Item Number as partial search and activity date ranges.
Uses: To identify the handling of a particular stock batch or serial number from receiving to despatch. This report is primarily used to show stock level changes by item, location, bin. It can also be used as a workflow tool to track stock movement delays between locations or as an audit trail to review stock quantity adjustments and changes made to batch serial numbers, or expiry dates.
Name: Stock Count
Purpose: This report shows each stock batch quantity and serialised items by location and bin. It has a first and second count space provided for manual auditing.
Filters: All locations or just a single location can be selected for review. Group and filter by Bin and optionally mask the actual quantities to force recounts.
Other filters include Item Number as partial search and sorting of stock by ascending or descending Alphabetical order.
Uses: To provide a count sheet and reconcile actual stock quantity with current WMS quantities. This report is primarily used to facilitate stock takes. Stock Adjustments can be grouped and sorted using the same fields as the Count report reducing data entry error.
Example: This example shows a count sheet for item 120 only.
Name: Stock Reconciliation
Purpose: This report shows the total count for each item as compared with MYOB item inventory count and reports any differences.
Filters: All items or an item number can be selected for review. It is also possible to show location and batch serial details to assist in identifying possible discrepancy sources.
Uses: This report is typically used in conjunction with the stock count report. Once a stock count is completed and the necessary adjustments made to the WMS a stock reconciliation report details the adjustments needed to be made to your MYOB Companyfile. Another approach is to run the reconciliation report first and make whatever adjustments are necessary in MYOB, then conduct a full stock count and synchronise any new adjustments directly from the WMS to MYOB.
Name: Stock Turn
Purpose: This report provides an estimate of how long (in days) it will take your inventory on hand to completely sell through given current selling rate.
Filters: All locations or just a single location can be selected for review. Other filters include Item Number as partial search and activity date range required monthly.
Uses: This report can be used to manage purchasing and avoid potential stock outs or to fine tune sales strategies in order to move slow turning stock.
To understanding the stock turn report you must appreciate how the ratio is calculated. The stock turn days and ratio ONLY APPLIES to the stock received and sold for the date range selected. It does not take into account existing stock on hand.
In this example item 300 for the period selected sold 3 units but 8 were received, on this basis it will take approximately 80 days to turn the received stock.
On the basis of this example re-ordering could wait for sometime.
Name: Special Pricing
Purpose: This report shows all special pricing schedules active in the WMS Sales module.
Filters: All items or an item number can be selected for review. It is also possible to limit by customer.
Uses: This report is used to verify current pricing agreements for key customers. Special Pricing Schedules are created and maintained in MYOB as Item Sale Quotes.
Other Stock Reports:
Report Name | Purpose
Putaway Report | List all items and associated default Put-away bins.
A simple guide on how to use Stock History to look up transaction details.
If you need to track information regarding an Item or all Items, you can use the Stock History. Using Stock History, you can track all the movement of an Item, such as how much you have received in a period of time and how much you have sent out.
Stock History is accessible from any Register, so it does not matter what Register you are currently in. To access Stock History, you can either click on Tools > Stock History, or press Ctrl+H. This will bring up the Stock History window.
To see all the transactions involving a specific Item, type in the exact Item Number inside the Item Number box and press Enter. All the transactions involving the Item within the set date range will then be shown. If you want to see all transactions within a certain date range, regardless of the Item, leave the Item Number box blank.
You can filter the Stock History based on Serial Number. Type in a serial number and press Enter, and all transactions involving any Item with matching Serial Number within the set date range will be shown. The serial number doesn’t need to be an exact match. For example, simply typing in ‘2005’ inside the Batch Serial box and typing Enter will bring up all transactions involving any Item where its serial number contains the keyword ‘2005’.
You can also filter stock history based on Location. This can be used, for example, if you want to see only transactions made in Perth. Simply expand the drop-down box and select the desired Location. The result shown below will show only transactions made from the selected Location within the set date range.
You can combine the filters explained above to get more specific result. For example, to find transactions involving an Item with a specific Serial Number from a certain Location, within the set date range.
You can also drill into the transactions itself. Simply double-click on one of the listed transactions and it will bring up the related form.
Furthermore, you can also filter the result by the type of transactions. Simply click on one of the tabs shown below. For example, to show only Transfers, click on the Transfer tab.
You can also select a result and select “Print Labels…” to print a barcode of the appropriate Item. How to print barcodes will be explained in its own document.
If you want to print a report of the search result you see on the screen, simply click on “Display Stock History Report” and it will bring up a report you can simply save or print.
Reference : DPL-0229
How to use Stock List Report.
If you want to have a report listing your stock, you can use the Stock List Report. To bring up the Stock List Report, select Reports > Stock > Stock list from the Menu.
Once the Stock List Report form is opened, there will be filters you can set to show only specific Items. If you only want to have a report of all the Items in your Inventory, simply click on Generate Report.
A Summary report will only show the total number of Item in each Location, plus the total quantity on hold.
A Detiled report will show a breakdown of the Items in your Inventory, listing the Serial Numbers in each Location, Expiry Date and Received Date.
You can filter the Report to only show you Items located in a specific Location. To do this, simply expand the Location drop-down box and select the desired Location, then select Generate Report.
You can filter the Report to only show you a specific Item, by typing in the exact Item Number, then select Generate Report.
You can alternatively show only Items that have been flagged. To do this, simply expand the Flag drop-down box and select the desired Flag, then select Generate Report.
You can also opt to only show Items that reside in a certain Bin. To enable this function, you MUST select a Location. Afterwards the Bin drop-down box will be selectable, and it will contain Bins that exist in the selected Location. Select Generate Report to get the relevant report.
You can also choose to sort the report using different criteria other than Item Number.
Simply expand the Order By drop-down box and select the desired criteria, and select whether it is to be sorted in ascending or descending order.
Select Generate Report, and the resulting report will be ordered accordingly.
Optionally, you can also show the Item’s barcode on the report. To do this, check the Show Product Barcode checkbox and click on Generate Report. The barcode will be displayed underneath the Item Description.
The filters above can be combined to get a more specific result. For example, you can filter the report to only show you Items inside a specific bin in particular location.
Reference : DPL-0232
The sales reports group provides summary and detailed information regarding customer orders, sales performance, and order fulfilment status.
Example: Sales Summary
Report Name | Purpose
Sales Summary | List all items and associated default Put-away bins.
Commission Report | Sales by Sales people and related Sales/Commission margins.
Back Order | Orders and items on Back Order.
Shipping List | Orders that have been processed and related status.
Many of the Sales reports include a Gross Profit Value, the calculation of Gross Profit is explained Below.
TITLE: BOM and KIT Reports from MYOB
APPLIES TO: Warehouse Management System Installations - ENTERPRISE
KEYWORDS: WMS, KITS, BOM, Bill Of Materials, Assemblies, Reports
The following support note describes the steps required to report on all active Bill-Of-Materials in MYOB as Purchase Quotes.
It is important that ONLY ONE active Purchase Quote (BOM) is present in your MYOB Companyfile at one time. The following procedure can be used to identify more than one Bill-Of-Materials for a single Item.
To create a report on Bill-Of-Materials / KIT Report…
Step 1: Open the MYOB Companyfile and choose the Reports Menu Item. Choose Purchases and Quotes from the Purchase Register.
Step 2: Choose Customise. Set a wide date range (as shown below). To limit the BOM or KIT items shown on the report enter the ITEM NUMBER in the Supplier Inv.# field. You can also select the supplier as the LOCATION CARD to limit the transactions displayed.
Step 3: Click Display. To Drill-Down into a Bill-Of-Materials use the mouse to hover over the BOM or Kit line and when the Magnifying Glass icon appears left click to open the Purchase Quote transaction. Step 4: Modify or Delete the Quote and click the Redisplay button to update the onscreen report. Step 5: Use a Maintenance Replication to ensure all changes to Bill-Of-Materials is updated or removed from your WMS Workspace.