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.
How can we pull the details of the invoices?
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.
OEAUDH, OEAUDD
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