Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

GP 9.0 Project Acct - Odd billing cycle

Posted on by 345

 We need to use an 'once every two weeks' invoicing.

The billing cycles available do not support this.

The twice a month cycle (in specfic numeric days) does not work.

Basically, I need to have our invoices include two weeks of billables Monday -> Friday for each of the two weeks.

Is there a way to accomplish this?

 

Thanks,

John

*This post is locked for comments

  • alyssascavetta Profile Picture
    alyssascavetta 15 on at
    RE: GP 9.0 Project Acct - Odd billing cycle

    Hey John,

    I know it's been a while since you had this question but you know there are a ton of add-ons that are way better than GPPA that can do this trick for you? Journyx is a great example. Here's the site in case you wanna check it out.

    journyx.com/.../accountlink-microsoft-dynamics-gp-end-user

    -A

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: GP 9.0 Project Acct - Odd billing cycle

    You're welcome!

     

    Take care,

    Christina

  • jakorsme Profile Picture
    jakorsme 345 on at
    Re: GP 9.0 Project Acct - Odd billing cycle

     Thanks, I think I was thinking billing cycle had more intelligence than it does. This seems pretty straight forward.

     

    John

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: GP 9.0 Project Acct - Odd billing cycle

    Hi John--

     So four timesheets...

    10/10

    10/17

    10/24

    10/31

    When these are entered, project tracks if they have been billed yet.  The billing cycle provides defaults for a billing batch.  So when you go in to run the biling cycle, you can override those defaults to whatever you want.

    Using your example...cutoff date of 10/17, billing date 10/19, it will pick up the time from 10/10 and 10/17.  But lets say, you adjust the bill and only end up billing the 10/17 charge.  So in the database, 10/17 timesheet is marked as billed.

    So when you run the billing cycle again, this time with cutoff of 10/31, it will pick up 10/24 and 10/31 timesheets...but also the 10/17 that wasn't billed before.

    All billing cycle does is generate bills for you according to the settings you specify.  Anything before the cutoff date that has not been previously billed will show up.


    Make sense?


    Take care,
    Christina

  • jakorsme Profile Picture
    jakorsme 345 on at
    Re: GP 9.0 Project Acct - Odd billing cycle

    Thank you Christina,

    If I understand you correctly, I'm not exactly seeing the point of 'billing cycle' configuration to begin with?

    Ok. If I have 4 weekly timesheets (each spanning Saturday -> Friday. dated on Friday: 10/10, 10/17, 10/24, 10/31

    When I run a 1st billing cycle on Sunday 10/19 with a cutoff of Friday 10/17, I should create one invoice with billings for two timesheets dated 10/10 and 10/17

    When I run the next billing cycle on Sunday 11/2 with a cutoff of Friday 10/31, I should again create one invoice with billings (line items) for two timesheets dated 10/24 and 10/31

    and so on and so on...

    Am I understanding how it works correctly?

    Thanks,

    John

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: GP 9.0 Project Acct - Odd billing cycle

    Hi John--

     When you manually run the billing cycle, you could set the cutoff date to be the Friday before.  And assuming you had previous run the cycle, it would only pick up since the last billing...the two weeks.  So although you could not necessarily default the dates correctly, running the cycle every two weeks with the appropriate cutoff should be able to accomplish what you need.

     Let me know if you have questions.


    Take care,

    Christina

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans