Incorrect Cost Variance GL Distributions in POP Invoice when created through eConnect

(2) Share

Report

Posted on by PP-27011140-0

Hi,

I have a PO with an item unit cost of 93.721 and 1 Quantity Ordered.

Received the Item with the same cost of 93.721.

Vendor sent an Invoice for the Receipt with below details:

Total Amount = 96.2 of which Shipment Cost = 93.72 and Freight Cost = 2.48.

Now when I created this Invoice in GP with eConnect, in GL Distributions, instead of the 0.001 variance, a variance of 0.066 was created.

Please note that I have CREATDIST Flag set to 1. So I am not sending Distributions explicitly from eConnect.

Can you please help me as to why it was the case ?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Lisa at AonC.com 1,154 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Is there something going on with Multi-Currency that may explain the difference?

What is the item's valuation method?

If you go into the transaction in GP and open the Distributions window, if you click Default does GP redisplay the expected entry? (Note: This is only a quick way to check because you are having eConnect default the distributions.)

Was this reply helpful? Yes No
PP-27011140-0 63 on at

Like (0)

Report
Copy link

Link copied!

Hi Lisa,

Thanks for the response!

1. No, both Functional and Originating Currency is USD.

2. Valuation method is Average Perpetual.

3. Yes, when I click Default in Distributions, GP redisplays the expected entry.

Observation: When I deliberately created an Invoice with $1 variance, 6.600 Variance GL Distribution was created.

Was this reply helpful? Yes No
Verified answer

Lisa at AonC.com 1,154 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the additional information!

It sounds like you are running into an old issue discussed here: Solved: Purchasing Distribution incorrect when matching with eConnect

[The post ends with a link to the Developer Tools Learning page but the file links are broken. @Terry R Heley - Is it possible to get new links? Edit: Terry set me on the correct path: You'll need a PartnerSource/CustomerSource login in order to download the files.]

Was this reply helpful? Yes No
PP-27011140-0 63 on at

Like (1)

Report
Copy link

Link copied!

Thank you Lisa!

Was this reply helpful? Yes No