Streamline Dynamics GP: Mastering Default Accounts in Purchase Item Detail Entry

Table of Contents

Understanding how default accounts are populated in Microsoft Dynamics GP is crucial for maintaining accurate financial records and streamlining purchasing processes. Specifically, the Purchasing Item Detail Entry window relies on a hierarchy of settings to determine the default accounts for inventory, purchases, and drop-ship items. This article provides a comprehensive guide to mastering these default account settings, ensuring efficiency and accuracy in your Dynamics GP system. By understanding the source of these default values, users can effectively manage their financial data and reduce manual data entry.

Inventory Account Defaults¶

The Inventory Account field within the Purchasing Item Detail Entry window is automatically populated based on a predefined hierarchy. This default mechanism is designed to simplify data entry and ensure consistency across transactions. Let’s explore the steps Dynamics GP takes to determine the default inventory account.

Item Account Maintenance Window¶

The primary source for the default Inventory Account is the Item Account Maintenance window. This window allows you to define specific accounts for individual inventory items. To access this window, follow these steps within Dynamics GP:

1. Navigate to the Cards menu.
2. Hover over Inventory.
3. Click on Item.
4. Finally, click Accounts.

Within the Item Account Maintenance window, locate the Inventory field. If an account number is specified in this field, it will be used as the default Inventory Account in the Purchasing Item Detail Entry window. This item-specific setting provides the most granular level of control over account defaults.

Posting Account Setup Window¶

If the Inventory field in the Item Account Maintenance window is left blank, Dynamics GP will look to the Posting Account Setup window for the default inventory account. This window provides a system-wide default account for inventory. To access the Posting Account Setup window:

1. In Microsoft Dynamics GP, navigate to the Microsoft Dynamics GP menu.
2. Hover over Tools.
3. Hover over Setup.
4. Hover over Posting.
5. Click Posting Accounts.
6. In the Display List, select Inventory.

Within the Posting Account Setup window, find the Inventory Control field. If an account number is entered here, and no account was specified in the Item Account Maintenance window for the specific item, this account will be used as the default Inventory Account in the Purchasing Item Detail Entry window. This ensures a default account is used even if item-specific settings are missing.

Empty Inventory Account Field¶

In the event that no inventory account number is found in either the Item Account Maintenance window or the Posting Account Setup window, the Inventory Account field in the Purchasing Item Detail Entry window will remain empty. This scenario indicates a gap in your account setup and requires immediate attention to ensure proper financial tracking. Users should review their item and posting account setups to define an appropriate default inventory account.

Purchases Account Defaults¶

Similar to the inventory account, the Purchases Account field in the Purchasing Item Detail Entry window also defaults based on a hierarchical system. This ensures that purchase transactions are correctly categorized and recorded in your financial statements. Let’s examine the sources for the default purchases account.

Vendor Account Maintenance Window¶

The primary source for the default Purchases Account is the Vendor Account Maintenance window. This window allows you to assign specific accounts to individual vendors. To access this window:

1. Navigate to the Cards menu.
2. Hover over Purchasing.
3. Click on Vendor.
4. Click Accounts.

Within the Vendor Account Maintenance window, locate the Purchases field. If an account number is entered in this field, it will be used as the default Purchases Account in the Purchasing Item Detail Entry window. This vendor-specific setting allows for tailored account assignments based on your vendor relationships.

Posting Account Setup Window (Purchases)¶

If the Purchases field in the Vendor Account Maintenance window is empty, Dynamics GP will then look to the Posting Account Setup window for a default purchases account. This acts as a system-wide fallback if vendor-specific settings are missing. To access the Posting Account Setup window (as described previously):

1. In Microsoft Dynamics GP, navigate to the Microsoft Dynamics GP menu.
2. Hover over Tools.
3. Hover over Setup.
4. Hover over Posting.
5. Click Posting Accounts.
6. In the Display List, select Inventory (Note: While the Display List says Inventory, the Posting Account Setup window is used for various posting accounts, including Purchases).

Within the Posting Account Setup window, locate the Purchases field. If an account number is present here, and no account was defined in the Vendor Account Maintenance window, this account will be used as the default Purchases Account in the Purchasing Item Detail Entry window. This ensures a default purchase account is available even without vendor-specific configurations.

Empty Purchases Account Field¶

If no purchases account number is found in either the Vendor Account Maintenance window or the Posting Account Setup window, the Purchases Account field in the Purchasing Item Detail Entry window will be left blank. This signals a missing account setup that needs to be rectified to ensure accurate recording of purchase transactions. Review both vendor and posting account setups to establish a default purchases account.

Drop-Ship Account Defaults¶

The Drop-Ship Account field in the Purchasing Item Detail Entry window, used for items directly shipped from the vendor to the customer, also follows a default hierarchy. Properly configuring this account ensures accurate tracking of drop-ship transactions. Let’s examine the sources for this default.

Item Account Maintenance Window (Drop-Ship Items)¶

The primary source for the default Drop-Ship Account is again the Item Account Maintenance window. This window allows item-specific settings for drop-ship accounts. To access this window (as described previously):

1. Navigate to the Cards menu.
2. Hover over Inventory.
3. Click on Item.
4. Click Accounts.

Within the Item Account Maintenance window, locate the Drop Ship Items field. If an account number is entered here, it will be used as the default Drop-Ship Account in the Purchasing Item Detail Entry window. This item-level setting provides specific control over drop-ship account assignments.

Posting Account Setup Window (Drop-Ship Items)¶

If the Drop Ship Items field in the Item Account Maintenance window is blank, Dynamics GP will look to the Posting Account Setup window for a default drop-ship account. This provides a system-wide default if item-specific settings are absent. To access the Posting Account Setup window (as described previously):

1. In Microsoft Dynamics GP, navigate to the Microsoft Dynamics GP menu.
2. Hover over Tools.
3. Hover over Setup.
4. Hover over Posting.
5. Click Posting Accounts.
6. In the Display List, select Inventory.

Within the Posting Account Setup window, locate the Drop Ship Items field. If an account number is present here, and no account was set in the Item Account Maintenance window, this account will be used as the default Drop-Ship Account in the Purchasing Item Detail Entry window. This ensures a default drop-ship account is used even without item-specific settings.

Empty Drop-Ship Account Field¶

If no drop-ship account number is found in either the Item Account Maintenance window or the Posting Account Setup window, the Drop-Ship Account field in the Purchasing Item Detail Entry window will be empty. This indicates a missing account setup that needs to be addressed to properly track drop-ship transactions. Review both item and posting account setups to define a default drop-ship account.

Project Accounting Considerations¶

When Project Accounting is registered within Dynamics GP, and project-related fields such as Project Number and Cost Cat. ID are populated in the Purchasing Item Detail Entry window, the account defaulting behavior is influenced, particularly for non-inventoried items. The behavior also differs between versions of Dynamics GP, specifically before and after Microsoft Dynamics GP 10.0 Service Pack 3.

Versions Earlier Than Microsoft Dynamics GP 10.0 Service Pack 3¶

In versions of Dynamics GP prior to 10.0 Service Pack 3, when Project Accounting is active and project details are entered in the Purchasing Item Detail Entry window, non-inventoried items may not post to the Purchasing Account displayed in the window for subsequent receiving transactions. This is because the system prioritizes project accounting settings in these older versions, potentially overriding the standard purchasing account defaults for non-inventoried items when project information is involved. Users on older versions should be aware of this behavior to ensure correct account postings for project-related purchases of non-inventoried items.

Microsoft Dynamics GP 10.0 Service Pack 3 and Later Versions¶

Starting with Microsoft Dynamics GP 10.0 Service Pack 3, significant changes were implemented to provide a more accurate representation of the account used during the receiving process, especially for non-inventoried items in project accounting scenarios. These changes aim to clarify and improve the account defaulting behavior in project-related purchasing. Let’s explore specific scenarios for non-inventoried items under project accounting in these later versions.

Cost Plus and Fixed Price Projects¶

For Cost Plus and Fixed Price project types, the Work in Process (WIP) account from the source window will be displayed as the default account in the Purchasing Item Detail Entry window. This ensures that costs associated with these project types are correctly tracked in the WIP account during the purchasing process.

Time and Materials Projects - When Billed Accounting Method¶

For Time and Materials project types that utilize a When Billed value in the Accounting Method field, the Work in Process (WIP) account from the source window will also be displayed. This aligns with the revenue recognition approach of “when billed,” where costs are initially accumulated in WIP until the project is billed.

Time and Materials Projects - When Performed Accounting Method¶

For Time and Materials project types with a When Performed value in the Accounting Method field, the Cost of Goods Sold account from the source window will be displayed. This reflects the “when performed” revenue recognition approach, where costs are expensed to Cost of Goods Sold as services are performed, rather than being held in WIP.

Time and Materials Projects - Non-billable or No Charge Budgets¶

For Time and Materials projects where the budget is set up with a Bill Type of Non-billable or No Charge, the Cost of Goods Sold account from the source window will be displayed. Since these budget types are not intended for billing, costs are directly expensed to Cost of Goods Sold.

Time and Materials Projects - WIP Account Sourced to None¶

For Time and Materials projects with a When Billed accounting method, and where the WIP account is sourced to None, the Cost of Goods Sold account from the source window will be displayed. In this specific configuration where WIP tracking is explicitly disabled, costs are directly expensed to Cost of Goods Sold.

By understanding these nuances in account defaulting, especially within the context of Project Accounting and different Dynamics GP versions, users can ensure accurate financial postings and streamlined purchasing workflows. Regularly reviewing and verifying default account settings is a best practice for maintaining data integrity and operational efficiency within Dynamics GP.

Do you have any experiences or questions regarding default account settings in Dynamics GP Purchasing Item Detail Entry? Share your thoughts in the comments below!