link table for bridge transaction after posted to GL

(0) Share

Report

Posted on by agus

1,174

hi eexpert,

i'm posting GL entry by selecting function >> select bridge transactions. what i need is link after posted from "voucher bridging" to GL after posted.

where is that table ?

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (1)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Agus,

I do not understand your question.

Once you selected the bridged transactions, they will be transferred to your GL lines.

What kind of link do you need here?

Best regards,

Ludwig

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

yes ludwig,

what i mean is, after i "accept" voucher bridging, it will be transferred to GL lines, then I posted this GL. one day I want to know that this "voucher bridging" has been settle to which journal number on GL. how do i know ?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Agus,

The bridging account is first used when you make the payment.

Then the system will post for example:

DR: Accounts Payable

CR: Bridging account

This transaction has a vouche number from the payment journal.

When you clear the bridging account against the bank the system will post

DR: Bridging account

CR: Bank

Also this second transaction has a voucher that is assigned by the GL voucher number series.

What some companies do is they settle the debit and credit transactions that are recorded on the bridging account to double check only open balances that might reside there.

This can be achieved with the GL ledger settlement functionality.

Is this what you are looking for?

Best regards,

Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Agus,

If you are looking for a technical table name, then check the table LEDGERTRANSFURTHERPOSTING. This table hold all bridged transactions which are not finally posted as described above by Ludwig.

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

hi ludwig,

I describe by using your scenario :

The bridging account is first used when you make the payment.

Then the system will post for example:

1. let say I create on AP payment journal with voucher number series : "AP/VCR/123" (journal batch number : GL18000263). then system will create below journal entries :

DR: Accounts Payable

CR: Bridging account

This transaction has a voucher number from the payment journal.

2. I create on General Journal with voucher series : "MEM18/001929" & journal batch number : "GL18000264" by selected bridge voucher above "AP/VCR/123" then accept & posted. then system will create below journal entries :

DR: Bridging account

CR: Bank

once GL posted, LEDGERTRANSFURTHERPOSTING record also deleted.

then few days later, user want to know that "AP/VCR/123" has been settled to which voucher series on General journal ?

it supposed to be found voucher series "MEM18/001929" & "GL18000264" .

i want to know the related table between these 2 transaction vouchers to build some inquiry/report.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

If I understand this then you want to have the voucher from the payment included in the voucher from the bridge posting, right?

Can you try making use of the default description functionality that is available in the organization admin tool?

If do not know which default description might match.

Search possibly for something like 'settlement' or briding or alike.

Thanks,

Ludwig

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

If I understand this then you want to have the voucher from the payment included in the voucher from the bridge posting, right? ==>yes, i wanna get voucher payment bridging link to voucher GL posted.

ax does not store the link table ?what do you think ?

without using "description"

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Agus,

I checked that in my demo machine and things work as expected.

You can use default texts to get the voucher number recorded in the text field.

This number is then inherited when you make the payment and the bridge clearing posting.

This allows you following up what voucher has been used for recording, the invoice, the payment and the bridge posting.

Best regards,

Ludwig

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

thanks ludwig,

so, you suggest me to using default text & create inquiry base on that "description" ?

regarding your statement "to get the voucher number recorded in the text field. ==> how ? please show me your setup.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello agus,

Here is an example from D365FO - in AX2012 things should work the same:

Step 1: Setup default descriptions

Here you have to setup the following 3 if you record invoices via the pending vendor invoice form.

If you use journals, you might have to look for other default descriptions or enter them manually.

I have not checked that because I never use invoice journals.

Step 2: Record invoices => the default description should automatically be there in the voucher when you post the invoice

Step 3: Make the payment against a briding account.

Here the default description from the vendor - payment, vendor default description hits in. This needs to be setup as follows:

The important thing is no 4 the 'description' field.

For no 5 you can select the voucher field.

Note: You have to use the payment proposal. If you directly select a single invoice, the description text is not inherited.

Step 4: Post the payment journal

Step 5: Open a GL journal and select the bridge posting

Step 6: Open the bank transactions and check the information posted. Here is my example where I added something like the invoice number, vendor, etc. In your case, you should see the voucher numbers that have been used.

Notes:

* If you use multiple languages, please ensure that the default descriptions are setup for all languages. I made that mistake a couple of times until I noticed my issue.

* I plan to make a blog post about this. In case you are stuck, you can have a look at the post later on but it might take a couple of weeks until I publish this one. So, take a look at my blog if you like.

Hope this helps you getting this fixed and resolved.

Best regards,

Ludwig

Was this reply helpful? Yes No