General Journal Different Line Dimensions

(0) Share

Report

Posted on by tlhgolfer

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.

How I was able to make it happen.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Bilal Haider 414 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

tlhgolfer 23 on at

Like (0)

Report

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

Was this reply helpful? Yes No