First, you need to switch on Lightyear's Inventory export feature, to learn how to do so,
click here. Once activated, head to Settings > Inventory Settings and select 'Other' from the software dropdown.
Once selected, click 'Export Mappings' as pictured below:
On the next screen, select 'Bossii' from the 'Manage Inventory Export' dropdown and click 'Save' at the top right of the page:
This will pre populate the file format required to import your purchase data into Bossii successfully but first let's talk units...
Default Product Units
Once you have selected Bossii as your Inventory/POS Software in Lightyear, we want to set the default product units. To do so, select "Edit" as shown below.
Now, ask yourself if your supplier invoices mainly contain Cases (Cartons), or individual Units (which will always default the quantity to be 1). To help, let's define a case, and a unit:
Unit – Item that is sold as that item whole (e.g. 1 Duff beer bottle = 1 Unit)
Case – Item that is made up of multiple units (e.g. A case of 24 Duff beer bottles = Case of 24)
Don't worry too much if you aren't sure what is best for you, by design this can be changed at any time as different suppliers invoice stock in different ways. If in doubt, recommend setting to 'units' to start, you can always change this as needed.
Mandatory Export Fields
By default, Lightyear will prevent you from exporting if your bills are missing a Case Qty or Unit Type, but this can be changed!
In Inventory Settings, click into the Inventory/POS Settings option.
Here you can mix and match the Mandatory Export Fields between these options:
- Case Qty
- Unit Type
- POS Code
Click confirm.
Any bills added to inventory from this point will check that the mandatory fields are met.
These will be flagged in Panel 1 with a warning icon . Panel 2 will highlight the fields with mandatory data missing, and users won't be able to export without adding in the missing information.
Once you have made the necessary adjustments, click Save and you will then be able to export.
Inventory Supplier Cards
We'll want to configure your Supplier cards, so that when you import your file to Bossii, the stock is assigned against the right supplier. To do so, select "Edit" Supplier Cards.
Supplier Cards can be manually entered by selecting "Add", or for larger lists, a csv file can be uploaded (more on this below). Bossi only requires the Supplier Name, but this must match exactly as it appears in Bossii Admin.