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 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”.

• 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”.

• 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”

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”

Hope it helps.

Until next post.