Current position:  Home > Default > Calculation Of invoice amount

Calculation Of invoice amount

Time:October 11
Advertisement
I got Invoice_Amount two ways By Joining Some tables
First way
Tables:
wsh_delivery_details
wsh_delivery_assignments
wsh_new_deliveries
The Query :
select max(wnd.STATUS_CODE) Status, wnd. DELIVERY_ID INV_NO,
Max(wdd.DATE_SCHEDULED) Inv_Date, Max(wdd.CUSTOMER_ID) CUSTOMER_ID, sum(nvl(wdd.SHIPPED_QUANTITY,0) * nvl(wdd.UNIT_PRICE,0)) Inv_Amt
from wsh_delivery_details wdd, wsh_new_deliveries wnd ,wsh_delivery_assignments wda
where wdd.DELIVERY_DETAIL_ID= wda.DELIVERY_DETAIL_ID
and wda.DELIVERY_ID=wnd.DELIVERY_ID
group by wnd. DELIVERY_ID
Second way
Tables:
ra_customer_trx_lines_all
ra_customer_trx_all ct
Query:
select max(cl.CUSTOMER_TRX_ID) Cust_trx_no ,max(ct.TRX_NUMBER) ct_trx
,cl.INTERFACE_LINE_ATTRIBUTE3 INV_No,max(cl.CREATION_DATE) Inv_date,
sum(cl.QUANTITY_INVOICED* cl.UNIT_SELLING_PRICE) inv_amt ,
Max(cl.SALES_ORDER) Ord_No ,Max(cl.SALES_ORDER_DATE) Order_date ,max(ct.TRX_DATE)
ct_TRX_DATE,Max(ct.SOLD_TO_CUSTOMER_ID) ct_SLDtoCust
from ra_customer_trx_lines_all cl,ra_customer_trx_all ct
where cl.CUSTOMER_TRX_ID=ct.CUSTOMER_TRX_ID
group by cl.INTERFACE_LINE_ATTRIBUTE3
Note:cl.INTERFACE_LINE_ATTRIBUTE3 is INV number.
But invoice Amounts are different. Why it is so? Shall i apply any more
conditions? Why same Data(ie selling price and Quantity) storing in two tables(ra_customer_trx_lines_all,wsh_delivery_details)?
Advertisement
Hi Mike,
U r using transaction types to generate your distributions, right?
Try to insert distribution info for each of your invoices in the table ra_interface_distributions_all, specifying REC, REV and TAX (tax where applicable) lines.
Hope this will solve your prob.
Vik

Calculation of partial amount

2015-10-11

My problem is How the total amount of the invoice can be found and partial amout...and how to calucalte it it is stated that enter will be there in BSEG-REBSG..but hwen i goto that table the DMBTR value is filled... can anyone explain below part... F

Payment batch shows some invoice amount in rounding ....in AP

2015-10-11

For a supplier a check of 1000$ is applied to 10 invoices containing standard and credit memo type. But the total amount for all the 10 invoices were 1400 including the standard invoice amount minus the credit memo amount. 400 were in the rounding li

Rate - How to get the total invoice amount?

-0001-11-30

Hi Experts, I need assign the 'total invoice amount' to an operand then do some discount calculation. The question is how I could get it. I tried COMPUT99, but it doesn't get anything. Thank you,Hi - Why don't you use DISC*  ( discount ) variant prog

GST calculation and Invoice History Instance

-0001-11-30

Hi experts, I really need your help here. My decimal places settings: amount 2 price 5 rates 6 quantities 0 percent 2 units 2 My 1st question: How SAP calculates the GST 7%? I worked out this formula by seeing from SAP results: Exc. Rate 1.408000 Lin

Report for Differences in Invoice Amount and PO Amount

2015-10-11

Hello, Is there any standard report available in SAP to compare the differences in PO Amount andd Actual Invoiced Amount against that PO? Regards, Rohit GargHello, Try report MC$4 - Vendor Analisis: Purchasing Values. I personally find it very useful

A/R extractor - Material and Invoice Amount

2015-10-11

Hi Gurus, I just wanted to extract Material and Invoice amounts for Accounts Receivables from R/3 to BW? Is there any standard extractor for the same. I found 0FI_AR_4 but it doesnt have material field. How can I link the BSID table with material. Is

Date wise invoice amount

2015-10-11

Dear all, I am in need of a report which will tell me what is the vendor invoice value posted for any particular date. I checked in MC$4 report where the invoice amount is shown cumulated for a particular month. - can i have a date wise details for a

Difference between Invoice amount and invoice amount on psting date

2015-10-11

Hi Gurus, I had run MC$G report which dispalys Vendor/Order Qty/PO value/Gr quantity/GR value/Invoice quantity/Invoice amount (Posting date) / Invoice amount In this issue is Invoice amount Posting date and Invoice amount fields were not showing same

Payment Amount is greater than invoice amount in sales order

2015-10-11

Hi experts: I have a Sales order that contained originally  3 lines of which the first 2 lines was delivered totally and the third was delivered partially. The client decided to change the remaining quantity for another reference so the procedure in

Reverse calculation of tax amount

2015-10-11

Hi Experts, Is it possible to calculate tax on reverse mode? I will enter the total invoice amount, the system will calculate the unit price  and  tax amount. How will it possible? Regards, Sanju M Sclosed...!Read other 2 answers

Payment amount is greater than invoice amount error

2015-10-11

Payment amount is greater than invoice amount error when doing incoming payment regards kavitha SHi Kavitha, please check in the OINV table the balance due on the invoice. This amount has to match the payment. If the problem is due to different decim

Duplicate Invoice Check Not Checking the Gross Invoice Amount-

2015-10-11

Gurus, When checking for duplicate invoices in MIRO/FB60, I have made all the config and setup but still the system is not checking the gross Invoice amount field. Lets say I enter Invoice 1 :                  Vendor                 X                

Need to display invoice amounts under each aging period (columns  dynamic)

2015-10-11

Hi All i'm developing Aging Report but i'm missing how to get the idea that i show the aging period(period_sequence_number)dynamically & show the invoice amount under its corresponding period As for example Vendor No      Vendor Name      Invoice No

To caliculate invoice amount with Tax amount

2015-10-11

HI, We r here creating purchase register report. user requirement is in purchase register user wants invoice values as invoice value + taxes. we have takne invoice amount form RSEG Table & taxes form BSET table. How can we link RSET to BSET table.we

MIRO invoice amount exceeding the blanket po overall limit

2015-10-11

Hello Gurus, I'm having trouble with invoicing against a blanket purchase order. Can anyone please explain why and when does invoice amount can exceed the blanket po amount.As I understood from the SAP documentation I should not be able to invoice fo

How to know the splitted invoiced amount for the services in a PO?

2015-10-11

Hello SAPients! Scenario: I have a PO with one item, this Item has 3 services attached, this one item of the PO has been invoiced. I need to split the invoiced amount into its corresponding amounts for each of the services. Is there a transaction cod

When reporting "Spend" do you use PO Value, Invoice Amount or Goods Receipt

2015-10-11

When reporting "Spend" do you use PO Value, Invoice Amount or Goods Receipt? I am trying to standardize reporting and would like feedback on what is the norm. The users cannot agree so I need to know what the standard is.PO Value is what is budg

The amount of down payment must be less than the invoice amount

2015-10-11

Hi all, Our customers are using SAP 2007-PL15 and SAP 2007-PL41. When we want to create a down payment for a sales order, and we want to pay the entire amount of the sales order, including tax, we have to put an amount inthe TOTAL field of the Down P

Invoice amount not change according to qty

2015-10-11

Dear Experts, Po qty 10 unit & price is RM1/unit. GR has been done for full qty. Now I'm going to to perform IV via MIRO. Let say I receive invoice for 4 qty. So when I enter PO no in MIRO, system pull all the information from GR that done against th