Hello,
We had an issue where the Discount on an Invoice was not being calculated properly.
For example, we had two lines - first line was a regular Item (Discountable) and the second line was Freight (not discountable).
Oracle was for some reason reducing the Freight amount from the Item instead of the Invoice Total, thus returning a reduced discount.
I wrote this query to find out all the lines where the "Discountable amount" was not equal to the Item total.
select i.invoice_id, i.invoice_num, i.invoice_date, i.invoice_amount,i.amount_paid,i.amount_applicable_to_discount,
il.item_total, il.other_total, t.name, i.source,i.creation_date--, trunc(sysdate) -700--, i.discount_amount_taken
from ap_invoices_all i, ( select * from
(
select
case
when upper(line_type_lookup_code)= 'ITEM' then 'Item'
else 'Other'
end line_type,
invoice_id,
amount
from ap_invoice_lines_all
where 1=1
) t
pivot
(
sum(amount)
for (line_type )
in ( 'Item' as Item_total,
'Other' as Other_total
)
)
) il, -- group by line_type_lookup_code
ap_terms_tl t
where 1=1
and i.invoice_id = il.invoice_id
and i.exclude_freight_from_discount = 'Y'
and i.disc_is_inv_less_tax_flag = 'N'
and trunc(i.creation_date) >= to_date('12/23/2019','mm/dd/yyyy') -- trunc(sysdate) -700
and nvl(i.amount_paid,0) <> 0
and i.amount_applicable_to_discount <> il.item_total
and i.terms_id = t.term_id
and il.other_total > 0
order by i.creation_date
Please feel free to share your code or if you have any suggestions to make it better.
Sabarimala season is about to start and our temple here is having Ayyappa puja every other Saturday. Our
Anyway, I liked going to the temples in Kerala, always felt divine and holy after coming out... though I used to look at girls while praying, that did not take the feeling of godliness. In fact, the girls too looked divine. Most of the girls wore a red pavadai (long skirt) and green top with golden shiny border. They would have a little sandal wood paste in the forehead and below it or over it red bindi - kunkumam. Eyes beautiful with the kajal (kan mashi), small golden ear rings, thick golden necklace on their chest, silver colored padaswaram (anklets)... black oily hair separated from the center... little mulla-poo (jasmine flower) ....their back (above the hips) wet with the water from the hair...a smile in the face... anyways... I miss that in the temples here.
I asked the temple manager why they serve such things as prasadam? He gave me the common answer - 'That's what we get here....' I wonder..... Since they do not get 'ghee' here... will they use cheese instead for the nei (ghee) abhishegam for Ayyappa???
Cheese(nei) abhisegham swamikyu,
kalpura deepam swamikyu....
do they get camphor here??? Is it not banned???