Managing Prepayments of Deposits in the Customer Order Process
Introduction
A deposit payment is defined as a payment that must be placed before releasing the acquisition of goods. Stock supplied through hard-coded order-initiated acquisition orders or supply chain orders is blocked from release until the deposit is paid by the customer.
This is similar to the prepayment solution for customer orders connected to advance invoicing processes activated with the 'Adv invoicing' setting type 3-'Adv invoicing allowed. Prepayment calculated' in 'CO Type. Open' (OIS010).
Use of deposit
During customer order entry, a check for deposit is performed. If there is a valid setup in 'Advance Invoice Selection Table. Open' (OIS121), the deposit amount is automatically calculated and assigned to the order.
When leaving the order header, 'Customer Order Deposit. Open' (OIS157) is started automatically, where a list of deposit and remaining balance amounts per planned payment date is displayed including VAT amounts. The deposit amount displayed in (OIS157) at order level is the sum of its calculated value per its order lines as displayed in 'Customer Order Deposit Lines. Open' (OIS158).
For an existing order, the deposit program can be launched by selecting the 71='Customer Order Deposit. Open' option in 'Customer Order. Open Toolbox' (OIS300).
Setup
- Use a customer order type with the 'Adv invoicing' setting set up with the 5-'Deposit' alternative in (OIS010).
- Use a payment term with the 'Payment prop' setting selected in 'Payment Term. Open' (CRS075).
- If the 'Payment prop' check box is not selected, the order is treated as if 'Adv invoicing' is set to 1-'Advance invoicing allowed'.
- To launch the cash desk for payment of the deposit, the 'Cash dsk active' setting must be selected in (OIS010).
- To have specific payment terms for the deposit, the 'Deposit payterm' field must be defined in (OIS010).
Change a deposit amount connected to the customer order
A manual change of the deposit amount is made on the order line level in (OIS158).
The deposit line program can be launched by selecting the 11='Prepayment lines' option in (OIS157) or 72='Customer Order Deposit Line. Open' option in (OIS300).
The advance invoice type controls if a manual change of the deposit is allowed and defines a tolerance percentage for the change, per setup in 'Advance Invoice Type. Open' (OIS122).
Print of advance payment document and order confirmation
When you are ready with the customer order, you must print an advance payment document and hand it to the customer for the deposit payment.
In addition, you can print an order confirmation document if an overview of the entire order is requested by the customer, that is, all order lines including order totals.
Use the 6-'Print' option in (OIS157) to print the advance payment document for the deposit and the F14-'Customer Order. Print Confirmation' action in (OIS157) to print the order confirmation.
- Order confirmation document, both at the order line level (XML section type PREPAY_LIN on level 5) and on the order level (XML section type PREPAY and PPAY_TAX on level 3).
- Advance payment document (OIS199PF variant 04) at the order line level (XML section type PREPAY_LIN on level 5).
Payment of the deposit
Payment of the deposit creates an advance invoice per VAT code. The advanced invoices are automatically reconciled with the payment, as for 'Adv invoicing' type 3. The difference from 'Adv invoicing' type 3 is that the payment of the deposit does not create one advance invoice with a default VAT code.
The advance invoices can be configured not to be printed, as the customer instead gains a receipt upon payment of the deposit against the advance payment document.
The 'No printout' setting on 'Settings - Customer Order Invoicing' (CRS722/F) controls if the advance invoice is printed. If selected, the advance invoice is not printed, and the delivery invoice references the advance payment document instead of the advance invoice.
Release for delivery and invoice
Once the goods have arrived in inventory, there are several ways to manage the delivery and invoice process to the customer.
You can release the goods for delivery from (OIS157) if everything on a 'Remaining balance' record is allocated and is to be delivered at the same time. (There are several 'Remaining balance' records if the order lines have different planning dates.) Use the 21-'Release for delivery' related option to process the delivery through the normal dispatch flow.
Use the 22-'Deliver and invoice' related option to bypass the normal dispatch flow and directly invoice the delivery.
You can also release the goods for delivery from (OIS158). Here you can also release the goods if not all the goods for a 'Remaining balance' record should be delivered simultaneously.
Use sorting order 1 when releasing goods for delivery in (OIS158). This is the default sorting order when called from the menu or from (OIS300). The F14-'Propose quantity' action proposes the allocated quantity for release. You can enter or change the quantity manually. Use the F17-'Release for delivery' action to process the entered quantities through the normal dispatch flow. Use the F18-'Deliver and invoice' action to bypass the normal dispatch flow and directly invoice the delivery.
Cancellation of order and refund of the deposit
A deposit refund can be manually created in 'Customer Order. Invoice in Advance' (OIS105) when an order is cancelled.
Limitations
- You cannot use a deposit customer order type (when you create a customer order in OIS100) in a Sales Tax Division. That is, in a division where the 'Tax method' > 1 on 'Company. Connect Division' (MNS100/G).
- The prepayment deduct method 1='Offset as credit note' in (CRS722) is not supported.
- Different payment terms per order line are not supported. The reason for this is that it is the 'Payment prop' check box on the 'Payment terms' on the customer order header that dictates whether the order is executed as a deposit order or a normal order.
- Order total discount is not considered when calculating the deposit and the remaining balance. This means that the delivery invoice becomes negative if the order total discount is greater than the deposit.
- Discount in kind is not supported.
- Charge calculation methods 1-'Fct*gross prc' and 2-'Fct*net prc' are not supported.
- Kit items are not supported.
- Core items are not supported.
- Warranty management is not supported.
- Copy from a normal order to a deposit managed order is not supported.
- Quotes through EQM are not supported.
- Automatic closing of payment proposal through 'CO Delivery. Close Payment Proposal' (OIS952) is not supported.
- Rounding applied to the deposit ('Rnd-off cat' on (OIS010/K)) is not settled on the
delivery invoice. Example: If a $0.25 rounding is paid on the deposit amount $99.75 (pay
$100.00), only $99.75 is deducted on the delivery invoice. Note: The rounding amount creates a separate advance invoice record.
- 'VAT sum method' 2-'Base mult rate' gives rounding differences since the VAT calculation is split up on two smaller base amounts (a deposit and a remaining balance) compared to when calculating the VAT for the full order amount.
- Amount charges with 'Debit frequency' 1-'First delivery' and using 'Release for delivery' are not supported. The charge is incorrectly included in the amount for the new remaining balance too. The invoiced amount is however correct.