Skip to Content
avatar image
Former Member

I/U profit and loss in Inventory : data source

Hello dear gurus :

I am trying to define information, to load in inventory data and supplier data: for example company A sells goods to company B, products P1 (100 units) and P2(200 units), with several profit margin in the month. B sells to another customer P2 by 50 units.

INVENTORY DATA :

Company : B

Trading Partner : Blanks

Product group : P1; P2

Book Value : purchasing cost

Periodic qty : 100 and 150 (200 u2013 50)

Item : ?????

so, the inventory data is the stock qty in subsidiary company, is it true ? Item is a neccesary, is the position value ? is possible to create an validation against the amount in stock position ?

SUPPLIER DATA :

Company : A

Trading Partner : Blanks

Product group : P1; P2

COGM per U/M : cost at end of month from company A

so, the supplier data is data coming from main company, were the item stock was produced, is it true ?

Thanks a lot in advance

Ismael

Edited by: Ismael Lozano on Sep 4, 2008 8:25 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 04, 2008 at 07:14 PM

    INVENTORY DATA :

    Company : B

    Trading Partner : Blanks

    - Supplying unit = A

    Product group : P1; P2

    - Yes.

    Book Value : purchasing cost

    - Book value of the rest of stock, separately for P1 & P2 (P1's purchase price * q-ty left on the stock and P2's purchase price * q-ty left on the stock)

    Periodic qty : 100 and 150 (200 u2013 50)

    - not needed

    Item : ?????

    - must be defined in customization: UCWB/ConsfUNCTIONS/IPI/Settings/Inventory items

    so, the inventory data is the stock qty in subsidiary company, is it true ?

    - Not necessarily, it's a stock book value at the end of period in the one of unit of the group bought from another unit of the group.

    Item is a neccesary, is the position value ?

    - Item is necessary. Do not underastand the rest of your Q.

    is possible to create an validation against the amount in stock position ?

    - What do you mean exactly? SEM-BCS is not a transactional ECC system.

    SUPPLIER DATA :

    Company : A

    Trading Partner : Blanks

    - Inventory managing ConsUnit = B

    Product group : P1; P2

    - Yes, but separately

    COGM per U/M : cost at end of month from company A

    - Instead of this I usually use Gross or markup margin in %

    so, the supplier data is data coming from main company, were the item stock was produced, is it true ?

    - Supplier data is coming from the one of the unit of the Group (not necessarily from the mother one) which stock is still on the B/S of the B at the end of the period.

    Add comment
    10|10000 characters needed characters exceeded