Default General Business Posting Group for Inventory Transactions

In standard Dynamics BC365, one specific account is set to be used when registering different types of transactions with stock items. Because according to accounting requirements different ledger accounts should be used, the users must change the setup before registering some specific item transactions.

To avoid user interference into the recommended accounting setup, a functionality had been developed to allow the system to use a specific setup with a particular ledger account when registering:

  1. Items reclassification transactions – the general business posting group is set up at journal batch level;
  2. Internal consumptions – the general business posting group is taken from Inventory Setup;
  3. Transfer orders – the general business posting group is taken from Inventory Setup;
  4. Physical Inventory Journal – the general business posting group is set up at journal batch level;
  5. Item journal lines – the general business posting group is set up at the journal batch level.
Important

Using this setup, the user can post different types of item transactions without modifying the G/L account from posting groups setup and trace the types of transactions posted.

The setup of the Gen. Bus. Posting Group for each Inventory transaction is made in the Inventory Setup window.

Note

Access Inventory Setup by searching for it in the Tell me icon.

Inventory Setup

The new fields that were added in the Inventory Setup page are:

  • Gen.Bus.Posting Group Order: in this field is selected the Gen.Bus.Posting Group specific for transfer orders;
  • Gen.Bus.Posting Group Int. Cons.: in this field is selected the Gen.Bus.Posting Group specific for internal consumptions;
  • Gen.Bus.Posting Group Assembly Hdr.: in this field is selected the Gen.Bus.Posting Group specific for assembly order's header.
  • Gen.Bus.Posting Group Assembly Lines: in this field is selected the Gen.Bus.Posting Group specific for assembly order's lines.

Item Journal Batch Setup

You can access Item Journal Batches by searching in the Tell me icon for Item Journals. You must then click next to the Batch Name on the Lookup value for Batch Name button and the list of batches will show up.

In the Item Journal Batch line were added the following fields:

  • Gen. Bus. Posting Group: the posting group selected in this field will be used for each transaction posted from that Item Journal Batch.
  • Gen.Bus.Posting Gr. Inv. Plus: the posting group selected in this field will be used for plus inventory identified at the posting of the Physical Inventory.
  • Gen.Bus.Posting Gr. Inv. Minus: the posting group selected in this field will be used for minus inventory identified at the posting of the Physical Inventory.
Important

For each transaction type, the corresponding Gen. Business Posting Group must be filled in based on the setup.

1. Transfer Orders

  • Open the Transfer Orders page by searching in the Tell me icon for Transfer Orders.
  • Create a new transfer order.
  • Select an item code;
  • The Gen.Bus.Posting Group Order will be filled in from the Inventory Setup page.

2. Assembly Orders

  • Open the Assembly Orders page by searching in the Tell me icon for Assembly Orders.
  • Create a new assembly order.
  • Select an item code;
  • The Gen.Bus.Posting Group Order will be filled in from the Inventory Setup page.

3. Internal consumptions

  • Open the Internal consumptions page by searching in the Tell me icon for Internal consumptions.
  • Create a new internal consumption card.
  • Select an item code;
  • The Gen.Bus.Posting Group Order will be filled in from the Inventory Setup page.

4.Item Journals

  • Open the Item Journals page by searching in the Tell me icon for Items Journals.
  • Create a new line with Entry Type: Positive adjustments
  • Select an item code;
  • The Gen.Bus.Posting Group Order will be filled in from the Item Journal Batch.
    Note

    The same situation applies to Entry Type: Negative adjustments.

5.Physical Inventory Journals

  • Open the Physical Inventory Journals page by searching in the Tell me icon for Physical Inventory Journals.
  • Calculate the physical inventory at a certain date.
  • Modify the physical inventory quantity in the field Qty. (Phys. Inventory) with bigger or smaller quantities for different lines.
    Note

    Based on the difference between the Qty. (Phys. Inventory) and Qty. (Calculated) fields, we have two situations:

    • For Positive adjustments, the field Gen.Bus.Posting Group is filled with the posting group set up in the Item Journal Batch – field Gen.Bus.Posting Gr. Inv. Plus;
    • For Negative adjustments, the field Gen.Bus.Posting Group is filled with the posting group set up in the Item Journal Batch – field Gen.Bus.Posting Gr. Inv. Minus;