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

SOLVED

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 ######## <Cash Basis> 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 ######## <Cash Basis> 2 2 1 C 40000-01 101 Week Beginning COLEMAN, LOGAN   6/2/19 2 -101 exempt 0 0 Test-2 FALSE
  • +1
    verified 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.

  • +1
    verified answer

    Document1.pdf

    See the attached screen shot - please!!!

  • +1
    verified answer

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

  • 0
    SUGGESTED

    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.