Press Release Forum [] Forum Index

Press Release Forum []
Free Press Release Distribution

A site of EPR Network

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Real Time Press Release Distribution is here. Try it out, it's free!


Alba Spectrum Microsoft Dynamics GP WMS Reporting

Post new topic   Reply to topic    Press Release Forum [] Forum Index -> Computers Press Releases
View previous topic :: View next topic  
Author Message
Andrew Karasev

Joined: 03 Aug 2006
Posts: 1505

PostPosted: Tue Jul 27, 2010 4:44 pm    Post subject: Alba Spectrum Microsoft Dynamics GP WMS Reporting Reply with quote

Alba Spectrum Microsoft Dynamics GP Warehouse Management System Reporting

If you are deploying Microsoft Dynamics GP as Corporate ERP application or older version of Great Plains Dynamics or eEnterprise, we would like to discuss reports design and such questions as Barcode Label printing. In earlier publications we already covered such topics as comparisons between External WMS and Warehouse Management extensions for Great Plains, so if you are in WMS software licenses purchase research mode, please see earlier articles. In this publication we assume that you are on Dynamics GP WMS extensions and all the reporting is based on Great Plains tables and data flow

1. Barcode Labels. Typically you print barcode labels while receiving new merchandise or restocking existing items. In WMS extensions for GP it is in POP Purchase Receipts (exposed via WMS to barcode scanning). There are several options to print labels. First one is this – consider Dynamics GP ReportWriter custom report which looks at the items received via POP Purchase Receipt with restriction by dates, where you change the font to be the one barcoding compliant. Second, more elegant in our opinion (but probably requiring some Crystal Report designer help) is to create stored procedure with parameters (POP Purchase Receipt from/to or date from/to), where you pull all the items received with quantities and Crystal Report prints labels based on Items ID and Quantity received. Please, note that such report is probably too difficult for Crystal Report Wizard, and you will need SQL Stored Procedure – this approach (SQL procedure) is recommended as it gives you more control in possible future changes in Barcode Labels printing logic. Microsoft SQL Server Reporting Services should give you the results, similar to Crystal Reports

2. Order Fulfillment Report. In WMS you typically post Invoices allocated via barcoding on the warehouse floor. Consider Sales Transactions History report in detail (which also could include unposted documents, if you think this is required). Here you can filter by document number (where numbering schema could be set to be distinguished for WMS documents, for example have the prefix WMS in the numbering convention), Document Date and Customer ID. If this report is not covering your specific requirements, you can modify it in Dynamics GP Report Writer. In the case when you need really custom reporting logic, this report (or any one available in Reports.dic) could be customized in Microsoft Dexterity

3. Items Quantities available in each warehouse and across the company. Consider Inquiry Inventory->Item Stock. If this inquiry doesn’t make your life easier, please review Reports->Inventory Purchase Receipts, Stock Status, Historical Stock Status

4. Custom WMS reporting. Obviously here you have full control over linking various tables in Dynamics GP in your SQL Stored Procedure or View, but these reports require Great Plains Programmer time. Sometimes WMS customers have EDI, ecommerce integration scenarios, or when reporting should pull the data from heterogeneous DB platforms, such as Oracle, IBM DBII, MS Access, Pervasive SQL (formerly known as Btrieve), Ctree, MySQL/PHP

5. Great Plains Dexterity Reporting. Dexterity was the original architecture for Great Plains Dynamics, introduced in earlier 1990th. Microsoft Dexterity has unlimited control in Dynamics GP customizations and reporting. If you tried Crystal Reports, Report Writer, SSRS, please review Dexterity as the last resort (or maybe natural next step)

6. How to request help? Please call us 1-866-528-0577, 1-630-961-5918 or email us We are helping businesses locally in Michigan: Saint Joseph, Benton Harbor, Holland, Kalamazoo, Muskegon, Grand Rapids, Ludington, South Haven, Grand Haven; Illinois: Chicago Downtown, Naperville, Aurora, Bolingbrook, Schaumburg, Downers Grove, Lisle and other areas of Chicagoland; Southern California: Los Angeles, San Diego, Orange County; Houston Texas. We are serving you USA, Canada, Mexico nationwide and this is our preferred method of service – via web sessions, short visits onsite and following remote support

Andrew Karasev, Alba Spectrum 1-866-528-0577, Informational portal Andrew is Dynamics GP Certified Master and specializes in challenging customizations, data conversions, integrations, reporting. As an announcement, Alba Spectrum is opening the location in Benton Harbor/ Saint Joseph Area of the state of Michigan, where we are welcoming Dynamics GP customers, who need second opinion, barcoding, failed implementation recovery, version upgrade, challenging data conversions
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Press Release Forum [] Forum Index -> Computers Press Releases All times are GMT - 4 Hours
Page 1 of 1

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Submit Press Release (Free)Submit Press Release


Editor's pick: