Design Documents and Transaction Flows

The following topics provide detailed explanations about the tables and table fields for master records and transaction records in Microsoft Dynamics GP. This information is broken down by series and module. This information will assist developers that access the database tables directly for integrations.

Foundation

System Manager

• Company Information (Taxes, Internet Information, and Record Notes)

Financial

General Ledger

• GL Transaction Entry Transaction Flows
• GL Budget Transaction Entry Transaction Flows
• Budget Master Import Guidelines
• Account Master Import Guidelines

Analytical Accounting

• Analytical Accounting Table Design

Bank Reconciliation

• Bank Reconciliation Deposit Entry Transaction Flows
• Bank Reconciliation Import Guidelines

Bank Management

• Bank Management Table Design

Multilingual Checks

• Multilingual Checks Table Design

Multidimensional Analysis

• Multidimensional Analysis Transaction Flows
• Multidimensional Analysis Setup

Electronic Banking

• Electronic Reconcile EFT Module Transaction Flows
• Payables Management EFT Module Transaction Flows
• Receivables Management EFT Module Transaction Flows
• Safe Pay EFT Module Transaction Flows

Withholding Certificates

• Withholding Certificates

Sales

Receivables Management

• RM Transaction Entry Transaction Flows
• Customer Master Import Guidelines

Sales Order Processing

• SOP Transaction Entry Transaction Flows

Invoicing

• Invoicing Transaction Entry Transaction Flows

Purchasing

Payables Management

• PM Transaction Entry Transaction Flows
• Vendor Master Import Guidelines

Purchase Order Processing

• POP Transaction Entry Transaction Flows

Inventory

Inventory

• Inventory Transaction Entry Transaction Flows
• Item Master Import Guidelines
• Item Stock Inquiry Flow
• Lot Consolidation Flow

Bill of Materials

• Bill of Materials Processing Transaction Flows

Shipping Documents

• Shipping Documents

Human Resources/Payroll

Payroll

• UPR Transaction Entry Transaction Flows
• Payroll Master Import Guidelines

Human Resources/Payroll

• Human Resources Applicant
• Human Resources Attendance
• Human Resources Benefits
• Human Resources Defaults
• Human Resources Employee
• Human Resources Organization
• Human Resources Index
• Human Resources System

Direct Deposit

• Direct Deposit

Canadian Payroll

• Payroll Master Import Guidelines