web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Config. Package Errors...
Small and medium business | Business Central, N...
Suggested answer

Config. Package Errors - Attempted to Divide by Zero

(0) ShareShare
ReportReport
Posted on by Kelvin Hew 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

I have the same question (0)
  • Matthew1 Profile Picture
    Matthew1 138 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
    Kelvin Hew 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
    Danko 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
    Olister Rumao 3,963 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
    Teddy Herryanto (Th... 14,008 Super User 2025 Season 2 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
    Olister Rumao 3,963 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
    Kelvin Hew 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
    Kelvin Hew 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
    Olister Rumao 3,963 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
    Teddy Herryanto (Th... 14,008 Super User 2025 Season 2 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,899 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,444

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,304

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans