After the long wait for version 4.90, we are pleased to return to our more routine release timeline. Our next upgrade is to version 4.91 which brings some highly requested improvements across the platform.
Order filters on financial reports
Orders can be assigned a channel, lead source and project to allow you to report and analyse income, costs and profit on your sales. These assignments will also filter down to the accounting level so you can filter your profit & loss report.
Sometimes it's useful to be able to look at other financial reports and take order channel, lead source or project into consideration. For example,
- To see tax liability per channel filter the nominal ledger summary report by order channel
- To see all accounting activity generated from a certain channel filter the general ledger by order channel
- To see all payments for orders from a certain channel filter the general ledger by SR journal type and order channel
Configurable columns & presets added to more reports
The popular column configuration and preset view feature is now available on all sales analysis reports:
- Sales by channel
- Sales by customer
- Sales by company
- Sales by lead source
- Sales by product
- Sales by product group
- Sales by product type
Improved account management via the payment allocation screen
Due to popular demand, we’ve added functionality to the payment allocation screen. You can still do all the things you've always been able to, but now you will also be able to:
- Enter an amount to pay and auto allocate it across invoices and credits until it runs out
- Batch select and mark which transactions to pay/unpay
- Enter an on account payment at the same time as allocating a payment
You will notice new checkboxes for each row, some batch processing buttons and new on screen fields for entering the payment details. We've added new functionality, but haven't removed anything you could already do.
Use the eBay tax amount on downloaded orders
You will now be able to choose whether to apply the tax amount to an order using the value calculated by Brightpearl or the value calculated by eBay. Find this new option on the eBay channel settings at Settings > Brightpearl Apps > eBay.
Note: When using the eBay tax calculation you will need to have set up tax in eBay, otherwise zero tax amounts will be applied to the order in Brightpearl. Brightpearl will continue to assign tax codes to orders in the same way, and therefore the tax amount from eBay will not always match up to the tax rate.
Updated purchase invoicing account creation
To prepare for multi-currency accounting, we’ve made some changes to the way that PI and PC journals are created for purchase orders when you “receive invoice”. What you will notice:
- Separate accounting journal when price corrections are made
Previously, if you had cost of sales accounting on, and you had already received inventory at value A when you receive an invoice for them at value B, Brightpearl made a cost of sales correction entry within the PI journal. This is now a separate GO journal (in base currency). That’s because the PI journal will be a foreign currency journal for foreign currency purchase orders, and inventory transactions (the GO) need to be in base currency.
- Cost of sales corrections made for zero priced products
Previously, when you received inventory at zero cost and then later received an invoice for the items with a non-zero cost, the cost of sales correction entry mentioned above was not made. Brightpearl will now automatically make this adjustment.
- A journal row per order row
Brightpearl will now create one journal line per purchase order line. Previously, Brightpearl aggregated lines with the same nominal code, but this was a source of rounding errors for foreign currency journals. As a result, your journals will now contain many more rows. We’re assessing how to make the accounting screens easier to use with large journals.
Ability to import any type of order
When importing orders you can now choose the type - sales order or credit, purchase order or credit. All orders in the same file need to be of the same type, and need to match the contact type for any contacts that already exist, i.e you can only import sales orders/credits for customers and purchase orders/credits for suppliers.
Store credit in EPOS
We've updated the store credit feature in EPOS to use order payments.
To ensure store credit is correctly recorded and accounted for in Brightpearl you must create a payment method with the code "CREDIT" and assign it a bank account. You will probably want to create a new bank account specifically for handling payments by store credit, since you probably don't want these transactions getting mixed up with money moving through your bank account which needs to be reconciled.
When store credit is used to pay for a sale in EPOS, the following things will happen:
- A new sale is created for the sold item and it is marked as paid
The sale is invoiced and shipped, an order payment is created and the SR journal is also created (as long as the bank account is set on the payment method).
- The sales credit used for paying the sale will be marked as paid
An order payment is created to mark the sales credit as paid and an SR journal is also created, provided the "CREDIT" payment method exists and has a bank account assigned.
You should also note the following:
- A store credit balance is the sum of unspent sales credit balances
Store credit will not be equal to the customer account balance as it does not include open invoices or on account payments. Store credit is the sum of any unspent sales credit balances.
Other smaller improvements
Journal type filter on GL is now multi-select
To help you get the reports you need for reconciliation we've made the journal type filter multi-select. One example of when this would be used is for your Amazon reconciliation where the payment and fees are now in separate journals of type SR and BP.
Confirmation required when cancelling payment journals
Now that Brightpearl uses order payments to mark orders as paid, all corrections and amendments to payments should be made via the orders module - changes made in accounting will affect only accounting and will not update orders. For this reason we've added in a double check and now require you to confirm you wish to edit or cancel any payment journal since it might not have the affect you desire.
New column available on sales detail report
You will find a new column available to add to your sales detail report called "order list price". This will show you the list price of an item on an order as it was at the time the order was placed, i.e. the price which was on the price list. This will allow you to compare the actual price the item was sold for against the price on the price list at that time.
Create accounting action on order payments
As of version 4.90 all orders are marked as paid by an order payment. The order payment is used to create the accounting for the payment. If the accounting wasn't created for any reason, for example, no bank account was set on the payment method, you can correct the setup and then retry.
EX type journals are now included on the VAT return
If you are using the staff expense claim feature you may have noticed that these journals were not being included on the VAT return following the change of type from JJ to EX. JJ journals were included on VAT returns, but EX weren't.