FI- MM Integration question

[former_member261477]

Dear experts,

We have a Sub-Contract Process:

During GRN the entries as below (as is no change required)

Dr.  AXXXXX01 a/c Finished Goods  -  5000

Cr.  LXXXXX02 a/c GRIR - Inventory    - 3000

Cr.  Axxxxxx20 Stock Contra Account     -   5000

Dr. Exxxxxx02 Rework Cost (Control)     -  3000

During IR (AP) the entries as below (changes are required here)

Cr. 1xxxxx02 Vendor AP               - 4800

Dr. Lxxxxxx02 GRIR - Inventory      -   5000

Cr. Exxxxxx02 Rework Cost (Control - 200

So my requirement here is during GRN the above entries should be same.

During IR invoice receipt I wan the system to different GL account 

Cr. Exxxxxx02 Rework Cost (Control - 200 (this is as )

Cr. Exxxxxx09 COGS account - 200 ( to be process)

Kindly let me know without doing any customization is it possible in standard SAP.

Regards,

Chandu

[former_member183424 · Accepted solution]

No.. Not possible in standard SAP.

Whatever the SAP is creating the account entry during Invoice, it is designed.

You have given job work charges 5000 during GR (as per PO price). Now you don't want to pay 5000 to vendor, so you are posting amount 4800 to vendor, then the rest 200 amount should go back to the job charges account (not COGS account).. It is standard business process.

System is taking FRL transaction key for both GR and Invoice posting for job changes and it is designed by SAP.

You can't change it.

[former_member261477 · Accepted solution]

Hi Patra,

Really appreciated for your quick and great response.

Yes, you are right form OBYC transaction key FRL the GL account is being derived and will be posted during GRN and IR to the same account.

So in order to be able to fulfill my requirement what is the solution.

Can it be done by customization.

Regards,

Chandu

[former_member183424 · Accepted solution]

Yes.. I think a smart abaper can write a program/Enhancement.

Where the different G/L account will be picked during invoice posting. Sit with your ABAPer and tell him your requirement. He can do the enhancement. I can give you the logic.

Activate the valuation/account modifier in OBYC for the transaction key FRL. Then assign the COGS account for that particular valuation/account modifier and valuation class.

Then in enhancement, abaper has to do the programming that system will pick the g/l account with regards to the particular valuation/account modifier and valuation class only during posting invoice.

[former_member261477 · Accepted solution]

Thanks for your valuation time spending here.

Without any help of ABAP I have made the changes in OBYC for FRL.

But it will post during GRN and IR as well to the same account.

*******************************************************************************************************************

by the way I have another similar kind of requirement again.

**** This is standard Normal PO ****

Price difference will be posted to (PRD) EXXXXX04 Price difference account

We would like to know the impact if we change the GL code to EXXXXX101  COGS-Price diff account.

******************************************************************************************************************

Regards,

Chandu.

[former_member183424 · Accepted solution]

You missed the Enhancement part. Without enhancement, system will not fetch the valuation/account modifier for the transaction key FRL.

G/L account assignment in OBYC will not effect anything.. You just have to concern about the G/L account for balance sheet and P/L statement.

Just consult with your manager and other FI consultant (If any).

[former_member261477 · Accepted solution]

the first question is answered. I will with my abaper if not we drop out from this requirement.

*****************************************

the second requirement

both are P& L accounts only

One is Price Difference Acc which assigned to PRD

the another one is COGS - Price Diff we would like to assign this account if there is no impact.

What are the scenarios trigger to PRD account. if you could explain that really would be great.

[former_member183424 · Accepted solution]

My opinion is you should not mix the price difference account and COGS account.

PRD is totally different than COGS account.

COGS mean Cost Of Goods Sold.It should be triggered only when you sale the material from your warehouse..

Price difference account will be triggered when you purchase a material with XX price but you have the material standard price ZZ.

When you will transfer a stock from one material to another (both are having different standard price)

When you will post a IR with different price of GR and there are no sufficient stock for the material (material is having moving price).

[former_member261477 · Accepted solution]

Could explain sales perspective as well.

- Sales Order received,

- During Outbound delivery is there any price difference does it trigger to this PRD price difference account?

[former_member183424 · Accepted solution]

I don't think there are any price difference account will hit at the time of PGI - Accounting entry.

It will just create two entries

COGS account Credit

Stock account Debit.

[former_member261477 · Accepted solution]

Let's

In my material Master got moving average Price

Stock 100  price 6 = 600

During PGI stock 100 price 5.90 = 590.

Cr. Finished goods 590

Dr. GI/IR a/c            600

Cr  Which a/c ?          10

the remaining 10 will be posted to which account. in this case?

Please clarify this.

[former_member198650 · Accepted solution]

Hi Chandu,

At the time of PGI system will not credit GR/IR account. The below accounting entry will be posted:

COGS A/c Dr 600

Finished goods A/c Cr 600

Regards,

Mukthar

[former_member261477 · Accepted solution]

if in case during outbound delivery VL01N if there is any difference

will it post to which account?

regardless of Moving average price or Stand price in the Material master.

[former_member183424 · Accepted solution]

There are no option to give PGI price..

System will always create accounting entry = Quantity X material price for PGI.

So there wouldn't be any remaining price..

Stock 100  price 6 = 600

During PGI stock 100 price (5.90) 6.00= (590) 600.

Cr. Finished goods (590) 600

Dr. GI/IR a/c            600.

[former_member198650 · Accepted solution]

Hi Chandu,

There is no difference raised at the time of VL01N. Suppose if you revaluate your FG before PGI, then system will take a new price at the time of PGI.  If you have faced any issue, then explain clearly. Then only we provide a suggestion.

Regards,

Mukthar

[former_member261477 · Accepted solution]

but still I am able to see three entries in the system at the time of VL01N.

[former_member183424 · Accepted solution]

What is the 3rd line item ?

What are the transaction event key for total line items ?

Can you post a screen shot for the accounting entry with transaction event key.

[former_member261477 · Accepted solution]

Hi,

Please check it if you need more info... please let me know.

[former_member183424 · Accepted solution]

It is the accounting entry for Goods receipt not PGI..

You can see the transaction event keys..

BSX, WRX, PRD. It is exactly same as per my first scenario

"Price difference account will be triggered when you purchase a material with XX price but you have the material standard price ZZ."

[former_member261477 · Accepted solution]

if that is the case why the document type show at document header level?

WL : Goods Issue/Delivery

TCode  : VL02N

[former_member183424 · Accepted solution]

What is the movement type posted for this document ?

[former_member261477 · Accepted solution]

the movement type is : 161

[former_member183424 · Accepted solution]

Movement type 161 is used for return delivery. Return delivery is quite same line as Goods receipt cancel. Your system is showing correct accounting entry.

[former_member261477]

Hi Patra,

Thanks a lot! your great effort and time spending here I really appreciate for your replies.

by the way where to assign points?

[former_member183424]

You do not need to assign points manually.. It will be added automatically..

If your all doubts got cleared, then you can leave the discussion as you have already marked the discussion as answered..

[former_member261477]

Thanks!

Last time I used to assigned points manually that's the reason I have asked you.

its resolved!