Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

Billing Worksheet Revenue

(0) ShareShare
ReportReport
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

*This post is locked for comments

  • 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans