Friday, September 20, 2013

Searching All Documents in BlueBox

BlueBox2.0 has recently had an upgrade in the form of 2 search facilities which cover all financial documents in the system.

The first is the new bb_userdocs module which lists all the documents in the system linked to a particular user. This new module can be accessed via Admin > Users > Userdocs or you can access it via a quick link when doing a 'find a person' lookup:


The second is a new quick document lookup added to the old 'find a person' and 'find an item' area:


This searches document number and total amount, and will only take a numeric input. It then lists all the matching documents across all Debtor and Creditor financial documents.

Tuesday, September 10, 2013

Auto Generated Codes for Users etc in BlueBox

In BlueBox2.0 we have a bbsetting called bbsetting_autogen_alphanum_fields which allows you to define the auto-generation of 'code' fields for data that is added to a module.

A typical application of this would be the bb_users table where the 'code' field may need to be autogenerated. If this is the case, then using module settings (data-functions>module settings in the desired module), set bbsetting_autogen_alphanum_fields as follows.

A comma separated list of field names and their desired prefixes:

{field_name}={prefix},{second_field_name}={prefix} etc

If you require the prefix to be auto-created from data that is submitted, then use square brackets with the field/s required separated by |'s pipes).

So, a real-world example would be, to set the 'code' field in the bb_users table to use the company name or the last name (if company name is not entered)

code=[company_name|last_name],

Saturday, September 7, 2013

Getting the latest currency values for despatch/invoice when using forex

BlueBox2.0 is a multi-currency platform, and uses a strict parent-to-child value transfer when migrating data from document to document. This is handy in most instances, but can cause come discrepancy when the document is captured in a forex currency.

If the time difference between the date a Sales Order is captured varies significantly from the date the subsequent Despatch or Invoice are generated you can find that the forex variation is great. The 'spot rate' is stored in the original Sales Order and is then copied onto the downline documents (Despatch/Invoice) causing a widening forex difference if the IMF sport rate changed between the dates of the documents.

To get around this we have introduced a new bbsetting called bbsetting_force_latest_forex_currency_when_copying_from_parent which, when set on a module like bb_sales_despatch_notes and/or bb_sales_debtors_invoices will force the system to check the date and value of the most recent currency entries and warn the user if the currency table is out of date. 

It then also forces the latest currency value into the 'forward rate' box, thereby retaining the original 'spot rate' captured in the Sales Order and overriding this with the latest rate as the 'forward rate'.

Though this is not strictly a 'forward rate' it does the job perfectly. Obviously if a forward rate were set in the Sales Order originally then this override would not kick in as it would not be required.

Auto allocation of Sales Order Items via Replenishment (MRP) Module

In BlueBox2.0 we recently made some amendments to the way SO's link automatically via the POs generated by the Replenishment/MRP report. 
  • SO auto-allocation is switched on using the 'attempt to auto allocate' switch in the filter - the wording is important here as this is an 'approximate method' - the system tries to find the list of hungry SO items and marry then to the items ordered, however, there are many outside factors that can affect this (ie if the items are ordered manually outside of this process) - so it remains an 'attempt'.
  • If this switch is ON, the system builds a list of hungry SO items and counts their total. It then checks to see that the amount to order (ie the input QTY on each line) is more than or equal to this qty.
  • If the qty to order is sufficient, an icon shows with a page stack which indicates that the auto-allocation is ON for that line. Clicking on the page stack shows all the SOs and what is being allocated for each one.
  • If the qty to order is not enough to supply the hungry SOs the icon changes to an 'alert' and the auto-allocation will be 'disabled' for that line. Clicking on the icon will show the qty required for this to be changed to a 'page stack' and if the qty to order is manually adjusted to this qty the icon will change and the auto-allocation will be switched on.
  • If 'no icon' is showing next to the SO backorder qty, this indicates that there were no hungry SOs found for that line (or the new setting in the filter has not been switched on);.

Tuesday, September 3, 2013

Bulk Allocation for Sales Order Items - Now Specific

A powerful feature in BlueBox2.0 has always been the bulk-allocation of stock to Sales Orders where they are short of stock. A nifty new add-on in the Item Data View makes this more specific - allowing you to 'Bulk Allocate' only that specific item: