Set up Prepayments

Overview

  • Learn how to setup prepayments 

Why setup prepayments? 

You can use the prepayment functionality if you require your customers to submit partial or full payment before you ship an order to them, or if your vendor requires you to submit a partial or full payment before they ship an order to you.  

How to setup prepayments? 

The following parameters need to be set up before you can use prepayments. 

  • Assign G/L accounts on general posting setup for prepayments 
  • Set up a number series for prepayment documents 
  • Assign prepayment percentages 

General posting set up  

You’d need to set up G/L accounts to where the prepayment would be recorded until the final invoice is posted.  

Note: 

  1. Customer prepayments are in a Liability account until the items are shipped. 
  2. Vendor prepayments are in an Asset account until the items are received.  
  1. Search for General Posting Setup on the top right-hand corner of your Wiise page. Select the related link. 

    GPostingsetup
  2. The General Posting Setup table is displayed below.  
General Posting Setup List
    1. Every line that contains a combination of the general business posting group and general product posting group that requires updates as follows: 
      1. In the Sales Prepayments Account field, enter the G/L account to use for posting sales prepayment amounts.  
        Sales Prepayments Account
      2. In the Purch. Prepayments Account field, enter the G/L account to use for posting purchase prepayment amounts. 
        Purchase Prepayment Account
  1. You’ve completed the general posting setup. 

Set up prepayment verification and number series  

Prepayment verification ensures that inventory isn’t shipped to a customer or received from a vendor before the prepayment invoice is applied. 

For every type of prepayment document that is used, you must set up a number series. The prepayment documents are as follows: 

    1. Sales prepayment invoices 
    2. Sales prepayment credit memos 
    3. Purchase prepayment invoices 
    4. Purchase prepayment credit memos

Note: You can use the same number series for prepayment invoices, regular invoices and credit memos. Or you can use different number series. 

  1. Search for Sales & Receivables Setup on the top right-hand corner of the Wiise page. Select the related link.  
  2. The Sales & Receivables Setup table below is displayed.  

    Sales & Receivables Setup
    1. Expand the General section. 

      Sales & Receivables Setup General Section
      1. Enable the Check Prepmt. when Posting toggle button to prevent the posting of invoices before the receipt of the prepayment amount.  
      2. The Prepmt. Auto Update Frequency field specifies how often the job must run and automatically updates the status of sales orders that are pending prepayment.
      3. Select the drop-down menu to either never update automatically or update daily or weekly.
    2. Expand the Number Series section.
       
      Number Series
      1. In Posted Prepmt. Inv. Nos. enter the number series to assign numbers to sales prepayment invoices when they’re posted. 
      2. In Posted Prepmt. CR/Adj Note Nos. Enter the number series to assign numbers to sales prepayment credit memos when they’re posted.  
  3. Search for Purchase & Payables Setup on the top right-hand corner of the Wiise page. Select the related link.  
  4. The Purchase & Payables Setup table below is displayed.
     
    Purchase and Payables Setup
    1. Expand the General section.  

      PPSG
      1. Enable the Check Prepmt. when Posting toggle button to prevent the posting of invoices before you pay the prepayment amount. 
      2. The Prepmt. Auto Update Frequency field specifies how often the job must run and automatically updates the status of purchase orders that are pending prepayment. Select the drop-down menu to update automatically or update daily or weekly. 
    2. Expand the Number Series section.
       
      PP Number Series
      1. In Posted Prepmt. Inv. Nos. enter the number series to assign numbers to purchase prepayment invoices when they’re posted. 
      2. In Posted Prepmt. CR/Adj Note Nos. Enter the number series to assign numbers to sales prepayment credit memos when they’re posted. 
  5. You’ve completed the setup for prepayment verification and number series.  

Assign prepayment percentages 

Note: You can specify a default percentage for prepayments to use for all sales and purchases or for just an item for all customers or vendors, for a customer or vendor price group or for a specific customer or vendor. Set up this default in the Prepayment % field on the customer and vendor cards or on all sales and purchase orders lines. 

  1. Search for items on the top right-hand corner of the Wiise page. Select the related link.  
  2. You’ll see the Items list as displayed below.  

    items list
  3. To update the sales prepayment percentages, select an item. When you’re in the Item Card, select Related. From the drop-down menu, select Sales. Then, select Prepayment Percentages.  

    Item card
  4. The table below is displayed. Fill in the field with the following information:
     
    SPP
    1. Sales Type: Specifies whether the prepayment percentage is defined for a single customer, a customer price group or for all customers.  
    2. Sales Code: Depending on the sales type, fill in the unique code of the customer or customer price group.  
    3. Item No: Defines which item the prepayment percentage is for. 
    4. Starting Date and Ending Date: Defines a period in which the prepayment percentage is valid.  
    5. Prepayment %: The prepayment percentage you will require.  
  5. To update the purchase prepayment percentages, select an item. When you’re in the Item Card, select Related. From the drop-down menu, select Purchases. Then, select Prepayment Percentages
  6. The table below is displayed. Fill in the field with the following information:
     
    PPER
    1. Vendor No: Specifies which vendor the prepayment percentage will be defined.
    2.  Item No: Defines which item the prepayment percentage will be for. 
    3. Starting Date and Ending Date: The period in which the prepayment percentage is valid.  
    4. Prepayment %: The prepayment percentage you will require. 
  7. You’ve completed the Prepayment setup.  

What’s next? 

Once you’ve set up prepayments on Wiise, you can now proceed to process the prepayment invoices related to sales or purchase order.  

 

Need more help?  

No problem, that's what we're here for. Reach out to support@wiise.com anytime you can't find what you're looking for.