Error message when you try to post a batch of transactions in General Ledger in Microsoft Dynamics SL: "System Message 3011 - is not in balance and not posted"

Article ID: 968812 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Consider the following scenario in General Ledger in Microsoft Dynamics SL.
  • You try to post a batch of transactions in the Post Transactions (01.520.00) screen in General Ledger in Microsoft Dynamics SL, but receive the following error message:

    System Message 3011 - is not in balance and not posted
  • The batch does not release.
  • The batch of transactions originated in Flexible Billings in Microsoft Dynamics SL.
  • The account and the subaccount are blank in the batch.
Additionally, you notice that the following error messages are written in the Microsoft Dynamics SL event log:

System Message 6654: Subaccount is invalid for posting.

System Message 6658: Batch Module: 'BI' Module Batch: 'XXXXXX' with blank Acc or Sub is invalid for posting.

CAUSE

The Cost of Sales/Deposits tab in the Billings Setup (BI.SET.00) screen is blank. However, the billing rule for the project has the COS Method box set to To Date in the Billing Rules Maintenance (BI.RUL.00) screen.

WORKAROUND

To work around this problem, change or delete existing batches that contain this problem. To do this, select one of the following options.

Change the batch in General Ledger. To do this, follow these steps:

  1. Turn on Initialize Mode.
    • Microsoft Dynamics SL 7.0 and Microsoft Dynamics 2011: On the Application menu, click Initialize Mode.
    • Microsoft Dynamics SL 6.5: On the Application Options menu, click Initialize Mode.
  2. Change the batch. To do this, follow these steps:
    1. In the navigation pane, click Financial.
    2. In the Financial navigation pane, click General Ledger.
    3. In the General Ledger details pane, click Journal Transactions under Input.
    4. In the Module box, select BI.
    5. In the Number box, specify the batch number for the batch that you want to change.
    6. Specify the appropriate values in the following boxes:
      • Account
      • Sub
    7. Click Save, and then close the Journal Transactions (01.010.00) screen.
  3. Post the batch. To do this, follow these steps:
    1. In the General Ledger details pane, click Post Transactions under Processes.
    2. Click to select the Selected check box for the batch that you changed in step 2, and then click Begin Processing.
  4. In Access Journal Transactions (01.010.00) and change Module field to indicate the two letter abbreviation of the module (BI) for the batch to edit or delete. >> To Delete the batch: a. Select the appropriate batch in the Batch Number field. b. Click the Delete button on the toolbar for the Journal Transactions screen c. Respond Yes to System Message 12 - 'Are you sure you want to delete?' >> To Edit the batch: a. Select the appropriate batch in the Batch Number field. b. Make appropriate changes and click the Save button on the toolbar for the Journal Transactions screen. 4. Post the batch in Post Transactions (01.520.00)

Delete the batch in General Ledger. To do this, follow these steps:

  1. Turn on Initialize Mode.
    • Microsoft Dynamics SL 7.0 and Microsoft Dynamics SL: On the Application menu, click Initialize Mode.
    • Microsoft Dynamics SL 6.5: On the Application Options menu, click Initialize Mode.
  2. Delete the batch. To do this, follow these steps:
    1. In the navigation pane, click Financial.
    2. In the Financial navigation pane, click General Ledger.
    3. In the General Ledger details pane, click Journal Transactions under Input.
    4. In the Module box, select BI.
    5. In the Number box, specify the batch number for the batch that you want to change.
    6. Click Delete.
    7. Click Yes when you are prompted with the following confirmation message:
      System Message 12 - Are you sure you want to delete?

RESOLUTION

To resolve this problem, select one of the following resolutions.

Resolution 1

You want to allow for Cost of Sales postings.
  1. In the navigation pane, click Project.
  2. In the Project navigation pane, click Flexible Billings.
  3. In the Flexible Billings details pane, click Billings Setup under Setup.
  4. On the Cost of Sales/Deposits tab, specify the following settings in the Cost of Sales area:
    • Account Category:
    • Post To Account:
    • Subaccount:
    • Offset Account:
    • Subaccount:
  5. Click Save, and then close the Billings Setup (BI.SET.00) screen.

Resolution 2

You do not want to allow for Cost of Sales postings.
  1. In the navigation pane, click Project.
  2. In the Project navigation pane, click Flexible Billings.
  3. In the Flexible Billings details pane, click Billing Rules Maint under Maintenance.
  4. In the Billing Rules box, specify the billing rule that you want to change.
  5. In the COS Method box, specify <none>.
  6. Click Save, and then close the Billing Rules Maintenance (BI.RUL.00) screen.

Properties

Article ID: 968812 - Last Review: July 13, 2011 - Revision: 3.0
APPLIES TO
  • General Ledger
  • Flexible Billing
Keywords: 
kberrmsg kbsurveynew kbtshoot kbprb kbexpertisebeginner kbmbsmigrate kbexpertiseinter KB968812

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com