action.skip

Enabling Booking Accounts for Payment Data

← Booking Account Allocation

JustOn Billing & Invoice Management allows for writing bookkeeping data for revenues and taxes from finalized invoices. These records can then be transferred to accounting systems like DATEV, SAP or Microsoft Dynamics via CSV export or, for DATEV, direct transfer.

With booking details created from payment balances, the field G/L Account Number specifies the bookkeeping account number of the bank account or payment provider. To provide for the correct booking account allocation, you create dedicated Collective Account settings.

Payment bookings usually requires the following booking account:

Account name Account no.
SKR 03
Configuration Type
Bank 1200 Collective Account
Debtor Debtor number

Remember that depending on your accounting system, the booking account numbers may differ.

  1. Create a Collective Account setting for the payment bookings.

    To cover the outlined use cases, you need at least the following settings:

    Name Booking Account Type
    Bank 1200 Payment

    If you use multiple collective accounts, specify additional information, like Business Entity, to determine the best matching collective account as necessary. For details, see Collective Account Concepts.

    For details, see Configuring Collective Accounts.

  2. Enable the debtor account number.

    Depending on your requirements, the way to define the debtor account number differs:

    For customer-specific debtor numbers, you use the Account field ON_DebtorNo.

    1. Navigate to the fields list of the Account object.
    2. Create the following new field.

      API Name Data Type Description Example Values
      ON_DebtorNo Text (255)
      or
      Formula
      Specifies the contra account number for booking details. If configured as a formula, it can determine the value based on other fields. 12345
      AnotherField__c

    To support collective debtors (or debtor groups), you use the Business Partner Account field of the collective account setting created for payment bookings.

    1. Click to enter Setup, then open Custom Settings.

      In Salesforce Lightning, navigate to Custom Code > Custom Settings.

      In Salesforce Classic, navigate to Develop > Custom Settings.

    2. Click Manage in the row of Collective Accounts.

    3. Click Edit in the row of the relevant collective account setting.
    4. In the Business Partner Account field, specify the contra account number.

      Following the example, your Collective Account setting may look like

      Name Booking Account Type Business Partner Account
      Bank 1200 Payment 12345
    5. Click Save.

    Info

    When creating booking details, the Account field ON_DebtorNo takes precedence over the Collective Account field Business Partner Account. If the Account field ON_DebtorNo is empty or does not exist, JustOn Billing & Invoice Management uses the Collective Account field Business Partner Account to set Contra Booking Account in the booking detail.