Microsoft Dynamics AX (Archived)

Prepayment to Vendors

(0) Share

Report

Posted on by Community Member

Dear All,

I have done the setup for Prepayment to vendors in ax 2012 R3.

01)Vendor Posting profile:- Created new item "PRE" and assigned to "Prepaid account"

02)Account Payable Parapameters" under Ledger & Tax : Prepayment posting profile with Prepayment tick button enabled.

03) Under inventory management -Posting -Prepayments given main account "Prepaid account".

I hope all the places I have given the correct setting but whet i'm making Prepayment for PO vendor statement getting two time Dr and two times Cr.

Basically one Dr and one Cr should come.

Please suggest is there any other fields to be corrected.

Zuresh

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi zuresh,

For no 02) Have you specified the prepayment posting profile also in the section "prepayment" in the AP Parameters Ledger&SalesTax section?

Can you provide some additional information on the steps that you followed for recording your prepayment?

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Ludwig,

Yes..Under I have selected both . 01) Posting Prepayment with Profile and 02)Posting profile with Prepayment journal voucher.

Steps:

Under PO I just give 50% Advance as description and 50% given.

Next under PO I select Invoice and select "Prepayment Invoice" then post the invoice.

Payment Journal selected and posted the payment journal. While Payment journal posting under "Payment" tab and enabled tick box "Prepayment journal voucher"

Also Ludwig, I'm getting doubt whether I have given the correct Vendor posting profile account.

Zuresh

Was this reply helpful? Yes No
Suggested answer

Prashant Singh 8,802 on at

Like (0)

Report

Dear Zuresh,

In AX you can manage advance payment in two way

1. Advance payment against vendor

2. Advance Payment Against Purchase Order order amount $700

Bothe the case parameter selections and configuration is different. In your scenario you are talking about advance payment against vendor.

Once you will invoice the prepayment order

system will do the following entry

Dr. Prepayment $700 Cr. Vendor Balance $700

Once you will make the payment system will do the following entry

Dr. Vendor Balance $700 Cr. Bank $700

when you will make the invoice after goods receiving system will

Cr. Vendor Balance $700 Dr. Inventory $700

Cr. Prepayment $700 Dr. Vendor Balance $700

So I think you are worried about the double entry in vendor statement just because of settlement voucher.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Mr Prashant,

Thanks for the reply. Issue raised for Prepayment is "Prepayment against PO" not against "Prepayment against Vendor". Please can you give the some idea why the entries are updating in two times..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Zuresh,

According your post, it is found that you have defined Prepayment ledger in both sections (AP and Inventory) instead using different, hence the posting is happening twice for same ledger. to resolve the same you have to define Vendor in AP posting and Prepayment ledger in Inventory postings

then the prepayment will affect as below

Dr. Prepayment/ Advance to Vendor

CR. Vendor A/c

********

Was this reply helpful? Yes No