If you use other application areas in addition to General Ledger
and post to accounts such as Customers, Vendors, Items, or
Resources, you must set up a link between these accounts and the
G/L accounts. If you only use the General Ledger application area,
it is not necessary to set up posting groups.
Posting Groups are used to create these links between the
different application areas and the General Ledger application
area. As a result, you must have set up the chart of accounts
before you can create posting groups. When sales, purchases, and
other transactions are recorded and posted where a specific G/L
Account is not specified directly, Posting Groups provide the
mapping to the correct accounts. For example, in the sale of an
item to a Customer on a Sales Order, no general ledger accounts are
specified directly. However, upon completing the Navigate function,
the review of a posted invoice shows entries that were posted to
the G/L. This occurs because the customers and items were assigned
Posting Groups to identify the G/L accounts.
There are three major types of posting groups that deal with
selling inventory and resources to customers and buying inventory
from vendors:
General Posting Groups
Specific Posting Groups
VAT Posting Groups
General Posting Groups
General Posting Groups are added to Customers, Vendors, Items
and Resources to link item and/or resource transactions from
purchases and sales documents as well as item journals and job
journals to the General Ledger.
General Business Posting Groups: Specifies "who we sell to"
(Customers) and "who we buy from" (Vendors).
General Product Posting Groups: Specifies "what we sell" (Items
and Resources) or "what we buy" (Items).
General Posting Setup: A matrix window that combines business
and product posting groups. With each combination the user can
determine to which accounts the program will post:
Sales and Purchases
Sales and Purchase Credit Memos
Sales and Purchase invoice discounts and payments discounts
Cost of Goods Sold and Inventory Adjustments
Direct Cost Applied and Overhead Applied
Purchase Variances
There are exceptions, but typically
the General Posting Setup matrix is used to designate the income
statement accounts to which you will post. For each combination of
business and product posting groups you can assign a different set
of G/L accounts. You can post the sale of the same item to
different sales accounts in the G/L due to customers being assigned
different business posting groups. You may use the same G/L account
for different combinations, enabling you to use posting group
filters on reports.
You assign business posting groups to customers and vendors. In
the Gen. Business Posting Groups window,
you enter a code and a description for the posting group.
How many groups you need for breaking down sales by
customers.
How many groups you need for breaking down purchases by
vendors.
The business groups can be set up to group customers and vendors
by geographical area (Domestic, EU Countries/Regions, Overseas, and
so on) or the type of business (retail, industrial, wholesale,
service) or to distinguish between private entities and government
agencies. The number of groups are directly related to the chart of
accounts.
If you do not want to distinguish sales and purchases by
customers or vendors, it is not necessary to set up any General
Business Posting Groups.
You assign product posting groups to items and resources. In the
Gen. Product Posting
Groups window, you enter a code and a description for
the posting group.
How many groups you need for breaking down sales by products
(items and resources).
How many groups you need for breaking down purchases by
items.
Examples of how Product Posting Groups can be divided are Raw
Materials, Retail, Resources, Capacities, and so on. The Product
Posting Groups provide the major product groups reflected in the
Chart of Accounts. Each Inventory Item and Resource is assigned a
Product Posting Group.
In the General Posting
Setup window, for each combination of business and product posting
groups, you can assign a different set of G/L accounts. As a
result, it is possible to post the sale of the same item to
different sales accounts in the G/L due to customers being assigned
different business posting groups.
If using inventory, in addition to entering every possible
combination of General Business and General Product Posting Groups,
you should enter a line for each General Product Posting Group with
a blank General Business Posting Group assigned. An instance when
this combination is necessary is for posting activity from Item
journals when there is not a Customer or Vendor assigned to the
transaction.
Copying Posting Setup Lines
The more product and business posting groups you have, the more
lines you see in the General Posting
Setup window. This can mean a lot of data entry to set up
the general posting setup for the company. While there may be many
different combinations of business and product posting groups,
different combinations may still post to the same G/L accounts. To
limit the amount of manual entry, copy
the G/L accounts from an existing line in the General Posting Setup window.
Specific Posting Groups
The purpose of the Specific Posting Groups is to link the
subsidiary ledgers (for example the customer ledger entries) to the
general ledger. This allows you to use sales documents, for
example, instead of posting directly to the general ledger. When
customer ledger entries are created, the posting groups ensure that
corresponding entries are made in the general ledger.
There are Specific Posting Groups for the following:
Customers: This posting group maps the accounts receivable
account, payment discount accounts, invoice and application
rounding accounts, interest and fee accounts relating to
customers.
Vendors: This posting group maps the accounts payable account,
payment discount accounts, invoice and application rounding
accounts, interest and fee accounts relating to vendors.
Inventory: This posting group is used to specify the inventory.
Each Inventory Posting Group is then combined with each appropriate
Location Code in the
Inventory Posting Setup window.
For each combination you can map the inventory accounts, WIP
account and other variance accounts relating to inventory in the
Chart of Accounts.
Bank Accounts: This posting group maps a bank G/L account to a
bank account in the program.
Fixed Assets: This posting group
specifies the accounts to which
the program posts transactions involving fixed assets.
After opening balances have been entered in the chart of
accounts for subsidiary ledgers (for example, Accounts Receivable),
you should clear the Direct
Posting check box on the G/L
Account Card.
In the Customer Posting
Groups window, you enter a code and a description for
the posting group. This window defines which accounts are used when
accounts receivable transactions are posted to your general ledger.
Each customer must belong to a posting group because the customer's
posting group tells the system where to post the transactions
associated with that customer. You can create as many customer posting
groups as you like.
If you are using inventory in conjunction with receivables, the
combination of General Business Posting Group assigned to your
customers and the General Product Posting Group assigned to the
Inventory item determine which accounts the Sales Order line
entries post to in the General Ledger.
In the Vendor Posting
Groups window, you enter a code and a description for
the posting group. This window defines which accounts are used when
accounts payable transactions are posted to your general ledger.
Each vendor must belong to a posting group because the vendor's
posting group tells the system where to post the transactions
associated with the Payables accounts, Service Charge accounts, and
Payment Discount accounts. You can create as many vendor posting groups
as you like.
If you are using inventory in conjunction with payables, the
combination of General Business Posting Group assigned to your
vendors and the General Product Posting Group assigned to the
Inventory item determine which accounts the Purchase Order line
entries post to in the General Ledger.
Inventory Posting Groups let you define the balance sheet
Inventory Accounts for your various Items. In the Inventory Posting
Groups window, you enter a code and a description for
the posting group.
Each Item must have a General Product Posting Group and an
Inventory Posting Group assigned to it. The item's posting groups
tell the system where to post the transactions associated with that
item.
Inventory Posting Groups also provide an ideal way to organize
your inventory. When generating reports, you can separate items by
their posting groups.
Inventory Posting Setup
After you have set up
your inventory posting groups, you use the Inventory Posting Setup window to
create links between Inventory Posting Groups, inventory Locations,
and G/L accounts. When you post item-specified entries, the program
posts to the G/L account set up for the combination of Inventory
Posting Group and Location linked to the item. Note that the only
two accounts initially required are Inventory Account and Inventory
Account (Interim). The other accounts pertain to specific
application areas you may or may not be using.
Bank Account Posting Groups are used to map a bank G/L account to a bank account in
the program. To simplify tracing transactions and bank
reconciliations, each Bank Account should be associated using a
Posting Group to a unique General Ledger account.
Fixed Assets Posting Groups allow you to create links between
fixed assets and the general ledger where general ledger
integration is activated. Posting groups also facilitate groups of
fixed assets for statistical purposes.
In the FA Posting
Groups window, you must enter a code for each group of
assets you want to work with.
You specify the G/L account numbers needed for the different
types of expenses and costs.
You define the accounts for the acquisition costs, accumulated
depreciation amounts, acquisition costs on disposal, accumulated
depreciation on disposal, gains on disposal, losses on disposal,
maintenance expenses, and depreciation expenses.
Please note that not all accounts are shown in the standard
layout. To see all of the fields, click Posting Gr., Card to open the FA Posting Group Card window. On the
General and Balancing Account tabs, you can see all of
the account fields. The FA Posting Group
Card window gives you a good overview of the account
structure of the posting group. Each FA posting type can have more
than one relation to a G/L account. In most cases, the same account
is used for all kinds of depreciation. Only the acquisition cost
account is different because it is connected with a VAT Posting
Group.
VAT Posting Groups
Value-added tax (VAT) is a transaction tax. VAT is paid by the
end consumer, including businesses. The principles for setting up
VAT Posting Group, both Business and Product, are similar to those
used for setting up General Posting Groups.
VAT Business Posting Groups: Specifies "who we sell to"
(Customers) and "who we buy from" (Vendors).
VAT Product Posting Groups: Specifies "what we sell" (Items and
Resources) or "what we buy" (Items).
VAT Posting Setup: A matrix window that combines business and
product posting groups. For each combination, you can fill in the
VAT percent, VAT calculation type, and G/L account numbers for
posting of VAT related to:
Sales
Purchases
Reverse charge VAT
Whether VAT is recalculated when a payment discount is granted
or received
In the VAT Business Posting
Groups window, you set up VAT Business Posting Group to
distinguish between the types of customers and vendors. You can use
the VAT Business Posting Groups to determine calculation and
posting of VAT, for example by specifying whether the
customer or vendor involved in the transaction is in an EU or
non-EU country/region.
Before setting up VAT Business Posting
Groups, you must decide how many different groups you need.
This depends on a number of factors including local legislation and
whether you trade both domestically and internationally.
On each customer and vendor card, you must enter the code that
represents the group to which the customer or vendor belongs. In
some situations, VAT is included in the price of goods and services
on item or resource cards. In such situations, you must fill in a
VAT Business Posting Group in the VAT
Bus. Posting Gr. (Price) field for customers or vendors with
whom you trade these goods and services.
In the VAT Product Posting
Groups window, you set up VAT Product Posting Group to
indicate the different VAT calculations needed for the types of
items or resources you purchase or sell.
On each item and resource card, you must enter the VAT Product
Posting Group code that represents the group to which the item or
resource belongs.
In the VAT Posting
Setup window, you determine to which accounts the
program will post VAT.
The VAT Posting Setup consists of combinations of VAT Business
Posting Groups and VAT Product Posting Groups. You can set up as many combinations as you need and
link various G/L accounts to each combination. For each
combination, you can fill in a VAT percent, VAT calculation type
and account numbers for posting of VAT related to sales, purchases,
and reverse charge VAT.
When you fill in a line in a general journal, purchase or sales
line, the program checks the VAT
Posting Setup window to see which accounts to use for this
particular combination of VAT business posting group and VAT
product posting group.
Example of Linking Posting Groups
The Customer Card contains the General Business Posting Group
and the Customer Posting Group. The Item Card contains the General
Product Posting Group and the Inventory Posting Group. When a sales
document is created, the Customer Card information pulls into the
sales header and the Item Card information pulls into the sales
lines.
The Revenue Posting (Income Statement) is determined by the
combination of the General Business Posting Group and the General
Production Posting Group in the General Posting Setup window.
The Accounts Receivable Posting (Balance Sheet) is determined by
the Customer Posting Group.
The Inventory Posting (Balance Sheet) is determined by the
Inventory Posting Group.
The Cost of Goods Sold Posting (Income Statement) is determined
by the combination of General Business Posting Group and General
Product Posting Group.
The timing of the posting to these accounts depends upon your
setup. For example, the time of posting is affected by when you
execute periodic activities, (Post Inventory Cost to G/L
and Adjust Cost Item Entries) and whether or not the
Automatic Cost Posting check
box is selected in the Inventory
Setup window.