Skip to content
English
  • There are no suggestions because the search field is empty.

Lightyear

3rd Party Integrations - Exports / Imports

Lightyear

 

 

This provides information about ...

 

Subjects      ▲ ▼

 

About      ▲ ▼

 

What Is It?      ▲ ▼

Lightyear is an Accounts Payable Automation, PO & Expense Management Software application. Refer HERE for more information.

 

What Is Required?      ▲ ▼

  • Lightyear has been configured to export inventory data to Swiftpos.
  • The required Supplier exists in Swiftpos and is Active.
  • The Supplier Account is configured where available.
  • The Supplier ABN is configured where available.
  • Required items/products exist in Swiftpos.
  • Supplier Order Codes are maintained against items/products where applicable.
  • Lightyear Supplier Cards are configured and linked to the appropriate suppliers.
  • Product Unit and Case Quantity settings in Lightyear are appropriate for the items/products being exported.
  • The correct Swiftpos Location is being supplied for the invoice.

 

What To Consider?      ▲ ▼

  • Lightyear provides the invoice quantities and values imported into Swiftpos.

  • The Lightyear integration does not introduce a separate Swiftpos costing method. When the Pending Invoice is completed, Swiftpos processes the invoice using the standard Supplier Invoice costing selected HERE.

  • Refer HERE for more information regarding costing, freight, discounts and completing Supplier Invoices.

 

What To Reference?      ▲ ▼

Lightyear

Swiftpos

 

When Is It Used?      ▲ ▼

Lightyear can export supplier invoice data for import into Swiftpos.

The integration is file-based. Lightyear processes the supplier invoice and exports inventory data using the Swiftpos Generic Supplier Invoice (.inv) file format.

The resulting .inv file is imported into Swiftpos Back Office, where the Supplier and items/products are matched before the invoice is processed through the standard Swiftpos Supplier Invoice workflow. The workflow is:

Supplier Invoice → Lightyear → Swiftpos .inv file → Invoice Import → Match Supplier and Products → Save as Pending → Invoices / Receipt Goods → Save as Complete

Refer HERE for more information.

 

Example      ▲ ▼

The following is an example:

 

Swiftpos Generic Invoice (.INV) File      ▲ ▼

H,ILG,1234,,70252541400,02439103,02/05/2020,,1,99999,
I,395-6785,APEROL,,1.0000,0,3.0000,58.0299,,5.8030,
I,305-2421,BULLEIT BOURBON 45%,,1.0000,0,1.0000,41.0500,,4.1050,
I,395-1021,CAMPARI APERITIF 25%,,1.0000,0,3.0000,86.4801,,8.6480,
I,285-0775,GORDONS PINK GIN 700ML,,1.0000,0,2.0000,78.7800,,7.8780,
I,285-5217,HENDRICKS GIN,,1.0000,0,2.0000,126.7300,,12.6730,
I,345-0367,KRAKEN BLACK SPICED RUM,,1.0000,0,1.0000,46.9600,,4.6960,
I,345-5638,SAILOR JERRY SPICED RUM,,1.0000,0,1.0000,38.8200,,3.8820,
I,115-0033,ASAHI SUPER DRY 5%,,1.0000,0,24.0000,47.5296,,4.7530,
I,110-1257,COOPERS PALE ALE STUBB 4X6P,,1.0000,0,24.0000,47.2200,,4.7220,
I,115-2246,CORONA (P) 4X6PK STUBBIES,,1.0000,0,48.0000,87.9600,,8.7960,
I,460-0774,BUNDABERG GINGER BEER 4PK STUB,,1.0000,0,24.0000,33.5592,,3.3559,
D,,,,,,,,,,,
T,11,693.1188,69.3119,,,,,,,,

 

How To?      ▲ ▼

 

How To GET STARTED?      ▲ ▼

 

Configure Lightyear      ▲ ▼

Lightyear configuration is completed within Lightyear. Refer HERE for more information.

  • Enable Inventory/POS Export In Lightyear. This enables the SwiftPOS-specific inventory export settings in Lightyear. Do as follows:

    • Navigate to Settings > Company Settings.

    • Enable the Inventory/POS option.

    • Save the settings.

    • Navigate to Settings > Inventory Settings.

    • Select SwiftPOS as the Inventory/POS software.

  • Configure Mandatory Export Fields
    Lightyear can prevent an invoice from being exported when required inventory information is missing. Available Mandatory Export Fields include:
    • Case Qty
    • Unit Type
    • POS Code

    Configure the fields appropriate to the site's Product and Supplier setup. If a mandatory value is missing, Lightyear identifies the affected items and prevents export until the required information has been completed.

  • Configure the Default Cellar Location
    A Default Cellar Location can be configured in Lightyear. This value is included in the data exported for Swiftpos.

    If different Suppliers need to be received into different locations, Lightyear can assign different Cellar Locations against individual Supplier Cards.

    Ensure the resulting Location is correct before committing the invoice in Swiftpos.

    The Location is important because stock is posted to the selected Location when the Supplier Invoice is later saved as Complete.
  • Configure Supplier Cards in Lightyear

    Supplier Cards associate Lightyear Suppliers with the inventory suppliers used for export. In Lightyear:

    • Navigate to Inventory/POS Settings.
    • Select Edit against Supplier Cards.
    • Add the required Supplier Cards.
    • Supplier Cards can be entered individually or imported using a CSV where supported.
    • Navigate to Suppliers.
    • Edit the required Lightyear Supplier.
    • Select the appropriate Supplier from the Inventory Supplier field.
    • Save the changes.

    Supplier information should correspond with the Supplier configuration in Swiftpos to assist with identifying the correct Supplier during import.

    Swiftpos Generic INV Supplier matching is performed using the Account ID and Supplier ABN contained in the .inv file. If a Supplier cannot be identified automatically, Swiftpos prompts the user to select one.

 

Configure Swiftpos      ▲ ▼

Do as follows:

  • Configure The Swiftpos Supplier

    Before importing invoices from Lightyear, confirm the following Supplier details in Swiftpos:

    • The Active option is selected to ensure Purchase Orders and Supplier Invoices can be created.

    • The Account field contains the Account/Customer Number assigned by the Supplier where applicable. 

    • The ABN field the Supplier's ABN where available. 

 

Notes ...

 

The Account field is commonly used for electronic invoice imports. When importing a Swiftpos Generic INV file, Swiftpos first attempts to match the Account ID contained in the file against the Supplier Account configured in Swiftpos.
If Swiftpos cannot match the invoice using the Account ID, it attempts to match the Supplier's ABN from the .inv file against the Supplier's ABN configured in Swiftpos. If neither value identifies a Supplier, Swiftpos prompts the user to manually select the Supplier.

 

  • Configure The Swiftpos Supplier continued ...
    • Refer HERE for more information.
  • Configure The Default Product Unit
    • In the SwiftPOS Inventory/POS settings, configure the default Product Unit. The available options include:
      • Units – items default to individual units.
      • Cases – suitable where suppliers commonly invoice products by case/carton.

      The default Product Unit can be changed against individual items before the invoice is exported.
      Ensure this setting reflects how the corresponding items/products are maintained and received in Swiftpos.

Notes ...

 

The default Product Unit can be changed against individual items/products before the invoice is exported. Ensure this setting reflects how the corresponding items/products are maintained and received in Swiftpos.

 

How To Export An Invoice From Lightyear?      ▲ ▼

Once the supplier invoice has been processed and is ready for inventory export, do as follows:

  • Move or send the invoice to the appropriate Lightyear Inventory workflow.
  • Check the inventory information, including:
    • Product Unit
    • Case Qty
    • Quantity
    • POS Code
    • Supplier
    • Cellar/Location
  • Select Export. Lightyear creates a ZIP file containing the exported invoice files. A ZIP may contain:
    • one .inv file for a single exported invoice; or
    • multiple .inv files when multiple invoices are exported.
  • Extract the ZIP before importing the invoice into Swiftpos. Swiftpos imports the extracted .inv file, NOT the ZIP file.

 

Notes ...

 

It is recommended that the extracted files are saved to a folder used specifically for Swiftpos invoice imports.

 

How To Import An Invoice Into Swiftpos?      ▲ ▼

In Swiftpos Back Office, do as follows:

  • Move or send the invoice to the appropriate Lightyear Inventory workflow.
  • Check the inventory information, including:
    • Product Unit
    • Case Qty
    • Quantity
    • POS Code
    • Supplier
    • Cellar/Location
  • Select Export. Lightyear creates a ZIP file containing the exported invoice files. A ZIP may contain:
    • one .inv file for a single exported invoice; or
    • multiple .inv files when multiple invoices are exported.
  • Extract the ZIP before importing the invoice into Swiftpos. Swiftpos imports the extracted .inv file, NOT the ZIP file.

 

Notes ...

 

It is recommended that the extracted files are saved to a folder used specifically for Swiftpos invoice imports.

 

How To Find A Lightyear Invoice?      ▲ ▼

Once a Lightyear invoice has been committed into Swiftpos, it can be located using the Find Invoices option in the Suppliers menu in Back Office.

 

Troubleshooting      ▲ ▼

  • Lightyear will not allow the invoice to be exported

    Check the mandatory export fields configured in Lightyear. Depending on configuration, the invoice may require:

    • Case Qty
    • Unit Type
    • POS Code

    Complete the missing information, save the changes and export the invoice again.

  • Swiftpos prompts for a Supplier

    Swiftpos could not automatically identify a Supplier using the Account ID or Supplier ABN contained in the .inv file. Check the Swiftpos Supplier record, particularly:

    • Account
    • ABN
    • Active status

    If required, manually select the correct Supplier.

    If the wrong Supplier is selected, delete the imported invoice and import the .inv file again.

  • Products are not automatically matched

    Open the Match Invoice screen and review the unmatched invoice lines. Check:

    • Supplier/POS Product Code exported by Lightyear
    • Supplier Order Code associated with the Swiftpos Product
    • Swiftpos Product Code
    • Product Description

    Manually select the correct Swiftpos item/product where required.

  • Invoice quantity or costing appears incorrect

    Before committing the invoice, check:

    • Product Unit in Lightyear
    • Case Qty
    • Number of Cases
    • Unit Quantity
    • Product matching
    • Location
    • Imported values

    Case Quantity is particularly important because imported case quantities are applied to matching Swiftpos item/product records when the invoice is committed as Pending.

  • The invoice imported successfully but stock has not increased

    Importing the .inv file and committing it creates a Pending Supplier Invoice. The invoice must still be retrieved and completed. Refer HERE for more information.  Stock is incremented when the Supplier Invoice is saved as complete.

  • The invoice imported but cannot be found
    Using the Find Invoices option in the Suppliers menu in Back Office, search using the Invoice Number, Supplier, date or Location. Find Invoices displays both Pending and Completed Supplier Invoices.

     

  • Swiftpos cannot import the Lightyear file

    Confirm:

    • The ZIP exported from Lightyear has been extracted;
    • The selected file has an .inv extension;
    • Generic > INV has been selected as the import format;
    • The exported .inv file has not been manually modified.

    For file format specifications refer HERE.

 

End of article      ▲