Small and medium business | Business Central, N...

Account Schedules

(0) Share

Report

Posted on by stephenm171

I am trying to build an account schedule that lists all accounts (balance sheet and income statement posting accounts) in the rows with 2 columns - 1 to display debit account balances and the 2 to display credit account balances.

By using the Amount Type to be Debit Amounts for Column 1 and Credit Amounts for Column 2 - this just produces a results balances for both columns if the account has both debit and credit transactions.

By using the Amount Type - Net Amount and then for Column 1 (Debit) show When Positive and for Column 2 (Credit) show when Negative - this produces the required result for each account row.

The problem then is the final row I want to display a total for the column - it displays zero balance as its the full Trial Balance - display the total as zero.

Snapshot of the output trying to be achieved

Account Code	Account	Account Type	Debit	Credit
200	Fixed Revenue	Revenue		870,092.57
201	Deliverables	Sales		325,845.66
202	Workforce Planning	Sales		2,120,150.01
203	Communications	Sales		2,246,378.90
204	Skilling	Sales		1,555,038.16
205	Admin	Sales		1,089,784.00
207	Reimburseable Income	Sales		417,236.29
208	Talent Acquisition	Sales		532,201.08
Total			13,814,195.65	13,814,195.65

I have the same question (0)

All responses (6)

Answers (0)

JAngle 125 on at

Like (0)

Report

RE: Account Schedules

Does the trial balance report not fit the bill? Has all the components you’re mentioning I believe

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Account Schedules

Stephen,

Here is my image of an Account Schedule that takes multiple rows and shows the Debit and Credit columns and summarizes at the end. Just to clarify one thing, you are creating a total for the Debit and Credit column so they will not equal. You could add a 3rd column the nets the 2 together, like my example.

As Josh noted, the Trial Balance could work here too.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
stephenm171 27 on at

Like (0)

Report

RE: Account Schedules

It does have the components just not the look and feel customer required

Was this reply helpful? Yes No
stephenm171 27 on at

Like (0)

Report

RE: Account Schedules

It put the split based on transaction not balance which is not what customer needed. Thank you.

Was this reply helpful? Yes No
Dallefeld 197 User Group Leader on at

Like (0)

Report

RE: Account Schedules

Did you find your answer yet? If so, can you share?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Account Schedules

Stephen,

If you want me to try to massage to what the client needs, feel free to attach the Account Schedule layout and Column Layout and I can play with it in my database.

Thanks,

Steve

Was this reply helpful? Yes No