Mandatory deposit (%) per customer for order to work order
This feature allows you to assign a default percentage when creating a new customer. A combination of the customer's credit limit and a mandatory deposit percentage activates the mandatory deposit feature. When exceeding the limit, a window appears indicating the amount required to allow the order transfer to work-order.
This document explains the available configuration, usage, and functionality, as well as some of the available permissions.
Configuration
In the general configuration, ‘Accounting’ tab, ‘CAR’, it is possible to assign a mandatory order deposit %.
Creating a customer
When creating a customer only, the mandatory order deposit % from the general configuration is automatically assigned. This data can be entered under the 'Accounting' tab of the customer file.
Use
This feature is triggered and used when an order is transferred to a work order.
This section explains the calculations used for triggering and usage.
If a credit limit is exceeded, the following window appears:
Calculation method
Customer file
A- Represents the unpaid invoice balance
B- Credit limit used for unpaid invoices and order-to-work order transfer
C- Total amount of deposits (unbilled)
D- Percentage of required deposits when order-to-work order transfer
Overdraft window (order to work order)
1- Credit limit from the customer file (B in the customer file)
2- Represents the unpaid invoice balance (A in the customer file)
3- Total amount of unbilled WOs including selection (without tax)
4- Total amount of deposits (unbilled) (C in the customer file)
5- Percentage of mandatory deposits when transferring an order to a work order (D in the customer file)
6- Amount (taxes included) of the total WO during a transfer action in work order. Information not used. For demonstration purposes.
In the overdraft image, the required amount requested is $3811, 15.
Here's how the calculations are performed.
X = % Mandatory Order Deposit (5) X (Total Unbilled WOs (3))
X = 10.5 % X (112 000 $) = 11 760 $
IMPORTANT: The credit limit - the unpaid invoice balance can result in a negative. Subtracting a negative becomes a positive. The calculation takes this into account.
Y = X - (Customer Credit Limit (1) - Unpaid Invoice Balance (2)) - Amount of Unbilled Deposits (4)
Y = 11 760 $ - (10 000$ - 10 001,15 $) - 7950 $ = 3811,15 $
The customer must therefore provide this amount of $3811, 15 to begin the work.
Authorization (without permission)
Without permission, a user with access can allow the overdraft.
Permission: Create a work order for an overdue account.
A window appears an asked a username and password from a user having the rights to proceed.