Sage 100

What is the secret? Trying to use the transaction JE to process ACH withdrawals from bank account. ADP takes out $200. The distribution is to multiple accounts. Have tried various combinations but every one results in multiple lines being posted to the bank rec. I just want to see the $200 posted as a single line in the BR.

You don't want to use manual check entry instead? That would allow multiple distributions but would only post the total amt to BR.

Fall back plan. Point is, shouldn't you be able to distribute an amount without the distribution appearing on the BR? I am sure this is a WAD. I wonder if Sage could send someone to the Disney Institute for customer service. So many ideas for improvement just aren't thought/implemented completely through. Sigh........

Did you check the summarize box in the journal format? That should control that.

Jeff have you checked the Transaction Total check box in your set up for that Transaction JE? You can also use the same check # for the multiple accounts. Or set up a Expense Distribution Table for the manual check entry.

Jeff have you gone through training on the GL and how to check the Transaction Total Check Box?

@DianeRuth - You mean like the attached? Not working for me. Batch entry is activated. Perhaps the wise (acre) in the crowd can post a solution.....

Yes but I made it a check - and used the same check # for all entries.

Ding, Ding, Ding, give that woman a prize!!!! Always great to be on the receiving end of positive comments. The solution worked but still think there is an inconsistency with it. But then again, this is Sage. I personally preview the AP check solution as this then give the client a quick way of summarizing costs incurred from a vendor. Also, if you put the processing in the normal AP workflow, you can save time and effort by entering as a voucher. But alas, people hate ""wasting"" a check....

@JeffSchwenk they won't waste a check - wire transfer they can use and if the have the Expense Distribution Table they don't have to think on what GL accounts they need unless it changes each time.

Also, beginning with I think 4.4, you can use alphanumeric check numbers.

Sorry the Expense won't work forgot it was % - have client using it and loves it but don't think that will work for you? But Wire will....