Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / General Journal Differ...
Small and medium business | Business Central, N...
Answered

General Journal Different Line Dimensions

(0) ShareShare
ReportReport
Posted on by tlhgolfer 6

I have a question I want to make sure I am not missing something on.

I have a customer we want to import customer invoices and can use a general journal to import them the only issue is if I import to one line using a balancing account the AR account also takes on those dimensions which is not what we want.  We want the 1500 to have no dimensions and the income to have dimensions.  Is this possible other than two lines?  I have tried defaults and review priorities, but nothing is working other than two lines.

Thanks in advance,

Tanya

What we want.

pastedimage1625760382613v2.png

How I was able to make it happen.

pastedimage1625760405625v3.png

Categories:
Dynamics 365 Business Central
  • Verified answer
    tlhgolfer Profile Picture
    tlhgolfer 6 on at
    RE: General Journal Different Line Dimensions

    Yes you are correct I don't really want to have the customer import sales invoices as I know that this would handle the issue.  I will take a look at the link and see if that will be better.  The double line is not horrible and it works and they only import once a month and have to manipulate the file a lot to get it to work.  Better than keying it in!

    Thanks everyone,

    Tanya

  • Suggested answer
    JAngle Profile Picture
    JAngle 46 on at
    RE: General Journal Different Line Dimensions

    If you use actual invoices this issue is avoided as the background posting takes it a line at a time. Meaning you can have different dimensions at header (AR account) and lines (revenue account). If you’re looking to avoid a bad import experience I can see why this option was neglected.

    To enhance the journal import so working on a multi line file isn’t as bad you could use: joshanglesea.wordpress.com/.../

    Found it to handle larger journals better than the edit in excel tool or configuration packages. If you need it to do 8 dimensions you’ll need 8 custom fields which then call the gen. journal line vaidateshortcutdim functions

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 41 on at
    RE: General Journal Different Line Dimensions

    Hi Tanya,

    As per my knowledge you are not missing anything. In BC, journal is the lowest level in posting routine and when posting from a Journal the dimension to the general ledger entry is transferred by using the Gen Journal line field called Dimension Set ID.

    So when you use two accounts in single line then both of them will have same Dimension Set ID and hence same dimensions on General Ledger Entries. 

    eeeee.PNG

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans