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
Adobe Premiere Elements 12.1 Update Installation failed. Error Code: U44M1P7 Adobe Photoshop Elements 12.1 Update Installation failed. Error Code: U44M1P7 Failed updates everyone on an iMac 27" running Mavericks- what can i do to get the latest updat [More]
Hello! I just purchased a new Windows 8 laptop on which I want to load my existing copy of CS6 (I have the CD). I deactivated it on my old computer and tried to load it on my new one.  I'm receiving the following error message: This serial number is [More]
I have Pages '09, and looked on Apple's tutorials for how to export as an ePub file... It says just click share, export, ePub, but I do not have an ePub option. My only options are PDF, Word, RTF, and Plain Text. Am I missing something very obvious?I [More]
Many times I tried to update the apps but after typing of password onwards window is going into silent mode since the time of purchase my id is one and the same but previously it is from usa sotre and recently from Indian storeHave you tried logging [More]
hi, when i try translations in SE63, give source and target, i get a status message 'INVALID CODE PAGE FOR LANGUAGE &' what is this ?If you got the solution to your problem related to translation messages which was giving an error saying 'Invalid Cod [More]
I use this built-in in C.S. and it works just fine, but when I published my reports under web I got the next error: " invalid report id" also I typed the name of reports server in form's properties of the report. Any recommendations? Forms 6i pa [More]
hi OAS4 does a great job of providing WebForms and i've found all sorts of documentation about these forms being state-based but how is it possible to determine the username of the user accessing a particular form (from within the form)? And, what ot [More]
Hi all, Every night during the incremental db backups (and during the weekly full db backup) i get an alert for the "Agent resident memory utilization" level. I did find this similiar post but it didnt' help me out much (Agent memory utilization [More]
Hello, How can I insert the Registered TradeMark and the Copyright Characters in the database ? Using SQL*Loader I am trying to load a flat file into a table having CLOB column. But in place of these chars a ? gets into the database. Regards, Swati.< [More]
Hi all I am trying to create bookmark that opens another document's 1st page?. This can be done by usking link option. But I am trying to do with bookmark! Is there any possible ways? I am using CS5. Thanks in advance Regards arulI´m afraid not... yo [More]