SBX - Search With Button

SBX - Forum Post Title

Account Schedule Issue

Dynamics 365 Business Central Forum

Sam Phoon asked a question on 14 Jun 2019 3:34 AM

Question Status

Suggested Answer

I have created a simple 12 mths Expenses report using CORNUS Australia Pty Ltd data. For the individual months, the figure generated are correctly. However when it comes to the last column (Total YTD), the figure is wrong.

The correct amt should be $69,191.40

The amount generated is $2534.03 (ie it takes Jan+Oct+Nov+Dec) which I can't understand. I don't know where goes wrong

Any help is much appreciated

Reply
Mary Myers responded on 14 Jun 2019 3:28 PM
My Badges
Suggested Answer

Take a look at your column set up.  See if there are any formulas that are causing it to add all those months

Reply
Teddy Herryanto responded on 16 Jun 2019 5:50 AM
My Badges

can you repost your images ? I can't see it.

Reply
Sam Phoon responded on 17 Jun 2019 2:11 AM
Suggested Answer

Hi Guys

Thanks for all the help. I managed to resolve the issue.

My issue is due to the column numbering. I renumbered to C1000 to C1012 and it works. So the answer is all columns must use a consistence numbering.

Reply
Mary Myers responded on 14 Jun 2019 3:28 PM
My Badges
Suggested Answer

Take a look at your column set up.  See if there are any formulas that are causing it to add all those months

Reply
Sam Phoon responded on 17 Jun 2019 2:11 AM
Suggested Answer

Hi Guys

Thanks for all the help. I managed to resolve the issue.

My issue is due to the column numbering. I renumbered to C1000 to C1012 and it works. So the answer is all columns must use a consistence numbering.

Reply

SBX - Two Col Forum

SBX - Migrated JS