It is a typical KPI request to be able to report on unit account values. Let's go ahead and say that we're looking at a profit and loss report, by product and the business wants to see units sold that are included in that margin.
In a perfect world (and using some tools that are not named Management Reporter), if you're capturing the Product A quantity in the Sales Order Processing (SOP) module in GP, you'd be able to reference the sum of the sales instead of using a unit account. However... We don't live in a perfect world whilst using Management Reporter thus Unit Accounts are required.
So what we'd see is in GP, we'd setup a unit account for something like "Units Sold - Product A"
In Management Reporter, we'd then have a row definition that looked something like...
Sales Product A
- Expenses Product A
/ Units Sold - Product A
In a typical fashion, in order for this report to be up to date, the accounting team would need to make a routine journal entry to the unit account within GP. This process leaves way for manual errors, timing issues & the potential for management to lose confidence in their reports.
Using the method below, we complete streamline this process by automating the unit account journal entry within GP.
Part 1: Associate a unit account with an inventory item in GP.
Note: For example deliverable, one item may be used at multiple locations (segment 1 of COA). Therefore, we just assign the Natural account to the item & then let the integration define the remaining COA segments)
Approach: We accomplish this using
eOne Solution's Extender product