Payment before invoicing

jayshyne
jayshyne Member Posts: 29
edited 2006-01-24 in NAV/Navision Classic Client
I was wondering if there was a way in the purchases and payables section where you can make payments to orders before invoicing. I also want to know how u can then link the payments already made to the invoices you create. If there's not already a way it is handled i would like to know how to go about something like that. It would also help if i knew how i can link invoices to orders. :-k Would be of great help. thanks

Comments

  • kine
    kine Member Posts: 12,562
    There such a modules like "Advanced payments" etc... for example in Czech Navision it is local modification (but not usable for czech laws... :-)) and addons from Czech partners... but they are specific for czech laws (special handling of VAT etc.). But I am sure, that someone have such a module for general usage...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Shenpen
    Shenpen Member Posts: 386
    Solutions can range from doing it manually to developing a full advance payment solution like in Hungarian localization.

    If you don't want to program a lot, you could just enter the No. of the order to the Document No. in payment journal, and run form Vendor Ledger Entries from a new menu item on the order, filtered for document no., so you can check the amount of prepayment.

    Payment with a Payment Journal can later be applied to an invoice by going to the customer/vendor card, looking at the entries (ctrl + F5) and using the Functions menu.
    Do It Yourself is they key. Standard code might work - your code surely works.
  • Savatage
    Savatage Member Posts: 7,142
    edited 2007-04-19
    Here's how to record a Deposit(Payment) from a Customer and have it applied against an Invoice later.

    When you receive the Deposit, enter the Deposit in the Cash Receipts Journal:
    1.Enter the date
    2.Set the Document Type to Payment
    3.Enter a reference for the Check Number in the External Document Number
    4.Account Type will be "Customer" (in this example)
    5.Enter the Customer Number
    6.Enter a Description for the Deposit
    7.Enter the Deposit Amount as negative.
    8.Enter the balance Account Type as "B" for Bank
    9.Enter the Bank Account Number for the Deposit.
    10.Post.

    This will debit the bank Account for Cash and credit the Customer Account and A/R.
    ______________________________

    When it's time for you to Invoice the Customer, go into Sales Invoices or Sales orders (depending):

    1.Enter the Order or Invoice as normal.
    2.Make sure you've added the Applies to Document Type and Applies to Docment Number field to the Sales header Form, and enter Type Payment, and select the applicable number in the Applies to Document Number field.
    3.Enter the Sales Order or Invoice
    4 Post the Invoice.

    As this posts, the Customer Prepayment will be applied against the related Posted Invoice that you are recording. This will credit Sales, credit Sales Tax Payable if applicable, and debit your Customer Account and A/R, and the Payment will offset the Invocie in the Customer Ledger Entries.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • lkirk@aquasys.biz
    lkirk@aquasys.biz Member Posts: 1
    We have scenarios where customers will pay before they are invoiced. Our customers are set up with Application Method = Apply to Oldest (automatic application of payments). We have Unrealized Tax set up on the GL setup. We also have Unrealized Tax Type set to Last (Fully Paid) in Sales Tax Juristiction setup. When an invoice is posted which automatically applies it to the prepayment, the tax is posted as unrealized. It never moves to the amount field in the VAT Entry Table (i.e., is never realized). Does anyone know how to make this work without using Application Method = Manual? :o

Categories