You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... GP econnect to map emp...

Finance | Project Operations, Human Resources, ...

GP econnect to map employee expense distributions

(1) Share

Report

Posted on by kwj3

We are trying to create an eConnect mapping for Project Accounting Employee Expense.

We are unable to figure out how to map Distributions.

When manually entering an Employee Expense, the Line Distributions and Summary Distributions are automatically populated.

When using eConnect to integrate an Employee Expense, neither distributions are populated.

What is necessary to map the distributions?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Assisted by AI

Gaurangkumar Jani

4,542 User Group Leader on at

Like (1)

Report

Copy link

Link copied!

✅ Answer: How to map distributions for Project Accounting Employee Expense using eConnect

When integrating Project Accounting Employee Expenses through eConnect, GP does NOT auto‑generate distributions the way the GP UI does.

This is expected behavior.

In GP:

When you enter an Employee Expense manually, GP automatically creates:
- Line Distributions
- Summary Distribution

But in eConnect, these distributions must be explicitly provided.

eConnect will not calculate or default them for you.

✔️ What you must do

1. You must supply the distributions manually in your eConnect XML

This means you must populate:

taPAEmployeeExpenseDistInsert (line‑level distributions)

taPAEmployeeExpenseSummaryDistInsert (summary‑level distributions)

eConnect requires:

Account numbers

Debit/Credit amounts

Project, cost category, and other PA fields

Line sequence numbers

Distribution types

If you do not provide these nodes, GP will create the expense header and lines, but no distributions will appear.

✔️ Why GP doesn’t auto‑generate distributions in eConnect

The GP UI uses internal business logic to:

Look up PA defaults

Apply cost categories

Determine GL accounts

Create PA/GL distributions

eConnect bypasses that logic, so it cannot infer or generate distributions.

✔️ Summary

To successfully integrate Employee Expenses:

Requirement	Explanation
Provide Line Distributions	Required — GP will not generate them.
Provide Summary Distributions	Required — GP will not generate them.
Use PA‑specific eConnect nodes	`taPAEmployeeExpenseDistInsert` and `taPAEmployeeExpenseSummaryDistInsert`.
Expect no auto‑defaulting	All accounts and amounts must be supplied.