how to change COGS at movement type in SD modules

[Former Member]

Dear Experts,

I'm midst of make some settings for online buyers for our company goods. We call this as eSP process. Below I explain more in details how it works before go to my issue. This may help you understand well about this issue.

Exp: customer - EP-ZSB277

Stor. loc : 10TP

Stock available : 10 pcs (t/code: MMBE)

Material : 3100010223 & moving average price (MAP) RM10/pc

1. SO : ZEI1 (SRS)

- qty: 1pc

- outbound delivery : YEI1

- billing : XEI1

- movement type : 631

- material movement : 10TP qty 9pcs (stock reduce) & customer consignment stock EP-ZSB277 qty 1pc (stock increase)

• since this is online business, user do Billing once customer place the order BUT that material still at our premises under special stock (customer consignment stock, NOT at stor. loc. 10TP) until sufficient stock to make delivery

2. SO : ZEF1 (replenishment)

- qty: 1pc

- outbound delivery : YEF1

- NO billing

- movement type : 633

- material movement : customer consignment stock qty 0pc (stock out from location) & NO effect at stor. loc. 10TP

• user will do ZEF1 & YEF1 when delivery to customer taking place (stock out will happen in system)

So far I managed to do all these settings & all are work fine unlikely COGS.

- COGS happen during YEF1, NOT at YEI1. Honestly I didn't do any settings against this COGS for eSP process so I don't know how this happen & how to change this. In fact I'm wonder how to make this settings in SD modules.

- user said this is wrong coz SRS & replenishment is not happen in same day

Exp: ZEI1 (SRS) today but ZEF1 (replenishment) happen at next month. Before ZEF1 for 3100010223 material to EP-ZSB277 customer, there are high possibilities that 3100010223 sell to other customer & this caused to COGS can be differ.

Now I'm seeking your help how may I set COGS to YEI1 & cancel COGS at YEF1. Please assist me. TQ

rgds,

nema

[Former Member]

Hi

In your case at YEI1 the stock is in special stock(customer stock ) it is responsible of company's end thats why there are no accounting entries for that ,coz the stock is still showing in your books by special stock indicator.

Once the actual sale happend at YEF1 the system will reduce the inventory from the system and accounting entries will be updated

If you have any further clarifications let mwe know

Regards

Damu

[Former Member]

Dear Experts,

Thanks for your immediate response. By the way I got to know that vov6 (schedule line config) contains the movement type...The settings in OMJJ (movement type) + OBYC determines the GL for COGS... BUT I didnt know how it works. Anyone can help me explain how it works & assit me to do this settings.

As the same time is that possible we make COGS at YEI1 (mov. type 631) & cancel at YEF1 (mov. type 633) upon Outbound Delivery. If yes, please assist me how to do this.

Thanking in advance.

rgds,

nema

[Former Member]

Dear Experts,

I created few settings such;

SO type: ZEI1

1. OMJJ

- create new goods movement 631 = Z31 (copy from 631)

- account grouping for Z31 u2013 GBB (trans. Event. Key) u2013 Z31 (acct. modifier)

2. Schedule line

- Y6

- tag movement type Z31

- this use at SO type ZEI1

3. OBYC

- transaction GBB

- c/code 3100 u2013 general modification Z31 u2013 valuation class 7920 (base on material master) u2013 g/l acc

SO type: ZEF1

1. OMJJ

- create new goods movement 633 = Z33 (copy from 633)

- account grouping for Z33 u2013 GBB (trans. Event key) u2013 Z33 (acct. modifier)

2. Schedule line

- C4

- tag movement type Z33

- this use at SO type ZEF1

3. OBYC

- transaction GBB

- NO g/l acct set against acct. modifier Z33

Now I create SO ZEI1 & outbound delivery YEI1 u2013 COGS not created with error

Material document 4900349707 does not include an accounting document

Message no. M7082

Diagnosis

The system cannot find an accounting document for the material document 4900349707.

Possible reasons for this are:

u2022 The goods movement has no relevance to accounting. Therefore, the system did not generate an accounting document for the material document.

u2022 The material document is a document that was posted before Release 2.1. Such documents must be converted so that the system can find the relevant accounting document.

u2022 The procedure for the subsequent calculation of value is not active in your system. For further information, refer to the documentation on the program for valuating goods movements: RM07MWBU.

Procedure

u2022 Choose Continue and then choose another function.

u2022 Find out when the material document was created. If the document was created prior to the Release changeover, ask your system administrator to carry out the conversion of the documents. The individual steps required for document conversion are described in the Release Notes for Release 2.1B.

But when I created another SO ZEF1 & outbound delivery YEF1, system give error during PGI. Actually I didnu2019t set any g/l acct for acct modifier Z33.

Account determination for entry CNI GBB 3100 Z33 7920 not possible

Message no. M8147

Diagnosis

The system did not find an account for this transaction. This means that the account determination for key CNI GBB 3100 Z33 7920 is not maintained in MM Customizing (Valuation). The key is made up of:

u2022 Chart of account

u2022 Transaction key (= Posting transaction)

u2022 Valuation grouping code

u2022 Account grouping code

u2022 Valuation class

System Response

The system cannot update a G/L account for this transaction. You cannot post the transaction.

Procedure

Contact your system administrator.

If you have the authorization, check the Account determination in Customizing for Valuation.

Proceed

Note

The relevant posting transaction can be found in Table T030A.

1. Well may I know how the system know that this movement Z33 (633) should have acct determination (COGS) & not at movement type Z31 (631).

2. how to change the COGS from Z33 to Z31, even though I did some creation at OMJJ. OBYC & schedule line

3. appreciate if you could help me explain on the 1st error message that I attached on top such release 2.1, release 2.1B , RM07MWBU & others.

Thank you so much for your support so far.

Plz guide me Guru.

Rgds,

nema

[Former Member]

hi,

is there anyone can assist me?

nema

[Former Member]

Hi,

When you create delivery, then G/L gets updated

Cost of finsihed goods

Finished good inventory,

And when you create invoice & save's, then this values that is cogs & revenue flows in Profitability analysis.

Take help of your FICO team, to sort out this problem.

kapil

[Former Member]

Hi Kapildev,

For Consignment SO process, Is that possible we make accounting entry during PGI in SO fill up & avoid accounting entry for SO issue. If yes, may I know how we make this happen. Please advise. TQ

rgds,

nema