Skip to Content
author's profile photo Former Member
Former Member

SBO - Management of 2 stock accounts

Hi,

I'm currently stuck within one of my implementation.

I'm deploying the same solution worldwide which worked pretty well until now. All the items are connected to an item group, with a unique GL account, supposed to book at the same time the good receipt and the good issue (Balance-Sheet Account = 14xxxxx). These flows are done like this :

PO - GR - AP Invoice

SO - Delivery - AR Invoice

My new unit is willing to use two different GL accounts when performing its stock entry / Good receipt (let say 14xxx10) and another GL account for the good issue / delivery , let say 14xxx20.

Meanwhile, we don't want to use manual good entry / good issue as we want to keep the flow integrated.

Do you have any clue so i can please them and keep using at the same time the item group ?

Thanking you in advance

Stephane

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 04:20 AM

    Stephane,

    The Inventory Account is derived from the Item Group Accounting defintions. Since there is only one Inventory G/L Account you can define, SBO will use the same Account for Goods Receipts and Goods Issue.

    It is not possible to specify two seperate G/L Account, one for inwards and one for outward Inventory movement.

    If you could let me know the reason why you would want to use two seperate G/L Accounts for the same Item. Functionally it does not make sense as the Goods Receipt will Debit to one G/L and the Goods Issue will Credit another Inventory G/L and the Accounting will not match.

    Pls let me know

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I guess I wasn't clear enough on my first answer.

      What, should be done (in the following order):

      - Say on the company parameters, how you want to determine the G/L Accounts,

      - Use the G/L Account Determination transaction to set the default accounts,

      - Create the misc. Item groups and warehouses and set the "good" accounts.

      Then, when you create an item, depending on the setting on the company it'll have the defined accounts. In all cases, these accounts can't be changed directly at this stage.

      If, on a per item basis, you want specific accounts, you'll have to go to the "Inventory data" tab on the "Item Master Data" dialog for your item. Then, you should change the option "Set G/L Account by" to "Item Level".

      In your case, what I would do is to create different warehouses and assign to each the "correct" G/L accounts. Then, when you'll do transactions from one warehouse or an other, the "good" accounts are going to be used. If it's not clear enough, you can contact me directly and we can speak in french, since from your name I think you're french just like me...

      I hope this is clearer this time...

      Regards,

      Eric

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 03:33 PM

    Stephane,

    Could I ask why would you have an Item as a Inventory Item without it being either a Purchase / Sale Item? If the Item is not a Sale Item when the COGS account does not come into use and thats probably why you are not able to change this account.

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.