Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Project Accounting Cyc...
Microsoft Dynamics GP (Archived)

Project Accounting Cycle Biller loses Next Document Number

(0) ShareShare
ReportReport
Posted on by Kristie McNulty 977

Project Accounting Cycle Biller loses Next Document Number at each run and thousands of transactions created in the batch with no dollars associated with them when we're only expecting a couple hundred invoices.

Process log started: 1/15/2014 4:14:33 PM

Processing Billing Cycle ID: MONTHLY

 Creating one invoice per project.

   Processing completed Project:  Invoice:      

   Zero Document Deleted - Project:  Invoice:

 Processing Project: 2912649-GIQU

 Processing Invoice:

   Zero Project Deleted:2912649-GIQU

   Processing completed Project: 2912649-GIQU Invoice:

That is how the log report starts and it appears to me as though I may have a "blank" project, but not sure.  I'm working in our test environment trying to debug the issue.  We delete the batch that is generated, establish the next document number again, run Cycle Biller with the same results, next document number goes missing and a large batch gets created.  Two pop-up forms appear each time too: 1) Errors occurred while processing of projects.  Please check the log file.  2) The default document number is invalid.  Please check module setup.  Ran reconcile, same problem, PA CheckLinks, same problem.  Anyone have any ideas?

*This post is locked for comments

  • SeanScott Profile Picture
    SeanScott 10 on at
    RE: Project Accounting Cycle Biller loses Next Document Number

    Thank you- that worked perfectly.  We had blank records in PA01101 and PA61020 that must have been causing this.  Also- I would add RM00401 (RM Keys) to the list of tables to clear- we had a blank document number in that table as well.

  • Suggested answer
    Kristie McNulty Profile Picture
    Kristie McNulty 977 on at
    RE: Project Accounting Cycle Biller loses Next Document Number

    Thank you for writing because I forgot to update this incident with our resolution.  Before you begin, take a backup of your database.  We performed our corrections in a TEST database first before updating PROD.

    Whenever we found a blank record (missing project or contract number or document number) we would delete it using:  "delete PAXXXXX where DEX_ROW_ID = ###"    Order of tables to be checked:

    PA01201 | PA01101 | PA01301 | PA01901 | PA13100 | PA13200 | PA13201 | PA13202 | PA13203 | PA61020

    FYI...when looking at any of the PA13XXX tables...there should only be records if there are WORK invoices.

    Next, set your NEXT INVOICE number to the correct value.  Run CheckLinks on PA BILL TRX / ML TRX HIST / EE TRX HIST (you may use others, but this was all that was relevant to our situation).  Finally, run your billing cycle to confirm invoices and expected amount.

    I hope this is helpful and good luck.

    Kristie

  • SeanScott Profile Picture
    SeanScott 10 on at
    RE: Project Accounting Cycle Biller loses Next Document Number

    Hey Kristie- did you ever find the reason for this issue?  We are experiencing the same thing- where cycle billing process clears out our next invoice number and cannot figure out why.

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans