EAP: Voucher Build Incorrectly Updates the STATE_SHIP_FROM on PS_VOUCHER_LINE for Some India GST Vouchers
(Doc ID 3014064.1)
Last updated on APRIL 07, 2024
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When creating India GST Vouchers through Voucher Build, Voucher Build is updating all Voucher lines' STATE_SHIP_FROM field on PS_VOUCHER_LINE based on the Address associated to the Supplier Location of the first Voucher that Voucher Build processes. As a result, the subsequent Voucher lines’ STATE_SHIP_FROM field may not be updated correctly based on the respective Supplier’s Location.
If the Vouchers are displayed on-line, the correct Ship From State is being displayed on the Voucher > Invoice Information > Goods and Service Tax (GST) Details page for the Vouchers that were created in the same Voucher Build run. However, through SQL, the STATE_SHIP_FROM field on PS_VOUCHER_LINE is incorrect for some Vouchers. As a result, the on-line Voucher data and back end data are out of sync.
STEPS TO REPLICATE
1. Set Up Financials/Supply Chain > Business Unit Related > Payables > Payables BU Definition
2. Payables Definition > Definition page, Business Unit = IND03 / Ship To = IND03
3. Suppliers > Supplier Information > Add/Update > Add/Update Supplier
4. Display Supplier ID = IND0000001
a. Supplier > Address page
b. Address ID = 1
c. State = KA
d. Supplier > Location page
e. Location = MAIN
f. Click Procurement link
g. Procurement Options page
h. Ship From Address = 1
5. Display Supplier ID = IND0000002
a. Supplier > Address page
b. Address ID = 1
c. State = TN
d. Supplier > Location page
e. Location = MAIN
f. Click Procurement link
g. Procurement Options page
h. Ship From Address = 1
6. Items > Define Items and Attributes > Define Item
7. Display SetID = SHR04 / Item ID = INDSER02
a. Current Status Date = 11/08/2002
b. Click the Purchasing Item Attributes link
c. Purchasing Item Attributes page
d. PO Available Date = 11/08/2002
8. Set Up Financials/Supply Chain > Common Definitions > India GST > Tax Determination
9. SetID = SHR04 / Tax Type = GST / Tax Determination Option = Item Category / Transaction Type = Domestic / Tax Rate Code = WB_INTER18
10. Set Up Financials/Supply Chain > Common Definitions > India GST > Trading Partner GST Setup
11. Trading Partner Category = Supplier / Trading Partner ID = IND0000001
12. Trading Partner Category = Supplier / Trading Partner ID = IND0000002
13. Accounts Payable > Vouchers > Add/Update > Quick Invoice Entry
14. Add 1st Quick Invoice
a. Business Unit = IND01
b. Voucher = INDSHIP1
c. Supplier ID = IND0000001
d. Item ID = INDSER02
15. Add 2nd Quick Invoice
a. Business Unit = IND01
b. Voucher = INDSHIP2
c. Supplier ID = IND0000002
d. Item ID = INDSER02
16. Accounts Payable > Batch Processes > Vouchers > Voucher Build
17. Run Voucher Build
a. Process Option = Business Unit
b. Voucher Sources = New Voucher Data
c. Business Unit = IND01
d. Interfaces = Quick Invoice
18. Accounts Payable > Vouchers > Add/Update > Regular Entry > Find an Existing Value
19. Display Business Unit = IND01 / Voucher ID = INDSHIP2
a. Voucher > Invoice Information page
b. Click Goods and Service Tax (GST) link
c. Goods and Service Tax (GST) Details page
d. Ship From State = TN, which is the correct State of the Address
20. Through SQL, on PS_VOUCHER_LINE for VOUCHER_ID = INDSHIP2, STATE_SHIP_FROM = TN, which is correct since it matches the Ship From State in Step 19d
21. Display Business Unit = IND01 / Voucher ID = INDSHIP1
a. Voucher > Invoice Information page
b. Click Goods and Service Tax (GST) link
c. Goods and Service Tax (GST) Details page
d. Ship From State = KA, which is the correct State of the Address
22. Through SQL, on PS_VOUCHER_LINE for VOUCHER_ID = INDSHIP1, STATE_SHIP_FROM = TN, which is incorrect since it does not match the Ship From State in Step 21d. The value should be KA.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |