I/U profit and loss in Inventory : data source

[Former Member]

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

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Hi Eugene,

some days ago I did the following question "is possible to create an validation against the amount in stock position ?"

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

Now I can explain better ( I solved the problem), probably you knew the answer, but only to try to give a little comment :

With AFD "Reported Financial Data" I load monthly amount of accounts stock

p.e : position 11090100 March USD 15.000

With AFD "Inventory Item" I load a detail using product group

p.e. Position 11090100 March PG Z355 8 units 3.000 USD

Position 11090100 March PG Z389 9 units 5.000 USD

Position 11090100 March PG Z399 4 units 8.000 USD

In the example above describe Reported has 15.000 and Inventory has 16.000; so this is a wrong.

In Validation, using a Task / Additional Financial Data and chosing Inventory Data option, the system uses standard fixed validation.

Thanks!

[Former Member · Accepted solution]

Ismael, thank you very much for clarification and coming back with updates!