Hello,
We need a report of invoices by paid date. We use the distribution suite therefore we invoice through OE.
Which tables do I need to use to pull the payment information in AR and link it to the OE invoice?
Thank you.
If you're using this query for commission calculation, it gets a bit complicated. For basic reporting, this SQL query will get you started.
Yes, I am trying to automate commissions calculations.
Yes, I am trying to automate commissions calculations.
Have you accounted for a possible situation where there are two or more salespeople splitting, or are you fortunate enough to be in a situation where this does not happen?
Sorry, I seem to be unable to post the query - getting a Sage City error about being blocked.
Fortunate enough to only have one sales rep per invoice.
Thank you much.
*Community Hub is the new name for Sage City