Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Config. Package Errors - Attempted to Divide by Zero

(0) ShareShare
ReportReport
Posted on by 195

I'm importing Payables Opening Balance from legacy system to BC365 using Configuration Package Table 81.

I come to this error when the line is actually multicurrency transaction. For LCY transactions, I don't have this problem, it only happen to Multicurrency transactions. Any idea what causing this to happen?

In the migration data, I have input the exchange rate in Currency Factor.

Attempted-to-divide-by-zero.jpg

  • Matthew1 Profile Picture
    115 on at
    Config. Package Errors - Attempted to Divide by Zero
    Don't click: "Verify Package", just click "Apply Package" and there will be 0 errors and journal rows will be inserted..., there is a kind of bug? on configuration packages that for this example which You described system by verifying package shows error: "attempted dived by zero", but when you will apply it, problem dissapear.
    PS. On all fields validation checks turned on, nothing disabled. 
  • Kelvin Hew Profile Picture
    195 on at
    RE: Config. Package Errors - Attempted to Divide by Zero

    True.

    I found out later on that I just need to rearrange the Processing Order of the Currency and Amount field in the Configuration package.

  • Suggested answer
    Danko Profile Picture
    10 on at
    RE: Config. Package Errors - Attempted to Divide by Zero

    Hi, 

    you just have to import amount first and then currency. Took me few hours to get to that :D.

  • Suggested answer
    Olister Rumao Profile Picture
    3,959 on at
    RE: Config. Package Errors - Attempted to Divide by Zero

    Hi,

    Just as Teddy said that removing validation can be dangerous I agree to that.

    It can be dangerous but will allow you to fill the fields.

    All you need to do is manually type in the amount for the entries which will validate it.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    13,695 Moderator on at
    RE: Config. Package Errors - Attempted to Divide by Zero

    Skipping the validation on the Amount is quite dangerous. Check everything, check the Amount LCY, etc.

  • Suggested answer
    Olister Rumao Profile Picture
    3,959 on at
    RE: Config. Package Errors - Attempted to Divide by Zero

    Hi Kevin,

    You can do Preview Posting and see if there are any issues prior to posting if there are any issues in the entries.

    I don't think there should be any issues if it is posting.

  • Kelvin Hew Profile Picture
    195 on at
    RE: Config. Package Errors - Attempted to Divide by Zero

    Hi Olister, your suggestion is working. As I try to post the data, it seems fine too.

    By skipping the validation in "Amount" field, will it bring any side effect at the back end?

  • Kelvin Hew Profile Picture
    195 on at
    RE: Config. Package Errors - Attempted to Divide by Zero

    I try to import using a single line transaction (with multicurrency), I still get the same error message at amount field.

  • Suggested answer
    Olister Rumao Profile Picture
    3,959 on at
    RE: Config. Package Errors - Attempted to Divide by Zero

    Hi,

    I have observed this.

    In General Journal importing using Configuration Package, remove the Validate trigger check mark on the TABLE FIELDS.

    First try only with amount and fill in only the minimum fields required.

    If you still have issues then remove trigger for some fields and then you will need to manually validate the entry.

    I'm pretty sure that this will resolve your errors.

  • Teddy Herryanto (That NAV Guy) Profile Picture
    13,695 Moderator on at
    RE: Config. Package Errors - Attempted to Divide by Zero

    when you make changes to the data, BC will remove the error mark.

    when you try to apply the data again, you will get the error again.

    Try to import with little data and see if it is related to amount or not.

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

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 >

Featured topics

Product updates

Dynamics 365 release plans