web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / analysis cubes recieva...
Microsoft Dynamics GP (Archived)

analysis cubes recievables

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • GPDavid Profile Picture
    GPDavid 2,250 on at

    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

  • Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at

    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

  • GPDavid Profile Picture
    GPDavid 2,250 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans