This website is not affiliated with, sponsored by, or approved by SAP AG.

PO with condition type not going to the right GL account

Logistics : MM and its sub-modules (WM, IM, PO, LIS)

Moderators: Snowy, thx4allthefish, svetja, Ha Tran

PO with condition type not going to the right GL account

Postby sapfanatic.com » Sun Feb 08, 2015 10:56 pm

I created a Purchase order with account assignment I where I manually entered the GL account 50XXXXXX in the PO account assignment. In my PO there is a transportation fee paid separately from the purchase price so we created a ZTRA condition type for that transportation fee and assign an account key where it's setup to post to GL account 79XXXXXX. That ZTRA is manually entered in the PO conditions tab with a certain fee.
When I process the GR and check the GR accounting document, the transportation fee still posts to that 50XXXXXX and not in 79XXXXXX. why is that so? We want the transportation fee to post to 79XXXXXX. We have setup correctly the pricing procedure and the condition type in M/08 and M/06.
sapfanatic.com
 
Posts: 473
Joined: Mon Oct 09, 2006 6:09 pm
Location: Cebu

Re: PO with condition type not going to the right GL account

Postby MM888 » Mon Feb 09, 2015 12:46 am

In the pricing schema, did you maintain also "accrual key" ?

BR,
MM888
MM888
 
Posts: 90
Joined: Fri Mar 09, 2012 9:12 am
Location: Kuala Lumpur

Re: PO with condition type not going to the right GL account

Postby sapfanatic.com » Mon Feb 09, 2015 3:25 am

Accrual key is maintained with FR1 which has the GR/IR Clearing account. I also maintained account key in the AccKey which is the 79XXXXXX but it does not post to that account.
sapfanatic.com
 
Posts: 473
Joined: Mon Oct 09, 2006 6:09 pm
Location: Cebu

Re: PO with condition type not going to the right GL account

Postby Ha Tran » Mon Feb 09, 2015 11:52 pm

Hi,

The setting of the accrual key for your related pricing condition type will only allow you to post the related costs to the GR/IR freight account (i.e. crediting not debiting).

Cheers,
HT
Ha Tran
 
Posts: 28316
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Re: PO with condition type not going to the right GL account

Postby sapfanatic.com » Tue Feb 10, 2015 5:35 am

Yep understand that Ha Tran. I'm ok with the GR/IR clearing account.
But for the account key which should post to 79XXXXXX it does not post to that.
sapfanatic.com
 
Posts: 473
Joined: Mon Oct 09, 2006 6:09 pm
Location: Cebu

Re: PO with condition type not going to the right GL account

Postby Ha Tran » Tue Feb 10, 2015 8:41 pm

Hi,

Can you provide the posting lines of your accounting document upon GR posting? Can you also capture in your subsequent reply the screen shot of your pricing schema configuration in M/08 transaction?

Cheers,
HT
Ha Tran
 
Posts: 28316
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Re: PO with condition type not going to the right GL account

Postby sapfanatic.com » Thu Feb 12, 2015 1:34 am

I do not know how to attach screenshot sorry.
Here are the details.

Accounting document is:
Itm PK G/L acct Account short text Profit Ctr Plnt Material Quantity BUn Amount Crcy
1 81 0050101101 TRAD SALES - MISC CR 295.01 GBP
2 96 0030101105 A/P:PETRL GR/IR CLRG 245.76- GBP
3 50 0030101100 A/P:GR/IR CLEARING 49.25- GBP

The 49.25 is the ZTRA transportation fee that Im referring to where it also posted in 50101101 where is shoult be posting to the 79XXXXXX account.

--------------------------------------

In the M/08, the ZTRA is setup with Manual ticked, Account Key ZTO, and Accrual key FR1.
ZTO is the 79XXXXXX account while the FR1 is the 30101100 account.

I'm having problem with that ZTRA not posting to 79XXXXXX but to 50101101.
sapfanatic.com
 
Posts: 473
Joined: Mon Oct 09, 2006 6:09 pm
Location: Cebu

Re: PO with condition type not going to the right GL account

Postby sapfanatic.com » Thu Feb 12, 2015 2:36 am

if that's is really the standard SAP behavior where it always posts to whatever GL account you assign in the PO line item, then is there a user-exit that can be applied when GR posting is saved which will trigger to put an enhancement to put a logic that will define all condition types to post to specific GL accounts?
sapfanatic.com
 
Posts: 473
Joined: Mon Oct 09, 2006 6:09 pm
Location: Cebu

Re: PO with condition type not going to the right GL account

Postby Ha Tran » Sun Feb 15, 2015 8:59 pm

Hi,

It is the ''Accrual Key'' field which shall be set as ZTO and FR1 to be assigned to the ''Account Key'' field. Let me know again how it goes.

Cheers,
HT
Ha Tran
 
Posts: 28316
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Re: PO with condition type not going to the right GL account

Postby sapfanatic.com » Mon Feb 16, 2015 3:03 am

Hi Ha Tran, we cannot do that because the postings will become incorrect. If we do that, the posting would be like this:
1 81 0050101101 TRAD SALES - MISC CR 295.01 GBP
2 96 0030101105 A/P:PETRL GR/IR CLRG 245.76- GBP
3 50 0073403000 OTHER PROD TRANS-TRD 49.25- GBP

We are expecting the below to be the correct postings:
1 81 0050101101 TRAD SALES - MISC CR 295.01 GBP
2 96 0030101105 A/P:PETRL GR/IR CLRG 295.01- GBP
3 0073403000 OTHER PROD TRANS-TRD 49.25- GBP
4 0030101100 A/P:GR/IR CLEARING 49.25 GBP

By the way, the account of FR1 is 0030101100.
sapfanatic.com
 
Posts: 473
Joined: Mon Oct 09, 2006 6:09 pm
Location: Cebu

Re: PO with condition type not going to the right GL account

Postby Ha Tran » Mon Feb 16, 2015 8:31 pm

Hi,

What is the account that you have assigned to your ZTO transaction/event key in OBYC?

Cheers,
HT
Ha Tran
 
Posts: 28316
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Re: PO with condition type not going to the right GL account

Postby sapfanatic.com » Mon Feb 16, 2015 10:03 pm

Sorry for the confusion Ha Tran. The account assigned to ZTO is 73403000 (that is the one I was referring with 79XXXXXX).
sapfanatic.com
 
Posts: 473
Joined: Mon Oct 09, 2006 6:09 pm
Location: Cebu

Re: PO with condition type not going to the right GL account

Postby Ha Tran » Mon Feb 16, 2015 10:14 pm

Hi,

If this is the case, then the way the system performs below is correct if your pricing condition type is maintained as part of the PO pricing condition -
1 81 0050101101 TRAD SALES - MISC CR 295.01 GBP
2 96 0030101105 A/P:PETRL GR/IR CLRG 245.76- GBP
3 50 0073403000 OTHER PROD TRANS-TRD 49.25- GBP

In this particular case, the account 73403000 (which is assigned to ZTO transaction/event key) will be considered as GR/IR freight clearing account.

If you are referring to the attached posting lines as the required rule, then you have to maintain your freight condition as a separate PO line item -
1 81 0050101101 TRAD SALES - MISC CR 295.01 GBP
2 96 0030101105 A/P:PETRL GR/IR CLRG 295.01- GBP
3 0073403000 OTHER PROD TRANS-TRD 49.25- GBP
4 0030101100 A/P:GR/IR CLEARING 49.25 GBP

It is, however, in this particular case that the account 73403000 will be considered as the P&L account which shall be assigned to the transaction/event key GBB/xxx where xxx will be defaulted to the related account assignment category via OME9 transaction and used in the PO freight-related line item.

Cheers,
HT
Ha Tran
 
Posts: 28316
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Re: PO with condition type not going to the right GL account

Postby sapfanatic.com » Tue Feb 17, 2015 2:38 am

Thanks Ha Tran, we have also thought of that as another solution which is to create a separate line for the freight but does not seem to be a good solution because the PO might get messed up especially if there will be multiple line items. Also the Purchase order and GR are automatically created that's why we want to make use of the condition type in the PO line item.

It is a bit weird that when you put account assignment in the line item then it will be applied to all even if you have condition type that is setup to be posted in a different GL account.
sapfanatic.com
 
Posts: 473
Joined: Mon Oct 09, 2006 6:09 pm
Location: Cebu

Re: PO with condition type not going to the right GL account

Postby Ha Tran » Tue Feb 17, 2015 8:59 pm

Hi,

Unfortunately, this is the way SAP has so far designed its system and there have been many similar business requirements being raised in this forum (and others) as far as I am concerned. However, to my best knowledge, SAP is not ready to make any technical change in the near future to attend this requirement.

Cheers,
HT
Ha Tran
 
Posts: 28316
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia


Return to Logistics MM

Who is online

Users browsing this forum: No registered users and 7 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.