Finance | Project Operations, Human Resources, ...

Free text Invoice posting Summarized ledger entry in Voucher transactions

(0) Share

Report

Posted on by saurabh bharti

15,039 Moderator

Hi All,

Here is one clarification or input require from all of you.

Scenario: I have created one free text invoice with two lines both lines are having following information:

Line -1 : Description Rent for the month, (Main Account-Dimension) 301001-BU01 Amount 400

Line-2: Description Maintenance for the month, (Main Account-Dimension) 301001-BU01 Amount 50

Now when i post this entry, here is what i see in voucher transactions:

Two line:

Customer debit 450

301001-BU01 Credit 450

Is it possible to get three lines?

Customer debit 450

301001-BU01 Credit 400

301001-BU01 Credit 50

Please suggest the same.

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

You can get three lines only if there is an accounting 'difference' between line 1 and line 2.

As an example, you need to post line 2 on a different account of financial dimension.

Otherwise, D365FO summarizes the lines automatically.

Best regards,

Ludwig

Was this reply helpful? Yes No
saurabh bharti 15,039 Moderator on at

Like (0)

Report

Thanks Ludwig for quick response.

I understand that it summarize, is there any way to get three lines with same main account and dimensions?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Saurabh,

I don't know any trick that would help here.

Best regards,

Ludwig

Was this reply helpful? Yes No
Elsa Guo on at

Like (0)

Report

hi Saurabh,

User need to post line 2 on a different account of financial dimension. or AX will summarizes the lines automatically.

FYI.

docs.microsoft.com/.../accounting-distributions-subledger-journal-entries-free-text-invoices

Thanks.

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

Hi Saurabh,

Just thinking loudly, Is your customer not willing to create 02 different ledger accounts for Rent and Maintenance income :)

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Hi Junaid,

That's just example i have taken, this scenario can be for other ledger account as well.

So, requirement is to see each free text lines as individual entry in voucher transactions even if there share same ledger and dimensions.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Saurabh,

You won't be able to achieve that without using a workaround such as an additional financial dimension that differs between the lines.

The same applied to other kind of invoices that you have for sales orders, purchase orders, etc.

Best regards,

Ludwig

Was this reply helpful? Yes No