AX 2012 R1 - Vendor Settlement duplicate entries

(0) Share

Report

Posted on by MuthukumaranAX

2,903

Hi All,

While doing vendor settlement after posting the payment journal, we see duplicate entries are also being created from the settlement.

has anyone faced this issue? pls let me know.

thanks.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

André Arnaud de Cal... 303,724 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Some questions: Where do you see these duplicate entries? In a form? Which form? Can you also see multiple records in the related table(s)? Then we can see it is a data or display problem.

Was this reply helpful? Yes No
MuthukumaranAX 2,903 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for the response.

I'm seeing the duplicates data in vendor transaction form and yeah the data's are available in the tables as well.

Also I don't see the journal ref number in the duplicate entries.

Thanks.

Was this reply helpful? Yes No
Matloob 781 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Are the voucher numbers are same for those duplicates entries in vendor transactions form ?

Was this reply helpful? Yes No
MuthukumaranAX 2,903 on at

Like (0)

Report
Copy link

Link copied!

Yes the duplicate entries are having same voucher numbers.

Was this reply helpful? Yes No
Suggested answer

Matloob 781 on at

Like (0)

Report
Copy link

Link copied!

By saying creating duplicate lines ,are you referring to the following example ?

If yes, then it is standard system behavior when user settles two transaction both them will have an offset line as shown below, but only one voucher will be posted in GL and the module.

Regards

Mohammad Matloob

Was this reply helpful? Yes No
MuthukumaranAX 2,903 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for your screenshot. can you send me a screenshot for multiple vendor and multiple invoice settlement transaction screen.

thanks again

Was this reply helpful? Yes No
Suggested answer

Matloob 781 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Same behavior will be on all vendors, its not vendor specific. If you are facing something else then described above please let me know that specific problem.

Was this reply helpful? Yes No
MuthukumaranAX 2,903 on at

Like (0)

Report
Copy link

Link copied!

Hi,

below is the scenario

Vendor 1 has Inv-1 with 100 USD and Inv-2 with 200 USD .

Vendor 2 has Inv-3 with 100 USD and Inv-4 with 150 USD

Now if do the settlement for the above mentioned invoices after posting the journal i am seeing in the transaction like below

Vendor -1

-------------

Voucher Date Amount in trans. currency currency

--------------------------------------------------------------------

Vouc-1 11/10/2012 300 USD

vouc-1 11/10/2012 100 USD

Vouc-1 11/10/2012 200 USD

-------------

Vendor -2

---------------

Voucher Date Amount in trans. currency currency

--------------------------------------------------------------------

Vouc-2 11/10/2012 250 USD

vouc-2 11/10/2012 100 USD

Vouc-3 11/10/2012 150 USD

is this the standard behavior?

thanks

Was this reply helpful? Yes No
Matloob 781 on at

Like (0)

Report
Copy link

Link copied!

It will be better if you copy past the screen shot also.

Was this reply helpful? Yes No
shardendu Prakash S... 40 on at

Like (0)

Report
Copy link

Link copied!

Hi ,

Please tell me why is showing invoice balance double in vendor transaction form?

Example : Vendor Invoice -- -50000

Balance -- -100000

Was this reply helpful? Yes No