warehouse management integration - blue moon...

Blue Moon IndustriesWarehouse Management Integration

for Microsoft Dynamics GPAccellos WMS

Release 10.0

Copyright Manual copyright © 2009 Blue Moon Industries. All rights reserved.

Your right to copy this documentation is limited by copyright law and the terms of the software license agreement. As the software licensee, you may make a reasonable number of copies or printouts for your own use. Making unauthorized copies, adaptations, compilations, or derivative works for commercial distribution is prohibited and constitutes a punishable violation of the law.

Trademarks Warehouse Management Integration is a trademark of Blue Moon Industries.

Microsoft and Microsoft Dynamics GP are either registered trademarks or trademarks of Microsoft Corporation or its affiliates in the United States and/or other countries.

The names of actual companies and products mentioned herein may be trademarks or registered marks - in the United States and/or other countries - of their respective owners.

The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred.

Warranty disclaimer Blue Moon Industries disclaims any warranty regarding the sample code contained in this documentation, including the warranties of merchantability and fitness for a particular purpose.

Limitation of liability The content of this manual is furnished for informational use only, is subject to change without notice, and should not be construed as a commitment by Blue Moon Industries. Blue Moon Industries assumes no responsibility or liability for any errors or inaccuracies that may appear in this manual. Neither Blue Moon Industries nor anyone else who has been involved in the creation, production or delivery of this documentation shall be liable for any indirect, incidental, special, exemplary or consequential damages, including but not limited to any loss of anticipated profit or benefits, resulting from the use of this documentation or sample code.

License agreement Use of this product is covered by a license agreement provided with the software product. If you have any questions, please call Blue Moon Industries at 401.276.9000.

Publication date February 11, 2009

W A R E H O U S E M A N A G E M E N T I N T E G R A T I O N i

C O N T E N T S

ContentsIntroduction .......................................................................................................................................................... 1

What’s in this manual ........................................................................................................................................... 1

Prerequisites.......................................................................................................................................................... 1

Symbols and conventions ..................................................................................................................................... 1

Part 1: Installation & Setup ........................................................................................................................4

Chapter 1: Installation .................................................................................................................................... 5Compatibility notes .............................................................................................................................................. 5

System requirements............................................................................................................................................. 5

Installation checklist........................................................................................................................................... 13

About the installation process ............................................................................................................................ 13

Installing Warehouse Management Integration................................................................................................. 14

Enabling security to Warehouse Management Integration resources ............................................................... 17

Registering Warehouse Management Integration.............................................................................................. 19

Uninstalling Warehouse Management Integration ............................................................................................ 20

Chapter 2: Back-Office setup ................................................................................................................... 23Setting up inventory and general options .......................................................................................................... 23

Setting up module-specific options.................................................................................................................... 27

Activating the Upload Processor ........................................................................................................................ 28

Using synchronization utilities........................................................................................................................... 29

Ensuring Microsoft Dynamics GP posting setup compatibility........................................................................ 30

Part 2: Sales........................................................................................................................................................... 34

Chapter 3: Sales setup .................................................................................................................................. 35About managed sales document types............................................................................................................... 35

Setting up sales options ...................................................................................................................................... 35

Chapter 4: Sales document release ....................................................................................................... 39Release status ...................................................................................................................................................... 39

Releasing sales documents to the WMS ............................................................................................................. 40

Recalling sales documents from the WMS......................................................................................................... 41

Viewing the release status of sales documents ................................................................................................... 42

Fulfillment indicators ......................................................................................................................................... 43

Hold indicators ................................................................................................................................................... 43

Sales document entry and release process ......................................................................................................... 43

Sales document entry and release process illustration....................................................................................... 46

Chapter 5: Fulfillment options................................................................................................................. 47Entering fulfillment options ............................................................................................................................... 47

Setting up default fulfillment options for customers ......................................................................................... 47

Setting up default fulfillment options for customer addresses .......................................................................... 49

Entering fulfillment options for orders .............................................................................................................. 50

Viewing fulfillment options for orders ............................................................................................................... 52

ii W A R E H O U S E M A N A G E M E N T I N T E G R A T I O N

C O N T E N T S

Chapter 6: Fulfillment instructions ....................................................................................................... 55About fulfillment instructions ............................................................................................................................ 55

Setting up default fulfillment instructions for customers .................................................................................. 55

Entering fulfillment instructions for orders ....................................................................................................... 57

Viewing fulfillment instructions for orders........................................................................................................ 58

Chapter 7: Store names and EDI information ................................................................................. 61About store names .............................................................................................................................................. 61

Setting up store names ........................................................................................................................................ 61

Assigning store numbers and EDI information to items on sales documents................................................... 62

Viewing store numbers and EDI information .................................................................................................... 64

Chapter 8: Bill To - Ship To Notes.......................................................................................................... 67About Bill To - Ship To Notes.............................................................................................................................. 67

Setting up default Bill To - Ship To Notes for customer addresses ..................................................................... 67

Entering Bill To - Ship To Notes for orders......................................................................................................... 68

Viewing Bill To - Ship To Notes for orders ......................................................................................................... 70

Chapter 9: Price label information........................................................................................................ 73About price label information ............................................................................................................................ 73

Entering price label information for items for specific customers ..................................................................... 73

Entering price label information for items for specific customer stores ............................................................ 74

Chapter 10: Picking information ............................................................................................................ 75About picking information................................................................................................................................. 75

Entering default picking information for items for specific customers ............................................................. 75

Entering picking instructions for a line item during order entry ...................................................................... 76

Viewing picking instructions for line items........................................................................................................ 77

Chapter 11: Shipment tracking................................................................................................................ 81Viewing track & trace information for items and shipments............................................................................. 81

Viewing tracking information for a shipment.................................................................................................... 82

Tracking shipments related to a PRO number.................................................................................................... 83

Chapter 12: Work area................................................................................................................................. 85Setting up work areas.......................................................................................................................................... 85

Viewing work area information.......................................................................................................................... 85

Entering work areas and assembly notes during order entry............................................................................. 86

Viewing work areas and assembly instructions for orders................................................................................. 87

Chapter 13: Sales document release synchronization utility ................................................. 89About the sales document release synchronization utility................................................................................. 89

Applying document management settings to existing SOP documents............................................................ 89

Chapter 14: Sales Report Writer extensions .................................................................................... 91About the Report Writer extensions ................................................................................................................... 91

Using the Report Writer extensions.................................................................................................................... 91

Part 3: Purchasing ........................................................................................................................................... 94

Chapter 15: Purchasing setup................................................................................................................... 95

W A R E H O U S E M A N A G E M E N T I N T E G R A T I O N iii

C O N T E N T S

Setting up purchasing options............................................................................................................................ 95

Chapter 16: Purchasing document release ....................................................................................... 99Release status ...................................................................................................................................................... 99

Releasing purchasing documents to the WMS ................................................................................................ 100

Recalling purchasing documents from the WMS ............................................................................................ 101

Viewing the release status of purchasing documents....................................................................................... 102

Purchasing data flow......................................................................................................................................... 102

Chapter 17: Receiving and put away instructions ......................................................................105About receiving and put away instructions...................................................................................................... 105

Setting up default receiving instructions.......................................................................................................... 105

Entering receiving and put away instructions during PO entry ...................................................................... 106

Viewing receiving and put away instructions for purchase orders .................................................................. 108

Chapter 18: Purchasing document release synchronization utility ..................................111About the purchasing document release synchronization utility.................................................................... 111

Applying document management settings to existing POP documents ......................................................... 111

Part 4: Inventory............................................................................................................................................ 114

Chapter 19: Kits .............................................................................................................................................115Enabling the alternate window ......................................................................................................................... 115

Assigning kit components ................................................................................................................................ 116

Chapter 20: Assembly transactions.....................................................................................................119About assembly transactions............................................................................................................................ 119

Entering an assembly transaction .................................................................................................................... 119

Releasing work orders to the WMS .................................................................................................................. 120

Viewing the release status of work orders ........................................................................................................ 120

Chapter 21: Additional inventory information.............................................................................123Setting up hazmat categories ............................................................................................................................ 123

Entering additional inventory information...................................................................................................... 124

Entering vendor item options........................................................................................................................... 125

Chapter 22: Reason Codes.......................................................................................................................127About reason codes .......................................................................................................................................... 127

Setting up reason codes .................................................................................................................................... 127

Chapter 23: Inventory utilities...............................................................................................................129Item master synchronization utility ................................................................................................................. 129

Product code conversion utility ....................................................................................................................... 130

Stock count processor utility ............................................................................................................................ 131

Part 5: Field Service.................................................................................................................................... 136

Chapter 24: Field Service setup ............................................................................................................137Setting up field service options ........................................................................................................................ 137

Chapter 25: RTV transactions ................................................................................................................139

iv W A R E H O U S E M A N A G E M E N T I N T E G R A T I O N

C O N T E N T S

RTV types and the warehouse system .............................................................................................................. 139

Chapter 26: RMA transactions.............................................................................................................. 143RMA receiving process overview ..................................................................................................................... 143

Chapter 27: Field Service document release ................................................................................ 147Release status..................................................................................................................................................... 147

Releasing RMA documents to the WMS.......................................................................................................... 148

Recalling RMA documents from the WMS ..................................................................................................... 149

Viewing the release status of RMA documents ................................................................................................ 150

Field service data flow....................................................................................................................................... 150

Part 6: Manufacturing ..............................................................................................................................154

Chapter 28: Manufacturing setup ....................................................................................................... 155Setting up the modified window ...................................................................................................................... 155

Setting up manufacturing options.................................................................................................................... 156

Chapter 29: Manufacturing document release ............................................................................ 159Release status..................................................................................................................................................... 159

Releasing manufacturing documents to the WMS .......................................................................................... 159

Recalling manufacturing documents from the WMS ...................................................................................... 160

Viewing the release status of manufacturing documents................................................................................. 161

Chapter 30: Fulfillment instructions.................................................................................................. 163About fulfillment instructions .......................................................................................................................... 163

Entering fulfillment instructions for manufacturing orders ............................................................................ 163

Viewing fulfillment instructions for manufacturing orders............................................................................. 164

Chapter 31: Manufacturing document release synchronization utility ......................... 165About the manufacturing document release synchronization utility.............................................................. 165

Applying document management settings to existing manufacturing documents......................................... 165

Part 7: System...................................................................................................................................................168

Chapter 32: Processing log utility ....................................................................................................... 169About the processing log .................................................................................................................................. 169

Viewing and maintaining the processing log ................................................................................................... 169

Chapter 33: Errors........................................................................................................................................ 171General error codes........................................................................................................................................... 171

SOP errors ......................................................................................................................................................... 172

POP errors......................................................................................................................................................... 176

Inventory errors ................................................................................................................................................ 177

Manufacturing errors........................................................................................................................................ 179

Appendix A: Data tables........................................................................................................................... 181

Appendix B: Accellos WMS quick reference ................................................................................ 185Cycle Count and Stock Count Calculations ..................................................................................................... 185

Physical Inventory Process Checklist ............................................................................................................... 186

W A R E H O U S E M A N A G E M E N T I N T E G R A T I O N v

C O N T E N T S

Index.....................................................................................................................................................................189

Documentation Comment Form...........................................................................................................191

vi W A R E H O U S E M A N A G E M E N T I N T E G R A T I O N

C O N T E N T S

W A R E H O U S E M A N A G E M E N T I N T E G R A T I O N 1

IntroductionWelcome to Warehouse Management Integration, an application that provides the capability to integrate your back-office Microsoft Dynamics GP system with a WMS.

This introduction is divided into the following sections:

• What’s in this manual• Prerequisites• Symbols and conventions

What’s in this manual

This manual is designed to give you an in-depth understanding of how to use the features of Warehouse Management Integration, and how it integrates with the Microsoft Dynamics GP system.

Prerequisites

This manual assumes that you are familiar with Microsoft Dynamics GP. You should be able to perform tasks using the following modules:

• Sales Order Processing• Purchase Order Processing• Inventory Control

You should also be familiar with Accellos WMS and warehousing vocabulary.

Symbols and conventions

This manual uses the following symbols and conventions to make information stand out.

Symbol/Convention Description

The light bulb symbol indicates helpful tips, shortcuts and suggestions.

The warning symbol indicates situations you should be especially aware of when completing tasks. Typically, this includes cautions about performing steps in their proper order, or important reminders about how other information in Microsoft Dynamics GP may be affected.

File >> Print The (>>) symbol indicates a sequence of actions, such as choosing items from a menu, toolbar, or pressing buttons in a window. This example directs you to go to the File menu and choose Print.

I N T R O D U C T I O N

2 W A R E H O U S E M A N A G E M E N T I N T E G R A T I O N

PAR

T 1: INSTA

LLATIO

N &

SETUP


Part 1: Installation & SetupThis part of the documentation explains installation and setup tasks for Warehouse Management Integration.

The following topics are discussed:

• Chapter 1, “Installation,” describes how to install and register Warehouse Management Integration.

• Chapter 2, “Back-Office setup,” describes how to set up Warehouse Management Integration.


Chapter 1: InstallationThis portion of the documentation describes how to install and register Warehouse Management Integration.

This information is divided into the following sections:

• Compatibility notes• System requirements• Installation checklist• About the installation process• Installing Warehouse Management Integration• Enabling security to Warehouse Management Integration resources• Registering Warehouse Management Integration• Uninstalling Warehouse Management Integration

Compatibility notes

Before installing Warehouse Management Integration, you should review this section to understand any compatibility issues with your system.

• Due to an issue with how tables are updated when using Microsoft Dynamics GP Professional Tools, if you use Microsoft Dynamics GP Professional Tools (i.e. Vendor Combiner or Customer Combiner) and experience any issues, please contact Blue Moon Product Support for assistance.

System requirements

Client requirements

Component Requirements Notes

Operating system One of the following:• Windows Vista Business Edition, Ultimate

Edition, or Enterprise Edition (32-bit or 64-bit) • Windows XP Professional SP2 (32-bit or 64-

bit)

See #6 in the Additional notes section to verify that all products you're using are compatible with 64-bit operating systems.

Processor Intel Pentium IV 2.4 gigahertz (GHz) or higher

Available hard disk space 800 megabytes (MB) or more on the system root

Minimum available RAM 512 MB (1 gigabyte (GB) recommended)

Network card 100 MB Full Duplex or 1 GB Ethernet

Microsoft Office One of the following:• 2007 Microsoft Office system• Office 2003• Office XP

Microsoft Office Outlook is required for the Outlook area to display on the Microsoft Dynamics GP home page.The Microsoft Office Web Components are required for home page metrics. If you are using Office 2007, you must install the Office 2003 Web Components:• Office 2003 Web Components• Office XP Web Components

Microsoft Internet Explorer One of the following:• Internet Explorer 7.0• Internet Explorer 6.0 SP1 or higher

Adobe Adobe 8.0, 7.0, or 6.0

C H A P T E R 1 I N S T A L L A T I O N


Server recommendationsReview the following customer profiles to determine which profile best reflects your environment based on user count, modules used, and transaction volume. Use that customer profile as a recommendation for your server hardware implementation.

Customer profile 1

The following profile applies if you:

• Use only Financial Series modules

• Have 0-20 concurrent users for Microsoft SQL Server or 0-10 concurrent users for SQL Server Desktop Engine (MSDE) 2000 or SQL Server 2005 Express Edition

• Use Report Writer, Crystal Reports, or FRx

• Process fewer than 1,000 transactions a day

• Import very little data

• Have a dedicated server with SQL Server only

• Have a dedicated server with MSDE 2000/SQL Server 2005 Express Edition only (recommended)

Customer profile 2


Database One of the following:• SQL Server 2005 SP2 Standard Edition 32-bit,

Workgroup Edition, or Express Edition• SQL Server 2000 SP4 Standard Edition or

Workgroup Edition• MSDE 2000 SP4

NOTE: SQL Server 2000 mainstream support ended on April 8, 2008. Go to the Support Lifecycle page for SQL Server 2000 for more information.

Operating system One of the following:• Microsoft Windows Server 2008 Standard

Edition (32-bit or 64-bit) • Windows Server 2003 Standard Edition SP2 or

R2 Standard Edition SP2 (32-bit or 64-bit)• Windows Small Business Server 2003

Premium Edition SP2 or R2 Premium Edition SP2

• Windows Small Business Server 2003 Standard Edition SP2 or R2 Standard Edition SP2

Windows Server 2008 is supported with Microsoft Dynamics GP SP2 only. • While you can install MSDE 2000 and SQL

Server 2005 Express Edition on a non-server operating system, it is recommended you install those components on a server operating system. (See #3 in the Additional notes section.)

• See #6 and #7 in the Additional notes section to verify that all products you're using are compatible with Windows Server 2008 and/or 64-bit operating systems.

• Small Business Server 2003 Standard Edition is supported with MSDE 2000 and SQL Server 2005 Express Edition only.

Processor One dual-core or two single-core Ensure processors can be upgraded.

Disk configuration (for SQL Server only) • Minimum: RAID 5 for operating system, applications, and SQL database log and data files

• Recommended: RAID 1 for operating system and applications; RAID 5 for SQL database log and data files

• More available disks will improve SQL Server performance.

• We recommend using a dual-channel fast and wide SCSI-2 controller.

RAM 1 GB or greater

Network card 100 MB Full Duplex or 1 GB Ethernet




• Use Financial Series modules

• Use Distribution Series modules moderately

• Use Field Service Series modules

• Use Manufacturing Series or Project Series modules moderately

• Have 20-60 concurrent users

• Use Terminal Services

• Use Report Writer, Crystal Reports, or FRx

• Perform some online analytical processing (OLAP) cube generation

• Use an import routine/eConnect/Integration Manager

• Process 1,000–4,000 transactions a day originating in Sales (Sales Order Processing and/or Receivables Management), Payables Management, or General Ledger



Database One of the following:• SQL Server 2005 SP2 Enterprise Edition or

Standard Edition (32-bit and 64-bit)• SQL Server 2000 SP4 Enterprise Edition or

Standard Edition


Operating system One of the following:• Windows Server 2008 Standard Edition or

Enterprise Edition (32-bit or 64-bit)• Windows Server 2003 Enterprise Edition SP2,

R2 Enterprise Edition SP2, Standard Edition SP2, or R2 Standard Edition SP2 (32-bit or 64-bit)


• Windows Server 2008 is supported only with Microsoft Dynamics GP 10.0 SP2.

Processor One dual-core or two single-core Ensure processors can be upgraded to four processors for Standard Edition or up to eight processors for Enterprise Edition.

Disk configuration • RAID 1 for operating system and applications (two disks)

• RAID 1 for SQL database log files (two disks)• RAID 5 (four disk minimum) or RAID 10 (eight

disk minimum) for SQL data files• RAID 1 for TempDB (two disks)—optional,

but recommended• RAID 0 for SQL backups (full disk volume and

log) (two disks)

• Additional disks will improve SQL Server performance.

• To process more than 4,000 transactions a day, you might need to increase the number of disks in your RAID 5 disk volume.

• We recommend using an Ultra SCSI 3 or Fiber Controller.

RAM 4 GB or more If more than 2 GB of RAM is available, enable the 3 GB and/or the PAE switch in the boot.ini file if using Windows Server 2003 Enterprise Edition. Refer to Article Q283037 for more information.

Network card 100 MB Full Duplex or 1 GB Ethernet Ensure switch is capable of handling network traffic.



Customer profile 3


• Use Financial Series and Distribution Series modules extensively

• Use Field Service Series, Manufacturing Series, and Project Series modules extensively

• Have 60-100 concurrent users

• Use Terminal Services

• Use Report Writer, Crystal Reports, or FRx extensively

• Use an import routine or eConnect extensively

• Process more than 4,000 transactions a day originating in Sales (Sales Order Processing and/or Receivables Management), Payables Management, or General Ledger

• Perform OLAP cube generation to a different machine


Terminal Services server requirementsMicrosoft recommends using a dedicated Terminal Services server/Citrix server. There might be performance losses if SQL Server is running on the Terminal Services server/Citrix server.


Database One of the following:• SQL Server 2005 SP2 Enterprise Edition 32-bit

and 64-bit, or Standard Edition 64-bit • SQL Server 2000 SP4 Enterprise Edition


Operating system One of the following:• Windows Server 2008 Standard Edition (32-bit

or 64-bit) or Windows Server 2008 Enterprise Edition

• Windows Server 2003 R2 Standard Edition SP2 (64-bit)

• Windows Server 2003 Enterprise Edition SP2 or R2 Enterprise Edition SP2 (32-bit or 64-bit)



Processor Two dual-core or four single-core Verify processors can be upgraded to eight processors.

Disk configuration • RAID 1 for operating system and applications (two disks)

• RAID 1 for SQL database log files (four disks)• RAID 10 for data files (eight disk minimum)• RAID 1 for TempDB (four disks)• RAID 0 for SQL backups (full disk volume and

log) (two disks)

• Additional disks will improve SQL Server performance.

• To process more than 4,000 transactions a day, you might need to increase the number of disks in your RAID 5 or RAID 10 disk volume.

• We recommend using an Ultra SCSI 3 or Fiber Controller.

RAM 8 GB or more Enable the 3 GB and/or the PAE switch in the boot.ini file if using Windows Server 2003 Enterprise Edition. (See Article Q283037).

Network card 1 GB Ethernet Ensure switch is capable of handling network traffic.



To help offset performance losses, it is highly recommended to have two separate servers: one server with Terminal Services and/or Citrix, and one server with SQL Server.

Additional notes1. This document represents configurations tested by Microsoft and supported by

Technical Support. Use of technologies not specified in this document is not recommended and will not be supported. Testing is ongoing, and as newer technologies become supported, this list will be updated.

2. If you will be using Workflow for Microsoft Dynamics GP 10.0, refer to the System requirements for Microsoft Dynamics GP 10.0 Web applications page for Microsoft Office SharePoint Server recommendations.

3. If you're running MSDE 2000 or SQL Server 2005 Express Edition on Windows XP SP2, or if you're running SQL Server on Windows Server 2003 SP1, refer to this KB article: Some programs seem to stop working after you install Windows XP Service Pack 2. You might need to enable port 1433 for TCP/IP in Windows Firewall to ensure the incoming Open Database Connectivity (ODBC) requests are accepted.

4. For information about using Microsoft Dynamics GP in a virtual environment, see this KB article: Support for Microsoft Dynamics GP 10.0 in a virtual environment. Microsoft Virtual PC, Microsoft Virtual Server, and Microsoft SoftGrid 4.2 have been tested.


Operating system One of the following:• Windows Server 2008 Standard Edition or

Enterprise Edition (32-bit or 64-bit)• Windows Server 2003 Enterprise Edition SP2

or R2 Enterprise Edition SP2 (32-bit or 64-bit)• Windows Server 2003 Standard Edition SP2 or

R2 Standard Edition SP2 (32-bit or 64-bit)



Citrix (optional) Citrix Presentation Server 4.0 or 3.0 If accessing Citrix, the hardware and software must be supported according to Citrix configuration requirements.

Processor One dual-core or two single-core Verify processors can be upgraded to four processors for Standard Edition or eight processors for Enterprise Edition.

Disk configuration RAID 1 for operating system and applications (two disks)

RAM 2 GB or more The amount of RAM needed depends on the number of concurrent users per Terminal Services server.

Network card 100-MB Ethernet Full Duplex or 1-GB Ethernet • We recommend no more then 25 users per 100 Base-T network card, unless a Fiber NIC is installed. If a Fiber NIC is installed, the SQL server also should have a Fiber NIC installed for optimal network performance.

• Ensure switch is capable of handling network traffic.

Users Based on 15-20 users for each Terminal Services server

• Increased user count may require greater RAM and processor speed.

• Users of FRx or Crystal Reports via Terminal Services may require increased hardware to improve performance.



5. The Microsoft Dynamics GP 10.0 back office application is supported in a peer to peer (workgroup) environment. A peer to peer environment is not supported if you are using web applications such as Business Portal, Workflow, Web Services, eConnect, or FRx Webport. If web applications are used, a domain is required.

6. Review the following table to verify that the features and products you're using are supported on a 64-bit operating system.

Product or feature 64-bit support Notes

Microsoft Dynamics GP client or server installation

Yes • The automatic U.S. Payroll Tax Update Engine must be run on a 32-bit operating system.

• The Field Service e-mail feature will not work on a 64-bit server.

Analysis Cubes for SQL Server 2005 (client and server)

Yes Refer to KB article 929156 for more information about 64-bit compatibility.


No No compatibility is planned.

Business Portal: Client accessing Business Portal Yes

Business Portal: IIS Server No Not compatible with 64-bit operating systems until the next release of Microsoft Dynamics GP.

Business Portal: Migration Utility No Not compatible with 64-bit operating systems until the next release of Microsoft Dynamics GP.

Catalog Maintenance No Not compatible with 64-bit operating systems until the next release of Microsoft Dynamics GP.

Developer Toolkit for Microsoft Dynamics GP 10.0

Yes

Dexterity Development Tools Yes • Includes Visual Basic Application compatibility.

• The DSCCS.exe service must run on a 32-bit operating system, but the service can be accessed from a 64-bit operating system.

eConnect Runtime (including the SDK) No

eExpense No

Enterprise Reporting 6.5 No No compatibility is planned.

FRx Forecaster 6.7 No No compatibility is planned.

FRx Forecaster 7.0 No No compatibility is planned.

FRx Reporter 6.7 No • No compatibility is planned. • SYSDATA must be on a 32-bit server.

FRx Web Port 6.7 No No compatibility is planned.

Field Service Anywhere No Compatibility is being researched.

Human Resources and Payroll Suite Yes

Integration Manager Yes

Office SharePoint Server Wizard No Not compatible with 64-bit operating systems until the next release of Microsoft Dynamics GP.

Personal Data Keeper No Not compatible with 64-bit operating systems until the next release of Microsoft Dynamics GP.

Rapid Implementation Tools: Rapid Configuration and Rapid Migration

No Compatibility is being researched.

Rapid Implementation Tools: Rapid Installation Yes

SDK for Microsoft Dynamics GP Yes

Security Synchronization Utility No Not compatible with 64-bit operating systems until the next release of Microsoft Dynamics GP.



7. Review the following table to verify that the features and products you're using are supported on Windows Server 2008.

SmartTags No No compatibility is planned.

Solution Accelerator for Compliance Management


SQL Server Reporting Services Wizard No Not compatible with 64-bit operating systems until the next release of Microsoft Dynamics GP.

Web Services for Microsoft Dynamics GP Runtime (including the SDK and Management Tools)

Yes Refer to KB article 918983 for more information about 64-bit compatibility.

Workflow for Microsoft Dynamics GP (including the SDK)

No Not compatible with 64-bit operating systems until the next release of Microsoft Dynamics GP.

Workflow History Archiving Utility No

Visual Studio Tools for Microsoft Dynamics GP SDK

Yes Requires Microsoft Dynamics GP 10.0 SP1 or later to use the Dag.exe tool.

Product or feature 64-bit support Notes

Product or feature Windows Server 2008 support Notes

Microsoft Dynamics GP client or server installation

Yes • Supported only with Microsoft Dynamics GP 10.0 SP2 or later.

• If User Access Control (UAC) is used on the server, you must run Microsoft Dynamics GP Utilities as an administrator.


Yes • Supported only with SP2 of Analysis Cubes for SQL 2005.

• If UAC is used on the server, you must run the Microsoft.Dynamics.GP.AnalysisCubes. ConfigurationWizard.exe program as an administrator.

• If UAC is used, you must run SQL Server Management Studio as an administrator to connect to Integration Services and execute packages and process cubes.



Business Portal: Client accessing Business Portal Yes • Supported only with Business Portal for Microsoft Dynamics GP SP2 or later.

• If UAC is used and you're running Electronic Document Delivery from the browser on a Windows Server 2008 computer, documents will not send. To work around this issue, send the documents from a computer with a different operating system or use the ScheduledSend executable. Refer to KnowledgeBase Article 951517 for more information.

• The Add Users wizard will fail if you're running it from the browser on a Windows Server 2008 computer where UAC is enabled. To work around this issue, run Internet Explorer as an administrator or run the wizard on a computer with a different operating system.

Business Portal: IIS Server Yes Supported only with Business Portal for Microsoft Dynamics GP SP2 or later.

Business Portal: Migration Utility Yes

Catalog Maintenance Yes



Developer Toolkit for Microsoft Dynamics GP 10.0


Dexterity Development Tools Yes • Supported only with SP2 for the Dexterity Development Tools.

• Includes Visual Basic Application compatibility.

eConnect Runtime (including the SDK) Yes • Supported only with SP2 for eConnect.• If UAC is used, you must run the .msp file as

an administrator.

eExpense Yes

FRx Forecaster 6.7 No Compatibility is being researched.

FRx Forecaster 7.0 No Compatibility is being researched.

FRx Reporter 6.7 No Compatibility is being researched.

FRx Web Port 6.7 No Compatibility is being researched.

Field Service Anywhere No Compatibility is being researched.

Human Resources and Payroll Suite Yes Supported only with SP2 for the Human Resources and Payroll Suite.

Integration Manager Yes • Supported only with SP2 for Integration Manager.

• If UAC is used, you must run the .msp file as an administrator.

Office SharePoint Server Wizard Yes • Supported only with SP2 for the Office SharePoint Server wizard.

• If UAC is used, you must run the .msp file as an administrator.

Personal Data Keeper Yes • Supported only with SP2 for Personal Data Keeper.

• If UAC is used, you must run Personal Data Keeper as an administrator when you start it for the first time.

Rapid Implementation Tools: Rapid Installation, Rapid Configuration, and Rapid Migration


SDK for Microsoft Dynamics GP Yes Supported only with SP2 for the Microsoft Dynamics GP 10.0 SDK.

Security Synchronization Utility Yes

SmartTags No No compatibility is planned.

Solution Accelerator for Compliance Management


SQL Server Reporting Services deployment wizard

No • Supported only with SP2 for the SQL Server Reporting Services deployment wizard.

• If UAC is used, you must run the wizard as an administrator

Web Services for Microsoft Dynamics GP Runtime (including the SDK and Management Tools)

Yes Supported only with SP2 for Web Services and the Web Services SDK.

Workflow for Microsoft Dynamics GP No

Workflow History Archiving Utility Yes

Workflow SDK Yes Supported only with SP2 for the Workflow SDK.

Visual Studio Tools for Microsoft Dynamics GP SDK

Yes • Supported only with SP2 for the Visual Studio Tools SDK.

• If UAC is used, you must run dag.exe from an administrative command prompt to generate DAG assemblies.

Product or feature Windows Server 2008 support Notes



Installation checklist

1. Ensure your system meets the requirements. For more information, refer to System requirements on page 5.

2. Run the “WMI_10_00.exe” file to launch the installation wizard. For more information, refer to Installing Warehouse Management Integration on page 14.

• Accept the license agreement.

• Select an installation folder.

• Confirm your installation settings.

• Complete the installation wizard.

• Start Microsoft Dynamics GP and create new tables.

3. Enable security to Warehouse Management Integration resources. For more information, refer to Enabling security to Warehouse Management Integration resources on page 17.

4. Register Warehouse Management Integration. For more information, refer to Registering Warehouse Management Integration on page 19.

5. Open the WMI setup window to start setting up the product. For more information, refer to Setting up inventory and general options on page 23.

About the installation process

You will use a wizard-based installation program to begin the Warehouse Management Integration installation process. The installation program will allow you to select the local Microsoft Dynamics GP folder where the Warehouse Management Integration files will be saved.

For example, if your local Microsoft Dynamics GP folder is in the following location:

C:\Program Files\Microsoft Dynamics\GP10

The product chunk file, help system, and user manual will be saved in the following locations:

If you do not install to your local Microsoft Dynamics GP folder, you will need to copy the product chunk file (.cnk) and help system file (.chm) manually to your local Microsoft Dynamics GP folder.

When the installation wizard is complete, you will need to start Microsoft Dynamics GP and log in as system administrator.

File Installation folder

WMI_10.cnk C:\Program Files\Microsoft Dynamics\GP10

WMI2293.chm C:\Program Files\Microsoft Dynamics\GP10

WarehouseManagementIntegrationAccellos.pdf

C:\Program Files\Microsoft Dynamics\GP10\Documentation



Installing Warehouse Management Integration

Before you begin installing Warehouse Management Integration, ensure that your Microsoft Dynamics GP system has the most current service packs installed.

Use the following instructions to install Warehouse Management Integration.

If you are using the Radio Beacon for Microsoft Dynamics GP warehouse management system from Blue Moon Industries, please contact Blue Moon technical support to verify version compatibility prior to installing Warehouse Management Integration.

Before installing Warehouse Management Integration, you should create a backup copy of the “Dynamics.set” file, which is located in the local Microsoft Dynamics GP folder. Store the copy in a location outside of the local Microsoft Dynamics GP folder. You can delete this file after installing Warehouse Management Integration successfully.

To install Warehouse Management Integration:1. Run the “WMI_10_00.exe” file. The installation wizard will start.



2. Choose Next. The license agreement will be displayed.

3. To accept the license agreement and continue installing Warehouse Management Integration, mark the “I accept the terms in the license agreement” option. Then choose Next. The installation folder option will be displayed.

4. By default, the installation program will attempt to select your local Microsoft Dynamics GP folder. If necessary, you can select it manually by choosing Change and browsing to the local Microsoft Dynamics GP folder. This folder indicates where the product chunk file and help file will be saved during the installation process.



Then choose Next. The installation confirmation option will be displayed.

5. Choose Install. The product chunk file and help file will be saved in the local Microsoft Dynamics GP folder. The product user manual will be saved in the Documentation subfolder of that same folder.

To view additional information about Warehouse Management Integration, mark the Show the readme file option. When the installation wizard is complete, important enhancement and compatibility information will be displayed.

6. Choose Finish. The installation wizard program will close.



7. Start Microsoft Dynamics GP. The message “Do you wish to include new code now?” will appear.

8. Choose Yes. New code will be included in Microsoft Dynamics GP.

9. Log in as system administrator.

• If you are installing the product for the first time, the message “Tables for Warehouse Management Integration are not created for this company. Do you wish to create them now?” will appear.

Choose Yes. Data tables for Warehouse Management Integration will be created, and the installation process will be complete.

• If you are upgrading the product to a new build number, data tables will be updated (if necessary) and the installation process will be complete.

Enabling security to Warehouse Management Integration resources

New security features were introduced as part of Microsoft Dynamics GP 10.0. These features prevent users from immediately accessing resources of integrating products. Instead, security to the resources must be deliberately enabled during the setup process.

After installing Warehouse Management Integration, you will need to enable security to Warehouse Management Integration resources. This process ensures that users can access the windows, reports, and files (tables) necessary for using the product.

This section assumes familiarity with the Microsoft Dynamics GP security model and related concepts including tasks, roles, and users. For more information about this security model, refer to the Microsoft Dynamics GP user documentation.

You will enable security by assigning the Warehouse Management Integration security task to one or more roles in the Security Role Setup window.

About the Warehouse Management Integration security taskA security task named RBI_DEFAULTUSER is created during the installation process for Warehouse Management Integration. This task contains the necessary permissions to use Warehouse Management Integration windows, reports, and files (tables).

However, the Warehouse Management Integration security task does not contain permissions to use Microsoft Dynamics GP resources, even if those resources are used by Warehouse Management Integration. It is important to ensure that your Microsoft Dynamics GP security is configured appropriately for each user of Warehouse Management Integration.



You can view the settings associated with the Warehouse Management Integration security task by opening the Security Task Setup window (Microsoft Dynamics GP Menu >> Tools >> Setup >> System >> Security Tasks) and selecting RBI_DEFAULTUSER as the task ID. If necessary, you can add items from the access list to meet your needs.

Do not remove any items from the access list or errors may result during product use. If you would like to limit activity in Warehouse Management Integration, such as only allowing access to inquiry windows, the recommended method is to create a new security task and add the Warehouse Management Integration resources to meet your needs.

To enable security to Warehouse Management Integration resources:1. Open the Security Role Setup window.

(Microsoft Dynamics GP Menu >> Tools >> Setup >> System >> Security Roles)

2. Select a role ID for which you will enable Warehouse Management Integration resources.

3. Mark the RBI_DEFAULTUSER option in the security task ID list. Then choose Save.

4. If necessary, repeat steps 2 and 3 to enable Warehouse Management Integration resources for more roles.

5. When you are finished, close the Security Role Setup window.



Registering Warehouse Management Integration

Warehouse Management Integration is fully functional in the Microsoft Dynamics GP sample company to allow users to evaluate and learn more about the product. When you purchase Warehouse Management Integration, you will receive a registration key. After you’ve entered the registration key, you will be able to use Warehouse Management Integration in your company.

Use the following instructions to register Warehouse Management Integration to your company.

To register Warehouse Management Integration:1. Open the Microsoft Dynamics GP Registration window.

(Microsoft Dynamics GP Menu >> Tools >> Setup >> System >> Registration)

2. Open the Blue Moon Product Registration window.(Additional >> Blue Moon Product Registration)

This window allows you to register any installed Blue Moon product. It displays the version and build number for each Blue Moon product installed in your system.

3. Ensure that your site name matches the site name on your registration form.



4. Enter your registration key in the Warehouse Management Integration Registration Key field. When you are finished, chose the TAB key to move off the field. Repeat this process for any Warehouse Management Integration options that will be registered.

Warehouse Management Integration will be registered and you will now be able to use the product in your company.

Uninstalling Warehouse Management Integration

If you would like to remove Warehouse Management Integration from your system, you can uninstall it by using the following instructions.

Before uninstalling Warehouse Management Integration, you should create a backup copy of the “Dynamics.set” file, which is located in the local Microsoft Dynamics GP folder. Store the copy in a location outside of the local Microsoft Dynamics GP folder. You can delete this file after uninstalling Warehouse Management Integration successfully.

This process requires manually editing the Dynamics.set file, and should only be performed by advanced users. Use caution when editing the Dynamics.set file, as any editing errors may result in your system not functioning properly.

To uninstall Warehouse Management Integration:1. Start Windows Explorer and navigate to the local Microsoft Dynamics GP folder.

2. Delete the Warehouse Management Integration dictionary file (RBI2293.dic) and help system (WMI2293.chm).

3. Delete the Warehouse Management Integration dictionary file. This file is named “.”

4. Open the Dynamics.set file using Notepad.

5. Reduce the number on the first line by one. For example, if the number is currently 23, change the value to 22.

6. Delete the line containing the text “Warehouse Mgt. Integration” and the line directly above it, which contains the product ID number. In this case, the ID number is 2293.

When you delete these lines, ensure you also delete the “line breaks” at the end of the lines. There should be no blank vertical space between the remaining lines.

7. Delete the line that ends with the text “RBI2293.DIC” and the two lines below it.

When you delete these lines, ensure you also delete the “line breaks” at the end of the lines. There should be no blank vertical space between the remaining lines.

8. Save and close the Dynamics.set file.

9. To delete Warehouse Management Integration data tables, open Microsoft SQL Server Management Studio. Then select the Tables option in your company database.

10. Select and delete all Warehouse Management Integration tables. For a full list of data tables, refer to Data tables on page 181.

If you will be using other products from Blue Moon Industries, do not delete any tables that start with the “BMI” prefix.



11. Select the Stored Procedures option in your company database. Then select and delete all Warehouse Management Integration stored procedures. These procedures begin with the “zDP_RBI” and “zDP_WMI” prefix.

12. Close Microsoft SQL Server Management Studio.


Chapter 2: Back-Office setupThis portion of the documentation describes how to set up Warehouse Management Integration.


• Setting up inventory and general options• Setting up module-specific options• Activating the Upload Processor• Using synchronization utilities• Ensuring Microsoft Dynamics GP posting setup compatibility

Setting up inventory and general options

Before using Warehouse Management Integration, you will need to configure the program to meet the needs of your business. Use the Warehouse Management Integration Setup window to set up inventory and general options.

To set up inventory and general options:1. Open the Warehouse Management Integration Setup window.

(Microsoft Dynamics GP Menu >> Tools >> Setup >> Company >> WMI Setup)

2. Select the warehouse management system you are using.

C H A P T E R 2 B A C K - O F F I C E S E T U P


3. Choose the IV button. The Inventory Setup window will open.

4. Select your site mapping preference. This option maps the backoffice Site ID field to a field in the WMS.

• If you select Warehouse, the back-office Site ID will be mapped to WMS Warehouses.

• If you select Zone, the back-office Site ID will be mapped to WMS Zones.

5. An in-transit site is used as a temporary transfer location for items from transfer orders originating in the WMS. Inventory is transferred out of the source site, into the in-transit site, and finally into the inventory destination site.

To create an in-transit site, choose Cards >> Inventory >> Site to open the Site Maintenance window. Enter the information for your in-transit site and choose Save. Because the in-transit site represents a virtual site, you may want to avoid entering information such as the address and telephone number.

In the Warehouse Management Integration Setup window, enter or select the in-transit site you created.

The in-transit site you specify must be used exclusively by Warehouse Management Integration. Do not attempt to use this site as you would any other inventory site. For example, do not select this site while processing transactions.

6. Enter or select a default work area ID. A work area is a WMS assembly area where components are assembled into finished goods.

For information about setting up work area IDs, refer to Chapter 12, “Work area.”



7. Select whether to allow serial and lot number overrides.

• If you mark Allow Lot Number Override, you will have the option of editing lot numbers that are being used with the WMS.

• If you mark Allow Serial Number Override, you will have the option of editing serial numbers that are being used with the WMS.

8. Select whether to use the Map IV Category Fields to WMS feature.

Map IV Category Fields to WMS Select whether to download Microsoft Dynamics GP user category information to user-defined fields in the WMS. In Microsoft Dynamics GP, user category information is defined in the Inventory Control Setup window, and applied to items in the Item Maintenance Options window.

The last mapping option allows you to select a user category for cubage, if necessary.

9. Select whether to use the auto open feature for the Item Additional Information window.

Auto Open Item Additional Information Mark this option to automatically open the Item Additional Information window when you select an item in the Item Maintenance window. This option can save time if you need to set up additional information for multiple items.

10. Select the bar code options that will be used in your system. Changing the bar code options in this window will not change UPC/EAN bar codes currently stored in your system.

Bar Code Symbology Select whether to use the UPC-A or EAN-13 bar code symbology.

Default Number System Select a default numbering system value. This number will automatically be entered in the Number System field in the Item Additional Information window.

• For UPC-A bar codes, the default number system represents the first digit.

• For EAN-13 bar codes, the default number system represents the first two or three digits.

Lock Number System Field Mark this option to prevent users from editing the value in the Number System field in the Item Additional Information window. This option is useful in situations where the number system will not change. If this option is unmarked, the Number System field will be editable.

Manufacturer Code Manufacturer codes are consistent across all products. If you enter a manufacturer code, it will be added by default to your bar code.

Use care when entering this value, as changing manufacturing codes is not recommended without first removing the previous manufacturer code. A SQL query could also be used to make this change if necessary.

• For UPC-A bar codes, the manufacturer code will use five digits.

• For EAN-13 bar codes, the manufacturer code length can vary.



To enter one or more manufacturer codes, choose the Manufacturer Code expansion button. The UPC Manufacturing Codes window will open. Enter as many manufacturing codes as needed, but select only one as the default. Choose OK.

Product Code Length The product code length displayed in this field indicates the length of your product code after all other entries have been made.

• For UPC-A bar codes, the product code length will always be five.

• For EAN-13 bar codes, the product code length can vary.

11. Select whether to enable auto posting of inventory batches that were created by Warehouse Management Integration. This feature only affects inventory batches created by Warehouse Management Integration; other inventory batches in the system will not be affected. If you enable this feature, refer to Ensuring Microsoft Dynamics GP posting setup compatibility on page 30 for information about setup compatibility.

If auto posting of inventory batches is enabled, the feature will be active when the Upload Processor is running. If the Upload Processor is not running, inventory batches will not be auto posted, regardless of whether the feature is enabled in the Warehouse Management Integration Setup window. For more information about the Upload Processor, refer to Activating the Upload Processor on page 28.

Inventory batches created by Warehouse Management Integration will be named according to the following convention:

RBIYYYYMMDD-### (where ### indicates a three-digit sequence number)

Specify your auto post thresholds. These options define how often the Upload Processor computer will post inventory batches.

Transactions Enter the number of inventory transactions to accumulate into a batch prior to posting the documents. For example, if you enter 10, documents will be posted in batches of 10.

If you want documents to be posted immediately instead of accumulating for batch posting, enter 1 in this field.

Days, Hours, and Minutes Enter a time period for inventory transactions to accumulate into a batch prior to posting the documents. This option is useful for posting batches after a defined time period, such as a particular number of days, hours, and minutes.

If you want documents to be posted at a specific time each day, enter a 0 in the Days field and mark the “at” option. Then enter a time in the field to the right of the Days field. When entering times, use 24 hour time. For example, 2300 would indicate 11:00 PM.

Documents will be posted when either the transaction or the time-based threshold is met.

12. Choose OK to close the Inventory Setup window and return to the Warehouse Management Integration Setup window.

13. If you are going to use a split upload configuration, mark the Use Split Upload option.

This option is only recommended for high volume environments, and requires the use of two workstations running the Upload Processor.



14. Select your logging preferences. By default, all download and upload activity is recorded in the log file. You can choose not to record successful downloads and uploads using these options.

Recording successful downloads and uploads might result in a large log file size. For information on viewing and maintaining the log file, refer to Viewing and maintaining the processing log on page 169.

• If you select Log Download Errors only, documents successfully downloaded from the back-office to the WMS will not be recorded in the log file.

• If you select Log Upload Errors only, documents successfully uploaded from the WMS to the back-office will not be recorded in the log file.

15. Configure your exception log preferences. The exception log is a text file that contains a list of errors that occurred during the transfer process, causing the Upload Processor to stop processing documents.

• Specify an exception log path to indicate where the exception log file will be saved. To enter a path, choose the folder icon and browse to a file location, or enter the path directly into the field.

• To be notified of errors via e-mail, enter an e-mail address in the exception e-mail address field. This feature requires that you have a standard MAPI e-mail client installed.

• To stop transferring documents based on errors within a particular time frame, enter the number of exceptions and seconds. If the number of errors meets this threshold, Warehouse Management Integration will stop transferring documents.

16. When you are finished selecting your setup options, choose Save. Your setup options will be saved.

Setting up module-specific options

The Warehouse Management Integration Setup window provides access to module-specific setup options for Warehouse Management Integration.

For detailed setup instructions for each module, refer to the following chapters:



• Setting up inventory and general options on page 23 describes how to set up Warehouse Management Integration options that are specific to Inventory Control.

• Chapter 3, “Sales setup” describes how to set up Warehouse Management Integration options that are specific to SOP.

• Chapter 15, “Purchasing setup,” describes how to set up Warehouse Management Integration options that are specific to POP.

• Chapter 24, “Field Service setup” describes how to set up Warehouse Management Integration options that are specific to Field Service.

• Chapter 28, “Manufacturing setup,” describes how to set up Warehouse Management Integration options that are specific to Manufacturing.

Activating the Upload Processor

The Upload Processor is a back-office process that automatically transfers documents from the WMS to the back-office. You will need to activate this process on one client workstation in your configuration to allow the transfer of documents.

You will need to select one client to run the Upload Processor process. Only one client should have the Upload Processor activated at any time.

You will use the Warehouse Management Integration Setup window to activate the Upload Processor.

When you exit Microsoft Dynamics GP, the Upload Processor will automatically be deactivated. You can deactivate the Upload Processor without exiting the system by opening the Process Monitor window (Microsoft Dynamics GP Menu >> Process Monitor) and selecting Timed as the queue option. Then select the Warehouse Management Integration Upload Processor from the list and choose Remove. The Upload Processor will be deactivated.

Remember that the Upload Processor must be active for documents to be transferred from the WMS to the back-office. It’s also important to remember that the Upload Processor should not be active on more than one client at the same time.

The Microsoft Dynamics GP user that will run the Upload Processor requires a “POWERUSER” security role ID. For more information about security role IDs and other security model concepts, refer to the Microsoft Dynamics GP user documentation.



To activate the Upload Processor:1. Open the Warehouse Management Integration Setup window.


2. Choose Activate. The Upload Processor will be activated.

Using synchronization utilities

If you are setting up the first client installation of Warehouse Management Integration, you may want to use one or more of the following synchronization utilities.

Item master synchronization utilityIf you are setting up the first client installation of Warehouse Management Integration, and you want to download item master information from the back-office to the WMS, you will need to use the item master synchronization utility.

Refer to Chapter 23, “Inventory utilities,” for detailed instructions about downloading back-office item master information to the WMS.

Sales document release synchronization utilityIf you are setting up the first client installation of Warehouse Management Integration, and you want your document management settings to be applied to existing SOP documents, you will need to use the sales document release synchronization utility.

Refer to Chapter 13, “Sales document release synchronization utility,” for information about applying document management settings to existing SOP documents.

Purchasing document release synchronization utilityIf you are setting up the first client installation of Warehouse Management Integration, and you want your document management settings to be applied to existing POP documents, you will need to use the purchasing document release synchronization utility.

Refer to Chapter 18, “Purchasing document release synchronization utility,” for information about applying document management settings to existing POP documents.

Manufacturing document release synchronization utilityIf you are setting up the first client installation of Warehouse Management Integration, and you want your document management settings to be applied to existing manufacturing documents, you will need to use the manufacturing document release synchronization utility.



Refer to Chapter 31, “Manufacturing document release synchronization utility,” for information about applying document management settings to existing manufacturing documents.

Ensuring Microsoft Dynamics GP posting setup compatibility

If you enabled auto posting of Warehouse Management Integration-created inventory batches during the setup process, you will need to confirm your Microsoft Dynamics GP posting setup is compatible with that option.

To ensure Microsoft Dynamics GP posting setup compatibility:1. Open the Posting Setup window.

(Microsoft Dynamics GP Menu >> Tools >> Setup >> Posting >> Posting)

2. For each of the following series/origin combinations, ensure “Send To” option is compatible. If it is not compatible, change the entry.

The following Send To options are compatible with Warehouse Management Integration:

• All unmarked (if the Print option is unmarked)

• Printer and/or File

• Prompt and/or Display (if Printer and/or File is marked)

Series Origin

Inventory Transaction EntryTransfer Entry

Financial General Entry

Purchasing Receivings Transaction



Prompt and/or Display cannot be chosen alone because the system will prompt the user for input and prevent the auto posting process from occurring.

3. When you are finished, choose OK.

PAR

T 2: SALES


Part 2: SalesThis part of the documentation explains sales-related features of Warehouse Management Integration.


• Chapter 3, “Sales setup,” describes how to set up Warehouse Management Integration for sales.

• Chapter 4, “Sales document release,” describes how to release documents to the WMS.

• Chapter 5, “Fulfillment options,” describes how to enter fulfillment options for sales orders.

• Chapter 6, “Fulfillment instructions,” describes how to enter fulfillment instructions for sales orders.

• Chapter 7, “Store names and EDI information,” describes how to enter sore names and EDI information for sales documents.

• Chapter 8, “Bill To - Ship To Notes,” describes how to enter Bill To - Ship To Notes.

• Chapter 9, “Price label information,” describes how to enter price label information.

• Chapter 10, “Picking information,” describes how to enter picking information.

• Chapter 11, “Shipment tracking,” describes how to track shipments.

• Chapter 12, “Work area,” describes how to set up and use work areas in Warehouse Management Integration.

• Chapter 13, “Sales document release synchronization utility,” describes how to use the sales document release synchronization utility.

• Chapter 14, “Sales Report Writer extensions,” describes how to set up Warehouse Management Integration Sales extensions for Report Writer.


Chapter 3: Sales setupThis portion of the documentation describes how to set up Warehouse Management Integration for sales.


• About managed sales document types• Setting up sales options

About managed sales document types

During the sales setup process, you will select the sales document types that will be managed by Warehouse Management Integration. Managed sales document types require you to:

• Enable the separate fulfillment process For each sales document type that will be managed by Warehouse Management Integration, you will need to enable the Use Separate Fulfillment Process option in the Sales Order Setup window.

Refer to the Microsoft Dynamics GP Sales Order Processing documentation for more information about this option.

• Understand disabled fields For each sales document type that will be managed by Warehouse Management Integration, the Qty to Invoice and Qty Fulfilled fields in the Sales Transaction Entry window will be disabled. Instead, Warehouse Management Integration will manage these fields based on fulfillment in the warehouse.

Setting up sales options

Before using the sales functionality of Warehouse Management Integration, you will need to configure the program to meet the needs of your business. Use the following instructions to set up sales options for Warehouse Management Integration.

To set up sales options:1. Open the Warehouse Management Integration Setup window.


C H A P T E R 3 S A L E S S E T U P


2. Choose the SOP button. The Sales Options window will open.

3. Select a SOP document type and type ID that will be managed by Warehouse Management Integration. Then mark the appropriate options for the selected document type.

• If you mark WMS, documents of the selected type will be available to be sent to the warehouse management system. You will be able to release these documents to the warehouse management system manually or automatically.

• If you mark Auto, documents of the selected type will automatically be released to the warehouse management system when saved. Only managed documents can be automatically released. If you do not mark Auto, you will need to release documents manually.

• If you mark Pack, items on documents of the selected type will be subject to pack size restrictions based on item/customer combinations. Only managed documents can be configured for pack size restrictions.

• If you mark QTY Rules, unfulfilled quantities remaining after fulfillment of partial quantities will be canceled or back-ordered based on item number and/or customer ID configurations. This option is not available for back order document types.

Item Number (Cards >> Inventory >> Item >> Options button >> Allow Back Orders option)

Customer ID (Cards >> Sales >> Customers >> Additional >> Def. Fulfillment Options >> Allow Backorders option)

• If you enter or select a Default Site, documents of the selected type created with the Sales Transaction Entry window will use the selected site ID as the default.

Repeat this step for each SOP document type ID that will be managed by Warehouse Management Integration.



4. Select the sales options you want to enable.

Allow release with Process Hold If you mark this option, managed documents with process holds assigned to them can be released for fulfillment to the WMS. If you do not mark this option, you will need to remove process holds prior to releasing the document for fulfillment to the WMS.

Allow release with Customer Hold If you mark this option, managed documents for customers placed on hold in the Customer Maintenance window can be released for fulfillment to the WMS. If you do not mark this option, you will need to remove customer holds prior to releasing the document for fulfillment to the WMS.

Apply Shipping Charges from WMS If you mark this option, the freight amount on a managed document will be updated using the shipping charges from the WMS.

5. Select whether the Tracking Number from the WMS should be appended to or replace the existing sales document’s tracking numbers.

6. If necessary, enter a Backorder Threshold. If after partial fulfillment, the unfulfilled amount is below the specified threshold, the remaining amount will be canceled.

7. When you are finished entering the sales setup options, choose OK to save the information. Then choose Save in the Warehouse Management Integration Setup window.


Chapter 4: Sales document releaseThis portion of the documentation describes how to release documents to the WMS.


• Release status• Releasing sales documents to the WMS• Recalling sales documents from the WMS• Viewing the release status of sales documents• Fulfillment indicators• Sales document entry and release process• Sales document entry and release process illustration

Release status

As documents are transferred between the back-office and WMS, they will be validated and assigned a release status. This validation process ensures the integrity of the documents.

A release status describes the document’s relationship to the WMS. This status determines what types of actions you can perform on the document.

The document’s release status will be one of the following:

Release Status Description

Available The document has not been released to the WMS.You can release Available documents to the WMS.

Released The document has been released to the WMS, but has not been acknowledged by the WMS. You can recall Released documents from the WMS.

Acknowledged The document has been released to the WMS and acknowledged by the WMS. You can edit acknowledged documents in the back-office. When saved, the document will automatically be released to the WMS.You can recall Acknowledged documents from the WMS.

Locked The document is currently in use by the WMS. You cannot access locked documents from the back-office.

Confirmed The document has been confirmed by the WMS. The WMS has finished processing the document.

C H A P T E R 4 S A L E S D O C U M E N T R E L E A S E


Releasing sales documents to the WMS

The release process transfers documents from the back-office to the WMS for processing. During the setup process, you specified what types of documents to manage. When you save documents of a managed order type, the order will become available to release to the WMS.

To save time, you can set up the back-office to automatically release saved documents to the WMS. For more information, refer to Setting up inventory and general options on page 23.

You can release a document to the WMS by using the Sales Order Release Management window.

To release sales documents to the WMS:1. Open the Sales Order Release Management window.

(Transactions >> Sales >> Release Manager)

Marked documents are currently released to the WMS. Unmarked documents are currently not released to the WMS.

2. If necessary, use the Include options to filter the displayed documents and choose Redisplay. Documents meeting your criteria will be displayed.

3. If necessary, select a sorting option and choose Redisplay.

4. Mark the documents to release to the WMS.

5. Choose Process. The documents you marked will be released to the WMS.

6. Close the Sales Order Release Management window.



Recalling sales documents from the WMS

You can recall a document from the WMS by using the Sales Order Release Management window. Recalling a document is helpful if you need to edit a document before it is processed in the WMS.

Your ability to recall a document from the WMS depends on the document’s release status, which describes the document’s relationship to the WMS. For more information, refer to Release status on page 39.

To recall sales documents from the WMS:1. Open the Sales Order Release Management window.




3. Unmark the documents to recall from the WMS.

4. Choose Process. The documents you unmarked will be recalled from the WMS.

5. Close the Sales Order Release Management window.



Viewing the release status of sales documents

You will use the Sales Order Release Inquiry window to view the release status of sales documents.

To view the release status of sales documents:1. Open the Sales Order Release Inquiry window.

(Inquiry >> Sales >> Release Inquiry)



4. Select a record and choose a link to open a window to view more detailed information (optional).

The following table shows the link field and the window that the link opens:

5. When you are finished viewing the information, choose Close.

Link Field Window that opens

Sales Order Number Sales Transaction Inquiry Zoom window



Fulfillment indicators

In the Sales Order Release Management and Sales Order Release Inquiry windows, sales documents with a “confirmed” status will be marked with an icon to indicate whether the document has unfulfilled quantities remaining. This icon will be displayed in the Release Status field.

Hold indicators

In the Sales Order Release Management and Sales Order Release Inquiry windows, sales documents with a “hold” status will be marked with an icon to indicate the type of hold. This icon will be displayed in the Sales Document Number field.

Sales document entry and release process

This section describes the general process flow for entering and releasing sales documents.

1. A managed sales document type is entered in Microsoft Dynamics GP and saved.

For more information about setting up managed sales document types, refer to Setting up sales options on page 35.

2. Warehouse Management Integration records the sales document number into the Release Work table with a status of Available and a Release Count of zero.

• If auto-release is enabled, Warehouse Management Integration immediately sends the sales document through the sales document release process.

For more information about enabling auto-release, refer to Setting up sales options on page 35.

• If auto-release is not enabled, you must mark the sales document in the Sales Order Release Management window and choose Process. The sales document will be sent through the sales document release process.

For more information about releasing sales documents manually, refer to Releasing sales documents to the WMS on page 40.

3. Warehouse Management Integration increments the Release Work table Release Count for the sales document.

Icon Description

Indicates the document has unfulfilled quantities remaining. These documents can be marked for release to the WMS and processed.

Indicates the document is 100% fulfilled. These documents cannot be marked for release to the WMS

Icon Description

Indicates the SOP document is on hold.

Indicates a SOP document for a customer on hold.



4. Warehouse Management Integration writes a Pick Detail (PD) transaction to the DNLOAD table for each sales document line item having:

• An unfulfilled quantity remaining or • A quantity to backorder greater than zero

The quantity to pick is set to the calculated unfulfilled quantity remaining.

5. Warehouse Management Integration writes a Pick Header (PH) transaction to the DNLOAD table containing document header information.

6. Warehouse Management Integration assigns a status of Released to the sales document.

7. Accellos WMS reads the PD and PH transactions from the DNLOAD table, uses them to create a document in the warehouse, and deletes the transactions from the DNLOAD table.

8. Accellos WMS writes an “XC/DNLOADED/Unlock” status transaction for the sales document into the UPLOAD table.

9. Warehouse Management Integration reads the “XC/DNLOADED/Unlocked” transaction from the UPLOAD table, assigns a status of Acknowledged to the sales document, and deletes the UPLOAD table record.

10. Accellos WMS allocates the sales document and writes an “XC/ALLOCATED/Lock” status transaction for the sales document into the UPLOAD table. Note that Accellos WMS must be configured to “Lock on Allocate.”

11. Warehouse Management Integration reads the “XC/ALLOCATED/Lock” transaction from the UPLOAD table, assigns a status of Locked to the sales document, and deletes the UPLOAD table record.

12. Accellos WMS waves the sales document out to the warehouse for picking.

13. On the first pick, Accellos WMS writes an “XC/BEING PICKED/Lock” status transaction for the sales document into the UPLOAD table.

14. Warehouse Management Integration reads the “XC/BEING PICKED/Lock” transaction from the UPLOAD table, assigns a status of Locked to the sales document (redundant), and deletes the UPLOAD interface table record.

15. Accellos WMS writes a Pick Confirmation (PC) transaction into the UPLOAD table for each pick recorded by the warehouse. There can be multiple pick transactions against the same sales document line item (different pick bins, Serial/Lot numbers, etc.).

16. Warehouse Management Integration reads the “PC” Pick Confirmation transactions from the UPLOAD table, writes them into a Pick Confirmation Work table, and deletes them from the UPLOAD table.

17. Accellos WMS processes the sales document through the end-of-line process (rating, etc.) and writes an “XC/UPLOADED/Unlocked” status transaction into the UPLOAD table.

18. Warehouse Management Integration reads the “XC/UPLOADED/Unlocked” status transaction from the UPLOAD table and executes the sales document fulfillment process:



• Pick Confirmation Work data for the Sales Document is accumulated to the Sales Document Line Item level and the Sales Document Line Item quantities are updated.

• Sales document header information is updated (Date, Tracking, etc.).

• Unfulfilled quantity rules, if selected in Warehouse Management Integration setup, are applied.

• A status of Confirmed is assigned to the sales document.

• If auto-release is enabled, Warehouse Management Integration calculates the unfulfilled quantity remaining for the sales document. If unfulfilled quantities remain, Warehouse Management Integration sends the sales document through the release process.



Sales document entry and release process illustration


Chapter 5: Fulfillment optionsThis portion of the documentation describes how to enter fulfillment options for sales orders.


• Entering fulfillment options• Setting up default fulfillment options for customers• Setting up default fulfillment options for customer addresses• Entering fulfillment options for orders• Viewing fulfillment options for orders

Entering fulfillment options

Fulfillment option fields allow you to add fulfillment-related information to sales documents. You attach information directly to the sales document and when the document is transferred to the WMS, the fulfillment options information will also be transferred.

Setting up default fulfillment options for customers

You will use the Default Fulfillment Options window to enter default fulfillment options for orders from a specific customer.

To set up default fulfillment options for customers:1. Open the Customer Maintenance window.

(Cards >> Sales >> Customers)

2. Enter or select a customer ID.

C H A P T E R 5 F U L F I L L M E N T O P T I O N S


3. Choose Additional >> Def. Fulfillment Options. The Default Fulfillment Options window will open.

4. Define your backorder and shipment options.

Allow Backorders This option communicates to your WMS whether you allow partially picked orders. To allow backorders, mark this option. To require all of an order to be picked, leave this option unmarked.

Ship Complete This option communicates to your WMS whether you allow partial shipments. To allow partial shipments, mark this option. To require all of an order to be shipped, leave this option unmarked.

5. If necessary, enter a default Priority for the customer’s orders. You can enter a value from 0 to 9 to indicate the priority level of this customer’s orders.

6. If necessary, enter formats for labels, pack slips, and price tickets. These fields indicate the format ID used by the WMS. You can enter values for these formats only in this window; they cannot be defined during order entry.

7. If necessary, select a Ship Payment Type to indicate the default ship payment type for the customer. Enter the associated Cashier Account number if applicable.

This information will be used if you have an integrating shipping system. It is used by the shipping/manifesting system to determine who is paying for the shipment, and whether a third party account should be billed.

The following options are available:

Prepaid Select this option if the shipper pays, but the customer is billed for the cost. The shipping cost is sent from the integrated warehouse/shipping system.

Prepaid-Bill Select this option if the shipper pays, but the customer is billed for cost.

Bill Recipient – Account # Required Select this option if the recipient will be billed. This option requires the recipient’s account number that will be billed.

Third Party – Account # Required Select this option if someone other than the warehouse or recipient will be billed. For example, you may want to ship to one destination, but bill another.



Consignee/Collect – Account # Optional Select this legacy concept when billing an address. This option applies only to larger businesses with UPS accounts.

Freight Collect – Account # Optional Select this option to bill a UPS account. This option replaces the previous consignee concept.

8. Choose OK. The information will be saved.

9. Close the Customer Maintenance window.

Setting up default fulfillment options for customer addresses

You will use the Default Address Fulfillment Options window to enter default fulfillment options for orders for specific customer addresses. If you do not set up default fulfillment options at the customer address level, the default fulfillment options at the customer level will be used.

To set up default fulfillment options for customer addresses:1. Open the Customer Address Maintenance window.

(Cards >> Sales >> Addresses)

2. Select a customer ID.

3. Select an address ID for the customer.



4. Choose Additional >> Default Address Fulfillment Opt. The Default Address Fulfillment Options window will open.

5. If necessary, select a Ship Payment Type to indicate the default ship payment type for the customer address. Enter the associated Cashier Account number if applicable.


The following options are available:

Prepaid Select this option if the shipper pays. The shipping cost is sent from the integrated warehouse/shipping system.

Prepaid-Bill Select this option if the shipper pays, but the customer is billed for cost.

Bill Recipient – Account # Required Select this option if the recipient will be billed. This option requires the recipient’s account number that will be billed.

Third Party – Account # Required Select this option if someone other than the warehouse or recipient will be billed. For example, you may want to ship to one destination, but bill another.

Consignee/Collect – Account # Optional Select this legacy concept when billing an address. This option applies only to larger businesses with UPS accounts.

Freight Collect – Account # Optional Select this option to bill a UPS account. This option replaces the previous consignee concept.


7. Close the Customer Address Maintenance window.

Entering fulfillment options for orders

You will use the Fulfillment Options window to enter fulfillment options at the order level during order entry.



To enter fulfillment options for orders:1. Open the Sales Transaction Entry window.

(Transactions >> Sales >> Sales Transaction Entry)

2. Choose Additional >> Fulfillment Options. The Fulfillment Options window will open.

3. Define your backorder and shipment options.

Allow Backorders This option communicates to your WMS whether you allow partially picked orders. To allow backorders, mark this option. To require all of an order to be picked, leave this option unmarked.

Ship Complete This option communicates to your WMS whether you allow partial shipments. To allow partial shipments, mark this option. To require all of an order to be shipped, leave this option unmarked.



4. If necessary, enter a Priority for the customer’s orders. You can enter a value from 0 to 9 to indicate the priority level of this customer’s orders.

5. If necessary, select a Cancel Date for the order. This date indicates to the WMS the date the order should be cancelled if it has not been fulfilled.

6. If necessary, enter a Do Not Ship Before Date for the order. This date indicates to the WMS the date before which the order should not be shipped.

7. If necessary, select a Ship Payment Type to indicate the ship payment type for the order. Enter the associated Cashier Account number if applicable.



9. Finish processing the sales document.

Viewing fulfillment options for orders

You will use the Fulfillment Options window to view fulfillment options for sales documents.

To view fulfillment options for orders:1. Open the Sales Transaction Inquiry Zoom window.

(Inquiry >> Sales >> Sales Items >> Document Number link)



2. To view fulfillment options for the document, choose Additional >> Fulfillment Options. The Fulfillment Options window will open.

3. When you are finished viewing the information, close the Fulfillment Options window.


Chapter 6: Fulfillment instructionsThis portion of the documentation describes how to enter fulfillment instructions for sales orders.


• About fulfillment instructions• Setting up default fulfillment instructions for customers• Entering fulfillment instructions for orders• Viewing fulfillment instructions for orders

About fulfillment instructions

During the course of business, you may need to communicate fulfillment instructions about sales orders to your shipping team. For example, you might need to inform a shipping employee of special handling instructions for a package you are shipping.

Instead of relaying the information via traditional methods, you can attach the instructions directly to the sales order. Your fulfillment instructions will appear on RF handhelds during the fulfillment process. This communication method ensures that the shipping employee preparing the package also receives your instructions.

Fulfillment instructions allow you to communicate to your shipping staff by associating fulfillment instructions with sales orders.

Setting up default fulfillment instructions for customers

Setting up default fulfillment instructions is helpful if the same instructions are always needed for orders for a specific customer. With default fulfillment instructions, you can enter the information once and automatically apply it to all future orders for the customer.

C H A P T E R 6 F U L F I L L M E N T I N S T R U C T I O N S


To set up default fulfillment instructions for customers:1. Open the Customer Maintenance window.

(Cards >> Sales >> Customers)

2. Select a customer.

3. Choose Additional >> Def. Fulfillment Instructions. The Default Fulfillment Instructions window will open.

4. Enter the fulfillment instructions for sales orders for this customer.

There are seven 20-character fields available to store the fulfillment instructions.

5. Choose OK. The default fulfillment instructions will be saved.



These default fulfillment instructions will be applied to future sales orders for the selected customer.

6. Close the Customer Maintenance window.

Entering fulfillment instructions for orders

You can enter fulfillment instructions for sales order during sales order entry.

If the same fulfillment instructions are needed for every order for a specific customer, you can save time by using default fulfillment instructions. For more information, refer to Setting up default fulfillment instructions for customers on page 55.

If default fulfillment instructions exist, you can overwrite them at the sales order level. Modifying instructions at the sales order level only affects the instructions for the current order and does not overwrite the default fulfillment instructions for future orders.

To enter fulfillment instructions for orders:1. Open the Sales Transaction Entry window.


2. Begin processing the transaction, but do not save the sales order.



3. Choose Additional >> Fulfillment Instructions. The Fulfillment Instructions window will open.


If default fulfillment instructions for this customer exist, they will appear in the special instructions fields. If default instructions do not exist, the special instructions fields will be blank.

Enter or replace the fulfillment instructions for the order and choose OK. The instructions will be saved and applied to the current order.

4. Finish processing the order, then save it.

When the order is released to the WMS, the fulfillment instructions will be included with the order.

Viewing fulfillment instructions for orders

You will use the Fulfillment Instructions window to view fulfillment instructions for sales documents.



To view fulfillment instructions for orders:1. Open the Sales Transaction Inquiry Zoom window.


2. To view fulfillment instructions for the document, choose Additional >> Fulfillment Instructions. The Fulfillment Instructions window will open.

3. When you are finished viewing the information, close the Fulfillment Instructions window.


Chapter 7: Store names and EDI informationThis portion of the documentation describes how to enter sore names and EDI information for sales documents.


• About store names• Setting up store names• Assigning store numbers and EDI information to items on sales documents• Viewing store numbers and EDI information

About store names

Store names allow you to assign a text description to a specific customer “ship to” address. Store names will be used to accommodate “mark for labeling” requirements. Information such as the store number and address will be used for store-level labeling in the WMS.

Setting up store names

You will use the Store Name Maintenance window to assign store names to specific customer store numbers.

The store name and address information is passed to the external fulfillment system so the Store Mark for address detail can be printed on the shipping label. This is helpful if orders are being shipped to a central distribution location for later transfer to a specific store.

To set up store names:1. Open the Customer Address Maintenance window.



C H A P T E R 7 S T O R E N A M E S A N D E D I I N F O R M A T I O N



4. Choose Additional >> Store Name. The Store Name Maintenance window will open.

5. Enter the store name.

6. Enter the location code/destination number.

7. Choose OK. The Store Name Maintenance window will close.

8. If necessary, set up store names for other customer store numbers.

9. When you are finished setting up store names, close the Customer Address Maintenance window.

Assigning store numbers and EDI information to items on sales documents

You can assign store numbers and EDI information to items on sales documents in two ways.

• You can enter a store number and EDI information at the sales document level that will apply to all new line items on the sales document.

This method is helpful if you need to assign the same information to many line items. If you enter a default store number and EDI information, you can replace them at the line item level while processing line items.

• You can enter line item-specific store numbers and EDI information.

This method is helpful if you need to assign differing store numbers and/or EDI information to individual line items.



To assign store numbers and EDI information to items on sales documents1. Open the Sales Transaction Entry window.



3. To enter a store number and EDI information that will be assigned to the document, choose Additional >> EDI Information Entry. The Sales Transaction EDI Information Entry window will open.



Select a store number and enter EDI information. Then choose OK. New line items on the current sales document will be assigned this store number and EDI information by default. You will also have the option to apply these changes to existing line items on the document.

If necessary, you can later replace the store number or EDI information on a line item basis.

4. To assign a line item-specific store number, enter the standard information to complete the line item. Select the line item and choose the expansion button. The Sales Item Detail Entry window will open.

Choose Additional >> EDI Information Entry. The Item Detail EDI Information Entry window will open.

Select a store number and enter EDI information. Then choose OK. The store number and EDI information will be assigned to the selected line item. If a default store number or EDI information exist for this line item, they will be replaced. Close the Sales Item Detail Entry window.

If necessary, enter more line items and assign store numbers and EDI information to them.

5. Finish processing the sales document.

Viewing store numbers and EDI information

You can view store numbers and EDI information in two ways.

• You can view a store number and EDI information at the sales document level.

• You can view line item-specific store numbers and EDI information.



To view store numbers and EDI information:1. Open the Sales Transaction Inquiry Zoom window.


2. To view document-level store number and EDI information, choose Additional >> EDI Information Entry. The Sales Transaction EDI Information Entry window will open.

3. To view line-item specific store number or EDI information, select the line item and choose the expansion button. The Sales Item Detail Inquiry Zoom window will open.



Choose Additional >> EDI Information Entry. The Item Detail EDI Information Entry window will open.

4. When you are finished viewing the information, close the EDI inquiry windows.


Chapter 8: Bill To - Ship To NotesThis portion of the documentation describes how to enter Bill To - Ship To Notes.


• About Bill To - Ship To Notes• Setting up default Bill To - Ship To Notes for customer addresses• Entering Bill To - Ship To Notes for orders• Viewing Bill To - Ship To Notes for orders

About Bill To - Ship To Notes

Bill To - Ship To Notes allow you to record notes associated with a customer address. These notes are saved as part of a sales document. The notes associated with the ship to address on an order will be available to be printed on various documents generated in the external fulfillment system.

Setting up default Bill To - Ship To Notes for customer addresses

You will use the Bill To - Ship To Notes window to enter Bill To - Ship To Notes for customer addresses.

To set up default Bill To - Ship To Notes for customer addresses:1. Open the Customer Address Maintenance window.




C H A P T E R 8 B I L L T O - S H I P T O N O T E S


4. Choose Additional >> Bill To - Ship To Notes. The Bill To - Ship To Notes window will open.

5. Enter the Bill To - Ship To Notes for this customer address.

There are five 40-character fields available to store the notes.

6. Choose OK. The Bill To - Ship To Notes will be saved.

These notes will be applied to future sales documents to this customer address. The notes can be printed on packing lists, pick lists, and other shipment related documents in the external fulfillment system.

7. Close the Customer Address Maintenance window.

Entering Bill To - Ship To Notes for orders

You can enter Bill To - Ship To Notes for sales order during sales order entry.

If the same Bill To - Ship To Notes are needed for every order for a specific customer address, you can save time by using default Bill To - Ship To Notes. For more information, refer to Setting up default Bill To - Ship To Notes for customer addresses on page 67.

If default Bill To - Ship To Notes exist, you can overwrite them at the sales order level. Modifying notes at the sales order level only affects the notes for the current order and does not overwrite the default Bill To - Ship To Notes for future orders.



To enter Bill To - Ship To Notes for orders:1. Open the Sales Transaction Entry window.



3. Choose Additional >> Bill To - Ship To Notes. The Bill To - Ship To Notes window will open.

4. Enter the Bill To - Ship To Notes for this order.

There are five 40-character fields available to store the notes.

If default Bill To - Ship To Notes for this customer address exist, they will appear in the notes fields. If default notes do not exist, the notes fields will be blank.



Enter or replace the notes for the order and choose OK. The notes will be saved and applied to the current order.


When the order is released to the WMS, the notes will be included with the order.

Viewing Bill To - Ship To Notes for orders

You will use the Bill To - Ship To Notes window to view Bill To - Ship To notes for sales documents.

To view Bill To - Ship To Notes for orders:1. Open the Sales Transaction Inquiry Zoom window.




2. To view Bill To - Ship To Notes for the document, choose Additional >> Bill To - Ship To Notes. The Bill To - Ship To Notes window will open.

3. When you are finished viewing the information, close the Bill To - Ship To Notes window.


Chapter 9: Price label informationThis portion of the documentation describes how to enter price label information.


• About price label information• Entering price label information for items for specific customers• Entering price label information for items for specific customer stores

About price label information

You can record price label information that will be printed on price tickets. There are two methods for setting up price level information.

• Entering price label information for customer/item combinations• Entering price label information for customer/item/store combinations

Entering price label information for items for specific customers

Use the Price Labeling Maintenance window to enter details that will be printed on price tickets for the customer/item combination. The customer’s item number is also available to be printed on these labels.

To enter price label information for items for specific customers:1. Open the Price Labeling Maintenance window.

(Cards >> Inventory >> Cust Price Label)

2. Enter or select an item number.


4. Enter a description that will appear on the price ticket.

5. Enter the retail price. The retail price indicates the selling price of the item.

6. Enter the value price. The value price indicates the price a customer might pay elsewhere for the same item.

C H A P T E R 9 P R I C E L A B E L I N F O R M A T I O N


7. Choose Save. The price label information will be saved.

Entering price label information for items for specific customer stores

Use the Store Price Labeling Maintenance window to enter details that will be printed on price tickets for the customer/item/store combination. The customer’s item number is also available to be printed on these labels.

If a store price label exists, it will be used as the default. If a store price label does not exist, the customer/item level label information will be used as the default for the customer/item.

To enter price label information for items for specific customer stores:1. Open the Store Price Labeling Maintenance window.

(Cards >> Inventory >> Store Price Label)



4. Enter or select a store number.

5. Enter a description that will appear on the price ticket.

6. Enter the retail price. The retail price indicates the selling price of the item.

7. Enter the value price. The value price indicates the price a customer might pay elsewhere for the same item.

8. Choose Save. The price label information will be saved.


Chapter 10: Picking informationThis portion of the documentation describes how to enter picking information.


• About picking information• Entering default picking information for items for specific customers• Entering picking instructions for a line item during order entry• Viewing picking instructions for line items

About picking information

You can enter picking information for items for specific customers. This information is used by your picking staff and appears on the RF HandHeld during the picking process.

Entering default picking information for items for specific customers

Use the Picking Information Maintenance window to enter default special instructions and pack sizes for item/customer combinations.

To enter default picking information for items for specific customers:1. Open the Picking Information Maintenance window.

(Cards >> Inventory >> Picking Information)

2. Enter the special instructions for this item/customer combination.

There are seven 20-character fields available to store the instructions.

3. Enter inner, middle, and outer pack sizes for this item/customer combination. These values indicate the customer’s pack size requirements.

When you release documents to the external fulfillment system, this information will be sent with the order line item. The order will be placed in a status of “held for wrong format” until inventory is available in the pack size required by the customer. Currently, the middle pack size is for information only.

C H A P T E R 1 0 P I C K I N G I N F O R M A T I O N


During the setup process, you defined the types of documents subject to pack size restrictions. For more information, refer to Setting up inventory and general options on page 23.

4. Choose Save. The information will be saved.

Entering picking instructions for a line item during order entry

You will use the Picking Instructions window to enter picking instructions for line items during order entry.

To enter picking instructions for a line item during order entry:1. Open the Sales Transaction Entry window.





3. Select a line item. Then choose Additional >> Picking Instructions. The Picking Instructions window will open.

4. Enter the special instructions for this line item.

There are seven 20-character fields available to store the instructions.

5. Choose OK. The instructions will be saved with the line item.

6. When you are finished adding picking instructions, choose Save in the Sales Transaction Entry window.

Viewing picking instructions for line items

You will use the Picking Instructions window to view picking instructions for line items.



To view picking instructions for line items:1. Open the Sales Transaction Inquiry Zoom window.


2. Select a line item. Then choose the expansion button for the line item. The Sales Item Detail Inquiry Zoom window will open.



3. Choose Additional >> Picking Instructions. The Picking Instructions window will open.

4. When you are finished viewing the information, choose OK.


Chapter 11: Shipment trackingThis portion of the documentation describes how to track shipments.


• Viewing track & trace information for items and shipments• Viewing tracking information for a shipment• Tracking shipments related to a PRO number

Viewing track & trace information for items and shipments

You can access detailed item and shipment information by using the Sales Document Tracking window. You will use this inquiry to view the following information:

• Information about items in a specific shipment• Information about shipments containing specific items

To view track & trace information for items and shipments:1. Open the Sales Order Processing Document Inquiry window.

(Inquiry >> Sales >> Sales Documents)

2. Select a document and then choose Additional >> Track Trace. The Sales Document Tracking by Track & Trace window will open.

3. To view information for items in a specific shipment, select a shipment from the upper list. Information about items in the selected shipment will be displayed in the lower list.

C H A P T E R 1 1 S H I P M E N T T R A C K I N G


4. To view shipment information for a specific item, select an item from the lower list and choose the Item Number Expansion button. The Sales Document Tracking by Item Number window will open.

Select an item from the upper list. Information about shipments that contain the selected item will be displayed in the lower list.

If necessary, you can return to the Sales Document Tracking by Track & Trace window by selecting a shipment from the lower list and choosing the Track & Trace Number expansion button.

5. When you are finished viewing the information, close the Sales Document Tracking windows.

Viewing tracking information for a shipment

You will use the Sales Document Tracking window to view tracking information for a shipment. This window provides detailed information about the shipment.



To view tracking information for a shipment:1. Open the Sales Document Tracking window.

(Inquiry >> Sales >> Track and Trace Inquiry)

2. Enter or select a Track & Trace Number. Tracking information for the selected Track & Trace Number will be displayed.

3. If necessary, you can view information about items in the shipment by choosing the Track & Trace Number expansion button. The Sales Document Tracking by Track & Trace window will open with item details for the shipment.

4. To view UPS or FedEx package tracking information, choose the i button to the right of the Track & Trace Number expansion button. A web browser window will open and display the associated tracking information for UPS or FedEx.

Tracking shipments related to a PRO number

PRO numbers are used to identify shipments using carriers that ship “less than truckload.” You can use the PRO Number Tracking by Sales Document window to view shipments related to a specific PRO number.



To track shipments related to a PRO number:1. Open the PRO Number Tracking by Sales Document window.

(Inquiry >> Sales >> Pro Number Tracking)

2. Enter or select a PRO number. The shipments associated with that PRO number will be displayed.



Chapter 12: Work areaThis portion of the documentation describes how to set up and use work areas in Warehouse Management Integration.


• Setting up work areas• Viewing work area information• Entering work areas and assembly notes during order entry• Viewing work areas and assembly instructions for orders

Setting up work areas

A work area is a WMS assembly area where components are assembled into finished goods. You will use the Work Area Maintenance window to set up work areas for use in your system.

To set up work areas:1. Open the Work Area Maintenance window.

(Cards > Inventory > WMI Work Area Maintenance)

2. Enter a work area ID. Then enter a description for the work area.

3. Choose Save. The work area information will be saved.

4. If necessary, set up other work areas.

5. When you are finished setting up work areas, close the Work Area Maintenance window.

Viewing work area information

Use the Work Area Inquiry window to view information about work areas you defined in the Work Area Maintenance window.

C H A P T E R 1 2 W O R K A R E A


To view work area information:1. Open the Work Area Inquiry window.

(Inquiry > Inventory > WMI Work Area Inquiry)

2. Enter or select a work area ID. The description associated with the work area ID will be displayed.

3. When you are finished viewing work area information, choose OK to close the Work Area Inquiry window.

Entering work areas and assembly notes during order entry

You will use the Work Area ID and Notes window to associate work areas and assembly notes with orders.

To enter work areas and assembly notes during order entry:1. Open the Sales Transaction Entry window.





3. Choose Additional > Work Area and Notes. The Work Area and Notes window will open.

4. Enter or select a work area ID.

5. Enter the assembly instructions for this order.

There are five 40-character fields available to store the instructions.

6. Choose OK. The work area and instructions will be saved and associated with the current order.


When the order is released to the WMS, the assembly instructions will be included with the order.

Viewing work areas and assembly instructions for orders

You will use the Work Area ID and Notes Inquiry window to view work area and assembly instructions for sales documents.



To view work areas and assembly instructions for orders:1. Open the Sales Transaction Inquiry Zoom window.


2. Choose Additional > Work Area and Notes.

3. When you are finished viewing the work area and assembly instructions, close the Work Area ID and Notes Inquiry window.


Chapter 13: Sales document release synchronization utilityThis portion of the documentation describes how to use the sales document release synchronization utility.


• About the sales document release synchronization utility• Applying document management settings to existing SOP documents

About the sales document release synchronization utility

The sales document release synchronization utility allows you to apply your current Warehouse Management Integration document management options to existing sales documents. You will typically use this utility in the following situations:

• During the first client setup, you defined the document types that will be managed by Warehouse Management Integration. You can use the this utility to apply your document management settings to SOP documents that existed prior to setting up Warehouse Management Integration.

• If you change the document management options in Warehouse Management Integration, you can use this utility to apply the new document management settings to SOP documents that existed prior to modifying the setup options in Warehouse Management Integration.

Applying document management settings to existing SOP documents

You will use the Sales Document Release Synchronization window to apply document management settings to existing SOP documents.

To apply document management settings to existing SOP documents:1. Open the Sales Document Release Synchronization window.

(Microsoft Dynamics GP Menu >> Tools >> Utilities >> Sales >> Release Synchronization)

2. Select a range of documents.

3. If necessary, you can choose the print icon to print an edit list.

4. Choose Process. The document management settings will be applied to the selected range of existing documents.

C H A P T E R 1 3 S A L E S D O C U M E N T R E L E A S E S Y N C H R O N I Z A T I O N U T I L I T Y



Chapter 14: Sales Report Writer extensionsThis portion of the documentation describes how to set up Warehouse Management Integration Sales extensions for Report Writer.


• About the Report Writer extensions• Using the Report Writer extensions

About the Report Writer extensions

Information from the following windows can be added to Microsoft Dynamics GP reports using Report Writer:

• Bill To - Ship To Notes window - For more information about this window, refer to Entering Bill To - Ship To Notes for orders on page 68.

• Fulfillment Option window - For more information about this window, refer to Entering fulfillment options for orders on page 50.

The instructions in this chapter assume familiarity with Report Writer. For more information about Report Writer, refer to the Report Writer User’s Guide.

Using the Report Writer extensions

The Report Writer extensions make use of the rw_TableHeaderString function. Any of the following values can be retrieved:

The rw_TableHeaderString function uses the following five parameters:

Window Available Values

Bill To - Ship To Notes Ship Note 1Ship Note 2Ship Note 3Ship Note 4Ship Note 5

Fulfillment Options Ship Payment TypeCarrier AccountAllow BackordersShip CompletePriorityCancel DateDo Not Ship Before DateLabel FormatPrice Ticket FormatPack Slip Format

Parameter Value

Integer Must be 2293

String Must be one of the available values as listed above

String Must be the Sales Document Number (SOP Number)

Integer Must be the Sales Document Type (SOP Type)

Integer Must be WORK or HISTORY flag: 1 = WORK 2 = HISTORY

C H A P T E R 1 4 S A L E S R E P O R T W R I T E R E X T E N S I O N S


PAR

T 3: PUR

CH

ASIN

G


Part 3: PurchasingThis part of the documentation explains purchasing-related features of Warehouse Management Integration.


• Chapter 15, “Purchasing setup,” describes how to set up Warehouse Management Integration for purchasing.

• Chapter 16, “Purchasing document release,” describes how to release documents to the WMS.

• Chapter 17, “Receiving and put away instructions,” describes how to enter receiving instructions for purchase orders.

• Chapter 18, “Purchasing document release synchronization utility,” describes how to use the purchasing document release synchronization utility.


Chapter 15: Purchasing setupThis portion of the documentation describes how to set up Warehouse Management Integration for purchasing.


• Setting up purchasing options

Setting up purchasing options

Before using the purchasing functionality of Warehouse Management Integration, you will need to configure the program to meet the needs of your business. Use the following instructions to set up purchasing options for Warehouse Management Integration.

If you are using landed costs, you may want to avoid auto-posting PO receiving transactions.

To set up purchasing options:1. Open the Warehouse Management Integration Setup window.


C H A P T E R 1 5 P U R C H A S I N G S E T U P


2. Choose the POP button. The Purchasing Options window will open.

3. Select a purchase order type from the PO Type list and select whether to manage the document. If you mark a PO type, documents of the selected type will be available to be sent to the WMS. You will be able to release these documents to the warehouse manually or automatically.

4. If you mark Auto-Release Purchase Orders, purchase orders will automatically be released to the WMS when saved. Only managed documents can be automatically released.

5. Select your purchasing receipt preferences.

• Select whether to create one receipt per vendor or one receipt per PO.

• Select whether to create one receipt batch per day or one receipt batch per day per site.

• Select whether the receipt type will be a shipment or shipment/invoice.

• Enter a next receipt number. This number is used to create a purchasing receipt number in the Receivings Transaction Entry window for receiving transactions from the WMS.

6. Select whether to include/exclude site IDs from integration with the WMS.

If you mark the WMS option for a site ID, PO line items with that site ID will be available for download to the WMS for receiving. If the site ID is unmarked, PO line items with that site ID will not be available for download to the WMS.



7. Select whether to enable auto posting of PO receipt batches that were created by Warehouse Management Integration. This feature only affects PO receipt batches created by Warehouse Management Integration; other PO receipt batches in the system will not be affected.

If auto posting of PO receipt batches is enabled, the feature will be active when the Upload Processor is running. If the Upload Processor is not running, PO receipt batches will not be auto posted, regardless of whether the feature is enabled in the Warehouse Management Integration Setup window. For more information about the Upload Processor, refer to Activating the Upload Processor on page 28.

PO receipt batches created by Warehouse Management Integration will be named according to the following convention:

RBIRCTMMDDYY### (where ### indicates a three-digit sequence number)

Specify your auto post thresholds. These options define how often the Upload Processor computer will post PO receipt batches.

Transactions Enter the number of PO receipt transactions to accumulate into a batch prior to posting the documents. For example, if you enter 10, documents will be posted in batches of 10.

If you want documents to be posted immediately instead of accumulating for batch posting, enter 1 in this field.

Days, Hours, and Minutes Enter a time period for PO receipt transactions to accumulate into a batch prior to posting the documents. This option is useful for posting batches after a defined time period, such as a particular number of days, hours, and minutes.

If you want documents to be posted at a specific time each day, enter a 0 in the Days field and mark the “at” option. Then enter a time in the field to the right of the Days field. When entering times, use 24 hour time. For example, 2300 would indicate 11:00 PM.

Documents will be posted when either the transaction or the time-based threshold is met.

8. When you are finished entering the purchasing setup options, choose OK to save the information. Then choose Save in the Warehouse Management Integration Setup window.


Chapter 16: Purchasing document releaseThis portion of the documentation describes how to release documents to the WMS.


• Release status• Releasing purchasing documents to the WMS• Recalling purchasing documents from the WMS• Viewing the release status of purchasing documents• Purchasing data flow

Release status










C H A P T E R 1 6 P U R C H A S I N G D O C U M E N T R E L E A S E


Releasing purchasing documents to the WMS



You can release a document to the WMS by using the Purchase Order Release Management window.

To release purchasing documents to the WMS:1. Open the Purchase Order Release Management window.

(Transactions >> Purchasing >> Release Manager)




4. Close the Purchase Order Release Management window.



Recalling purchasing documents from the WMS

You can recall a document from the WMS by using the Purchase Order Release Management window. Recalling a document is helpful if you need to edit a document before it is processed in the WMS.


To recall purchasing documents from the WMS:1. Open the Purchase Order Release Management window.

(Transactions >> Purchasing >> Release Manager)




4. Close the Purchase Order Release Management window.



Viewing the release status of purchasing documents

You will use the Purchase Order Release Status Inquiry window to view the release status of purchasing documents.

To view the release status of purchasing documents:1. Open the Purchase Order Release Status Inquiry window.

(Inquiry >> Purchasing >> Release Inquiry)


3. Select a record and choose a link to open a window to view more detailed information (optional).

The following table shows the link field and the window that the link opens:


Purchasing data flow

The following diagram illustrates the flow of data between POP and the warehouse.

Link Field Window that opens

Purchase Order Number Purchase Order Inquiry Zoom window


Chapter 17: Receiving and put away instructionsThis portion of the documentation describes how to enter receiving instructions for purchase orders.


• About receiving and put away instructions• Setting up default receiving instructions• Entering receiving and put away instructions during PO entry• Viewing receiving and put away instructions for purchase orders

About receiving and put away instructions

During the course of business, you may need to communicate special instructions about purchase orders to your receiving team in the warehouse. For example, you might need to inform a warehouse employee of special handling instructions for a package you are expecting.

Instead of relaying the information via traditional methods, you can attach the instructions directly to the purchase order. Your receiving instructions will appear on RF handhelds during the receiving process. This communication method ensures that the warehouse employee receiving the package also receives your special instructions.

Receiving instructions allow you to communicate to your warehouse staff by associating receiving instructions with POs.

Setting up default receiving instructions

Setting up default receiving instructions is helpful if the same instructions are always needed for purchase orders from a specific vendor. With default receiving instructions, you can enter the information once and automatically apply it to all future POs from the vendor.

To set up default receiving instructions:1. Open the Vendor Maintenance window.

(Cards >> Purchasing >> Vendor)

2. Select a vendor.

C H A P T E R 1 7 R E C E I V I N G A N D P U T A W A Y I N S T R U C T I O N S


3. Choose Additional >> Def. Receiving Instructions. The Default Receiving Instructions window will open.

4. Enter the special instructions for purchase orders from this vendor.

There are seven 20-character fields available to store the special instructions.

5. Choose OK. The default special instructions will be saved.

These default receiving instructions will be applied to future purchase orders from the selected vendor.

6. Close the Vendor Maintenance window.

Entering receiving and put away instructions during PO entry

You can apply receiving instructions to POs during PO entry.

If the same instructions are needed for a vendor on every purchase order, you can save time by using default instructions. For more information, refer to Setting up default receiving instructions on page 105.

If default receiving instructions exist, you can overwrite them at the PO level during PO entry. Modifying instructions at the PO level only affects the receiving instructions for the current PO and does not overwrite the default instructions for future POs.

To enter receiving and put away instructions during PO entry:1. Open the Purchase Order Entry window.

(Transactions >> Purchasing >> Purch. Order Entry)

2. Begin processing the transaction, but do not save the PO.



3. To enter receiving instructions for the PO, choose Additional >> Receiving Instructions. The Receiving Instructions window will open.

There are seven 20-character fields available to store the receiving instructions.

If default receiving instructions for POs from this vendor exist, they will appear in the special instructions fields. If default instructions do not exist, the special instructions fields will be blank.

Enter or replace the receiving instructions for the PO and choose OK. The instructions will be saved and applied to the current PO.

4. Enter put away instructions for the line items, if necessary.

Select a line item and choose the item expansion button. The Purchasing Item Detail Entry window will open.

Choose Additional >> Put Away Instructions. The Put Away Instructions window will open.

Enter or replace the put away instructions for the PO line item and choose OK. The instructions will be saved and applied to the current PO line item.

Choose Save to close the Purchasing Item Detail Entry window.



Repeat this process for other line items, if necessary.

5. Save the purchase order.

When the order is released to the warehouse, the instructions will be included with the order.

Viewing receiving and put away instructions for purchase orders

Use the Receiving Instructions window to view receiving instructions for specific purchase orders.

To view receiving and put away instructions for purchase orders:1. Open the Purchase Order Processing Document Inquiry window.

(Inquiry >> Purchasing >> Purchase Order Documents)

2. Select a document and choose the PO Number column heading. The Purchase Order Inquiry Zoom window will open.

3. Choose Additional >> Receiving Instructions. The Receiving Instructions window will open.

When you are finished viewing the receiving instructions, choose OK to close the window.

4. To view put away instructions for a line item, select a line item and choose the item expansion button. The Purchasing Item Detail Inquiry Zoom window will open.



Choose Additional >> Put Away Instructions. The Put Away Instructions window will open.

When you are finished viewing the information, choose OK to close the Put Away Instructions window.


Chapter 18: Purchasing document release synchronization utilityThis portion of the documentation describes how to use the purchasing document release synchronization utility.


• About the purchasing document release synchronization utility• Applying document management settings to existing POP documents

About the purchasing document release synchronization utility

The purchasing document release synchronization utility allows you to apply your current Warehouse Management Integration document management options to existing purchasing documents. You will typically use this utility in the following situations:

• During the first client setup, you defined the document types that will be managed by Warehouse Management Integration. You can use the this utility to apply your document management settings to POP documents that existed prior to setting up Warehouse Management Integration.

• If you change the document management options in Warehouse Management Integration, you can use this utility to apply the new document management settings to POP documents that existed prior to modifying the setup options in Warehouse Management Integration.

Applying document management settings to existing POP documents

You will use the Purchase Order Release Synchronization window to apply document management settings to existing POP documents.

To apply document management settings to existing POP documents:1. Open the Purchase Order Release Synchronization window.

(Microsoft Dynamics GP Menu >> Tools >> Utilities >> Purchasing >> Release Synchronization)




C H A P T E R 1 8 P U R C H A S I N G D O C U M E N T R E L E A S E S Y N C H R O N I Z A T I O N U T I L I T Y


PAR

T 4: INV

ENTO

RY


Part 4: InventoryThis part of the documentation explains inventory-related features of Warehouse Management Integration.


• Chapter 19, “Kits,” describes how to set up kits in Warehouse Management Integration.

• Chapter 20, “Assembly transactions,” describes how to process assembly transactions in Warehouse Management Integration.

• Chapter 21, “Additional inventory information,” describes how to set up additional inventory information in Warehouse Management Integration.

• Chapter 22, “Reason Codes,” describes how to use reason codes in Warehouse Management Integration.

• Chapter 23, “Inventory utilities,” describes how to use the item master synchronization utility.


Chapter 19: KitsThis portion of the documentation describes how to set up kits in Warehouse Management Integration.


• Enabling the alternate window• Assigning kit components

Enabling the alternate window

Before using Warehouse Management Integration, you may want to enable the alternate Item Kit Maintenance window. This window provides WMS Kitting functionality.

To enable the alternate window:1. Open the Alternate/Modified Forms and Reports window.

(Microsoft Dynamics GP Menu >> Tools >> Setup >> System >> Alternate/Modified Forms and Reports)

2. Enter or select an ID.

3. Select Warehouse Management Integration from the Product list.

4. Select Windows from the Type list. Then expand the tree view and mark the Warehouse Management Integration window for the Item Maintenance Window.

5. Choose Save. The marked alternate window will be enabled.

C H A P T E R 1 9 K I T S


Assigning kit components

You will use the Item Kit Maintenance window to assign kit components. The alternate Item Kit Maintenance window provides a WMS Kitting Method option. For information about enabling this alternate window, refer to Enabling the alternate window on page 115.

To assign kit components:1. Open the Item Kit Maintenance window.

(Cards >> Inventory >> Kits)


3. Select whether sales transactions for the kit item should be posted to Cost of Goods Sold accounts for the kit components, or for the kit itself.

The Cost of Good Sold accounts are obtained from the kit or from the components, depending on your selection. If no Cost of Good Sold account exists for the kit or component items, the Cost of Good Sold accounts are based on the Posting Accounts Setup selections.

4. Select a WMS Kiting Method.

• If you select Build to Order, you will create a standard kit. Components for the kit will be picked during the standard fulfillment process.

• If you select Kit on the Fly, you will create a kit that will be assembled based on customer orders. Components for the kit will be picked and assembled in a work area during the fulfillment process.

5. Enter or select a component item number.

6. Enter the unit of measure and quantity for the component item.



For example, if you have a kitchen set with a table and four chairs, the unit of measure for the chairs might be Each, with a quantity of 4.

7. If necessary, continue adding component items to the kit.

8. Choose Save. The items you entered will be assigned to the kit.


Chapter 20: Assembly transactionsThis portion of the documentation describes how to process assembly transactions in Warehouse Management Integration.


• About assembly transactions• Entering an assembly transaction• Releasing work orders to the WMS• Viewing the release status of work orders

About assembly transactions

These transactions are used to update Inventory Control when you create finished goods from the components listed on a bill of materials. Assembly transactions typically include the quantities, dates, costs, and other information related to the transaction.

When assembling a finished good, you might have components that you pull from inventory, as well as those you assemble when you manufacture the finished good, depending on the stock method you selected when creating the bill.

Entering an assembly transaction

Use the Assembly Entry window to create assembly transactions. These transactions are used to update Inventory Control when you create finished goods from the components listed on a bill of materials.

To enter an assembly transaction:1. Open the Assembly Entry window.

(Transactions >> Inventory >> Assembly Entry)

2. If necessary, change the default Document Number.

3. If necessary, change the default Document Date.

4. Enter or select a site ID.

5. If necessary, enter a batch ID.

6. Enter or select a Bill Number.

7. Enter the Assemble Quantity.

8. Select the transaction status. You can select New, Released, or Not Released.

A status of Released is required to populate Work Order Release Management tables. When you change the status of the transaction, the contents of the active bill number are copied to the scrolling window. You can edit the stock or assemble quantity of any component in the scrolling window.

9. Choose Save.

C H A P T E R 2 0 A S S E M B L Y T R A N S A C T I O N S


Releasing work orders to the WMS

The release process transfers documents from the back-office to the warehouse for processing. You can release an assembly to the warehouse by using the Work Order Release Management window.

To release work orders to the WMS:1. Open the Work Order Release Management window.

(Transactions >> Inventory >> Release Manager)

2. Mark the documents to release to the warehouse.

3. Choose Process. The documents you marked will be released to the warehouse.

4. Close the Work Order Release Manager window.

Viewing the release status of work orders

You will use the Work Order Release Status Inquiry window to view the release status of work orders.



To view the release status of work orders:1. Open the Work Order Release Status Inquiry window.

(Inquiry >> Inventory >> Release Inquiry)




Chapter 21: Additional inventory informationThis portion of the documentation describes how to set up additional inventory information in Warehouse Management Integration.


• Setting up hazmat categories• Entering additional inventory information• Entering vendor item options

Setting up hazmat categories

Use the Hazmat Category Setup window to define the hazmat categories you will be using. Each category type is associated with a one-character code. This category list will be available when you associate hazmat codes with items.

To set up hazmat categories:1. Open the Hazmat Category Setup window.

(Microsoft Dynamics GP Menu >> Tools >> Setup >> Inventory >> Hazmat Category)

2. Enter hazmat category types and codes.

3. Choose OK.

C H A P T E R 2 1 A D D I T I O N A L I N V E N T O R Y I N F O R M A T I O N


Entering additional inventory information

You will use the Item Additional Information window to enter additional inventory information for items selected in the Item Maintenance window.

To enter additional inventory information:1. Open the Item Maintenance window.

(Cards >> Inventory >> Item)


3. Choose Additional >> Item Additional Options. The Item Additional Options window will open.

You can automatically open this window when you select an item in the Item Maintenance window. This setup option can save time if you need to set up additional inventory information for many items. For more information, refer to Setting up inventory and general options on page 23.

4. If necessary, enter bar code information. The type of bar code information you can choose depends on whether you selected UPC-A or EAN-13 during the setup process. For more information about the setup process, refer to Setting up inventory and general options on page 23.

Enter the number system, manufacturer code (if multiple manufacturer codes were defined during setup), and product code for the selected item. If the Number System field is not editable, the field was locked during the setup process. Product code check digits are calculated automatically, and entries are validated to ensure the proper length. If you do not enter a product code, a blank bar code will be saved.

The NS, Manufacturer Code, Product Code, and CD display code values for the current item and product code selection.

5. If necessary, enter special order and expiry date options.



• To designate this item as a special order and display a message in the warehouse management system RF handheld when this item is received, mark the Special Order option.

• To designate this item as requiring an expiry date, mark the Expiry Date Required option. If you mark this option, an expiry date will be requested by the warehouse management system RF handheld when the item is received.

6. Select the hazmat categories to associate with this item. You can select up to six categories for each item. These codes are used in the warehouse management system to identify hazmat-related products.

7. When you are finished setting up the additional information for the item, choose Save. Then close the Item Additional Information window and Item maintenance windows.

If you will be entering additional information for other items, leave the Item Additional Information window open. When you select a different item in the Item Maintenance window, the corresponding item will be selected in the Item Additional Information window.

Entering vendor item options

During receiving, you can capture the country of origin of products that are being received. You will use the Item Vendor Options window to enter the country of origin and special instructions for vendor items.

To enter vendor item options:1. Open the Item Vendors Maintenance window.

(Cards >> Inventory >> Vendors)

2. Enter or select an item number and vendor ID.

3. Choose Additional >> Item Vendor Options. The Item Vendor Options window will open.

4. Enter or select a country code to indicate the country of origin for the item.



• If you enter a new country code, the Country of Origin Maintenance window will open. You can use this window to set up country of origin codes and descriptions.

5. If necessary, enter the special instructions for purchase orders for this vendor item.

There are seven 20-character fields available to store the special instructions.

6. When you are finished entering the information, choose OK.

7. Choose Save in the Item Vendors Maintenance window.


Chapter 22: Reason CodesThis portion of the documentation describes how to use reason codes in Warehouse Management Integration.


• About reason codes• Setting up reason codes

About reason codes

Miscellaneous inventory adjustment transactions uploaded from the WMS can include specific reason codes. Each reason code is associated with an inventory offset (clearing) account that is used in the inventory adjustment transaction.

If a reason code does not have an account associated with it, the default inventory offset account will be used. If the account associated with a reason code is not valid, the transaction will be logged as a failure.

Setting up reason codes

Use the Reason Code Setup window to set up the reason codes you will be using.

To set up reason codes:1. Open the Reason Code Setup window.

(Cards >> Inventory >> Reason Code Maintenance)

2. Enter a reason code and description.

3. Select an inventory offset account.

4. Choose Save.

C H A P T E R 2 2 R E A S O N C O D E S



Chapter 23: Inventory utilitiesThis portion of the documentation describes how to use inventory utilities.


• Item master synchronization utility• Product code conversion utility• Stock count processor utility

Item master synchronization utility

The item master synchronization utility allows you to copy back-office item master information to the WMS. You will typically use this utility in the following situations:

• During the first client setup, you will use this utility to download item master information for all items distributed through your WMS.

• After you add or update item information in the back-office, you will use this utility to synchronize your updates to the WMS.

You will use the Item Master Synchronization window to download backoffice item master information to the WMS. You can download item master information for a range of items by item number or item class ID.

To use the item master synchronization utility:1. Open the Item Master Synchronization window.

(Microsoft Dynamics GP Menu >> Tools >> Utilities >> Inventory >> WMI Utilities)

2. Select the inventory items to download.

• If you select Item Number, information for items within your selected Item Number range will be selected.

• If you select Item Class Code, information for items within your selected Item Class Code range will be selected.

3. Choose whether to include the unit of measure schedule for pack sizes for items.

4. Choose Process. Item master information for the selected items will be downloaded to the WMS.

Downloading a large inventory may take several minutes.

C H A P T E R 2 3 I N V E N T O R Y U T I L I T I E S


Product code conversion utility

The product code conversion utility allows you to convert UPC-A or EAN-13 product codes that are currently located in the Short Description field in the Item Maintenance window. These values are checked for validity and moved to the Product Code field in the Item Additional Maintenance window.

The Short Description field is no longer used for product codes. Instead, the product code is now entered in the Product Code field in the Item Additional Information window. For more information about the Item Additional Information window, refer to Entering additional inventory information on page 124.

Before running this utility, ensure that you have set up UPC-A or EAN-13 bar code preferences in the Warehouse Management Integration Setup window. For more information, refer to Setting up inventory and general options on page 23.

To use the product code conversion utility:1. Open the Product Code Conversion window.

(Microsoft Dynamics GP Menu >> Tools >> Utilities >> Inventory >> Convert Product Code)

2. Select the product code configuration used in your system.

Bar Code Symbology Select whether to use the UPC-A or EAN-13 bar code symbology.

Default Number System Select a default numbering system value. This number will automatically be entered in the Number System field in the Item Additional Information window.

• For UPC-A bar codes, the default number system represents the first digit.

• For EAN-13 bar codes, the default number system represents the first two or three digits.



Manufacturer Code Manufacturer codes are consistent across all products. If you enter a manufacturer code, it will be added by default to your bar code.

Use care when entering this value, as changing manufacturing codes is not recommended without first removing the previous manufacturer code. A SQL query could also be used to make this change if necessary.

• For UPC-A bar codes, the manufacturer code will use five digits.

• For EAN-13 bar codes, the manufacturer code length can vary.

3. Choose Convert. The message, “Running this utility more than once will overwrite previous product code data in its new location.” will appear. To continue and use the utility, choose Continue.

The utility will convert product codes. When it is finished, you will have the option to print a report of items that were not converted. Print this report to determine which items were not converted. Then you can manually correct any noted issues.

Stock count processor utility

Before you upload stock counts from the warehouse management system, check the Stock Count Processor window to be sure it is empty. Delete or process stock counts before uploading a new stock count. This process is described in the following section.



To use the stock count processor utility:1. Open the Stock Count Processor window.

(Microsoft Dynamics GP Menu >> Tools >> Utilities >> Inventory >> Warehouse Stock Count Processor)

2. Ensure the Stock Count Processor window does not contain any stock count items. If this window contains items you’d like to delete, choose the Delete button.

3. Upload stock counts from the warehouse management system.

4. Open the Stock Count Processor window again.(Microsoft Dynamics GP Menu >> Tools >> Utilities >> Inventory >> Warehouse Stock Count Processor)

This window will now display stock counts and associated variances that will result if the stock counts are processed.

5. If necessary, you can filter by site, item number, and variance. Several sorting options are also available.

6. If necessary, you can print a report that displays stock counts and associated variances by choosing the print button.

7. When you are satisfied with the stock counts, choose the Process button.

Inventory variance transactions will be created based on the stock counts, and the associated stock counts in this window will be cleared.



All stock counts in this window, regardless of whether they are displayed or hidden via filtering, are processed when you choose the Process button.

An error report will be printed. This report describes any errors that occurred during the processing of stock counts.

PAR

T 5: FIELD SER

VIC

E


Part 5: Field ServiceThis part of the documentation explains Field Service-related features of Warehouse Management Integration.


• Chapter 24, “Field Service setup,” describes how to set up Warehouse Management Integration for Field Service.

• Chapter 25, “RTV transactions,” describes how to process RTV (Return to Vendor) documents in Warehouse Management Integration.

• Chapter 26, “RMA transactions,” describes how to process RMA (Return Materials Authorization) documents in Warehouse Management Integration.

• Chapter 27, “Field Service document release,” describes how to release documents to the WMS.


Chapter 24: Field Service setupThis portion of the documentation describes how to set up Warehouse Management Integration for Field Service.


• Setting up field service options

Setting up field service options

Before using the field service functionality of Warehouse Management Integration, you will need to configure the program to meet the needs of your business. Use the following instructions to set up field service options for Warehouse Management Integration.

To set up field service options:1. Open the Warehouse Management Integration Setup window.


2. Choose the FS button. The Field Service Options window will open.

3. Select a Field Service document type and type ID that will be managed by Warehouse Management Integration. Then mark the appropriate options for the selected document type.

C H A P T E R 2 4 F I E L D S E R V I C E S E T U P


• If you mark WMS, documents of the selected type will be available to be sent to the warehouse management system. You will be able to release these documents to the warehouse management system manually or automatically.

• If you mark Auto, documents of the selected type will automatically be released to the warehouse management system when saved. Only managed documents can be automatically released. If you do not mark Auto, you will need to release documents manually.

Repeat this step for each Field Service document type ID that will be managed by Warehouse Management Integration.

4. Enter a default office ID.

5. Enter or select a default transit site for RTV documents with a repair and return path.

6. When you are finished entering the Field Service setup options, choose OK to save the information. Then choose Save in the Warehouse Management Integration Setup window.


Chapter 25: RTV transactionsThis portion of the documentation describes how to process RTV (Return to Vendor) documents in Warehouse Management Integration.

This information is divided into the following topics:

• RTV types and the warehouse system

RTV types and the warehouse system

RTV documents are used to track items that are sent back to your vendors. Returns Management supports four different methods of accounting for returns to fit your business needs.

This section provides definitions of RTV documents as described in the Field Service-Returns Management manual. For detailed information about processing RTV documents, refer to the Field Service-Returns Management manual.

CreditWith this type of RTV, you receive a credit against your vendor’s account in Accounts Payable for the value of the items that you returned.

Credit RTV transactions can be downloaded to the warehouse system for picking and shipping to the vendor. The warehouse system provides notification of fulfillment (shipping) and the following data elements are updated in Microsoft Dynamics GP:

• Shipped Date and Time - These items are visible in the RTV Entry/Update window (Transactions >> Returns Management >> RTV Entry/Update).

• Travel Cost - This item is visible in the RTV Entry/Update window (Transactions >> Returns Management >> RTV Entry/Update).

• Quantity Shipped - This item is visible in the RTV Entry/Update window (Transactions >> Returns Management >> RTV Entry/Update).

• Track and Trace - This item is visible in the RTV Shipping window (Transactions >> Returns Management >> RTV Shipping).

• Marked to Post - This item is visible in the RTV Shipping window (Transactions >> Returns Management >> RTV Shipping).

This process reduces inventory in the warehouse system. The standard RTV shipping posting process creates the Microsoft Dynamics GP inventory adjustment and a credit document on the vendor account.

ReplacementWith this type of RTV, your vendor ships you the same, or a similar, item as a replacement. The shipment of the “original” item to the vendor generates a purchase order, that the replacement item will be received against.

Replacement RTV transactions can be downloaded to the warehouse system for picking and shipping to the vendor. The warehouse system provides notification of fulfillment (shipping) and the following data elements are updated in Microsoft Dynamics GP:

C H A P T E R 2 5 R T V T R A N S A C T I O N S







This process reduces inventory in the warehouse system. The standard RTV shipping posting process creates the Microsoft Dynamics GP inventory adjustment and a credit document on the vendor account. Additionally, Warehouse Management Integration automatically releases the resulting purchase order to the warehouse system.

Advance cross-shipWith this type of RTV, your vendor ships you the same, or a similar, item as a replacement. A purchase order is created immediately so that the replacement item can be received before the vendor receives the “original” item that you are returning.

Advance cross-ship RTV transactions can be downloaded to the warehouse system for picking and shipping to the vendor. The warehouse system provides notification of fulfillment (shipping) and the following data elements are updated in Microsoft Dynamics GP:






This process reduces inventory in the warehouse system. The standard RTV shipping posting process creates the Microsoft Dynamics GP inventory adjustment and a credit document on the vendor account. Additionally, Warehouse Management Integration automatically releases the resulting purchase order created in the RTV Vouchers window to the warehouse system.

Repair and ReturnWith this type of RTV, your vendor has agreed to take the item and repair it. You will receive the same, repaired item back from the vendor at the end of the repair process



Repair and return RTV transactions can be downloaded to the warehouse system for picking and shipping to the vendor. The warehouse system provides notification of fulfillment (shipping) and the following data elements are updated in Microsoft Dynamics GP:






This process creates a warehouse transfer in the warehouse system. There is no change in ownership for these items. When the items are shipped to the vendor for repair, they are transferred to an in-transit location. When the item comes back from the vendor, the second half of the warehouse transfer is processed in the warehouse system. The inbound side of the warehouse transfer updates the following data in Microsoft Dynamics GP:

• Quantity Received - This item is visible in the Inventory Receipts window (Transactions >> Returns Management >> Inventory Receipts).


Chapter 26: RMA transactionsThis portion of the documentation describes how to process RMA (Return Materials Authorization) documents in Warehouse Management Integration.

This information is divided into the following topics:

• RMA receiving process overview

RMA receiving process overview

Before the warehouse system receives the goods returned on the RMA, the RMA Receiving window will appear similar to the following illustration.

C H A P T E R 2 6 R M A T R A N S A C T I O N S


After the warehouse system receives the goods returned on the RMA, the RMA Receiving window will appear similar to the following illustration.

The return quantity is populated with what was actually received by the warehouse.

Process overview1. Create the RMA via the RMA Entry/Update Window (Transactions >> Returns

Management >> RMA Entry Update).

2. Release the RMA document to the warehouse. For more information, refer to Releasing RMA documents to the WMS on page 148.

3. RMA is picked in the WMS.

4. Open the RMA via the RMA Receiving Window (Transactions >> Returns Management >> RMA Receiving).

5. Verify the quantities.

6. Warehouse Management Integration marks the M and P boxes.



7. Follow the standard process for posting and closing the RMA.


Chapter 27: Field Service document releaseThis portion of the documentation describes how to release documents to the WMS.


• Release status• Releasing RMA documents to the WMS• Recalling RMA documents from the WMS• Viewing the release status of RMA documents

Release status










C H A P T E R 2 7 F I E L D S E R V I C E D O C U M E N T R E L E A S E


Releasing RMA documents to the WMS



You can release a document to the WMS by using the Returns Release Management window.

To release RMA documents to the WMS:1. Open the Returns Release Management window.

• You will need to add this window to your shortcut bar to access it. Right-click the shortcut bar, choose Add, then Add Window. Expand the Warehouse Mgt. Integration folder. Then expand the Project sub folder. Select Returns Release Management and choose Add.

In the shortcut bar, choose Returns Release Management.




4. Close the Returns Release Management window.



Recalling RMA documents from the WMS

You can recall a document from the WMS by using the Returns Release Management window. Recalling a document is helpful if you need to edit a document before it is processed in the WMS.


To recall RMA documents from the WMS:1. Open the Returns Release Management window.

• You will need to add this window to your shortcut bar to access it. Right-click the shortcut bar, choose Add, then Add Window. Expand the Warehouse Mgt. Integration folder. Then expand the Project sub folder. Select Returns Release Management and choose Add.

In the shortcut bar, choose Returns Release Management.



3. Choose Process. Returns Order Release Management window.



Viewing the release status of RMA documents

You will use the Returns Release Status Inquiry window to view the release status of RMA documents.

To view the release status of RMA documents:1. Open the Returns Release Status Inquiry window.

• You will need to add this window to your shortcut bar to access it. Right-click the shortcut bar, choose Add, then Add Window. Expand the Warehouse Mgt. Integration folder. Then expand the Project sub folder. Select Returns Release Status Inquiry and choose Add.

In the shortcut bar, choose Returns Release Status Inquiry.



Field service data flow

The following diagram illustrates the flow of data between Field Service and the warehouse.

PAR

T 6: MA

NU

FAC

TUR

ING


Part 6: ManufacturingThis part of the documentation explains manufacturing-related features of Warehouse Management Integration.


• Chapter 28, “Manufacturing setup,” describes how to set up Warehouse Management Integration for Manufacturing.

• Chapter 29, “Manufacturing document release,” describes how to release documents to the WMS.

• Chapter 30, “Fulfillment instructions,” describes how to enter fulfillment instructions for manufacturing documents.

• Chapter 31, “Manufacturing document release synchronization utility,” describes how to use the manufacturing document release synchronization utility.


Chapter 28: Manufacturing setupThis portion of the documentation describes how to set up Warehouse Management Integration for manufacturing.


• Setting up the modified window• Setting up manufacturing options

Setting up the modified window

Before using the manufacturing functionality of Warehouse Management Integration, you must set up the modified Manufacturing Component Transaction Entry window.

This window is contained in the MFG900CompTrxEnt.Package file. You must import this resource into the Microsoft Dynamics GP client that will be running the Warehouse Management Integration upload processor.

To set up the modified window:1. Log into Microsoft Dynamics GP as system administrator.

2. Open the Customization Maintenance window.(Microsoft Dynamics GP Menu >> Tools >> Customize >> Customization Maintenance)

C H A P T E R 2 8 M A N U F A C T U R I N G S E T U P


3. Choose Import. The Import Package File window will open.

4. Choose Browse, and then Local Files. Select the MFG900CompTrxEnt.Package file and choose Open. The file will be listed in the Import Package File window.

5. Choose OK in the Import Package File window. The package file will be imported.

6. Close the Customization Maintenance window.

7. Open the Alternate/Modified Forms and Reports window.(Microsoft Dynamics GP Menu >> Tools >> Setup >> System >> Alternate/Modified Forms and Reports)

8. Enter or select an ID.

9. Select Manufacturing from the Product list.

10. Select Windows from the Type list. Then expand the tree view and mark the Manufacturing window for the Manufacturing Component Transaction Entry Window.

11. Choose Save. The marked alternate window will be enabled.

Setting up manufacturing options

Before using the manufacturing functionality of Warehouse Management Integration, you will need to configure the program to meet the needs of your business. Use the following instructions to set up manufacturing options for Warehouse Management Integration.



To set up manufacturing options:1. Open the Warehouse Management Integration Setup window.


2. Choose the MFG button. The Manufacturing Options window will open.

3. Select the types of manufacturing documents that will be managed by Warehouse Management Integration. You can make standard MO and quick MO documents available to be sent to the warehouse management system.

When you mark a WMS option, more options will be displayed for the document type.

4. If you mark Auto Release, MO documents will automatically be released to the warehouse management system when you change the MO status to Released. If you do not mark the Auto Release option, you will need to release the documents manually.

5. If you marked the WMS option for Standard MO, enter the following standard MO setup options.

Issue Adjustments Location Enter or select a location from which adjustments for standard MOs will be made.



Backflush Bin Number Enter a warehouse bin location for standard MO backflushed components.

Reverse Issue Bin Number Enter a warehouse bin location for standard MO reverse issue.

Next MO Receipt Number Enter a temporary receipt number that will be used to receive against the MO in the warehouse management system.

Auto Post Component Transactions Mark this option if you want to automatically post component transactions created by Warehouse Management Integration. To post these transactions manually, leave this option unmarked.

Posting Reports Path If your system is configured to print posting reports, and you have enabled auto posting of component transactions, select a location where posting reports will be saved.

6. If you marked the WMS option for Quick MO, enter the following quick MO setup options.

Backflush Bin Number Enter a warehouse bin location for quick MO backflushed components.

Finished Good & Byproduct Bin Number Enter a warehouse bin location to which finished goods and byproduct are moved.

7. When you are finished entering the manufacturing setup options, choose OK to save the information. Then choose Save in the Warehouse Management Integration Setup window.


Chapter 29: Manufacturing document releaseThis portion of the documentation describes how to release documents to the WMS.


• Release status• Releasing manufacturing documents to the WMS• Recalling manufacturing documents from the WMS• Viewing the release status of manufacturing documents

Release status




Releasing manufacturing documents to the WMS

The release process transfers documents from the back-office to the WMS for processing. During the setup process, you specified what types of manufacturing documents to manage. When you change the status of an MO document to Released, the document will be available for release to the WMS.

To save time, you can set up the back-office to automatically release standard MO documents to the WMS. For more information, refer to Setting up manufacturing options on page 156.

You can release a document to the WMS by using the Manufacture Order Release Management window. When the MO is released, component transaction are sent to the WMS for fulfillment. A finished goods receipt for the MO is also sent to the WMS.







C H A P T E R 2 9 M A N U F A C T U R I N G D O C U M E N T R E L E A S E


To release manufacturing documents to the WMS:1. Open the Manufacture Order Release Management window.

• You will need to add this window to your shortcut bar to access it. Right-click the shortcut bar, choose Add, then Add Window. Expand the Warehouse Mgt. Integration folder. Then expand the 3rd Party sub folder. Select Manufacture Order Release Management and choose Add.

In the shortcut bar, choose Manufacture Order Release Management.




4. Close the Manufacture Order Release Management window.

Recalling manufacturing documents from the WMS

You can recall a document from the WMS by using the Manufacture Order Release Management window. Recalling a document is helpful if you need to edit a document before it is processed in the WMS.


To recall manufacturing documents from the WMS:1. Open the Manufacture Order Release Management window.

• You will need to add this window to your shortcut bar to access it. Right-click the shortcut bar, choose Add, then Add Window. Expand the Warehouse Mgt. Integration folder. Then expand the 3rd Party sub folder. Select Manufacture Order Release Management and choose Add.



In the shortcut bar, choose Manufacture Order Release Management.




4. Close the Manufacture Order Release Management window.

Viewing the release status of manufacturing documents

You will use the Manufacture Order Release Inquiry window to view the release status of manufacturing documents.

To view the release status of manufacturing documents:1. Open the Manufacture Order Release Inquiry window.

• You will need to add this window to your shortcut bar to access it. Right-click the shortcut bar, choose Add, then Add Window. Expand the Warehouse Mgt. Integration folder. Then expand the 3rd Party sub folder. Select Manufacture Order Release Inquiry and choose Add.



In the shortcut bar, choose Manufacture Order Release Inquiry.




Chapter 30: Fulfillment instructionsThis portion of the documentation describes how to enter fulfillment instructions for manufacturing documents.


• About fulfillment instructions• Entering fulfillment instructions for manufacturing orders• Viewing fulfillment instructions for manufacturing orders

About fulfillment instructions

During the course of business, you may need to communicate fulfillment instructions about manufacturing orders to your warehouse team. For example, you might need to inform an employee of special handling instructions for a manufacturing order item.

Instead of relaying the information via traditional methods, you can attach the instructions directly to the manufacturing order. Your fulfillment instructions will appear on RF handhelds during the fulfillment process. This communication method ensures that the warehouse employee preparing the item also receives your instructions.

Entering fulfillment instructions for manufacturing orders

You can enter fulfillment instructions for manufacturing orders during the order entry process.

To enter fulfillment instructions for manufacturing orders:1. Open the Manufacturing Order Entry window.

(Transactions >> Manufacturing >> Manufacturing Orders >> Entry)

2. Begin processing the transaction, but do not change the MO Status to Released.

3. Choose Additional >> Fulfillment Instructions. The Fulfillment Instructions window will open.


C H A P T E R 3 0 F U L F I L L M E N T I N S T R U C T I O N S


Enter fulfillment instructions for the order and choose OK. The instructions will be saved and applied to the current order.

4. Finish processing the order, then change the MO Status to Released.

When the order is released to the WMS, the fulfillment instructions will be included with the order.

Viewing fulfillment instructions for manufacturing orders

You will use the Fulfillment Instructions window to view fulfillment instructions for manufacturing orders.

To view fulfillment instructions for manufacturing orders:1. Open the Manufacturing Order View window.

(Inquiry >> Manufacturing >> Manufacturing Orders >> MO View)

2. To view fulfillment instructions for the document, choose Additional >> Fulfillment Instructions. The Fulfillment Instructions window will open.

3. When you are finished viewing the information, close the Fulfillment Instructions window.


Chapter 31: Manufacturing document release synchronization utilityThis portion of the documentation describes how to use the manufacturing document release synchronization utility.


• About the manufacturing document release synchronization utility• Applying document management settings to existing manufacturing documents

About the manufacturing document release synchronization utility

The manufacturing document release synchronization utility allows you to apply your current Warehouse Management Integration document management options to existing manufacturing documents. You will typically use this utility in the following situations:

• During the first client setup, you defined the document types that will be managed by Warehouse Management Integration. You can use the this utility to apply your document management settings to manufacturing documents that existed prior to setting up Warehouse Management Integration.

• If you change the document management options in Warehouse Management Integration, you can use this utility to apply the new document management settings to manufacturing documents that existed prior to modifying the setup options in Warehouse Management Integration.

Applying document management settings to existing manufacturing documents

You will use the Manufacture Order Release Synchronization window to apply document management settings to existing manufacturing documents.

To apply document management settings to existing manufacturing documents:1. Open the Manufacture Order Release Synchronization window.

• You will need to add this window to your shortcut bar to access it. Right-click the shortcut bar, choose Add, then Add Window. Expand the Warehouse Mgt. Integration folder. Then expand the 3rd Party sub folder. Select Manufacture Order Release Synchronization and choose Add.

In the shortcut bar, choose Manufacture Order Release Synchronization.


C H A P T E R 3 1 M A N U F A C T U R I N G D O C U M E N T R E L E A S E S Y N C H R O N I Z A T I O N U T I L I T Y




PAR

T 7: SYSTEM


Part 7: SystemThis part of the documentation explains system-related features of Warehouse Management Integration.


• Chapter 32, “Processing log utility,” describes how to use the processing log utility.

• Chapter 33, “Errors,” describes errors that may occur when using Warehouse Management Integration.


Chapter 32: Processing log utilityThis portion of the documentation describes how to use the processing log utility.


• About the processing log• Viewing and maintaining the processing log

About the processing log

The processing log records information about the documents that are transferred between the back-office and WMS.

You can set up the back-office to record transfer errors only. This method will ensure that the log file remains a small size. For information on setting up your log file preferences, refer to Setting up inventory and general options on page 23.

Viewing and maintaining the processing log

You will use the RBI Processing Log Inquiry window to view information about downloaded and uploaded documents. You will also maintain the log file using this window.

To view and maintain the processing log:1. Open the RBI Processing Log Inquiry window.

(Microsoft Dynamics GP Menu >> Tools >> Utilities >> System >> WMI Log Inquiry)

C H A P T E R 3 2 P R O C E S S I N G L O G U T I L I T Y


Check marks in the status column indicate transactions without errors. The X symbol in the status column indicates an error, and an associated error status code is displayed. For more information about error status codes, see General error codes on page 171.

2. If necessary, filter the displayed transactions by status. The following options are available.

• All Select this option to display all transactions.

• Errors Only Select this option to display only transactions with errors.

• Completed Only Select this option to display only completed transactions.

• Equals Select this option to display only error status codes you specify. For more information about error status codes, see General error codes on page 171.

3. If necessary, filter the displayed transactions by direction. The following options are available.

• All Select this option to display upload and download transactions.

• Up Select this option to display only upload transactions.

• Down Select this option to display only download transactions.

The direction is indicated by an up or down arrow in the direction field.

• Download refers to transactions sent from Microsoft Dynamics GP to the warehouse management system.

• Upload refers to transactions sent from the warehouse management system to Microsoft Dynamics GP.

4. If necessary, filter the displayed transactions by date.

5. If necessary, sort the transactions using the Sort By field.

6. To clear log items, select a log maintenance option and choose Process.

• If you select Clear successful transactions, log items with a Success status will be cleared.

• If you select Clear all through Date, log items with a date through your specified date will be cleared.

• If you select Clear all log entries for, log items from your specified tables (Download and/or Upload) will be cleared.



Chapter 33: ErrorsThis portion of the documentation describes errors that may occur when using Warehouse Management Integration.


• General error codes• SOP errors• POP errors• Inventory errors• Manufacturing errors

General error codes

The following table describes the errors associated with specific error codes in Warehouse Management Integration.

Error Code Error

1 Low on memory

2 Database manager not initialized

3 Database manager not supported

4 Too many tables opened

5 Record length too long

6 Too many keys for database type

7 Too many segments

8 Table not registered

9 Table not found

10 Locked recordThe above error is an indication that another Microsoft Dynamics GP user has the specific document open in one of the Microsoft Dynamics GP Transaction windows

11 Table name error

12 Table not open

13 Table not opened exclusive

14 Invalid command sent to database manager

15 Key number doesn't exist

16 End of fileThe above error indicates that the specific record no longer exists in the Microsoft Dynamics GP database

17 Duplicate recordThe above error indicates a record with the current primary index (unique) values already exists in the database

18 Missing recordThe above error indicates that the specific record no longer exists in the Microsoft Dynamics GP database

19 A set is already active

20 Transaction in progress

21 Not a variable length table

22 No table definition could be found

23 Attempted to lock two records

24 No lock on update

C H A P T E R 3 3 E R R O R S


SOP errors

Process holdsWhen the processing of a pick confirmation back into a Microsoft Dynamics GP sales document fails validation, one or more RBI SOP Holds will be assigned to the document. The document will remain “Locked by WMS” to prevent further activity against the document until the failure is resolved.

Further resolution typically consists of managing the sales document line item quantities manually so they are consistent with actual warehouse activity.

This process should be performed by advanced users only. Use caution when modifying table records directly, as it’s possible to make edits that will later result in errors.

25 Table doesn't match definition

26 The disk is full

27 Unknown error [27]

28 A non-modifiable key changed

29 Not a variable length field

30 A record was changed with a passive lockThe above error indicates that the record currently being modified was changed by another Microsoft Dynamics GP user prior to saving the current changes

31 DeadlockedThe above error indicates that multiple Microsoft Dynamics GP users have attempted to update the same record at the same time

32 Path not found

33 Buffer error

34 Error in creating a Btrieve table

35 Invalid key definition

36 Maximum number of SQL connections reached

37 Error accessing SQL data

38 Error converting SQL data

39 Error generating SQL data

## Unexpected Error Code [##]



To correct a document with process holds:1. Open the Sales Order Release Management window.


2. Select the document and zoom on the Sales Order Number column heading. Then examine the holds to assess the failures.



Document lock errorsThis procedure describes how to unlock a document that should not be locked.

This process should be performed by advanced users only. Use caution when modifying table records directly, as it’s possible to make edits that will later result in errors.

To unlock documents:1. Disable the Warehouse Management Integration product.

(Microsoft Dynamics GP Menu >> Tools >> Customize >> Customization Status)

Select Warehouse Management Integration and choose Disable.

2. Open the SOP Document in the Sales Transaction Entry window (Transactions >> Sales >> Sales Transaction Entry). You will be able to open the document even though it is “Locked by Accellos WMS.”

3. Remove the SOP Holds from the document.

4. Manage the Line Item Quantities so they are consistent with what was actually fulfilled by the warehouse. Then save the Sales Document.

5. Change the Sales Document Release Status by running a MS/SQL Update Query against the RBI13000 table or by using the WMI “Upload/Download Browser”:

• Update Query:

update RBI13000 set RBI_Release_Status to 5 where DOCNUMBR = '<document number>'

Note: Replace <document number> with your document number

• WMI Upload/Download Browser:

Choose Add >> Add Window from the Shortcuts menu. Then choose Warehouse Mgt. Integration >> Company >> WMI Upload/Download Browser. Choose Add.

Open the Upload/Download Browser and select the Upload table option. Then expand the scroll by using the expansion button. Browse through the scroll until you locate the “XC / UPLOADED / Unlock” transaction for your Sales Document:

Change the 1 (one) in the first column to a 0 (zero) and click “Redisplay”.



Again browse through the scroll until you locate the “XC / UPLOADED / Unlock” transaction for your Sales Document and verify that the first column is now a zero:

Note: The WMI Upload Processor may have run in the interim and removed the record from the Upload table.

The next WMI Upload Processor cycle should process the “XC / UPLOADED / Unlock” transaction and the Sales Document should no longer be “Locked By Accellos WMS.”

6. Enable the Warehouse Management Integration product.(Microsoft Dynamics GP Menu >> Tools >> Customize >> Customization Status)

Select Warehouse Management Integration and choose Enable.

7. The SOP Document should now have a status other than Locked and can continue through its typical life cycle.

SOP hold descriptionsThis section provides a list of the SOP holds in Warehouse Management Integration.

Hold Code Description

RBI BAD PICKQTY Total quantity picked not even multiple of base UofM

“Invalid QTY Packed [####]. Base U of M [##]. Decimals QTY [##].”

RBI OVERPICK Total quantity picked exceeds unfulfilled quantity remaining

“QTY Picked [####] > QTY Remaining [####]”



Other SOP errorsThis section provides a list of other SOP errors in Warehouse Management Integration.

POP errors

POP error descriptionsThis section provides a list of the POP errors in Warehouse Management Integration.

RBI WRONG ITEM Item Number picked not the same as the SOP Line Item

“Item Picked [<Item Number>] different from SOP Line [<Item Number>] for SOP Document [<SOP Number>][<SOP Line Sequence Number>]”

“Error [<BMI_ErrorText>] reading Item Master for [<Item Number>]”

RBI SHORTAGE Insufficient inventory available in Microsoft Dynamics GP

RBI SOLD Serial / Lot Number picked is marked as Sold in Microsoft Dynamics GP

RBI DIFFERENT Serial / Lot Number picked is different from what was allocated in Microsoft Dynamics GP

RBI NOT IN IV Serial / Lot Number picked is not in Microsoft Dynamics GP

Cause Description

Missing SOP Line record “Error [<BMI_ErrorText>] reading SOP Line for [<SOP Number>][<SOP Line Sequence Number>]”

Missing SOP Header record “Error [<BMI_ErrorText>] reading SOP Header for [<SOP Number>][<SOP Line Sequence Number>]”

Setup table has bad value in “Lot Attribute” field (must be 1)

“Unexpected LOT NUMBER ATTRIBUTE in RBI Setup table [##] received for [<Item Number>]”

Setup table has bad value in “Serial Attribute” field (must be 2)

“Unexpected SERIAL NUMBER ATTRIBUTE in RBI Setup table [##] received for [<Item Number>]”

Database lock on the Sales Document Header record. This occurs during Sales Document Line Item Pick transactions.

“[XC] Upload record not deleted as per lOK2Delete flag.”

The XC transaction will be left in the UPLOAD table for the next processing cycle.

If the lock results from a workstation or server crash, the XC transaction will continue to be left in the UPLOAD table until the underlying cause of the lock is corrected.

Error Code Description

DUPLICATE Already exists in database

MISSING Not found in database

HISTORY Already exists in history

LOCKED Locked (being accessed) by another user

STATENOTAVAIL Document is not currently available for editing

BATCHACTIVITYERROR Batch being accessed by another user

MARKED_TO_POST Batch is marked for posting

VOID Receipt document has been marked as VOID

INVALIDDATE Date is invalid

MCXRATE_MISSING MultiCurrency exchange rate is missing

INVALIDDOCTYPE DropShip PO only allowed on Invoices

VENDORERR Duplicate vendor document error



Inventory errors

This section provides a list of the inventory errors in Warehouse Management Integration.

INACTIVE Vendor is marked as Inactive

NOCREDIT Vendor has $0.00 credit

MISSINGVEND Vendor not set for this receipt

INVALIDOPERATION Attempt to write to a read-only record

MISSINGPOITEM The Item wasn’t entered on the purchase order

MISSINGITEM Item has been deleted from IV

NOTRECEIVABLE Kit item

POP_POLINESTAT_CANCELED PO Line has been canceled

POP_POLINESTAT_CLOSED PO Line has been closed

HISTORICAL PO exists in history

POPRCPT_POCURRENCYINVALID

Currency on Receipt is not same as on PO

POP_POSTAT_CLOSED PO has been closed

POP_POSTAT_CANCELED PO has been canceled

VENDORERR PO does not have same vendor

OUTOFBALANCE Incorrect number of Serials/Lots

MULTIPLE_SHIPMENTS_EXIST Multiple shipments exist to match for this invoice line

INVALIDAMOUNT QTY Shipped minus QTY Rejected is less than QTY Invoiced

UNKNOWN [<error number>] Unknown / Unexpected error



Inventory transaction (MT and SC) errorsError Types Description

Header Errors

“Error creating Job Transaction Header:”

Note: Errors that refer to Document Number should include review of Microsoft Dynamics GP Inventory Setup for Adjustment, Variance and Transfer Document Numbering

Reconcile in process

Invalid next document number (0 or empty)

Next document number too long

Attempt to increment empty document number

Selected document number already in history

GL Posting Date (<date>) is in closed period

GL Posting Date (<date>) not in fiscal year

Duplicate Inventory Transaction Work Header record

Unexpected Error Code [####] saving Batch_Headers

Line Errors:

“Error creating Job Transaction Line:”

Note: All Items must have “IV Index”, “IV Offset” and “IV Variance” accounts assigned

Job Transaction Header record not found

Item Master record (<Item Number>) MISSING

Item Number (<Item Number>) missing U Of M Schedule

Item Number (<Item Number>) type not equal INVENTORY and not equal DISCONTINUED

Item Number (<Item Number>) invalid or missing UofM

Unable to get Quantity in UofM for Item Number (<Item Number>)

Invalid Location

Location does not exist

Transfer to Location does not exist

Quantity shortage when doing a negative quantity adjustment or variance for Item Number (<Item Number>)

Quantity shortage when doing a transfer for Item Number (<Item Number>)

Error saving IV_TRX_WORK_LINE record

Account Number not assigned to this item

Unexpected Error Code [####]

Serial/Lot Line Errors:

“Error creating Serial/Lot Transaction Line: “

Missing Document Number

Missing line sequence number

Missing serial/lot number

Missing serial/lot quantity

Item Number [<Item Number>] does not exist

Item Number does not exist in Location

Serial Number already exists

Serial Number already exists in another work table

Serial Number does not exist in Location

From Quantity Type (1) for serial number does not exist in Location

Transfer To Serial Number already marked as sold

Saving Serial Number

Serial Numbered Item has wrong QTY Type

Serial Number has already been sold

Saving IV_TRX_WORK_Serial_Lot record

Lot Number already marked as sold

Lot Number Quantity Type invalid in table

Unexpected Error Code [####] saving IV_Lot_Attributes

Unexpected Error Code [####]



Inventory transfer (MT/SM) errorsMT/SM transactions produce the same range of errors as other MT transactions described in the previous section. However, the following suffix is appended to MT/SM errors:

“processing MT/SM for [<Item Number>] from [<From Site>] to [<To Site>]”

Manufacturing errors

This section provides a list of manufacturing errors in Warehouse Management Integration.

Other Errors Error reading Item Master record for the Item

“Error [<BMI_ErrorText>] reading Item Master for [<Item Number>]”

Missing Record errors may indicate that the Item has not been defined

Error reading Master Quantities record for the Item / Site

“Error [<BMI_ErrorText>] reading Item Master Quantities for [<Item Number>] at [<Site ID>]”

Missing Record errors may indicate that the Item has not been assigned to the Site

One or more IV Account is missing from the Item Master data

“Error creating Job Transaction Line: Account Number not assigned to this item”

All Items must have “IV Index”, “IV Offset” and “IV Variance” accounts assigned

Sum of Bin Quantity not equal Total Quantity

“SC records for [<Item Number>] “out of balance [<Sum Bin QTY>] > [<Total OnHand>]”

This error indicated a discrepancy in quantity data for this item as uploaded by WMS

Cause Description

MO Security lock on the manufacturing order.

This occurs with Manufacturing Order Component Pick transactions and Manufacturing Order Finished Goods Receipt transactions.

“[XC] Upload record not deleted as per lOK2Delete flag.”

The XC transaction will be left in the UPLOAD table for the next processing cycle.

If the lock results from a workstation or server crash, the XC transaction will continue to be left in the UPLOAD table until the underlying cause of the lock is corrected.


Appendix A: Data tablesThis portion of the documentation provides information about the data tables created by Warehouse Management Integration.

Data table physical names and descriptionsThe following table shows the physical name and description for each data table created by Warehouse Management Integration:

Series Physical Name Description

Company RBI40700 IV Location Extended Data

RBI00300 Release Master

RBI13000 Release Work

RBI00010 Setup

Temp Setup (temporary)

UPLOADRC Upload RC

DNLOAD Download

Temp Download (temporary)

RBI00020 Log

UPLOAD Upload

Temp Upload (temporary)

RBI00800 Upload Activity

WMICONF Config File Settings

RBI00021 Processing Log

RBI30021 Processing Log History

WMI10500 SQL Auto Release

A P P E N D I X A D A T A T A B L E S


Inventory Temp ILS XRef Holder (temporary)

Temp Lot Number Allocations (temporary)

RBI30040 MO Picklist Confirmation History

Temp MO Picklist Confirmation (temporary)

RBI10040 MO Picklist Confirmation Work

RBI30300 MT History

Temp MT (temporary)

Temp Release (temporary)

Temp SC (temporary)

RBI32300 Transfer Header History

RBI12300 Transfer Header Work

RBI32301 Transfer Line History

RBI12301 Transfer Line Work

Temp VA (temporary)

Temp XC (temporary)

RBI40400 Country of Origin Master

RBI40300 Hazmat Category Setup

Temp Hazmat Type Selection (temporary)

RBI10300 Batch Processor

RBI30103 IV Item Customer Master

Temp IV Item Customer Master (temporary)

RBI31101 IV Item Master Extended

Temp IV Item Master Extended (temporary)

RBI40103 IV Item Master Vendor Extended

Temp Invalid Product Codes (temporary)

Temp MT History (temporary)

Temp MT SM Invalid (temporary)

Temp MT SM (temporary)

Temp Transfer Line History (temporary)

Temp Transfer Line Work (temporary)

WMI00102 Pending Status Changes

RBI10001 Reason Code Master

WMI00200 Stock Count Security

Temp Stock Counts Error (temporary)

WMI00100 Stock Counts Open

RBI00400 Work Area ID Master

WMI00090 UPC MFG Codes

Payroll RBI21300 PO Batch Processor



Project RBI30030 MO Component Transaction History

RBI30031 MO Component Transaction Serial/Lot History

RBI10031 MO Component Transaction Serial/Lot Work

RBI10030 MO Component Transaction Work

RBI10023 MOP Item Master Extended

RBI10233 MOP Item Master Extended History

RBI10022 MOP Order Master Extended

RBI10232 MOP Order Master Extended History

RBI05501 Codes RMA Type Extended

RBI06501 Codes RTV Type Extended

RBI90002 MOP Comp Trx Items Tab

RBI90001 MOP Comp Trx Pick Doc Tab

RBI90010 MOP Receipt Inquiry

Temp MOP Order Master (temporary)

Temp MO Comp Trx Serial Lot Alloc (temporary)

RBI30050 MO FG Header History

RBI10050 MO FG Header Work

RBI30051 MO FG Line History

RBI10051 MO FG Line Work

RBI30060 MO RC History

RBI10060 MO RC Work

RBI05001 RMA Posting (temporary)

Purchasing Temp Purchase Order Line (temporary)

RBI20100 Receipt Confirmation History

Temp Manifest Line Work (temporary)

RBI41200 PM Vendor Master Extended

RBI21200 PO Line Extended

RBI31110 PO Line Extended History

Temp PO Line Extended History (temporary)

Temp PO Line Extended (temporary)

RBI21100 PO Ext

RBI31105 PO Ext History

Temp PO Synchronize (temporary)

Temp RC (temporary)

RBI05200 RMA History

Temp UP (temporary)



You can also view Warehouse Management Integration table information using the Table Descriptions window in Microsoft Dynamics GP (Microsoft Dynamics GP Menu >> Tools >> Resource Descriptions >> Tables).

Sales RBI10055 MFG FG Posting SOP Update Work

Temp Pick Confirmation History (temporary)

RBI10200 Pick Confirmation History

Temp Pick Confirmation (temporary)

RBI10100 Pick Confirmation Work

RBI10211 Serial/Lot Work/History Temp

RBI10202 Track and Trace Master

RBI40101 Item Store Customer Master

Temp PZ (temporary)

RBI40201 Process SOP Process Holds

RBI30102 Customer Master Address Extended

Temp Customer Master Address Extended (temporary)

RBI30101 Customer Master Extended

Temp Customer Master Extended (temporary)

RBI06200 RTV History

RBI11100 SOP Header Work Extended

RBI31100 SOP Header Work Extended History

Temp SOP Header Work Extended History (temporary)

RBI40200 SOP ID Setup Extended

RBI11200 SOP Line Work Extended

RBI31200 SOP Line Work Extended History

Temp SOP Line Work Extended (temporary)

Temp SOP Synchronize (temporary)

Temp Timestamp (temporary)

RBI10201 Serial/Lot Work/History Extended Data

Temp Serial/Lot Work/History Extended Data (temporary)

WMI10200 Shipment Line

WMISOHDR SOP Header Auto Release

WMISOLIN SOP Line Auto Release

WMI00900 Ship Payment Terms

Temp Shipment Header (temporary)

Temp Shipment Line (temporary)

WMI10201 Track and Trace Master

Temp Track and Trace Master (temporary)

System BMI00991 Blue Moon Industries Product Registration

BMI00100 Blue Moon Industries Table Versions

3rd Party Temp MOP Synchronize (temporary)


Appendix B: Accellos WMS quick referenceThis portion of the documentation provides additional reference material for Warehouse Management Integration and Accellos WMS.

Cycle Count and Stock Count Calculations

Cycle Count When a bin location is cycle counted, Accellos WMS calculates the difference between the expected quantity and the counted quantity. The difference is then used in a Misc. Transaction with a type of Cycle Count (MT/CC).

Example: Accellos WMS has a current count of 20 for a product in a specific bin/location. The warehouse cycle count indicates the bin/location quantity as 26. Accellos WMS calculates the difference and sends an MT/CC transaction to Warehouse Management Integration of +6.

Warehouse Management Integration will use the difference value in an inventory “Variance” transaction in Microsoft Dynamics GP for the additional 6 sent from Accellos WMS.

Stock Count When a full physical inventory (Stock Count) is completed, the absolute value of the physical count by product/location is used in one or more Misc. Transactions with a type of Cycle Count (MT/CC).

Example: Accellos WMS has a current count of 20 for a product in a specific bin/location, and another 100 in an overstock location. The warehouse performs a stock count for both locations and counts 26 and 100 respectively. Accellos WMS sends a pair of MT/SC transactions for the absolute value of the inventory count by location (one for +26 and one for +100).

Warehouse Management Integration combines like product counts and calculates the difference between the Microsoft Dynamics GP on hand quantity for that site and the calculated quantity. Assuming the Microsoft Dynamics GP site had an on hand quantity of 120, the calculated difference is used to create a “Variance” transaction in Microsoft Dynamics GP of +6.

Accellos WMS Qty Warehouse Cycle Count Qty Transaction

20 26 + 6

Accellos WMS Qty Overstock Location Microsoft Dynamics GP Quantity

Transaction

20 100 120 + 6

A P P E N D I X B A C C E L L O S W M S Q U I C K R E F E R E N C E


Physical Inventory Process Checklist

Use the following instructions to ensure the accuracy of the physical inventory process.

1. Ensure all activity that affects inventory in Microsoft Dynamics GP and Accellos WMS has been halted.

2. In Accellos WMS, ensure no inventory is located in any system location (Example: Receive or Transit). Also ensure that all orders are in an un-allocated state.

3. In Accellos WMS, turn off the Upload Thread. Ensure the Accellos WMS download table is empty. Then turn off the Download Thread.

4. In Microsoft Dynamics GP, ensure the upload table (UPLOAD) is empty. If the table is not empty, correct and re-process transactions in the table until it is cleared of all transactions that affect inventory quantities.

5. In Microsoft Dynamics GP, ensure that all documents that affect inventory have been posted. These include invoices, inventory adjustments, and PO receipts. Any orders with fulfilled quantities should be transferred to invoices and posted. Run the SOP and POP Reconcile utility to ensure accuracy. In addition, run the Microsoft Dynamics GP Inventory Reconciliation utility prior to the next step.

6. In Microsoft Dynamics GP, print the inventory stock status report.

7. In Accellos WMS, print an inventory report.

8. In Accellos WMS, use the Inventory Wizard to save the book inventory and to complete the steps in the “Full Count” inventory process. Once the inventory is completed, use the Wizard to update Microsoft Dynamics GP.

Note: The inventory upload process must be run separately for each warehouse/site setup in Accellos WMS.

Note: The current Accellos WMS physical inventory process creates Cycle Count Transactions in the upload table while the inventory is being counted. These transactions are not required by Microsoft Dynamics GP and you should delete them from the upload table prior to performing the “Upload Inventory” step.

9. In Accellos WMS, run an inventory report to be used to compare the results of the inventory with Microsoft Dynamics GP once the Variance batch has been posted.

10. In Microsoft Dynamics GP, check the “Upload” table (UPLOAD) to ensure all uploaded transactions were processed. If there are remaining transactions, troubleshoot the transactions and correct them.

Uploaded transactions will appear in the Stock Count Processor window. Then create inventory variance transactions using the Stock Count Processor window. For more information about this window, refer to Stock count processor utility on page 131.

In addition, some items may have no quantities in Accellos WMS and are not associated with a dedicated bin. However, such items may have quantities in Microsoft Dynamics GP. Determine if any items meet this criteria using the appropriate methods. Some customers have developed custom reports that produce this information. Once identified, these adjustments will need to be manually added to the physical inventory batch created by the physical inventory process prior to posting.



Once all of the physical inventory transactions have been processed, print the batch edit list and review for accuracy prior to posting in Microsoft Dynamics GP. Once posted, run stock status and stock status with value reports in Microsoft Dynamics GP. These reports should equal the quantity on the Accellos WMS Inventory report. If not, additional research will be needed to identify any discrepancies and adjustments that will be required to balance the systems.

Note: It is also recommended to run the Microsoft Dynamics GP/Accellos WMS inventory variance report, which is available from Blue Moon in Crystal Reports format. No variances should appear on this report. If variances do appear, additional research will be needed to identify any discrepancies and adjustments that will be required to balance the systems.


I N D E X

Index

AAdditional inventory information 123, 124Assembly instructions 87Assembly notes 86Assembly transactions 119

BBackorders 48Bar code options 25Bill To - Ship To Notes 67, 68

Viewing 70Bill To - Ship To Notes window 68, 69, 71Blue Moon Product Registration window 19

CCustomer holds 37

DData tables 181Default Address Fulfillment Options window

50Default fulfillment instructions 55Default Fulfillment Instructions window 56Default fulfillment options 49Default Fulfillment Options window 48Default picking information 75

EEDI information 61, 62

Viewing 64Errors 171

FField Service document release 147Field Service Options window 137Field Service setup 137Fulfillment indicators 43Fulfillment instructions 55, 57, 163

Viewing 58, 164Fulfillment Instructions window 58, 59, 163,

164Fulfillment options 47, 50

Default 47Viewing 52

Fulfillment Options window 51, 53

HHazmat categories 123Hazmat Category Setup window 123Hold indicators 43

IInstallation 14In-transit site 24Inventory Setup window 24Inventory utilities 129Item Additional Options window 124Item Detail EDI Information Entry window 64,

66

Item Kit Maintenance window 116Item master synchronization utility 129Item Master Synchronization window 129Item Vendor Options window 125

KKit components 116Kits 115

LLot number overrides 25

MManaged sales document types, about 35Manufacture Order Release Inquiry window

161Manufacture Order Release Management 161Manufacture Order Release Management

window 160Manufacture Order Release Synchronization

window 165Manufacturing document release 159Manufacturing document release

synchronization utility 165Manufacturing documents

Recalling 160Releasing 159

Manufacturing Options window 157Manufacturing setup 155

PPicking information 75Picking Information Maintenance window 75Picking Instructions window 77, 79Posting setup compatibility 30Posting Setup window 30Price label information 73, 74Price Labeling Maintenance window 73PRO number 83PRO Number Tracking by Sales Document

window 84Process holds 37Processing log utility 169Product code 26Product code conversion utility 130Product Code Conversion window 130Purchase Order Release Management window

100, 101Purchase Order Release Status Inquiry window

102Purchasing document release 99Purchasing documents

Recalling 101Releasing 100

Purchasing Options window 96Purchasing setup 95

RRBI Processing Log Inquiry window 169Reason Code Setup window 127Reason codes 127Registration 19

Returns Release Management window 148, 149

RMA documentsRecalling 149Releasing 148

RTV transactions 139RTV types 139

SSales document release 39Sales document release synchronization utility

89Sales Document Tracking by Item Number

window 82Sales Document Tracking by Track & Trace

window 81Sales Document Tracking window 83Sales documents

Recalling 41Release status 42Releasing 40

Sales options 35Sales Options window 36Sales Order Release Management window 40,

41Sales Report Writer extensions 91Sales Transaction EDI Information Entry

window 63, 65Security 17Serial number overrides 25Setup

Backoffice 23General 23Inventory 23Sales 35

Shipment tracking 81Shipping charges 37Site mapping 24Stock count processor utility 131Stock Count Processor window 132Store Name Maintenance window 62Store names 61

Setup 61Store numbers 62

Viewing 64Store Price Labeling Maintenance window 74

TTrack & trace information 81Tracking information 82

UUninstalling 20Upload processor 28Utilities

Item master synchronization 129Manufacturing document release

synchronization 165Processing log 169Product code conversion 130Sales document release synchronization

89

I N D E X


Stock count processor 131

VVendor item options 125

WWarehouse Management Integration Setup

window 23Work Area and Notes window 87Work area ID 24Work Area Inquiry window 86Work Area Maintenance window 85Work areas 85, 86, 87Work Order Release Management window 120Work orders

Releasing 120

W A R E H O U S E M A N A G E M E N T I N T E G R A T I O N

Documentation Comment FormWarehouse Management Integration (Release 10.0)February 11, 2009

We welcome your comments and suggestions regarding the quality and usefulness of this manual. Your comments help us improve the documentation to better meet your needs.

• Did you find any errors?

• Is the information clearly presented?

• Are the examples correct? Do you need more examples?

• What features do you like most (and least) about the documentation?

If you find errors or have specific suggestions, please note the topic, chapter, and page number.

Send your comments using any of the following methods:

Thank you for taking the time to help us improve our documentation.

Note: By offering any suggestions to Blue Moon Industries, you give Blue Moon Industries full permission to use them freely.

E-mail [email protected]

Fax 401.276.9009(On the cover sheet, specify that the fax should be routed to the Documentation Lead)

Conventional mail Documentation LeadBlue Moon Industries295 Promenade StreetProvidence, RI 02908USA