Gift card mapping

Gift card sales

In LS One POS we have the functionality to issue a gift card. In order to track gift card sales in SAP Business One we need to map each gift card to one specific gift card item.

  1. SAP Business One
    1. Open Inventory > Item Master Data
    2. Click Add and configure the item to use as your gift card item. Uncheck the properties "Inventory Item" and "Purchase Item".

    3. (Optionable) Create and configure a new account for gift card sales
      1. Open Financials > Chart of Account
      2. Click Add and configure an account to use for gift card sales

      3. Open Administration > Setup > Financials > G/L Account Determination > G/L Account Determination
      4. Go to the Sales tab and select the rules for Revenue Accounts
      5. Create a new rule for your gift card item and select the revenue account you created for gift card sales

      6. Create a new Tax Code Determination rule to avoid tax being withdrawn from the total gift card amount and placed into a different revenue account. Go into Administration > Setup > Financials > Tax > Tax Code Determination. Setup a new rule for your gift card item with Line Tax Code set to X0.

        />

  2. Site Manager

    1. Open Tools > Replication > Jobs

    2. Select All from SAP Business One

    3. Click Run job

    4. Open SAP Business One > Data Mapping > General

    5. In the Gift card item section, select the item you created in SAP Business One. The drop-down will only display items of type "Service Item", so make sure the item you want to use is neither marked as"Inventory Item" nor "Purchase Item" in SAP Business One.

    6. Click Save

    Now when you issue a gift card in LS One and post the transactions to SAP Business One, the transaction will display your configured gift card item as the sold item. If you did step 1.3 you will also see that the gift card amount is withdrawn from the selected gift card sales account.

    Here is an example of an invoice in SAP Business One displaying a gift card sale made in LS One

    Under Remarks we can see the ID of the gift card that was sold.

Gift card payments

SAP B1 does not currently have any support for gift cards so we need to map our LS One gift cards to SAP B1 with credit card mapping.

  1. SAP Business One
    1. Open Administration > Setup > Banking > Credit cards
    2. Create a new credit card to use for gift card payments and select the account you want to use

  2. Site Manager 
    1. Open Tools > Replication > Jobs

    2. Select All from SAP Business One

    3. Click Run job

    4. Open Sites > Sites/Terminals > Stores
    5. Select a store
    6. Open Allowed payment types on the left
    7. Add a new allowed payment type
    8. Create a new payment type for gift cards and select the action Pay gift card

    9. Open SAP Business One > Setup > Data mapping
    10. Select Accounts
    11. Under Gift card payments select an account you want to use

    12. Select Credit cards
    13. For the gift card you created earlier, set the payment type to Gift card

    14. Press Map credit cards

Now each time you pay for an item using the Pay gift card operation in the LS One POS, the payments will be mapped to the selected account in SAP Business One.

Here is an example in SAP Business One of a payment made with a gift card in LS One

We can see the account the payment goes into and we can see the ID of the gift card used under ID No. and under Voucher No.

 

Now your setup is complete.

For additional tips and tricks see Setup complete