Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
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. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today. _.____.__ |