My Oracle Support Banner

GST: Tax Invoice Number is incorrectly updated in JAI_TAX_LINES for Delivery Challan post ship confirm (Doc ID 2667264.1)

Last updated on MAY 07, 2020

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Actual Behavior:
================

GST Document Number generated post ship confirm in case of Delivery challan flag , is getting updated in Acknowledgement Number field of JAI_TAX_LINES
which is expected.

But the same Number is getting copied to TAX INVOICE NUMBER field of JAI_TAX_LINES for the Sales order lines and the same is not copied at shipment level.

Expected Behavior:-
====================
If the TAX INVOICE NUMBER field in JAI_TAX_LINES table should be update with ACKNOWLEDGMENT NUMBER, then the same should be updated at shipment level,
rather than at sales order level.

Due to this, users are having below 2 issues:

Issue 1:-

======
1. On Sales order - India tax details form, GST Document number is not populated, Tax invoice number is populated with Acknowledgement number of Delivery
Challan.

2. On shipment - India tax details form, it is vice versa.Both should be consistent if data is populated in both forms.

Issue 2:-
=========
Even with this approach, the tax invoice number is populating to only one tax line, and not all the lines are getting updated at sales order india tax details form. 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.