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 think I have two apple IDs. One I created many years ago with an IPod, but I don't know what that one is now. It has most of my music attached to it. Now I have one with my email that doesn't have all that music and I can't get the music to attach [More]
Dear all, I want to display a Pie-Chart during my query execution dynamically. I am working only in query designer not in WAD. For example :  I have created a query in query designer based on Zonewise Sales Value. And i have designed the chart also b [More]
Hello, We are using Oracle 10.1.2 B2B Integration to test outbound XML messaging over HTTP 1.1. We get the following error when we try a outbound flow. Message Transmission Transport Exception Transport Error Code is OTA-HTTP-SEND-1005 Stack trace == [More]
Hi, I have problem regarding how to create a list of IP addresses given starting and ending IP address. E.g. IF I have starting IP address as 172.20.59.58 and ending IP address as 172.22.56.44, I want to find all the possible IP addresses within this [More]
Hi, Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production i have one stored pr [More]
Hello Friends,   I have a requirement that if the password is expired in LDAP, portal login should give change password screen instead of generic error message. Is there any way to do this other than implementing a custom login module. Has anyone tri [More]
I want to use the new file vault so homefolder files are encrypted in my time machine backup. When I was prompted in System Preferences, I chose to "turn off legacy file vault." After the passwords, etc., the system works for a while and has jus [More]
Hi all!. i just paid my biill the other day, toatalling £52 for the month and thought that i was paying way too much so i decided to analyse my bill. I have been with BT for 10+ years and was getting charged nearly £30 per month for BT Broadband Unli [More]
Am asking about Links/URLs  in the 'Bookmarks' section on the left side (the caps title 'Bookmarks' below the Collections section and NOT anything IN the Collections section) . I have several  hundred and can't take the time to delete each one.Thanks [More]
Hello! I was wondering if it was possible on Soundtrack Pro to remove continuous background "noise" from a recorded interview? An example would be someone clicking a pen or a tapping his foot during the duration of the interview. Any advice woul [More]