Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Friday, July 14, 2017

Distributing Analytical Accounting Details on Sales Transaction Entry ( Cost of Goods Sold and Sales/Reveue )


One of the complex requirements is generate a profit and loss statement per sales channel, which requires distributing all revenue, cost and expenses account per Sales Channel, in order to be able to generate a profit and loss statement with Analytical Accounting Dimension details from the Management Reporter. 

Analytical Accounting - Expenses

Most expenses can be distributed directly, either from the payable, bank or general ledger. It seems to be a straight forward process as you just need to fill out the expenses on the distribution and fill out the associated sales channel directly. 


Analytical Accounting - Revenue and Cost

Distributing Analytical Accounting on the sales account seems to be straight forward process as well, once the Sales Invoice is created, you can easily go to the distribution and fill out the associated AA dimension (sales channel in this example). 

The bottle neck of this process is the cost accounts, since Inventory/ COGS journal is usually determined after posting the sales transaction and depending on the inventory valuation method (FIFO, LIFO or average). 

For this case specifically, the analytical accounting provides an essential feature which allows you to distribute the Inventory / COGS analytical details before posting the sales transaction entry. 

On the sales transaction entry window, Click on "AA" button on the ribbon of the window to open the Analytical Sales Transaction window



AA - Sales Transaction E










On the Analytical Sales Transaction entry window, there is a button to switch between the Inventory/COGS journal and the main Journal, illustrated below:






Now you can fill out the distribution related to the COGS, and switch back to the Sales/Revenue distribution to fill out the associated analytical accounting dimension as well. 


Best Regards, 
Mahmoud M. AlSaadi








1 comment:

  1. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete