| If you are deploying Microsoft Dynamics GP as | | | | document number (where numbering schema could be |
| Corporate ERP application or older version of Great | | | | set to be distinguished for WMS documents, for |
| Plains Dynamics or eEnterprise, we would like to | | | | example have the prefix WMS in the numbering |
| discuss reports design and such questions as Barcode | | | | convention), Document Date and Customer ID. If this |
| Label printing. In earlier publications we already covered | | | | report is not covering your specific requirements, you |
| such topics as comparisons between External WMS | | | | can modify it in Dynamics GP Report Writer. In the |
| and Warehouse Management extensions for Great | | | | case when you need really custom reporting logic, this |
| Plains, so if you are in WMS software licenses | | | | report (or any one available in Reports.dic) could be |
| purchase research mode, please see earlier articles. | | | | customized in Microsoft Dexterity |
| In this publication we assume that you are on | | | | 3. Items Quantities available in each warehouse and |
| Dynamics GP WMS extensions and all the reporting is | | | | across the company. Consider Inquiry |
| based on Great Plains tables and data flow | | | | Inventory->Item Stock. If this inquiry doesn’t |
| 1. Barcode Labels. Typically you print barcode labels | | | | make your life easier, please review |
| while receiving new merchandise or restocking existing | | | | Reports->Inventory Purchase Receipts, Stock Status, |
| items. In WMS extensions for GP it is in POP | | | | Historical Stock Status |
| Purchase Receipts (exposed via WMS to barcode | | | | 4. Custom WMS reporting. Obviously here you have |
| scanning). There are several options to print labels. | | | | full control over linking various tables in Dynamics GP in |
| First one is this — consider Dynamics GP | | | | your SQL Stored Procedure or View, but these |
| ReportWriter custom report which looks at the items | | | | reports require Great Plains Programmer time. |
| received via POP Purchase Receipt with restriction by | | | | Sometimes WMS customers have EDI, ecommerce |
| dates, where you change the font to be the one | | | | integration scenarios, or when reporting should pull the |
| barcoding compliant. Second, more elegant in our | | | | data from heterogeneous DB platforms, such as |
| opinion (but probably requiring some Crystal Report | | | | Oracle, IBM DBII, MS Access, Pervasive SQL (formerly |
| designer help) is to create stored procedure with | | | | known as Btrieve), Ctree, MySQL/PHP |
| parameters (POP Purchase Receipt from/to or date | | | | 5. Great Plains Dexterity Reporting. Dexterity was |
| from/to), where you pull all the items received with | | | | the original architecture for Great Plains Dynamics, |
| quantities and Crystal Report prints labels based on | | | | introduced in earlier 1990th. Microsoft Dexterity has |
| Items ID and Quantity received. Please, note that | | | | unlimited control in Dynamics GP customizations and |
| such report is probably too difficult for Crystal Report | | | | reporting. If you tried Crystal Reports, Report Writer, |
| Wizard, and you will need SQL Stored Procedure | | | | SSRS, please review Dexterity as the last resort (or |
| — this approach (SQL procedure) is | | | | maybe natural next step) |
| recommended as it gives you more control in possible | | | | 6. How to request help? Please call us |
| future changes in Barcode Labels printing logic. | | | | 1-866-528-0577, 1-630-961-5918 or email us We are |
| Microsoft SQL Server Reporting Services should | | | | helping businesses locally in Michigan: Saint Joseph, |
| give you the results, similar to Crystal Reports | | | | Benton Harbor, Holland, Kalamazoo, Muskegon, Grand |
| 2. Order Fulfillment Report. In WMS you typically post | | | | Rapids, Ludington, South Haven, Grand Haven; Illinois: |
| Invoices allocated via barcoding on the warehouse | | | | Chicago Downtown, Naperville, Aurora, Bolingbrook, |
| floor. Consider Sales Transactions History report in | | | | Schaumburg, Downers Grove, Lisle and other areas of |
| detail (which also could include unposted documents, if | | | | Chicagoland; Southern California: Los Angeles, San |
| you think this is required). Here you can filter by | | | | Diego, Orange County; Houston Texas. |