Bugzilla – Attachment 1865 Details for
Bug 6330
DEBIT AND CREDIT DO NOT MATCH IN STOCK RECEIPT ENTRY
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
SS_0868_DS_Against call id - 6330
SS_0868_DS_Against call id - 6330.sql (text/plain), 613 bytes, created by
Sharad
on 2021-04-16 12:26:14 IST
(
hide
)
Description:
SS_0868_DS_Against call id - 6330
Filename:
MIME Type:
Creator:
Sharad
Created:
2021-04-16 12:26:14 IST
Size:
613 bytes
patch
obsolete
>UPDATE XFR_EXCISE_INVOICE_ITEMS SET IGST_RATE = TAX_RATE, IGST_AMOUNT = TAX_AMOUNT >WHERE XFR_COMPANY = '64' >AND INVOICE_TYPE = 'I1' >AND INVOICE_SERIES = 'TI21' >AND INVOICE_NO IN (182 , 183 , 184 ) >AND ENTRY_NO IN (21164, 21165, 21168 ) >AND NVL(IGST_RATE,0) = 0; > >/* >-- Script for checking purpose -- > >SELECT * FROM XFR_EXCISE_INVOICE_ITEMS >WHERE XFR_COMPANY = '64' >AND INVOICE_TYPE = 'I1' >AND INVOICE_SERIES = 'TI21' >AND INVOICE_NO IN (182 , 183 , 184 ) >AND ENTRY_NO IN (21164, 21165, 21168 ) >AND NVL(IGST_RATE,0) = 0 >ORDER BY INVOICE_DATE, INVOICE_NO; > >*/
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=1865">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 6330
:
1863
| 1865