Company Credit Fund
The company credit fund can be used to allocate credits to a customer which can then be used to purchase your products and services. For instance, you could assign a client a credit fund credit of £100, which they could then use to fund or part fund an order using the credit balance.
Setting the feature up
All of the new settings can be found in the Additional Settings > Credit Fund section of the system. There are 3 new settings, they are as follows:
The first setting, a tick box, will turn this feature on, making new tick boxes available on Sales Orders to allow you to top up or use credit funds. Please note that by turning the feature on you will also disable partial invoicing however it will not work the other way so if by turning this feature on you disable partial invoicing, when turning this feature off you will not enable partial invoicing.
The second setting is a text field for a product ID which will be used as the "Replenish Stock" product. You will first need to create a product you will add to invoices to top up company credit fund. We recommend setting the list price to £1 to be able to adjust the price of the stock top up easily through quantity. Once you've created this product, you'll need to enter the Product ID into the second setting in Credit Fund Settings. Now you've got a product to use to replenish stock for a company! More on this process in the next section.
The last setting is a list of invoice statuses which will stop stock from being removed from the account, this is useful if you do not need to remove stock till the status of the Invoice is "Sent" or "Accepted" for example. You can however leave it blank if you choose.
Note: By turning this feature on all of the fields you need will be set to visible, this is useful so you do not need to go through and edit all of the fields per module as there are 3 or 4 new fields which are needed for this feature, by default they will be visible to everyone however you can limit this using the default permissions within OpenCRM, for more information about default permission please click here!
Adding to the credit fund
To add to the credit fund we have created a fairly easy process. You will need to:
- Create a sales order linked to the company you would like to add stock to
- Link the Replenish Stock product (whose ID you've entered into the second setting in Credit Fund in Additional Settings)
- Tick the "Top up Company Credit Fund" box in the "Sales Order Information" section
When you save the Sales Order it will add stock to the selected account. Once you have saved the Sales Order you will not be able to untick the "Top up Company Credit Fund" box. To determine how much stock will be added to the Credit Fund you can change the Quantity or the List Price of the selected product, (remember we recommended that you set up a Replenish Stock product with a list price of £1 so you can adjust the quantity to have an easy way to add credit fund).
Please note that you should not add other products to a Sales Order when topping up a company credit fund.
Can I limit / lock down who can add to the credit fund?
In the normal OpenCRM system we have product permissions and also field permissions, you can change these around so only certain people can access the product which is used for the credit fund top up or so only certain people have access to the Top up Company Credit Fund tick box.
For more information on permissions please click here!
What if I make a mistake - can I edit the Credit Fund Amount?
Yes, you can edit a Credit Fund Top Up sales order simply by clicking Edit and changing the amount. This will log the change in the Credit Fund Audit on the company record and adjust the credit fund figure.
Another way of doing this is using the "Update" feature at the bottom of the list view on the Companies module. This also creates an entry in the Credit Fund Audit on the company record. Please note however that entering letters instead of numbers will create a value of 0 for the credit fund, and entering a negative value will make the credit fund a negative value. The number entered into this field replaces the credit fund value, it does not add or deduct from the existing field.
However, if you have already made credit funded purchases, you will not be able to reduce the top up to less than what was required for your purchases as this would put credit fund into a negative value. You are not able to do this.
Can I mass update the Credit Fund figure?
There are a couple of ways you can mass update the Credit Fund for accounts, one way you can do this is an "Update Import" which is where you import records into the system which will overwrite the existing fields, by doing this you can set all the account Credit Funds to be (for example) 1,000.
You can also do this is using the "Update" feature at the bottom of the list view on the Companies module as explained above as a solution to making a mistake, you can use this to mass update records within the system.
Can I edit a company record to update the Credit Fund?
Although this is possible to do by changing the display id within the system we do not recommend it because you then loose the credit fund trail within the system.
Can I cancel a credit fund top up sales order?
Yes, you can, however this will not update the credit fund amount on the company record. Instead, if you need to adjust the credit fund amount we recommend one of two ways:
- Use the 'Update' feature in the companies module ( this is often used for bulk updates, but it can also be used for just one company). Select the company whose credit fund you wish to edit, then in the update field below the list of companies select 'Credit Fund' as the update field, enter the value you'd like the credit fund to update to, and then click 'Go'.
- Create a dummy product to use in an adjustment invoice. To decrease the credit fund, draw up an invoice, tick 'Is SO credit funded', and add a dummy product for the amount you'd like to reduce the credit fund by. For instance you could create a product called 'Credit Fund Reduction' with a value of 1 GBP so you can simply adjust the quantity to suit the amount you'd like to reduce by on your adjustment invoice.
Using the credit fund
When you create a Sales Order you will have the option of "Is this SO credit funded". You can tick this box to add a 100% discount to each product row, by doing this it will do a check to make sure the account has enough credit fund to cover the order. If it does the Sales Order will save as normal, if not then you will not be able to save and there will be a warning error that tells you there is insufficient funds as well as the balance. You also cannot create a credit funded SO without linking to a company, it will not save as it will not be linked to an account with sufficient credit fund.
You can edit the Sales Order at any time up until you have invoiced it. Once the Sales Order has been invoiced then the Sales Order product rows will be locked down. You can also only invoice a Sales Order once.
Once you invoice a Sales Order the stock will be removed from the company (as long as the status is not within the excluded status'). If you then decide to change the company of the Invoice / Sales Order we will add back the stock to the original company and remove it from the new company. If you change from a "blocked" status to an "active" status then it will deduct the stock however if you then change back to a "blocked" status it will add the stock back to the company (you can repeat this process as many times as you like).
How can I find out how much Credit Fund a company has left?
When you view a company record there is a field under Credit Control called "Credit Fund" - this cannot be edited however it will show a monetary amount of how much stock is left for this account. You can also check your credit fund amount by clicking the 'Credit Fund Audit' green action button at the top of a company record. The Credit Fund Audit feature also shows you incoming and outgoing credit fund.
Can I edit an existing Sales Order and turn it into a credit funded Sales Order?
Yes. To edit an existing Sales Order and turn it into a credit funded sales order all you need to do is tick the "Is SO Credit Funded" box, this will do the necessary checks to make sure there is enough stock to allocate to the Sales Order. If the checks pass this will then need to follow the credit funded sales order route of being invoiced. Please note you cannot turn a sales order into a credit funded sales order if it has already been invoiced (without cancelling the invoice).
You can not change a credit funded Sales Order back to a normal sales order, this is the same with invoices.
Can I edit a Sales Order AFTER it has been saved / invoiced?
Once you save a credit funded sales order you have until it is invoiced to edit it. Once the Sales Order has a completed invoice linked to it you will not be able to edit the product rows on the Sales Order, the reason for this is because we have already allocated the stock to this sales order. You also cannot change it to a regular invoice from a credit funded invoice.
You can cancel a credit funded sales order after it is saved but not once invoiced - a pop up will ask if you're sure.
Can I change the company on a credit funded invoice?
Once invoiced, you can still change the linked company. A check will run to ensure that the company you're changing the invoice to has sufficient credit fund to go ahead, otherwise it will not save.
What happens if I cancel or delete an invoice?
The credit fund amount will be recredited to the company, able to be used for new sales orders and invoices.