Payment from one source for MULTIPLE clients (50+) at a time

Question

One of my clients receives payment from one source for MULTIPLE clients (50+) at a time. I am stuck now. None of the distribution lines are appearing, the full "sales" amount is being applied as Sales Tax, rather than the distribution. Customer ID Date Date Due Accounts Receivable Account Number of Distributions Invoice/CM Distribution Quantity Item Code G/L Account Unit Price Serial Number Description Tax Type Amount Sales Tax Agency Recur Number Recur Frequency Invoice/CM # Credit Memo COLEMAN 6/8/2019 ######## 2 1 1 T 40000-01 160.6 Week Beginning COLEMAN, LOGAN 6/2/19 2 -160 exempt 0 0 Test-1 FALSE COLEMAN 6/8/2019 ######## 2 2 1 C 40000-01 101 Week Beginning COLEMAN, LOGAN 6/2/19 2 -101 exempt 0 0 Test-2 FALSE

5050adams · Accepted Answer

The Invoice appears to Import properly, however, when I open the Invoice, the Sales Amounts are lumped in under the Sales Tax and NO distribution is done.

5050adams · Answer

Document1.pdf 
 See the attached screen shot - please!!!

5050adams · Answer

If I make the AMOUNT column ZERO, then the SALES TAX is ZERO, but still no Distribution or actual income...

KathleenF · Answer

5050adams I have tested this, and there are a few things things in the import example above that I may be causing this to occur. The first is that since you are using a Sales Tax Agency, there should be 3 distributions, with distribution 0 being your tax amount with the sales tax agency id listed in this column at a 0 quantity. The two line items should not have a sales tax id associated with it. Also, if both items should be on the same invoice, you will want the invoice / CM # to be the same on all 3 lines of distribution. 
 What I usually recommend when someone is trying to make an import / export file is to manually enter one invoice, and then export it and take a look at the values that Sage 50 is looking for. That is what I did using the information you included above in order to identify what is causing your invoice to put all values into the Sales Tax.

Sage 50 US

Payment from one source for MULTIPLE clients (50+) at a time

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING