Hi
Are the analysis cubes for recievables based on the date the invoice was paid? If not is there a way to get that data. We are trying to build a commision spread sheet as the comission plan here does not work inside GP.
Dynamics GP 2010 Rs with Analysis cubes sql 2005
Thanks
Vic
*This post is locked for comments
Hey Dale, great to hear from you!
Thanks for picking up on the subtle pieces that I missed. I only had a limited time to reply and so I did not have a chance to provide a more well-thought out answer. I can say with certainty that only the date from a single payment (the last one) will be picked up in the DateInvoicePaidOff field. For a more detailed analysis of apply information with multiple payments against a single invoice, a customization would be required to show this information.
You've certainly raised some interesting questions and perhaps Victor will answer with some of his own comments and more detail on what is required.
Take care,
David
I'm sticking my nose in where I know almost nothing in this area.
David,
The field DateInvoice PaidOff implies that it is fully applied. I don't know if that is the case. What happens if a customer makes installment payments or short pays for numerous reasons. Will Analysis Cubes pick up the individual payments or just the last one that finishes off the balance of the original invoice. If commission is based off individual payments, how will that work?
Also, what happens if a customer short pays and a decision is made to allow the customer's short pay to be "full payment", then a credit is issued to zero out the invoice.
I do not know Victor's needs, but I would assume one of two methods is used: (1) any payment would need to be picked up and the amount of such payment so commission can be recorded at that time, or (2) if commission is not paid until the final payment, then I would assume Analysis Cubes would need the date fully applied and the original invoice amt.
Just food for thought (Happy Thanksgiving!).
Best regards,
Dale
When using the Receivables Revenue measure group, it will default based on the document date of the Receivables document. It can be changed to default based on other dates, provided those dates are also available in the TotalRevenue table in the data warehouse.
A quick check on my system shows the DateInvoicePaidOff is available in the data warehouse. Changing this would require making the change at the Analysis Services Database level using Business Intelligence Development Studio.
David
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (