4.90 Release notes

Great news! Your next Brightpearl upgrade is getting close and it’s jam packed with new features, improvements and bug fixes - configurable columns, preset views, product archiving, not to mention the numerous improvements to accounting and order processing.

We’ve kept you waiting, but for good reason - this release is one of our biggest yet and one of the most complex upgrades we’ve done. It’s been no secret that we’ve been working on introducing full multi-currency support and whilst there are a huge number of changes you can see, there are also many you can’t...not yet anyway!

So here are our 4.90 release notes - and they are long. We’ve also got plenty of additional documentation to help you learn more about the changes and make sure you’re ready for your account upgrade - and there is plenty that you will want to know about.

Do I need to do anything?

There are some important changes to Brightpearl which will need your special attention to ensure you get the most out of this upgrade. For some of these changes you will need to do staff training and others will possibly mean your apps need updating. Please download our 4.90 Upgrade Guide to find out what you will need to do before and after your account is upgraded.

If you are a developer, all API changes are listed in the release notes. Please see our 4.90 & 4.91 API changes guide to learn more about what you will need to update on your apps.

If you have any questions or concerns then we’re here to help, so don’t hesitate to get in touch via Support@brightpearl.com.

Watch our release video

When will it be released?

We are currently in our final round of testing and expect the upgrade to be widely available towards to the end of May to early June. We’ve shared our release notes much earlier than we have in the past so that you have plenty of time to be ready for the coming changes.

Features, improvements & bug fixes

• New filters, column customisation & preset views
• Product statuses & archiving
• Products display all price lists
• Drop-ship improvements
• Order payments, payment methods & payment lists
• Foreign currency to base order total conversion
• Reset, migrate & begin to use the Brightpearl accounting module
• Journal types
• Amazon Canada
• Taskbot
   
• General accounting improvements
  • Auto-updating & fixed exchange rates on orders
  • US balance sheet improvements
  • Default invoice template per contact
  • US chart of accounts import
  • Journal assignments applied consistently
  • Landed cost reports shows inaccurate actual landed cost
  • Improved nominal code drop-downs
  • Zero value invoices
  • Batch purchase invoices
  • Write-offs/adjustment only transactions
  • Customer statement templates
• General order improvements
  • Order dates now easier to understand & always editable prior to invoicing
  • Total stock quantity count now also displayed on purchases & credits
  • Batch deleting goods-out notes
  • Display stock quantities on purchase order rows
  • Send cc, bcc emails
• General contact improvements
  • EOM Credit terms improvements - templates & contact import
  • New fields when adding a staff member
• Other improvements
  • New sales reports permission
  • Order payment status displayed on product info pop-up
• General apps & app store improvements
  • Amazon payments & fees
  • eBay global shipping program is supported
  • PayPal app now shown in the App Store
  • Sagepay app now shown in the App Store
  • New filters & messaging in the App Store
  • Warehouse types
  • Warehouse zones
• API improvements
   
• Deprecations
  • Customer > Take payment, and Supplier > Make payment screens have been removed
  • Add new quote or invoice is now add new order
  • Order refs on journals are locked
  • Account balances on chart of accounts no longer display by default
  • Payment method field has been removed from contacts
  • Customer/supplier financials screen is now the GL filtered
  • Recent payments are no longer displayed on customer/supplier payment allocation screen
  • Show hide/mapping codes & the IRIS report have been removed
  • Amazon refunds no longer supported
  • Customer quick invoice/credit reference
  • Flat Rate VAT (FRV) setting
  • Repeat transactions are no longer supported
  • Obsolete cost price field on POs has been removed
  • EPOS payment report changes
  • Remove obsolete setting for cash till
  • Add new price list from price list selector has been removed
  • Channel filter on accounts payable (aged creditors) report has been removed
  • Release payment filter & batch action from sales list has been removed
  • Bank activity chart has been removed
• Bug fixes
   
• 4.87 & 4.88 point releases
  • 4.87.14
  • 4.87.15
  • 4.87.17
  • 4.87.20
  • 4.88.1
  • 4.88.5
  • 4.88.8

New filters, column customization & preset views

Speed up your daily tasks by saving personalised preset processing lists with predefined filters and custom columns. Create exception lists for finding records which need action. Get the data and results you need in less time.

Learn more about what you will need to do to be ready for 4.90

• Use relative date filters such as “last week” or “last 30 days” which means your preset views and favourites are always current

• Customize columns, selecting from a wide range details and then arrange them in your preferred order. For a comparison of current Brightpearl to 4.90, please download detailed list of 4.90 column & filter changes

• Save the sort order of a preset listing view so results are automatically displayed ready for processing

Learn more detail in our support documentation

Learn more about what you will need to do to be ready for 4.90

Other improvements on listings include:

• A standardised filter layout so you’ll always find the same filter in the same spot
• Even more multi-select filters

So far these improvements have been added to the following screens, but more will follow:

• Sales and sales credit lists
• Purchases and purchase credits lists
• Sales detail
• Purchase detail
• Customers list
• Supplier list
• Sales Analysis (by product)

Product statuses & archiving

The most voted for feature on our development board is to provide the ability to archive products that are no longer sold. We now introduce product statuses - Live or Archived. When a product is archived it will hide it from all the necessary screens and features in Brightpearl, but maintain all historical reporting data. We’re looking to add more statuses in the future such as “Pre-order” or “Winding down” so watch this space.

New features include:

• New status field on products
• New status filter on the product list (defaults to Live to exclude archived items)
• Batch updating the status for multiple products
• Using the product import to set product status

For more details on when products can be archived, when they will be auto-activated and how channel listings and orders will be affected please see our support documentation

Products display all price lists

Up until now once you’ve added your 15th price list you will no longer see the whole list available to edit on a product record. This meant that you could only manage those price lists by using imports. Now, once you’ve added 15 or more price lists you’ll see the new UI where it’s possible to view and edit any price list by selecting it from a drop-down menu. If you have 14 or fewer price lists you’ll still see the tabs. Note that when using the drop-down menu you’ll need to save the product between editing each price list.

Drop-ship improvements

We’ve made various improvements for better handling and control of drop-ship orders.

New features include:

• Handling for partial shipping of drop-ship orders allows you to confirm some of the items on the PO as delivered
• Send a shipping update email to your customer when confirming shipment of the drop-ship PO (when “Mark as shipped” button is activated in Purchase Settings)

• Notes added to the sales order to indicate the shipping update email was sent to the customer

• Set a default template for emailing drop-ship shipping updates to customers

Order payments, payment methods & payment lists

Order payments changes how and when orders are marked as paid. You’ll be using payment methods with a streamlined workflow for payment gateways plus Brightpearl will now handle of the auth and capture workflow. Even with auth only payments you’ll see the order payment status is updated, and a pending payment amount exists, but the accounting won’t be created until there is a captured payment.

You will need to ensure that anyone processing or allocating payments in Brightpearl and anyone using the accounting module understand these changes before your Brightpearl account is upgraded. You should also be aware of what you will see immediately after your account is upgraded - to ensure no workflows are blocked we’ve created all the necessary details but you will probably want to review those.

4.90 - Order Payments - what you need to know and how to be ready for 4.90

New features:

• Work with payment methods instead of bank accounts

• Map bank accounts to payment methods to ensure the accounting is posted to the correct code. With the introduction of multi-currency a bank account for each currency may be chosen on a single payment method
• Connect payment gateways to payment methods so that the gateway is automatically accessed when that method is selected for processing a payment

• Record auth only payments in Brightpearl (currently Authorize.net only but more being added), in the future we’ll also be adding the option to capture these authorised payments from Brightpearl
• More informative order payment statuses ensure you know which orders are ready for shipping

• New order payment lists for customer and supplier payments made against orders

• Easily cancel or reverse payments

Learn more about setting up payment methods and processing payments in our support documentation

Foreign currency to base order total conversion

Brightpearl have updated the calculation method used for converting foreign currency order totals into base currency.

Up until now foreign currency order totals were converted to base by converting each row and then adding them together. This meant that, due to rounding on each row, the order total could be different than if you simply converted the overall order total straight to base. This sometimes meant that discrepancies were seen between the order total and the payment. With Brightpearl close to releasing multi-currency functionality this is one of the problems we were keen to fix.

Learn more about how this has changed and how it will affect existing orders

Reset, migrate & begin to use the Brightpearl accounting module

Due to the technical changes made for order payments it means that we are more easily able to clear down your accounting data ready for you to start using Brightpearl accounting and you won’t lose any of your order payment details. If you’re interested in upgrading to Brightpearl accounting please contact success@brightpearl.com

Journal types

With a wider range of journal types it becomes easier to recognise how or what a transaction represents.

New journal types now in use which were all previously JJ:

• GO - Goods-out
• PG - Purchased goods-in
• SG - Sales credit goods-in
• IA - Inventory adjustment
• EX - Expense claim
• VR - VAT return
• LC - Landed cost

View a full list of journal types and how to be ready for 4.90

Note that historical journals will retain their existing journal type of JJ, and all new journals created in 4.90 will use the new journal types. When filtering the general ledger by historical data ensure you include the relevant journal types.

Amazon Canada

You can now expand your sales and connect Amazon Canada to Brightpearl. All the existing features of the Amazon app are supported.

Taskbot

Taskbot is a processing robot which handles tasks such as generating reports or batch processing records. Taskbot takes the task and allows you to continue working on something else in Brightpearl while it is being completed. Moving these processes to Taskbot also improves performance and allows for larger batches and exports can be handled.

You can visit Taskbot to view all of the processes you’ve requested, view current the status, see details of any errors encountered. We’ve started by migrating just a few tasks to Taskbot and will be transferring more very soon. In 4.90 the following tasks are handled by Taskbot:

• Batch updating order statuses (sales & purchases)
• Batch allocation
• Batch fulfilment

You will know when a task is being handled by Taskbot because a green message will let you know a task has been created and provides a link to where you can view the status of that task - in Taskbot. If you want to visit the list of processing or completed tasks at any time you can find it under My Tasks, found on your username menu. Note that this screen was previously used to display your personal to-do list - activities, events and calls - you will now find these under My Events, also found on your username menu.

General accounting improvements

Auto-updating & fixed exchange rates on orders

When a foreign currency order is created it is assigned the system exchange rate. This exchange rate is used to provide an estimate of what the total order value is in base currency. Currently, the order rate can be manually edited as required and at the point of invoicing it’s the rate on the order which is used for the final base currency value and to create the accounting.

In 4.90 we are introducing some early multi-currency changes which mean that the exchange rate seen on the order is not necessarily the final exchange rate that will be used for conversion and for creating the invoice accounting. When a foreign currency order is created it is still assigned the system exchange rate and before the order is invoiced the exchange rate can be manually edited at any time to recalculate the estimated base currency value. What’s new is at the point the order is invoiced the rate will automatically be updated, unless the rate is set as “Fixed” (set per order).

Note: These changes are being introduced are for sales only. Although the new “fix” checkbox will be shown on purchases it is not functional.

Learn more about exchange rates on orders in our support documentation

US balance sheet improvements

We’ve tidied up the balance sheet in the US format so that it’s easier to read.

Default invoice template per contact

It’s now possible to set a default template per contact. This means you can define which invoice template is used for each customer. If a template is set on a customer it will override the one set on your channel brand.

US chart of accounts import

As part of the migration to using Brightpearl you will need your chart of accounts created in Brightpearl. Due to some problems with the process in the US the chart of accounts had to be entered manually, but we’ve fixed all of the issues and made it available once more.

Journal assignments applied consistently

The journal assignments are the lead source, channel and project details assigned to a journal. These are useful for filtering your profit and loss report and analysing performance in different areas. We identified some inconsistencies with the way they were assigned which could lead to misleading results when filtering the general ledger. As part of the multi-currency project we have been able to tidy up these assignments to ensure consistent and correct reporting. This is how they are assigned by Brightpearl:

• Journal assignments are set only on journal rows using a profit & loss account types (sales, purchases, expenses)
• Journal assignments will not be set for journals affecting only balance sheet account types (assets, liabilities, capital & reserves)

Why not assign them to balance sheet codes?

Profit & Loss transactions only relate to a sale or a purchase, and therefore can only have one channel, lead source, project. Whereas balance sheet transactions, i.e. assets such as stock, move around the business, from a purchase to a sale to credit etc. Each of which can have different assignments. What goes into stock for one project can come out on another. Filtering the balance sheet by a project won't give an accurate representation of the assets for that project. Similarly, for bank accounts, money in assigned to one channel won't come out on the same channel, so the balance of that bank account for that channel will not be accurate.

Landed cost reports shows inaccurate actual landed cost

The landed costs report displays estimated landed costs and actual landed costs. The actual landed costs figure was not being correctly calculated. This value will now display the values actually posted to accounting for each landed cost reference. You must ensure that your landed cost references are unique for the value to be correct calculated.

Learn more about the landed cost report changes

Improved nominal code drop-downs

For faster searching and selection of nominal codes you will now find a search field at the top of the drop-down menu (not displayed when the list is restricted, for example a list of bank accounts).

Zero value invoices

Brightpearl will now allow zero value sales invoices (handling for purchase invoices will be added in 4.91). This is important for ensuring that the correct accounting is handled for invoices for which the overall balance is zero, and no payment is required, but where revenue and discount both need to be recognised.

Batch purchase invoices

When receiving a purchase invoice across multiple purchase orders you’ll notice some changes to the journal which is created. Previously a single entry was made to 2100 Creditors Control/Accounts Payable, but now you will see it broken out per order. This will only be the case for new invoices, all historical journals will remain as they are.

Now that the journal rows are separated out per order it means we are able to better handle the allocation of the payment per order- we’ve fixed the bug where paying the batch invoice wouldn’t mark the orders as paid. However, any batch purchase invoices that were received before 4.90 will still have to be corrected manually.

You’ll also notice some changes when actually allocating the payment - you’re now able to view the invoice as a single row or you can view the individual orders. If you’re going to part pay the invoice you’ll need to specify which orders are to be paid so the payment allocations can be correctly made in the orders module.

Write-offs/adjustment only transactions

The payment allocation screen can now be used to make write-offs and adjustment only transactions (e.g. bad debt or exchange rate gains or losses). Previously a balance on a customer or supplier account could only be written-off or posted as an adjustment, when it was processed along with a payment amount.

Customer statement templates

Last year we introduced the outstanding items customer statement. To use this feature you needed to select a separate template when generating your statements. We’ve now merged them together, so you only need one template. On that template include the widget _statementDetails_ and then you can select your statement preferences during the process of printing/emailing your statements.

Note that the _outstandingStatementDetails_ widget will continue to work.

General order improvements

Order dates now easier to understand & always editable prior to invoicing

Every order will now show three dates and this is how they work:

• Created date - set as the date/time the order was created. This is the point the order is placed by the customer, so will be the date/time taken from a sales channel if the order downloaded.
• Tax date - this will default to the date the order was actually created in Brightpearl. When the order is invoiced it will either use this date, or today’s date (as per settings), a small info icon next to the field indicates that it will update on invoicing. You can change this date on an order but if Brightpearl is set to use today’s date on invoicing it will be overridden.
• Payment due date - this will default based on the tax date and contact credit terms. When the order is invoiced it will either remain as it is or will be updated based on the tax date used for the invoice and the contact credit terms (as per settings). You can change this date on an order but if Brightpearl is set to update it on invoicing it will be overridden - it can be manually changed again later.

Total stock quantity count now also displayed on purchases & credits

To display the total number of ordered items on orders and credits you will need to activate the shipping quotes section at Settings > Sales > Sales settings.

Batch deleting goods-out notes

Goods-out notes can now be deleted in batches via Sales > Goods-out notes due to…

Display stock quantities on purchase order rows

The current stock quantities for a product have always been displayed on sales order rows, we’ve now added them for purchases as well so that when ordering an item you can immediately see its current stock status. When the order row is added the colour represents the current on-hand status - green for items available on-hand and red for none available on-hand. When the order is saved the order row colour will begin representing the received status, as it has always been - green to represent all items have been received, red for items remaining to be received.

Send cc, bcc emails

Previously, adding additional email addresses when emailing a customer would send an entirely separate email to each person. Now you can send individual emails, or cc or bcc other people on the same email.

General contact improvements

EOM Credit terms improvements - templates & contact import

In our last release we added the option for Net or EOM Net credit terms on your contacts. We’ve now completed this work by updating the templates widgets and including the option to add or update this field using the customer/supplier import.

Use these three widgets on your templates:

_contactCreditDays_
_contactCreditTermsType_
_contactCreditLimit_

New fields when adding a staff member

In preparation for breaking down user access by apps, such as Brightpearl back office and Brightpearl POS the layout of the add staff member modal is changing. In relation to our new improved POS, you can set a maximum discount the staff member can set - this is not currently used for Brightpearl back office or our existing POS. You will also notice some new fields and options for recording job title and role.

Other improvements

New sales reports permission

When Sales > Sales report permission is OFF, a user cannot access:

• Sales dashboard
• Sales reports
• Sales workflow settings

Order payment status displayed on product info pop-up

It’s now possible to see the payment status of sales orders where stock items have been allocated. When viewing a product information (by clicking on the SKU within an order, or on the stock level on product lists) It is useful to know when stock is being held for an order which hasn’t been paid in case you need to release it for another sale which is urgent and definitely going ahead.

General apps & app store improvements

Amazon payments & fees

Amazon payments and fees are accounted for when your settlement report is provided by Amazon. Before version 4.90, the accounting was contained within a single journal. Now, due to the changes introduced by order payments, you will see the payment accounted for in an SR journal and the fees accounted for in a separate BP journal. The accounting effects are the same.

eBay global shipping program is supported

In this release an order to be shipped to an eBay distribution centre will be allocated the correct delivery address to ensure your goods-out notes and shipment automatically go to the correct place. Any changes needed to the shipping cost on the order are not currently handled and will need to be edited manually.

PayPal app now shown in the App Store

The PayPal integration has now been added to the app store, so we’ve removed the old activation screen (Settings > Other > Payment methods). Once activated the app will provide a button to the settings screen.

Sagepay app now shown in the App Store

The Sagepay integration has now been added to the app store, so we’ve removed the old activation screen (Settings > Other > Payment methods). Once activated the app will provide a button to the settings screen.

If you already have PayPal and/or Sagepay installed we’ve automatically switched on the app and created you a payment method. As part of the introduction of order payments we will also have created a payment method for each bank account, so you may want to check that you don’t have duplicated payment methods at Settings > Company > Payment methods.

New filters & messaging in the App Store

New filters will help you browse for apps. You will be able to browse for apps included in your subscription with Brightpearl, those you can add on top, or those available from third party developers. If you have a particular area of Brightpearl you’re looking to add functionality to try browsing by category such as fulfilment, inventory or accounting.

Warehouse types

In preparation for future apps and reporting features it’s now possible to set a warehouse type. All your existing warehouses will default to “Warehouse”.  They aren’t used for anything in Brightpearl just yet.

Warehouse zones

In preparation for future apps and reporting features it’s now possible to create warehouse zones. These will work as an extra grouping level for warehouse locations. They aren’t used for anything in Brightpearl just yet.

API improvements

Please refer to our 4.90 & 4.91 API changes guide for the updates that will need to be made to apps

New API - Location SEARCH

Journal SEARCH API slow

[WS] Stock Correction POST no validation for existence of nominal code is performed

Add 'quantity' to Order Row PATCH

Add "fixed rate" to order POST and GET

PM: Add Height, Width and Length to Product POST

Contact status PUT

Contact custom field data and metadata GET, PATCH

Update journal-entry POST to validate correctly for accounting period

Make new accounting services public / deprecate old services

Zone POST to create a new zone w/ validation

Zone GET to return list of zones

Zone PATCH to update a zone name

Zone SEARCH

Zone DELETE

Add warehouse zone to API: Warehouse location GET

Location PUT

Location POST to accept zone ID property

Add 'Product status' to Product GET and SEARCH

Update order row POST to reject archived products

Product status POST(Internal validation for archiving a product)

payment-method POST

payment-method PUT

payment-method GET

new endpoint accounting-service/customer-payment POST

new endpoint accounting-service/supplier_payment POST

CustomerPayment SEARCH : new endpoint

SupplierPayment SEARCH : new endpoint

sale-payment-total / purchase-payment-total GET : new endpoints

Is MC on or off? Using integration service account-config GET : multiCurrencyEnabled

New warehouse endpoint to break FIFO

New endpoint invoice/purchase-payment POST

PaymentAuth SEARCH : Search customer payments

PaymentAuth GET : Retrieve Customer Payments

PaymentAuth POST : Create Customer Payment

Deprecations

Removal of Customer > Take payment, and Supplier > Make payment screens

These screens have been removed to help simplify the application. The same functionality is provided on the Customers > Aged Debtors (or Accounts Receivable) screen and Suppliers > Aged Creditors (or Accounts Payable) screen. By streamlining our application it becomes easier to learn how to use and also means we are able to ensure quality of the application, by reducing the test requirement needed.

Alternatively, a customer/supplier search and using the mini tabs to navigate directly to the payment allocation screen will also provide a fast route to record a payment.

Add new quote or invoice is now add new order

When adding a new sales order you could select to add “New quote” or a “New invoice”. Both of these options added a new order, the only difference being the status on which the order was created, as defined in the Sales Settings. To make Brightpearl less cluttered and more easily understood we have now made this a single option for “New order”. You can choose what status the order starts on, and after that it can be updated manually either within the order, or using the batch processing options on the sales list.

Order refs on journals are locked

The order reference on a journal is no longer an editable field. All order references on journals are assigned based on the order the transaction was made against. Entering or editing an order reference on a journal will have no affect on the status of the order (the introduction of order payments means payments can no longer be allocated to orders in this way) and therefore may mean that the accounting displays different information that the orders module. To prevent this from happening the field is now locked. Any changes needed must be made via the original order.

Account balances on chart of accounts no longer display by default

For performance reasons the account balance for each account code no longer displays by default on the chart of accounts. If you do wish to view the current account balance from this screen you can click the Display link for an individual code. Remember the trial balance report also shows your chart of accounts and balances.

Payment method field has been removed from contacts

The payment methods field on a contact wasn’t used for anything anymore and so we’ve removed it. You will now find payment methods are recorded per payment recorded against each order.

Customer/supplier financials screen is now the GL filtered

You may notice some minor changes to the financial history on a contact record. This is because we have made a technical change to how this screen is generated. Rather than being a completely separate screen it is now the general ledger. When the general ledger is filtered by a contact and account code 2100 or 1100 you will see the financial history of the contact. This means that you can simply apply the filters to the general ledger to access their financial history, or you can continue to navigate to it via the links on the contact.

As part of these changes we chose not to transfer the options to send an email or SMS from this screen. We recommend accessing the same features from the customer/supplier list or within the contact record:

Email using the icon next to the email address in the contact information:

Send an SMS from the timeline:

Recent payments are no longer displayed on customer/supplier payment allocation screen

The recent payments section of the payment allocation screen has been removed. All these details can be found on the contact financial history, including the option to print checks (US) and remittance advice.

Show hide/mapping codes & the IRIS report have been removed

The map code on a account (nominal) code enables you to reference a different code ID than the one assigned by Brightpearl. This could then be used to replace the Brightpearl code throughout the application. However, this feature was no longer fully functional. We took the decision to remove the setting for this option since the alternative is to put your preferred code into the account name and to simply hide the Brightpearl codes (with another setting). The Mapped Trial Balance Report or IRIS Export also used these mapping codes, providing a list of accounts with their balances with the Brightpearl account code and the mapped code. This same report can be achieved using the main trial balance report and including the mapped code (in the filters), so we’ve removed the duplication. Removing code means we can more easily build and test the rest of Brightpearl.

Amazon refunds no longer supported

Now that orders are marked as paid by order_payments each sales channel which creates payments needed to be updated to create order payments instead of sales receipts to ensure that they continued to work. Up until now Amazon has also downloaded sales receipts for refunds, marking the original sales order as unpaid. These refunds could easily be re-allocated to the sales credit within the accounting module. Now that order payments are being created the process Brightpearl the same process would not move the refund from the original order to the credit. The new workflow involved completely reversing what Brightpearl was doing with the refund, and therefore creating additional work for you. Until the handling of Amazon returns and refunds can be improved we have removed this step to save you time.

Customer quick invoice/credit reference

When a customer quick invoice or credit is entered, Brightpearl will generate the invoice reference - just as it would for an invoice created via an order. Previously it was possible to override the invoice reference and enter your own.

Flat Rate VAT (FRV) setting

The way flat rate VAT was handled is not compatible with our new multi-currency functionality. If your account is using FRV you will already have been contacted regarding this change. If you need more help, please contact our support team.

Repeat transactions are no longer supported

The way we currently handle repeat transactions is not compatible with our new multi-currency functionality which introduces the ability to process foreign currency bank transactions. Due to repeat transactions not being widely used and because of our focus on delivering larger improvements, we have decided that we will not develop the repeat transactions feature further at this time.

Obsolete cost price field on POs has been removed

Up until now there has been an extra “cost price list” field on a purchase order which was not used for anything - it is only relevant on sales. This field has now been removed from purchases.

EPOS payment report changes

The POS payment report will now display payments for all orders taken created on that channel (or till). This means that if an order is created on till 1 as set as pending, then recalled on till 2 where payment is taken, the payment will show on the report for till 1.

Remove obsolete setting for cash till

An obsolete setting has been removed for “Cash till account” at Settings > Company > Accounting: Account codes or Nominal codes.

Add new price list from price list selector has been removed

It is no longer possible to add a new price list from the drop-down on a contact. This was added as a trial of the feature to see if this is something that can be introduced across the whole application. We have been concentrating our efforts on more important features and so for the time being we have removed this trial feature.

Channel filter on accounts payable (aged creditors) report has been removed

The channel filter has been removed from the accounts payment (aged creditors) report. This filter was not useful since contacts do not have a channel and invoices for a single contact could have multiple channels, therefore filtering by channel meant that partial balances for contacts were displayed.

Release payment filter & batch action from sales list has been removed

This feature was previously used for marking deferred Sagepay payments as captured (they also had to be marked as captured directly within SagePay). We are currently developing a new app for handling payment gateways which will offer a wider selection of providers plus consistent and improved features. This means that our existing SagePay integration will be migrated into the new version where better handling of deferred payments will be reintroduced. If a deferred payment is taken in SagePay using the current integration it will mark the order as paid straight away. The payment will just need to be marked as captured directly within SagePay.

Bank activity chart has been removed

We discovered that the bank activity chart was hardly used. To ensure we concentrated our efforts on developing multi-currency without trying to maintain old and unused features, we have removed this one. You’ll also notice that the “view transactions” link has changed to “Bank activity” - the name of the report.

Bug fixes

Code	Description
BP-13336	(7) [eBay] Orders Duplicated - single item orders
BP-13617	(18) [eBay] Error when trying to access or create eBay listings
BP-15348	Each time inventory changes, 2 updates sent to Magento per product
BP-15554	Incorrectly trying to pull the supplier from the bundle item itself on batch purchasing orders from a sales order.
BP-15778	(2) Customer Discount causes bundle prices to "double"
BP-15806	(2) eBay listing widgets not pulling "select option" custom field data correctly
BP-15880	(8) [Amazon] - Amazon order download problems for USE1
BP-10958	(3) [RM-1] When importing Chart of accounts into US account, accounts are assigned to incorrect account types
BP-11616	(2) PDF documents show different Order Row Totals from the Sales Order (in app)
BP-11705	State/County not transferred into Sagepay
BP-14059	(6) [EPOS] Some orders double allocating and others not allocating at all
BP-15311	You can delete the default address of a contact. If you do this for a supplier, it gives a whoops error on advanced fulfil screen.
BP-15730	(3) Amazon orders being duplicated across all marketplaces
BP-5831	(3) EPOS - will not use the Nominal code assigned to a customer
BP-10702	(1) The use of deferred in sagepay direct causes an error message when you use it in the back office - deferred will now create payments straight away read more
BP-11215	[VAT] when using a T8 code on a VAT return, when the posting of the VAT reconciliation is done, it includes this value in the journal
BP-11273	[VCA] when using a bank payment with T4 this will only show on the return in box 6
BP-12905	import@brightpearl.com is being seen in the catchall email on a configured SMTP server
BP-13571	Not able to add bank account from the accounting menu on US accounts
BP-13683	(2) [eBay] sales not respecting 'taxable: no' on products in US tax workflow
BP-14236	Setting Amazon order download activation date through the UI is not respected
BP-14614	(2) Magento Payments Not Downloading
BP-14824	(1) eBay orders downloading with incorrect delivery method
BP-15351	[EPOS] Adding MISC item with Tax to EPOS orders adds other items to the order
BP-15578	Creation of ghost contact record on contact creation
BP-15623	Ability to change customer type by contact update (XLS)
BP-15824	Customers can be changed into suppliers (and vice versa) when there are orders against the contact record
BP-15625	[DB Update] Submit a data fix to remove ghost contact records
BP-15628	Chart of accounts page times out for account bwruk
BP-15708	Brightpearl removing 'postage rate tables' shipping methods from listings
BP-15731	Unable to download eBay listings with long EAN/UPC numbers
BP-15747	Batch drop-ship purchase orders aren't respecting several parent order fields
BP-15829	Cannot download eBay order for a bundle containing no stock-tracked items
BP-15967	[BigCommerce] Tracking Ref number stopped pushing to BigCommerce from BP since November 18
BP-16110	[Auth.net] When payment is taken in BP via the App - it's recorded in Auth.net but in BP the SR journal is not created
BP-16149	Prevent user removing shipped items from Drop ship purchase order ( DSPO )
BP-16262	Amazon order did not download and no channel alert was produced (account: bathroombubblesltd1)
BP-16264	BP allows duplicate Invoice number - Bill number for different Vendors causing wrong balance issues on the Accounts payable report
BP-16280	(8) PO remains in partially received state even after being fully received due to multiple batch IDs and manual stock adjustments
BP-16302	[EKM] Orders do not download if a shipping address is missing
BP-11367	(5) [eBay] Updated shipping methods in eBay are not pulled into the shipping method field in Brightpearl
BP-12275	(2) [eBay] Updating QTY also triggers a 'Postage Terms' revision every time
BP-12840	(7) [BigCommerce] [EKM] was not updated for the stock when the Purchase order was received
BP-13857	(6) Exporting data only exports the first page
BP-14350	(7) Product variants no longer showing in variant order
BP-14762	(12) The outstanding statement report is showing incorrect values - payment amount is double
BP-15017	(11) When updating linked items ticking the Update item without updating the other sisters causes a whoops error
BP-15765	(10) Helpdesk tickets are not displaying notes
BP-15966	[Shopify] Orders downloading with product lines missing for account cuyana
BP-16256	[amazon] Unable to update and save Amazon channel settings: "Unable to update all of your settings."
BP-10809	After searching by customer First name cannot reorder the list alphabetically by last name anymore
BP-12219	(2) Primary contact name and address should be used as the "invoice to" on a sales order created against a secondary contact
BP-12299	(4) When re-invoicing an order when "use today as tax date" is on, old invoice reference is not used
BP-12900	(4) Changing Primary contact addresses do not update Secondary contact addresses
BP-13558	(2) Exports of accounting reports give an incorrect number of rows, and output format prepends a ' to rows
BP-13958	(7) Smart form created in BP the link doesn't load anything on the page when added to the website.
BP-15322	(9) When using the Use today as tax date when invoicing it changes the date on the order straight away
BP-15466	(6) 'Do refund with SagePay' modal incorrect on sales credits
BP-15555	(4) Currency Symbol missing on order totals
BP-15856	Sales Tax Detail Report - export displays incorrect date in both xls & PDF format
BP-15858	Cannot take Sagepay payments via the portal (vendoremail is invalid)
BP-15915	(3) Channels: connected / not connected to filter generates whoops error for connector channels
BP-10459	When transferring money by Bank transfer the system is only showing £1 and creating a journal for £1
BP-11204	Quick Invoices / Credits Create an Order Reference Number that Generates Whoops Error when Clicked
BP-11399	The addition of shipping overwrites the details of the first line of the order - Rubadubltd
BP-11785	(1) Ensure that "Product Last Modified" is populated in the Products Table
BP-12006	(4) When using the add row on a journal where the last row has been closed the new row is a duplicate of the last row and is closed too
BP-12240	The exchange rate calculation is not working correctly on some payments on sales
BP-12907	(2) [Shopify] Orders download with incorrect order total amount.
BP-13198	(3) [EKM] some payments are not downloading with the orders
BP-13352	Reconciled = No filter in general ledger not working correctly
BP-14069	When using the Nominal summary report the end balance does not match when running a part period to running a full period - Dreamkayaks
BP-14335	Unable to remove creator from a reassigned helpdesk ticket + general improvements
BP-14405	(3) When you use the Defer Cost of sales the deferred journal does not keep the channel ID
BP-14792	(3) You are unable to ship or edit orders (eg add note) on a order that is in a closed accounting period
BP-14941	API Rest searches do not return results for queries with comma character ( ' or %27)
BP-15177	(6) [ShipStation] Some line quantities for orders in ShipStation are not the same as the orders in Brightpearl
BP-15325	Unable to access SKU tab when editing variants
BP-15357	[Shopify POS] - Partial Refunds not downloading to Brightpearl as SC
BP-15472	Discount doesn't get applied to purchase orders
BP-15532	Sending e-mail from Recent Sales Screen doesn't respect template columns
BP-15538	The Bank account is pre-populated on the allocate payment screen
BP-15565	Able to retain price list ID assigned to Contact defaults after the Price list ID was deleted on the account
BP-15606	Some EKM orders are downloading as cancelled with incomplete customer details.
BP-15657	Approving a quote doesn't update the status of the quote when there are no comments in the box
BP-15683	Batch invoice POs should show values in order currency
BP-15688	LAKSHMI-'Misc' products (IDs 1000 & 1001) have a weight of 100 units
BP-15690	In Bank Activity Screen, the Order ID link should take you to the order, not back to the same screen.
BP-15691	Updating assignments on orders is inconsistent
BP-15694	[API]Large field lengths cause 500/400 errors
BP-15715	Drop shipping bundled products not working correctly
BP-15717	When using batch dropship and a sales order has 2 lines with the same SKU only 1 line is bright to the Purchase order
BP-15740	Delivery Date' shows as '"CHECKOUT_TEXT_DELIVERY_DATE" in Portal
BP-15771	(4) Event confirmation email uses Today as start date regardless of actual start date
BP-15788	[Amazon] Amazon Canada listings downloaded incorrectly for msginc
BP-15790	[eBay] UPC field not available for listings
BP-15792	Reference' data doesn't display if the modification reason contains a hash
BP-15809	Authorize.net configuration error for account abstiles
BP-15830	Negative values submitted within SR POST create overpayment
BP-15838	Label printing modal does not render correctly in some resolutions / display sizes
BP-15877	Authorize.net error when card post code does not match order post code
BP-15930	[3] - Default Warehouse address not correct on Purchase Orders
BP-15945	Whoops error when attempting to delete a primary supplier for existing product(s)
BP-15946	Cannot add bundle to order if any of the component SKUs are set to use grid view.
BP-15972	(2) [EKM] Orders are downloading with no tax showing on the order
BP-15975	SQL error thrown if an apostrophe is found in the address fields for the channel branding
BP-16007	Order created via API doesn't use accounts email but back office does
BP-16010	[SQL] Webstore functionality still showing in app
BP-16022	When filtering the contact list for more than 100 results, the next page of results gives an 'Invalid search query' error
BP-16028	[Webhooks] Order status update webhook not firing when updated via clone to PO
BP-16037	Can't display more than 50 coupons in a page
BP-5052	[DB-update] Expense claims over £10,000 are added as £9,999.99
BP-5689	Remittance advice showing incorrect paid amount for purchase credits
BP-5755	Filters on reports are showing as blue instead of grey
BP-10528	Payment total incorrectly rounded for foreign currency orders.
BP-12901	Order total is truncated not rounded
BP-5991	Rounding issue with the payment allocation modal on the sales Order
BP-10741	(3) Brightpearl apps menu not seen in service account
BP-10941	(2) Hide cancelled orders from 'Due to fulfil' screen.
BP-11203	Sales Forecast Report does not display subtotals on Sales Status change always 0.00
BP-11240	(2) Strange characters on Quote when sending it as HTML for UK customers
BP-12059	(2) Using Postcode Lookup for addresses with ampersands (&) in them shows: & after selecting to use the address and error is shown when saving the record
BP-12210	[PCF] Custom Fields have the option to change the field type; but this doesn't work
BP-12264	Open Sales & Quotes pane on Customers/suppliers displays the invoiced Sales/purchases total prefixed with £ sign even if in foreign currency
BP-13030	Sales Tax Detail export does not respect channel filters
BP-13064	Supplier remittance doesn't include payment reference
BP-13276	Allow adjustment only payment allocations
BP-13428	Outstanding statement aging section does not show a value when the balance of a period is 0
BP-13579	(7) In order quantity showing 4 decimal places on orders for some accounts
BP-14477	MUST: (2) Sales detail report showing incorrect total for certain columns
BP-14542	LAKSHMI(2) Dashboard Widgets not displaying in browsers
BP-14820	Add address widget for 'country' to template editor
BP-14887	Incorrect error message when attempting to receive stock against a PO in some cases
BP-15150	Credit card nominal codes not respecting "reconcile" setting
BP-15464	Item Cost removed after filtering by datamap
BP-15490	Using the < character in the notes on a timeline strips out text
BP-15493	Using a carriage return when updating a text area custom field from the recent sales list replaces the carriage return with rn
BP-15510	Hitting enter in a search filter causes export instead of a search
BP-15540	Inventory audit trail date filter uses the GON created date instead of GON shipped date
BP-15542	Non-standard characters break batch goods out note printing
BP-15553	Accounting permissions don't fully hide accounting
BP-15567	Partial refund on sales credit adds to the total amount
BP-15586	Message entered into the batch 'Send Statement' modal on aged debtors (UK) / accounts receivable (US) report does not preserve line breaks
BP-15596	Adding Fields to a datamap causes visual bug - appears to add them multiple times
BP-15622	Redundant setting for template prices in purchase settings
BP-15632	Cloning a sales order does not clone the shipping method
BP-16246	Cancelled SI journals are being read / validated when trying to un-invoice orders
BP-15711	Drop-ship batch action not releasing stock from SO if fully allocated
BP-15745	[Auth.net] erroneous error: 'Bill to Last Name is required'
BP-15756	Size issue for batchDSPO modal
BP-15768	Changing the invoice reference of a journal does not unclear any previously cleared invoices
BP-15795	(3) Apostrophe in template, Payment reference causes 'Whoops error'
BP-15800	Receiving non-stock tracked item on sales credit causes whoops error in modal
BP-15881	Email content spills out of jQote note template on contact timeline when <table> used
BP-15886	Create new Login Page
BP-15919	Filtering customer list by credit limit for values > 0 makes the column disappear
BP-15949	While creating amazon store system throws an exception
BP-15960	[+Datafix] Orders : Remove paymentIsDeferred from order import data map
BP-15974	Emails are not generated when a Helpdesk ticket is first created
BP-15976	Remove assignment fields from filter on Balance Sheet
BP-15978	Remove support for payment allocation with no contact
BP-15979	Logo missing from the automatic timeout page
BP-15982	Remove ticket delete button
BP-15996	The help drop down shows Sales_tel instead of the sales phone number
BP-16009	Bank account is blank on quick invoice/bill/credit entry doesn't fail
BP-16023	[Datafix] Sales Credit - writing off stock received creates a row in the audit trail without a date
BP-16024	_myCompanyAddress_ widget does not respect the Address format specified in the company settings
BP-16029	"Show bundle summary on quotes and invoices" also affects purchase orders
BP-16083	Allow multiple Creditors lines on a single PI / PC journal
BP-16090	Sales menu display wrong label *Customer by tag*
BP-16107	Product list sorted with variant info not working with page break
BP-16112	When switching on inventory sync - stock should update to Amazon
BP-16145	Merchant can break their authorize.net integration by modifying delimiter character
BP-16153	Poor language in EPOS popup
BP-16164	Stock level shown on 'Stock / Inventory' tab of product record only uses default warehouse inventory level
BP-16183	Remove "New" labels in Help menu
BP-16193	Misleading Guidance on Order Import Screen
BP-16261	Modifications to order date fields
BP-16269	Remove auto-clearing PHP code in db_update
BP-16365	Allow contact.accountReference (customers_code) to be inserted via the API
BP-16389	Multi select dropdowns collapse on first selection and are missing 'check all/uncheck all' options
BP-16421	OrderRounding : Order Row POST, PUT, PATCH
BP-16452	Remove customer_activity and supplier_activity reports from Reports : Accounts : More
BP-1978	Debtors batch Statement Email does not load the template for the second batch
BP-4105	Payment allocation screen : If payment total is zero don't require a bank account
BP-5094	Zero values from integer fields are not displayed in app
BP-6911	(3) Detailed section of statement doesn't appear in emailed PDF after clicking on "Show detailed payments"
BP-7131	Sales Receipt POST skips journal_ids
BP-7236	Cancelling a journal doesn't save the reason for modification note
BP-76	[DSHIP] Drop shipped order price doesn't reflect supplier price break
BP-9471	[Accounting] - When correcting a Journal/ transaction by inputting incorrect number (eg: invoice no) throws exception error
BP-9760	Payment allocation screen : Negative payments not displaying correctly
BP-10608	Cost Tab - The currency symbol is missing under the profit column
BP-10676	Statement Dates Default to 1970
BP-12379	Overpayment error message shown for no reason
BP-16547	Delays or errors in the invoicing process sometimes does not complete serial transactions in the process
BP-16493	(5) Cannot access Mailchimp Settings after new App Installation - page times out
BP-14840	Order paid via portal do not get updated to 'paid'
BP-15879	(2) Bundles do not display price on printed/emailed POs
BP-16180	A PO raised for a secondary contact will not allow you to add any products onto the order
BP-16172	Batch purchase order creation process does not allow choice of supplier
BP-16412	Batch fulfil from alternate warehouse not working
BP-15824	Customers can be changed into suppliers (and vice versa) when there are orders against the contact record
BP-15882	The Outstanding invoice report is not showing the correct details
BP-12072	(5) Incorrect tax calculation on negative prices; minus 0.83 gives tax of +1.83
BP-16078	Primary supplier is ignored when using the 'Batch purchase order' function on the sales list
BP-16039	Applying a filter to a set of results from the contact notification bar gives incorrect results
BP-15574	Bank Reconciliation performance
BP-16250	Pagination broken on 'warehouse locations' menu
BP-16461	Using a # in audit trail notes breaks the 'i' bubble
BP-12948	Sales Detail report data map not returning all columns when exported
BP-14899	Blank screen (time-out) when you run a bank reconciliation that has a lot of data
BP-8570	(16) When using batch invoice for Purchases orders, when you pay this in the allocate payments Screen, it does not mark orders as paid.
BP-16370	Cost reporting incorrect when drop shipping from foreign supplier
BP-15057	[Amazon] (6) newly added Amazon listings never downloaded into Brightpearl
BP-16191	[Dropship] Marking PO as received then splitting to back order doubles fulfilment
BP-16419	(4) [BigCommerce] [Shopify] Newly added products in BigCommerce and Shopify are not downloading into Brightpearl and no channel alerts created

4.87 & 4.88 Point releases

4.87.14

BP-15811

(4) re-Saving a DSPOrder changes the shipping status icon to not shipped

4.87.15

BP-16234

[Authorize.net] Internal Error when selecting Setup for auth.net App

4.87.17

BP-16224

Goods out notes sort order is incorrect

4.87.20

BP-15462	(14) Tax calculation for item_gross widget on orders with corrected tax is incorrect
BP-8551	(11) Contacts created via integration sales (Magento) can be grouped into company n/a
BP-16248	EPOS - When adding products onto an order we DELETE the existing reservation and then POST a new one
BP-15872	Sales Order Cost tab - unit breakdown for misc items

4.88.1

BP-16546

(16) Unable to e-mail, invoice or credit (Leads to a white screen)

4.88.5

BP-16354

(17) [eBay] Unable to edit listings with variations due to GTIN requirements

4.88.8

BP-16688

(2) Cannot edit user permissions even if you have required settings enabled