Skip to main content

Notifications

Dynamics 365 Community / Blogs / Business Central Page / Sales Invoice – General Led...

Sales Invoice – General Ledger Journals

In this post I will explain how does MS Dynamics GP and Business Central generate the journal when the “Sales Invoice” is posted.

Let’s summaries the difference:

  • MS Dynamics GP can retrieve the “Inventory”, “Cost of Goods Sold” and the “Sales” account even from the “Customer” or “Item” cards based on the “Sales Order Processing Setup” but Business Central will retrieve them only from the related posting groups.
MS Dynamics GP – Sales Order Processing Setup
  • Ms Dynamics GP may “flip” update a specific segment in the “Inventory”, “Cost of Goods Sold” and the “Sales” accounts based on the “Segment ID for Sites” in the “Inventory Control Setup” and the “Account Segment ID” in the “Site Maintenance” but in Business Central, this is not the case, Business Central will retrieve the related G/L Accounts as they are “there is no flipping”.
MS Dynamics GP Inventory Control Setup and Site Maintenance
  • In MS Dynamics GP, the invoice journal can be updated before posting but in Business Central it can’t.

This is “Sale Invoice” Journal in general (Without Tax/VAT to make it easier).

DR Accounts Receivables
DR Cost of Goods Sold
Cr Inventory
Cr Sales

  • Accounts Receivables: In MS Dynamics GP, this “Accounts Receivables” account in the “Customer “Debtor” Account Maintenance”, in Business Central it is the Accounts Receivables in the “Customer Posting Group”.
MS Dynamics GP – Debtor Account Maintenance
Business Central – Customer Posting Group
  • Inventory, Cost of Goods Sold and Sales Accounts: As I mentioned above, In MS Dynamics GP, these accounts are even retrieved from the “Item” card or the “Debtor” card (Usually the “Item” Card), flip the segment if required and the Journal is completed.
    In Business Central it is a different story.

The “Inventory” Account can be found in the “Inventory Posting Setup” which is a combination from “Inventory Posting Group” – which is assigned to the item- and the “Location”

Business Central – Inventory Posting Setup

The “Sales” and the “Cost of Goods Sold” Accounts are assigned in the “General Posting Setup” page, The records in the “General Posting Setup” are a combination from “Gen. Bus. Posting Group” and “Gen, Prod. Posting Group”. The “Gen. Bus. Posting Group” is assigned to the “Customer” and the “Gen. Prod. Posting Group” is assigned to the “Item”

Business Central – General Posting Setup Combinations

Hope it helps.

Until next post.

Comments

*This post is locked for comments