We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-acct] Report Painter - Cost Element Report Amounts Are to Separated According to Vendor Account Group

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from LCC352 on Sep 20 at 9:34 AM
Hi, Waza!

I don't believe that would make any difference. The lines with the charges to cost centers on cost elements are on the opposite side of the transaction from the vendor info. The vendor is the offsetting account to one or more cost center/cost element entries. It's the one thing I've found with SAP that drives me crazy. To get dollars charged to a cost center by vendor has never been easy. If there were more than one cost center or cost element, the Painter would separate them by cost center/cost element.

There are logical databases that solve this issue for "pure" documents, i.e. KR type documents where the offsetting account on the document is the vendor. It's GSEG and it's in the SDF and DDF logical databases and is meant to give "the other side" of the transaction. It fails, however, if there is more than one offsetting account in the document - it just picks the first one.

However, the requirement is to use Painter, not Query. Although you could probably "introduce" Painter to a library based on the FI side (or design one for that matter) you would still be left with the issue of trying to get both sides the transaction at once. That's why I picked the document type, because it approaches figuring out what's due to a vendor and what's not, which is what I think the original requirement really was.

I've had much better luck doing this type of requirement as a Query rather than a Painter, using one of the logical databases that has the opposite side of the transaction effect.

- Lou

---------------Original Message---------------
From: shamilapather
Sent: Wednesday, September 19, 2012 10:16 AM
Subject: Report Painter - Cost Element Report Amounts Are to Separated According to Vendor Account Group

Good day
I require some assistance please. I am required to create a report using Report painter.
Using cost elements i must show two columns that would identify supplier amounts and non-supplier amounts.
I am using Library 1vk but i cannot find one which would identify the vendor number as the vendor groups for supplier and non-supplier amounts are the only distinguishing factors.

Your assistance in this matter would be greatly appreciated

Kind Regards
Shamila

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2012 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
LCC352  

President
17 achievements
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Become a blogger at Toolbox.com and share your expertise with the community. Start today.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language