Multiple Financial dimensions on one line in an invoice journal

(0) Share

Report

Posted on by Community Member

While creating an invoice through invoice journal of AP module, I have to assign multiple financial dimensions, meaning distribute the amounts. if its a 110$ invoice, distributing the amount 60$ onto one Financial Dimension and 50$ on to other FD(Financial Dimension). Any way to achieve this? set up doc ? or any blogs? will be appreciated.

Tried the following:

1. Creating multiple lines for one single invoice ( not a solution becos multiple invoices on vendor transactions)

2. through general journal is not a good idea.

3. Tried the below through an invoice journal.... Added the dimensions in the second and third line, but the offset account should also be given the dimension , where as I am able to associate only one. In my P/L it will not match.

Suggest any other solution other than these

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

The third option is common practice. Are you serious you want to track the split of transactions on your vendor account? What would be the business case for this?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I think I did not communicate properly before. I do not need the split of the transactions on my vendor account. Instead I need the split(view in dimension on my GL).

the invoice I am creating is for my government paying 100$. i.e CPLVEnd-00071(government vendor). The fee i incurred to pay to government would be from different items purchased from different vendors. 100$ would be a mix of 30$ for itemA purchased from vendor1, 35$ for itemB purchased from vendor2 and 35$ for itemC

purchased from VendorC. My offset account would be 23089(government payable G/L account) and i needed my financial dimension to be on this G/L account based on my vendors.

whole of this business case scenario would be with respect to Vendor profit share. every transaction we make on the system would be given a financial dimension and this could be calculated easily without missing(missing any king of expenses incurred on that item) anything.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi mouni,

Just some thoughts on this:

If you enter your fee transactions on the debit side of your accounting voucher together with the financial dimension, you can use this voucher later on to do an allocation later on in GL by using the ledger allocation rules.

As an example, take a voucher of the following form:

debit: expense account 1 - financial vendor Dimension 1 100$

debit expense account 2 - financial vendor Dimension 2 150$

credit vendor account - financial vendor Dimension X -250$

Based on such a voucher you could create an allocation rule that splits up and distributes the 250$ posted based on the financial vendor dimensions recorded.

This is probably not a perfect solution but to me it Looks as a feasible Workaround if it is ok for you to track the Distribution on ledger accounts in GL only.

Hope it helps,

Ludwig

Was this reply helpful? Yes No