[Home] [Help]
372: Description:Service Tax accounting not happening for PO matched invoice having multiple distributions
373: Fix:Modified the cursor get_match_item_cur as the po_distribution_id would be null in ap_invoice_lines_all for a PO line having multiple distributions.
374:
375: 21. 18-Feb-2013 amandali for bug 16241506.
376: issue: STandard line accounting is not happening for a cancelled invoice when the accounting
377: is run after cancellation only.
378: fix:commented the ld_cancell_date is null and reversal_flag='N'
379:
380: 22. 05-March-2013 amandali for bug 16393213
381: Issue:Accounting entries not generated for cancelled lines for a PO/Receipt matched invoices
382: Fix: Added parent_Reversal_id condition to invoice_distribution_id in cursor get_match_item_cur
383: and also added parent the same condition in cursor get_matched_tax_cur
384: 24. 07-mar-2013 vkaranam for bug#16314805
385: Issue: accounting for a -ve line in a Standard invoice is wrong.
386: Fix:
387: changes are done in aruid_t1 to pick the correct accounts based on the sign of the distribution amount.
388: Dependency:
389: ----------
551: lv_called_from := 'AP_ACCOUNTING';
552: lv_source_trx_type := 'INVOICE_ACCOUNTING';
553: ld_gl_date := pr_new.accounting_date;
554: else
555: --If the standard line accounting exists then return.
556: return;
557: end if;
558: --end additions for bug#16241506
559: -- comment out by zhiwei.xin on 6-FEB-2012 for bug 13540555 begin
592: OPEN get_invoice_type_cur;
593: FETCH get_invoice_type_cur INTO lv_invoice_type;
594: CLOSE get_invoice_type_cur;
595:
596: IF lv_invoice_type IN ('STANDARD', 'CREDIT', 'DEBIT', 'QUICKDEFAULT', 'QUICKMATCH', 'MIXED') THEN
597: OPEN get_regime_id_cur;
598: FETCH get_regime_id_cur INTO ln_regime_id;
599: CLOSE get_regime_id_cur;
600:
795: lv_account_name := jai_constants.recovery_interim;
796: ELSIF (lv_event= 'ACCOUNTING' and sign(ln_dist_line_amount)=-1 ) then
797: lv_account_name := jai_constants.recovery;
798: elsif (lv_event = 'CANCELLATION' and sign(ln_dist_line_amount)=-1) then --'CANCELLATION'
799: IF lv_invoice_type = 'STANDARD' THEN
800: /*commented for bug#13934819
801: OPEN check_same_period_cur;
802: FETCH check_same_period_cur INTO lv_same_period_flag;
803: CLOSE check_same_period_cur;
856: );
857: end if;--Added by zhiwei for open interface POT change bug#13023443 on 20110930
858: END IF;/*tax_type is null*/
859: END IF;/*ld_transaction_date >= ld_accrual_date*/
860: END IF;/* lv_invoice_type IN ('STANDARD', 'CREDIT',....)*/
861: END IF; /*pr_new.line_type_lookup_code = 'MISCELLANEOUS' AND ln_dist_line_amount > 0 */
862: ---------------------------------------------------------------------------
863: --Add by Wenqiong for POT, reg bug#12397015 on 26-Apr-2011, end
864: End if; /* updating */