Vendor payment journal line aggregation

(0) Share

Report

Posted on by MartiT

Due to the integration, we receive one journal with a large number of lines. These lines all have the same account and offset account, but different amounts.

Tell me, please, does it exist any way to post these lines in the form of one transaction?

I thought about the principle of creating lines through proposal with the "total" parameter

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (2)

Report

Hi,

This is of course possible as long as your dimensions are same for all the journals, all you need to do is to write some logic/code to marge those lines into one line and import in journal.

If you need the help in code, kindly post a new question with that particular ask, experts will help you on this.

Again, note- this is not a complex thing, so you can talk to your developer.

Was this reply helpful? Yes No
Verified answer

Kadir Karaman 125 on at

Like (1)

Report

Hi MartiT,

Ramit is right, you can easily with developer.

In addition to, if Journal Name setup form in Detail level is "summary" for your journal and you post the large number of lines same account and offset account (if dimension's value of course). Your voucher will be created as a 2 lines and your balance will be marge.

I suggest, first you can do test environment this function.

Open journals have a same detail level on general tab and you can change it there.

Regards,

Was this reply helpful? Yes No
OhArthit 25 on at

Like (0)

Report

[deleted]

Was this reply helpful? Yes No
Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hi,

Your question is not clear, what do you mean by 'Transaction;?

If this is for vendor invoice, then regardless of any lines, only one vendor transaction gets created.

And, if you want to see the one voucher for all the ledger accounts, kindly follow the approach "Kadir Karaman" has mentioned above

Was this reply helpful? Yes No
Verified answer

saurabh bharti 15,039 Moderator on at

Like (1)

Report

Two options:

1. Check Journal name setup parameters posting summarised or total

2. Customize based on similar nature of data

Was this reply helpful? Yes No