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
I was recently on a website in safari on my iPad, I minimised the safari and went back on it a while later, now it's gone onto something called iPad theme? Every time I click off to turn it off, it does nothing Anyone know what to do as it has made t [More]
problem with "select into" in db function in 10.2 There are two schemas. 'mdbdev' is the master database and 'devusr' is granted SELECT table access to execute queries in mdbdev schema. with devusr, in SQL, I'm able to execute the following quer [More]
sorry if this a repeat question, but i'm stumped. i've set up a number of sites previously, and never had a problem using the ftp with dw. my typical setup has been ftp host: ftp.mysite.com host directory: public_html/ username password never a probl [More]
Hi Guys, I need some help in understanding the issue here, Please find the issue below. Please enter the Y7 block at the sales area level for 60& 62 sales area. Thanks. MMHi, Use VD05 and block for sales areas 60&62 at sales area leavel using bloc [More]
Dear All,                    I have to find the total of a Quantity value based on the Item code.How to achieve that in Crystal report. Scenario: Itemcode   orderno     Qty A               1             100 A               2               20 A        [More]
I am getting an error 131:4 in CS5. This happened several times in last 7-8 days and everytime I reinstalled software and it start to work for a day or two. Need to solve this issue permanently. Plz help.http://helpx.adobe.com/x-productkb/policy-pric [More]
Hi all, I'm using an SQL calendar which displays times and names when an insert is done. How can I add holidays to my calendar? Thanks, CleoHello Cleo, >> In the calendar, I'm only displaying the time, how can I display the name of the event - In pr [More]
adobe reader for symbian 60 is nearly useless because it requires reader to scroll left and right. There are serveral earlier posts on the tag issue, but adobe does not seem to do anyting about it. However, adobe reader for PocketPC has the auto tag [More]
Hello all, I am writing regarding a recent weird event that happened on a Solaris 10 with 7 local zones on it that I have no idea what happened. Maybe some of you experienced this kind of event before. Trying to login trough ssh to the server, after [More]
out of the past 5 times ive started up my computer, twice it hasn't gone to the picture of an apple, but to a picture of a harddrive, and then I have to click the little icon under it, and then it will go to the apple. this has never happened to me b [More]