Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Take on balance
Small and medium business | Business Central, N...
Suggested answer

Take on balance

(1) ShareShare
ReportReport
Posted on by MC-30050807-0 54
Hi guys i want to post opening balances in my new company, so i have the trial balance with dr and cr balances, so how do i put them in my new company. So on my journal how do cater for debits and credits and balancing accounts since in my environment there are no debit and credit fields
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,785 Super User 2024 Season 2 on at
    Take on balance
      1:SO I DONT NEED THE BALANCING ACCOUNT ON MY JOURNAL?
    screnario 
     
     
    For a trial balance typically no, you wouldn't have a balancing account on each line. The lines summed up together will balance or sum to zero.
     
     
    2:HOW ABOUT IF I DONT WANT TO INCLUDE OTHER ACCOUNTS AS OF NOW! IT WONT HAVE A ZERO BALANCE SINCE THE DR & CR WONT BE BALANCING
    The trial balance needs to balance or sum to zero. Can you expand on why you're not including all accounts?
     
  • Suggested answer
    Tarik Jerkovic Profile Picture
    Tarik Jerkovic 90 on at
    Take on balance
    Hi,
     
    You need to use Personalization or Designer mode to add or show column with debit amount and credit amount in Journals.
     
     
  • MC-30050807-0 Profile Picture
    MC-30050807-0 54 on at
    Take on balance

     @ Kasthuri & Madhan      1:SO I DONT NEED THE BALANCING ACCOUNT ON MY JOURNAL?
    screnario 2:HOW ABOUT IF I DONT WANT TO INCLUDE OTHER ACCOUNTS AS OF NOW! IT WONT HAVE A ZERO BALANCE SINCE THE DR & CR WONT BE BALANCING
  • Suggested answer
    KR-19060856-0 Profile Picture
    KR-19060856-0 8 on at
    Take on balance
    Hi,
     
    Please follow the steps for the Opening Balance import for the Company:
     
    1. Create Journal batch for Vendor, Customer, Item and Bank and Fixed Assets and G/L Values
    2. Export the Templates through configuration package and fill the data you want import in the Journal.
    3.Import the Vendor Balances, customer Balances, Bank Balances and Fixed Assets through configuration package. For each template        you   need to mention the Journal batch
    4. Once imported the value through template, please validate and apply the package to insert the values into the gen journal.
    5. Verify the imported value in the General Journal and Post the journal
     
    When entering the values in the template, enter '-' symbol for Credit balance and without '-' as consider as debit balances.
     
    Regards,
    Kasthuri
     
  • MK-19060840-0 Profile Picture
    MK-19060840-0 6 on at
    Take on balance
    Hi,
     
     
    Please use the -sign for credit balance and +sign for debit balance, then upload the TB.
     
    Note: The total values should be zero.
     
    Regards,
    Madhan 
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 12,167 Most Valuable Professional on at
    Take on balance

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

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans