Skip to main content

Notifications

Microsoft Dynamics SL forum
Unanswered

Billing Worksheet Revenue

Posted on by Microsoft Employee

Hi,

Due to a user error last month a over project maximum transaction was generated by the system, this increase the project fee by the same amount. The error (funding) was corrected and the fee category is now in balance, however, now the project revenue balance is off by the proj max transaction. All the ledger accounts balances are good except the system billing worksheet revenue category. Is it possible to fix this? Can I rebuild the worksheet from history? And it so, how will I do this?

Thanks,

Ken

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Billing Worksheet Revenue

    Hello Ken,

    Are you referring to the Billing Worksheet report in project controller?  Unfortunately,  The only "rebuild" we have is the PMA integrity check..which probably would not help you.

    From the Bill to max setup help file

    When the Allocation Processor (PA.PRO.00) determines that an allocated transaction will cause the project’s maximum to be exceeded, it creates a transaction for the Over-Max Adjustment Acct Category that has a negative amount for only that portion of the allocated amount that exceeds the maximum. The billing record for the “over-max” transaction will have the Billing/Expense Acct Category. For example, if the “over-max” transaction will post to an UNBILLED LABOR CAP account category, the billing record created from the UNBILLED LABOR CAP transaction might have the account category ADJUSTMENTS for presentation on the invoice. If this field is blank, the billing record will carry the account category of the “over-max” transaction.

    Overmax ..if you decide to bill it , meaning you went over the agreed cost, but the customer allows you to bill the overage.

    So are you saying you billed the overage? How did you do that? Did you "write it up"?

    For a quick answer(s) 

    If the overmax was a mistake , you normally fix it in the overmax setup on the project. Then Allocator will "back out" that overmax. (meaning increase or decrease it)

    You can adjust the Revenue  with a Project charge entry to correct the account in project controller (it would not be billable, since you've billed it already)

    I'm thinking a project charge entry is the way to go.

    Best Regards,

    Jana MacDonald

    Microsoft Dynamics SL Support.

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans