Microsoft Dynamics GP (Archived)

This Sales distribution amount is not incorrect and will not be posted. Do you want to save with errors?

(0) Share

Report

Posted on by sandipdjadhav

18,306

Hi,

Integrating sales invoice using eConnect with all non inventory items. GL Disribution also got created using eConnect.

There are few lines which has negative unit price. Below is screen shot for Transaction and Distribution.

Everything look good to me but still I am getting this error.

Distribution details:

Any help on this will be highly appreciate.

Thanks

Sandip

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

You are going to need to insert some logic to flip the debit and credit amounts. The negative sell price should be a debit to sales and a credit to receivables. The exact opposite of the positive sell price items.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Your distribution amounts balance but they are not equal to your document amount, 1665.80 <> 1636.80. If you are letting eConnect default the distributions that would be a bug in eConnect. If you click on the Default button in distributions, a new Total should display that equals the invoice amount.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Hello Sandip,

It's been a long time my friend.

When integrating sales invoices, you should be handling both; the header and details of the SOP transaction, if you are passing the total amount of sales document independently regardless of the sum of all line items, eConnect must handle such error and won't let it pass to Dynamics GP and it does in very different scenarios that I have seen.

My recommendation is to reconsider the scripts providing data to eConnect, you should include some sort of integrity check between the header and the detail to be matched after the logical criteria have been considered (tax, discount, mark down ... etc)

Let us know how things go with you

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (0)

Report

Thanks much everbody for your help.

FYI - Richard's logic work perfectly!!!

Thanks

Sandip

Was this reply helpful? Yes No