Set up G/L posting consolidation

To set up the posting of General Ledger entries in a consolidation format in NP Retail, follow the provided steps:

  1. Click the Lightbulb button, enter POS Posting Profiles, and choose the related link.
  2. Either modify the existing DEFAULT setup, or create a new profile.
  3. Set up the following fields to get the posting for transactions in a consolidated format per a POS unit:

  • POS Period Register No. Series - this number series is used for assigning a document number to the posted batch when consolidation is done per a period.

  • G/L Posting Consolidation - this field specifies how the system should consolidate the G/L entries created from POS Entry Sales Lines. The following options are available:

    • Unconsolidated - posting is performed on individual transactions without consolidating the values.
      The POS entry document number is used as the posting document number in G/L.
    • Per POS Entry - each individual posted entry is consolidated when there’s more than one line with the reference to the same G/L account, dimension set ID, VAT setup, etc. for that POS entry as one line.
      The POS entry document number is used as the posting document number in G/L.
    • Per POS Period - posting is consolidated for the entire POS period.
      The POS entries created in the same period are posted together to the General Ledger at EOD, and the resulting G/L entries are consolidated per POS Unit, G/L account, dimension set ID, VAT setup, etc.

      If you choose to consolidate the transactions posting by POS period, it is mandatory to set the POS period register number series. The POS Period Register No Series as defined in above field, is used as the posting document number and not the POS entry document number in G/L.

    There are additional settings on consolidation of G/L entries created from POS Entry Payment Lines in the POS Payment Method card.

  • Consolidation G/L Posting Description - this field allows user to modify the default description on the G/L entries in the General Ledger Entries. When posting to G/L, the default description of the G/L entries have a value of:

    • “Unconsolidated”, are G/L or Item description,
    • “Per POS entry” are “POS entry” + entry no from POS entry list
    • “Per POS Period” are “POS Period Register no” + entry no of POS period register

    When the transaction is posted, placeholders (values %1, %2 … %6) can be set to replace with default values where:
    %1 with “POS Unit No.”
    %2 with “POS Store Code”,
    %3 with “Posting Date”,
    %4 with “POS Period Register No.”

    You can use the placeholders %1 to %4 in any order. For example, “Posting from POS %1, Store %2, Period %4” will appear in the posted G/L description as “Posting from Unit 01, Store 01, Period 21.”

See also

← Automatically post Sales Orders every evening via job queue
Send notifications for failed job queue entries and retry →