Skip to main content
Avalara Help Center

Why are Sales Distribution Entry amounts incorrect with multiple accounts?

Overview

Selecting a different account for distribution on any line item in an invoice using custom imports results in all Debit values being applied to the first RECV line in Sales Distribution Entry, but then also to the next line with an Account as specified at the line level. Since line 1 includes the total value of the sale, and the line with a line specific account includes that line’s value, whatever line has an account specified value is listed twice in distribution, causing it to be out of balance (overstated). 

Environment

Microsoft Dynamics GP

Resolution

  • The service is working as intended, native GP functionality creates only one RECV line in distribution and our integration updates this line.
  • This issue is a result of customization to create separate lines of RECV entry for each line, we recommend that you customize distribution based on this multiple RECV line requirement to accommodate this need.