Generate Invoice from SO without Shipping Items - Down Payment Required

We have some customers who are on credit hold. We require that they pay either a percentage of the order or the entire order before the items are shipped. How would we create an invoice from the sales order listing the items and their cost and then once they pay ship the items?  We are a relatively small privately owned company.

It would basically be nice to have a special line item on the Sales Order that is for Down payment or Pre-payment that could be invoiced and then once received the rest of the items could ship and would generate an invoice amount of the total order less the pre-payment. 

Any help is appreciated.

  • 0

    We do this on a regular basis when requiring a down payment for a large order or because of a similar credit issue. We created a miscellaneous item code (/Downpayment) that is added to the invoice. All the sales order items are listed with a shipped quantity of zero. Then when shipped and the final invoice is generated, simply add the downpayment code again as a negative to correctly reflect the balance due.

  • 0 in reply to laray

    I should add that the misc. item code is linked to a customer down payment liability account so that no revenue is recognized until the items are shipped and invoiced.

  • 0

    You don't need to list the cost, you are just taking a deposit on the order. Just create a Performa invoice out of a sales order form and print it out.  When the money comes in just enter the check number on the totals page and enter the amount. The balance will show up.

  • 0 in reply to BigLouie

    How does one enter/create a pro-forma invoice in Sage 100 (2018)?

  • 0 in reply to DDW

    Create a new sales order form code and edit the Order Title formula.  Here is ours. Note that if the order is a Quote or Sales Order it says Proforma Invoice.

    select case {SO_SalesOrderWrk.OrderType}
        case "S"
            formula = "Proforma Invoice"
        case "B"
            formula = "Proforma Invoice"
        case "M"
            formula = "Master Order"
        case "R"
            formula = "Repeating Order"
        case "Q", "P"
            formula = "Proforma Invoice"
    end select

  • 0 in reply to BigLouie

    That is the approach we want to take.  However, I cannot figure out how the deposit is flowing into the correct GL account.  The account is set up in the GL and in SO Options but nothing is showing up in that GL account. So where is the deposit recorded or what am I doing wrong?