Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / SL 2011 FP1 - Invoice ...
Microsoft Dynamics SL (Archived)

SL 2011 FP1 - Invoice and Adjustment Posting (BI.REG.00) stops working

(0) ShareShare
ReportReport
Posted on by Community Member

In Flexible Billings, after installing FP1”Invoice and adjustment posting” (BI.REG.00) stops running. The process screen shows first initializing...., then start with the first invoice # and after 4 seconds stop. The event log was generated but not error was recorded.   

The following was done: run index and procs, review the BillcuryID, there are only invoices, the cut-off date is correct, period to post is current period.

Before try to post again, the Control Parameter needs to be deleted (PA.CNT.00) for INVOICE-REGISTER.

Is anybody have the same error?  Your comments and advise are appreciate,

Miriam

*This post is locked for comments

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: SL 2011 FP1 - Invoice and Adjustment Posting (BI.REG.00) stops working

    Hi Miriam,

    Do you need more assistance with this issue?

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: SL 2011 FP1 - Invoice and Adjustment Posting (BI.REG.00) stops working

    Hi Miriam,

    This is a tough one.  I'm not sure which user is trying to run the process, but have you tried it while logged in as Sysadmin?  Or maybe try it from the server or a different workstation.  It's unusual that the process just crashes without leaving a message in the text box on the screen or in the event log.  Could it be rights to write to the event log?

    Could the user create a demo database and run the process in the demo database?  Maybe if the process can run normally in the demo database, perhaps it's a data issue with one of the invoices.  You could try to fill out the Invoice and Adjustment Posting screen with different parameters to avoid the first invoice to see if other invoices will post.

    Another good troubleshooting option would be to run a trace in SQL Server profiler.  Please be sure to use the template we suggest as it has all events included that we think are necessary.  You can download the template and instructions from PartnerSource at this link:  mbs.microsoft.com/.../DLPP.aspx  

    Just choose the correct version of SQL Server.  

    Then let's see what the trace indicates that the appliication is doing at the time the screen crashes.

    Let me know if any of the above suggestions help.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: SL 2011 FP1 - Invoice and Adjustment Posting (BI.REG.00) stops working

    Carolyn,

    Thank you for your time and help.  The Database Calls was turning off and the event log is:

    Computer:MCRVMRDP-Tcp#0

    SetFocus(cGLSub)   '15:53:09

    SetFocus(cGLSub)   '15:53:09

    SetObjectValue(Control=cGLSub, Value='    ')   '15:53:15

    SetObjectValueExit(Control=cGLSub,Value='    ', Retval=0)   '15:53:15

    SetFocus(cCutoff)   '15:53:15

    Keyboard(, 9)   '15:53:22

    SetObjectValue(Control=cCutoff, Value='09252012', VALUE_CHANGED)   '15:53:22

    SetObjectValueExit(Control=cCutoff,Value='09252012', Retval=0)   '15:53:22

    SetFocus(cSelectPer)   '15:53:22

    SetObjectValue(Control=cCutoff, Value='09252012')   '15:53:22

    SetObjectValueExit(Control=cCutoff,Value='09252012', Retval=0)   '15:53:22

    SetObjectValue(Control=cSelectPer, Value='      ')   '15:53:25

    SetObjectValueExit(Control=cSelectPer,Value='      ', Retval=0)   '15:53:25

    SetFocus(cBiller)   '15:53:25

    SetObjectValue(Control=cBiller, Value='          ')   '15:53:29

    SetObjectValueExit(Control=cBiller,Value='          ', Retval=0)   '15:53:29

    SetFocus(cBillCuryID)   '15:53:29

    SetFocus(cBillCuryID)   '15:53:32

    SetFocus(cBillCuryID)   '15:53:33

    SetObjectValue(Control=cBillCuryID, Value='USD ')   '15:53:33

    SetObjectValueExit(Control=cBillCuryID,Value='USD ', Retval=0)   '15:53:33

    SetFocus(cBiller)   '15:53:33

    SetObjectValue(Control=cBiller, Value='          ')   '15:53:35

    SetObjectValueExit(Control=cBiller,Value='          ', Retval=0)   '15:53:35

    ClickButton(cBegProcessing)   '15:53:35

    System Message 6124: Process started: Wed Oct 03 03:53 P.M.

    I can't post invoices from Flexible Billings.

    Regards,

    Miriam

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: SL 2011 FP1 - Invoice and Adjustment Posting (BI.REG.00) stops working

    Hi Miriam,

    Did turning off Database Calls resolve the issue with the Invoice and Adjustment Posting process?

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: SL 2011 FP1 - Invoice and Adjustment Posting (BI.REG.00) stops working

    Hi Miriam,

    Why do you have database calls on?  I would turn that off and try again.  We have known some processes to abort if database calls is checked.  Let me know it that makes a difference.

  • Community Member Profile Picture
    Community Member on at
    Re: SL 2011 FP1 - Invoice and Adjustment Posting (BI.REG.00) stops working

    Carolyn,

    The following was found:

    After clicking “Process Company XXX” for a second the Process Status (BI.REG.00) is displayed:

    Processing Invoice Number 0187..

    Elapse Time: 00:00:01

    Then it disappears, no process status.

    In this run, no event log was generated. The Options Dialog contains:

    Database calls – checked

    Fatal Diagnostics – checked

    Data Entry Keystrokes – Always Write

    Under Control Parameter Maintenance (AP.CNT.PP) screen a new record was created for:

    Control Type BI

    Control Code INVOICE-REGISTER

    Description   Billing Setup Info

    Control Data INVOICE REGISTER user=XXX

    The following was checked:

    1 - Make sure the Project and Task are still valid in Project Maintenance

    Projects and task are active; we are entering transactions from other modules.

    2 - Check the project in the Billing Information Maintenance screen to make sure its setup and has a billing rule

    Projects have a billing rule.  Total invoices 14 using only two billing rules.

    3 - Check the billing rule in Billing Rules Maint screen to make sure the Account category is in the top grid of that screen.

    Checked.

    4 - Check the FiscalNo field on the transaction. This needs to match the period you enter in the Billings Transactions Load screen.

    PA.SET.00 was defined to Automatic Financial Transaction Transfer.

    The billing transaction load is done automatic when Allocation is run.  The PjinvDet table shows  FiscalNo 201209 for all records generated from Timecards. The PjinvDet.fiscalno is blank for all invoices entered manually in Invoice and adjustment entry.

    The Pjinvdet.bill_ status is “S” for all drafts in Pjinvhdr.inv_status equal to “PR”.

    As I mentioned before, invoices posting was working before to install SL 2011 FP1.

    Thank you for your help and advise.

    Miriam

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: SL 2011 FP1 - Invoice and Adjustment Posting (BI.REG.00) stops working

    Hi Miriam,

    After you click Process Company xx, and the process stops, do you get anything returned in the space below the Posting Period.  

    Otherwise, there could be a number of things keeping these transactions from loading.   Here are some things to check on:

    1 - Make sure the Project and Task are still valid in Project Maintenance

    2 - Check the project in the Billing Information Maintenance screen to make sure its setup and has a billing rule

    3 - Check the billing rule in Billing Rules Maint screen to make sure the Account category is in the top grid of that screen.

    4 - Check the FiscalNo field on the transaction.  This needs to match the period you enter in the Billings Transactions Load screen.

    Let me know what you find.

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

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans