web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / EMERGENCY! Flexible Bi...
Microsoft Dynamics SL (Archived)

EMERGENCY! Flexible Billings invoice posting creates extra lines in GL

(0) ShareShare
ReportReport
Posted on by Mark Fineman 420

We have 3 company databases, each with it's own base currency.  Flexible Invoicing works fine in two companies except with the GBP based company.  When any Flexible Billings invoice is posted there, an extra line in the GL batch needs to be deleted.  It has no GL Account, no subaccounts and no amounts.   Just an extra incomplete unnecessary line.   All the setups in each company db are the same so we're at a loss.  Any ideas on where I can look before I call Microsoft directly?  

*This post is locked for comments

I have the same question (0)
  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hello Mark,

    I have a couple of suggestions. Oopen Billing Rules Maintenance (BI.RUL.00) and enter the ID of your Billing Rule.  If you have more than one Billing Rule, you might have to check several of these.  Enter the Billing Rule and you will see a field called COS Method.  If that is set to “To Date”, change that to <none>.  If the COS Method is “To Date”, the invoice posting process is going to try to create cost of sales transactions when you post the invoice, and if your Cost of Sales account is blank in Billings Setup, that would explain why you are getting transactions with a blank account and subaccount.  

    The other thing you can do is open Control Parameter Maintenance (PA.CNT.00), enter a control type of BI, a control code of REG-NO-ZERO-GLTRAN and then enter a Y in the first position of the control data.  This tells the BI.REG.00 process to not create any GLTran record if the amount of the transaction is zero.

  • Mark Fineman Profile Picture
    Mark Fineman 420 on at

    Hi Carolyn, the answer it seems was to check our Billing Rules.  Someone accidentally changed the billing rule's COS method to something other than "NONE."  It seems that the extra zero line was added since it was trying to calculate COS when it wasn't configured.  Once we changed the drop down box to NONE on the Billing Rules, all was well.  thanks for your answer!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans