Microsoft Dynamics AX (Archived)

Vendor settlement automatic vouchers

(0) Share

Report

Posted on by Karla Chiriboga

Hi, I wish someone can help me with this.

Y have Dynamics AX 2012 R3 CU8.

When I make journas like this:

Voucher	Account (Vendor)	Ledger Account	Posting Profile	Debit	Credit
DGE000001737	1717267445	21104020001	AP	71.24
DGE000001737	1768150940001	21104010001	AP		71.24

Two vendors (vendor 1 and Vendor 2) in the same voucher (vendors have diferent groups, same posting profile, diferents acounts).

When I settle open transactions on any of the two vendors, it creates autoomatic Payment vouchers.

This vouchers cause differences between ledger vs module.

The same journals at previews dynamics versions doesnt create this vouchers.

Can someone explain me please, why this happen?

Thanks

Karla Chiriboga

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Khaled Alloud 3,658 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Can you attach a copy of these Vouchers here please?

Thank you,

Was this reply helpful? Yes No
Khaled Alloud 3,658 on at

Like (0)

Report
Copy link

Link copied!

Another thing, Please check Vendor Posting Profile form under A/P module Setup, is the checkbox Settlement checked? and A/P parameters -> settlement section, is the automatic settlement checked?

Was this reply helpful? Yes No
Karla Chiriboga 35 on at

Like (0)

Report
Copy link

Link copied!

Hi, are this checks?

Was this reply helpful? Yes No
Karla Chiriboga 35 on at

Like (0)

Report
Copy link

Link copied!

Hi,

This is the first journal, when two vendors are used in the same voucher

The for example at Vendor 2 you make a journal with vendor and bank, yo settle this transactions

And then, an automatic payment voucher is create, using the same accounts of voucher 1

This wouldn´t bring problems if I have only one vendor group, If I compare ledger vs module as total (all vendor ledger accoutns and all vendor gruous) is correct, but when I analyce each vendor group, it presents differences with its corresponding account.

Because at AP module the same vouchers has "0" balance, but in ledger balance is 71.24

Do I have to stop using two vendors at the same voucher?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

It looks that you have setup "New voucher" = In connection with balance (GL-> Setup -> Journals -> Journal names -> (particular journal) -> General -> New voucher). In this case new voucher is assigned when balance for the current voucher becomes "0". If you define offset account per each line, then voucher balance will be "0" per line, and new voucher will be created for new line. so, check mentioned setup.

Was this reply helpful? Yes No
Suggested answer

ZvikaR 184 on at

Like (2)

Report
Copy link

Link copied!

Hi Karla,

As it turns out having more than one vendor in a single voucher present conceptual design issues with the functionality of Dynamics AX in several areas including settlement, exchange rate gain/losses and cash discounts.

Microsoft published a whole white paper about the issues this is causing which you can read here:

docs.microsoft.com/.../single-voucher-multiple-customer-vendor-records

In addition, in the latest release of D365 Microsoft announced it is deprecating the ability to put more than one vendor line in a voucher, see in the link below page 61

download.microsoft.com/.../ReleaseNotes_Dynamics365_03192018.pdf

In simple, certain functionalities/algorithms that are tied to the details of a vendor transaction cannot "figure out" which of the vendor transactions to consider when performing an action.

It looks like you are running to some of the effects of that scenario.

My advise would be to follow the Microsoft recommended approach and NOT put 2 vendor lines in the same voucher.

Instead, create 2 vouchers, each with one vendor line, both posting into the same "clearing" account - so the net balance in clearing will be 0 and you can still move balance from one vendor account to another.

Was this reply helpful? Yes No
Karla Chiriboga 35 on at

Like (0)

Report
Copy link

Link copied!

Thanks Zvika, with those documents you help me a lot!

Was this reply helpful? Yes No
Faraz Hasan 212 on at

Like (0)

Report
Copy link

Link copied!

Case: customer have 2 posting profile. so moving balance from one account to another via General Journal. (same customer)

Customer DR and Clearing account CR. (posting profile 1)

11003 DR

99999 CR

new line new voucher Customer CR and Clearing account DR. (Posting profile 2)

99999 DR

18307 CR

at the time of settlement, system posting settlement entry that reverse the movement entry.

18307 DR

11003 CR

Can you please explain why system is posting settlement entry.

Was this reply helpful? Yes No
ZvikaR 184 on at

Like (0)

Report
Copy link

Link copied!

I recommend you post your question as a new thread otherwise no one can see it and respond (except for people who already responded to this thread 2 years ago)

Was this reply helpful? Yes No