Sitemap

Amicuk Programming Answers

Collection of Fully Paid Invoices from AR to Incentive Compensation

-0001-11-30   Views:0

Advertisement

Hello. We have a requirement to calculate commission on fully paid invoices only. In Compensation we are able to collect invoices but there is no restriction on submitting an invoice to calculation when it is not fully paid. For example: I have an AR

Hello.
We have a requirement to calculate commission on fully paid invoices only. In Compensation we are able to collect invoices but there is no restriction on submitting an invoice to calculation when it is not fully paid.
For example: I have an AR invoice for $1000 entered on 15-Mar-2003. A receipt is entered on 20-Mar-2003 for $600 against this invoice. On 31-Mar-2003 I collect this invoice and submit it for calculation. The system will not check whether this invoice is partially or fully paid before Calculation. It will calculate commission on the invoice anyway.
Is there a way through Mapping Actions Filters, User Code Block, Formulas, or any other means
that we can achieve this?
Can anyone help?
Regards,
Karim

The replay answer
Advertisement
Hi Raj,
You can get details of open item on customer from table - BSID, cleared item from - BSAD etc. For your BI reporting purpose you may use standard FI queries provided by SAP if possible. SQ01 will give you the details of standard queries.
I suggest you to post messages on FI related in ERP-Financials for getting a prompt reply as this area belongs to Treasury Applications.
Regards
Prasad AV

Go to See the other 2 answers

Collection of Fully Paid Invoices from AR to Incentive Compensation

Category:DefaultRelease time:-0001-11-30Views:130

Hello. We have a requirement to calculate commission on fully paid invoices only. In Compensation we are able to collect invoices but there is no restriction on submitting an invoice to calculation when it is not fully paid. For example: I have an AR[More]

Fully Paid invoice is  appearing in "Accounts payable  trial balance"

Category:DefaultRelease time:2015-10-11Views:130

Hi all, i have proble with AP trial balance report.. there is one invoice which is fully paid and accounted. but still that invoice is appearing in trial balance report. invoice amount is 0000000 rmaing amount is (9856568) note: negatinve amoun.. any[More]

Fully paid invoice without residual item

Category:DefaultRelease time:-0001-11-30Views:130

Hi,   I'm new to FI area, so I have some basic questions. 1. How should I view an invoice? What is the transaction? 2. How to check whether the invoice is fully paid or not? 3. I have check whether an invoice is fully paid without any residual item.[More]

Migrating Not fully paid  and Onhold invoices

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, we are reimplementing R12 from 11i and the requirement like need to migrate the "NOT FULLY PAID INVOICES" and "INVOICES ON HOLD". Can any one suggest me the process to do it. Please provide me the process or any PL/SQL packages[More]

Invoice 29869 is appearing in the aging report though it been fully paid up

Category:DefaultRelease time:2015-10-11Views:130

hi , I have problem that posting below Invoice 29869 is appearing in the aging report though it been fully paid up can any one tell me what is the reason Regards Srinivas Edited by: Darius Heydarian on May 9, 2008 2:33 PMPlease check if you are runni[More]

Downpayment is not clearing even after invoice has been fully paid

Category:DefaultRelease time:2015-10-11Views:130

Good day to everyone, I am currently having an issue with a down payment not clearing even though the invoice has been fully paid. to my understanding, once the order is fully invoiced- down payments should be cleared as well, am i correct? The order[More]

Part Paid Invoice Missing From Payment Wizard / Outgoing Payments

Category:DefaultRelease time:2015-10-11Views:130

Hi, Having a bit of an issue with a purchase invoice on SAP B1. In brief: The invoice was posted fine, then they paid 3 invoices but the total was short. The user allocated payment manually using outgoing payments to the 3 invoices, but partially pai[More]

Check register for partially paid invoices

Category:DefaultRelease time:-0001-11-30Views:130

Dear SAP gurus, I have paid a vendor for 4 invoices fully and 1 invoice partly. In check register, the system is showing payment value correctly but when i goto accompanying document tab, it gives the list of invoices which are settled fully. It does[More]

Pulling open invoices, and paid invoices with details (Query Help).

Category:DefaultRelease time:2015-10-11Views:130

Hello All, I am sure I messed something up in my joins. I am looking to pull a report of all invoices OINV for a month, then list details of any payment (if it is paid) next to it from RCT2. It is giving me a list of all of the paid invoices, but eve[More]

I have a fully paid subscription to CC and use of installed programs but I can no longer sign in to CC. It repeatedly says "You've been signed out". I have the need to install another program but I can't sign in.

Category:DefaultRelease time:2015-10-11Views:130

I have a fully paid subscription to CC and use of installed programs but I can no longer sign in to CC. It repeatedly says "You've been signed out". I have the need to install another program but I can't sign in.Sign Out When Sign In http://foru[More]

Match partial paid invoice with customer payment

Category:DefaultRelease time:2015-10-11Views:130

Hi all, My company FI user told me that those partially paid invoice will still shown full amount in the FBL5N report and also Statement of Account (F.27). Besides that, the customer payment that used to knock off the partially paid invoice also will[More]

Hot
Hi, I am a newbie to photography, but really interested in getting into it.  I thought the SX50HS would be a nice bridge into the hobby, but so far, I am not impressed!  I've ahd the camera for about two weeks.  I just downloaded the pix I have taken [More]
My Solaris 10 (5/08) box with 3 Seagate 1TB drives hooked to a PCI-X SiI3124 randomly stops responding to ZFS IO for up to a minute, during alternate long (100+MB) file reads and writes. Disabling NCQ may eliminate the problem during reads, but not d [More]
I'm trying to import video frames to layers in Photoshop CC, the most recent edition. I'm using a Mac OS X Maverick version 10.9.2. The video I'm working with is a .mov file with the following codecs: Timecode, Linear PCM, CEA 708, Apple ProRes 422 ( [More]
          Hi!           First goes the abstract: despite all other parameters, the only setting that seems           to make a difference for transaction handling is <isolation-level>. What I really           want to make use of, is <concurrency- [More]
Hello fellows, Is that possible to call a executable program, but in background? It is really important that is in background, because the calls will be through JOBs. I will send a string, and the program return another string. Thanks a lot, Marcos F [More]
When I receive a notification alert from Facebook via the Notification Center it shows 2 buttons; Close and Show. When I click on Show it just vanishes and does not open the Facebook page. Can anyone explain why this is? When I receive notifications [More]
I have this simple JSP, which flushes a String to the browser as a file (message.txt). The JSP gets opened in a new window when the user clicks a link. The problem is that after the JSP has run, the browser window won't close automatically. I've trie [More]
hi i have a gif files in jar file, this jar is in the same order of the .Class files i try to load the gif file, but the URL is ALWAYS null. what do i do wrong? thx the code Snippet : the location = "open.gif" // this is the gif name public Imag [More]
why can't i back my I phone to my computer?This should help http://www.techspot.com/downloads/5916-android-file-transfer-for-mac.htmlRead other 2 answers [More]
I'll like to create a flash of light from outside a window in a scary scene when the lightning and thunder rolls. Does anyone know how to do this in motion? I have motion 3 thankst&t2007 wrote: I'll like to create a flash of light from outside a wind [More]