Sage 100

Sage 100 Advanced 2016.5 - This customer does a lot of off-setting open credits in AR with open invoices. They do this via a $0 cash receipt where they first select the open credit and then select invoices to apply. For the most part, this works well. Where it falls apart is when you need to quickly know what open credit(s) paid off which open invoice(s). If you are only doing one to one it's not a huge deal as you can use the check # field which does appear on subsequent screens. The issue becomes when you have two or three credits on an account and the AR person wants to apply them all in one $ 0 cash receipt. It becomes very difficult to track what open credit paid what open invoice. Has anyone come up with an elegant way to carry this detail forward to the AR customer lookup - invoices screen and/or statement printing? As of now I'm toying with just printing a custom crystal and having them use the cash receipts comment field (which unhelpfully seems to flow almost nowhere except history) Anyone tackle this before?

I may be missing something but can't you see the credits applied if you print a Trial Balance report for that customer?

I don't think you can - if you pick out one or two open credits and apply against open invoices there's not a clear link to indicate which open credit was used to pay which open invoice

I would treat each credit as a separate entry with a unique check number APPLY1, APPLY2, etc.