Bugzilla – Attachment 1889 Details for
Bug 6380
GL POSTING DIFFERENCE
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
SS_0878_IMIS_Against call id - 6380_A
SS_0878_IMIS_Against call id - 6380_A.sql (text/plain), 931 bytes, created by
Sharad
on 2021-04-30 14:03:57 IST
(
hide
)
Description:
SS_0878_IMIS_Against call id - 6380_A
Filename:
MIME Type:
Creator:
Sharad
Created:
2021-04-30 14:03:57 IST
Size:
931 bytes
patch
obsolete
>DELETE FROM GL_POSTING_DETAILS >WHERE COMPANY = '73' >AND VOUCHER_TYPE = 'I1' >AND VOUCHER_SERIES = 'TI20' >and VOUCHER_NUMBER = 8985 >AND GL_POSTING_SEQ_NUMBER IN (92, 96); > >UPDATE GL_POSTING_DETAILS SET AMOUNT = -26701.5 >WHERE COMPANY = '73' >AND VOUCHER_TYPE = 'I1' >AND VOUCHER_SERIES = 'TI20' >and VOUCHER_NUMBER = 8985 >AND GL_POSTING_SEQ_NUMBER IN (90); > >/* >-- Script for checking purpose -- > >SELECT * FROM RM_PM_SALES >WHERE COMPANY = '73' >AND RP_TYPE = 'I1' >AND RP_SERIES = 'TI20' >and RP_NO = 8985; > >SELECT * FROM GL_POSTING_DETAILS >WHERE COMPANY = '73' >AND VOUCHER_TYPE = 'I1' >AND VOUCHER_SERIES = 'TI20' >and VOUCHER_NUMBER = 8985 >AND GL_POSTING_SEQ_NUMBER NOT IN (92, 96); > >UPDATE GL_POSTING_DETAILS SET AMOUNT = -26701.5 >WHERE COMPANY = '73' >AND VOUCHER_TYPE = 'I1' >AND VOUCHER_SERIES = 'TI20' >and VOUCHER_NUMBER = 8985 >AND GL_POSTING_SEQ_NUMBER IN (90); >*/
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=1889">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 6380
:
1882
|
1886
| 1889