Monday, June 2, 2014

Payments in advance ( prepayment ) To a Vendor | AX 2012

This Article discuss Payments in advance ( prepayment ) to a Vendor. This article divided into three parts
  • Introduction
  • Setup (Step by step with screenshots )
  • Implementation (Step by step with screenshots )
Introduction:                                                                          

Accounting practices in many countries/regions require that prepayment journal vouchers, or payments in advance, from a customer or to a vendor not be posted to the usual summary accounts for the customer or vendor. Instead, these prepayment journal vouchers must be posted to special ledger accounts for prepayment journal vouchers. When a sales order or purchase order is made, an invoice is issued to the customer or vendor. When the invoice is paid, the prepayment journal voucher and sales tax prepayment journal voucher on the ledger accounts for the prepayment journal vouchers are reversed. The invoice amounts are then automatically posted to the usual summary accounts.




 Setup:                                                                                     
    • Create Prepayment Posting Profile
1- Click Accounts Payable > Setup > Vendor Posting Profiles.
  1. Click New to Create New Posting Profile


  2. Write the posting profile name in the Posting Profile Field for example "PRE".


  3. Write the posting profile description in the Description Field for example "Prepayments".


  4. Go to the Setup Section.


  5. Click the Add Button and select All form the Account Code Filed to apply the setup for All Vendors in the legal entities


  6. Select the prepayment summary account from the summary Account filed.


  7. (if required) Select the prepayments sales tax Account from Sales Tax prepayments Filed. 


  8. Press the Close Button.


    • Setup Account Payable parameters to use prepayment posting profile 
  1. Click Accounts Payable > Setup > Accounts Payable parameters.


  2. Click Ledger and sales tax from the left pane then open the prepayment journal voucher Section .


  3. If sales tax is calculated and posted when you post a prepayment journal voucher, select the Sales tax on prepayment journal voucher check box. 


  4. In the Posting profile with prepayment journal voucher field, select a posting profile to indicate the accounts to which the prepayment journal voucher and sales tax prepayment journal vouchers are posted. (Select the Posting profile was created in the previous setup)
  5. Press the Close Button


Implementation:                                                                      
  • Create a prepayment journal voucher
  1. Click Accounts Payable > Journals > Payments > Payment journal.  
      
  2. Create a journal.
      

  3. On the Setup tab, select the Amounts include sales tax check box if you want to post the prepayment journal voucher together with sales tax amounts.

  4. Click Lines, and then create the payment line.

  5. On the Payment tab, select the Prepayment journal voucher check box. The posting profile changes automatically to the posting profile for the prepayment journal voucher.

  6. Post the prepayment journal voucher.

  • Settle Customer invoice with the prepayment.
  1. Click Accounts Payable> Common > Vendor Invoices > Open Vendor Invoices.


  2. Select Invoice and Click the Settle Open Invoice Button.
  3. In the Settle open transactions form, settle the invoice with the prepayment journal voucher
To get new posts and updates, please follow the blog by clicking the Join this site Button in the top-right side under my personal information

5 comments:

  1. Thanks Shafeaa'
    if i make a prepayment and link with PO vendor balance not correct !!!!.

    ReplyDelete
    Replies
    1. Dear Ahmad,
      what do you mean by PO vendor balance ? do you mean the summary account that we normally use for AP in the Vendor posting group ?

      Delete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Very good effort in explaining the vendor prepayment, here i have one question, can go through the following link, i have some problem and the details you can see and please suggest me the solution my email id is ulhaq.imran@gmail.com

    http://dynamicsuser.net/forums/t/74364.aspx

    Waiting for your reply, thanks in anticipation.

    ReplyDelete