abirama62

fix data journal_pos

Apr 19th, 2021
780
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Reprocess Submit POS, for POS with Termin Payment (Piutang)
  2.  
  3. -- cek process_message
  4. SELECT A.*
  5.     FROM t_process_message A
  6.     WHERE A.tenant_id = 10 AND
  7.         A.process_name = 'i_ho_process_pos_shop' AND
  8.         A.process_no = '280221041310400002'
  9.        
  10. -- execute func reprocess
  11. BEGIN;
  12.     SELECT i_ho_process_pos_shop_temp_for_fix(10, 'reprocess_pos_20210420', '280221041310400002');
  13. -- ROLLBACK;
  14. -- END;
  15.  
  16. -- cek header journal
  17. SELECT * FROM gl_journal_trx WHERE doc_no = '280221041310400002';
  18.  
  19. -- cek detail item journal
  20. SELECT B.doc_no, A.*
  21. FROM vw_gl_journal_trx_details A
  22. INNER JOIN gl_journal_trx B ON A.journal_trx_id = B.journal_trx_id
  23. WHERE B.doc_no = '280221041310400002';
  24.  
  25. -------------------------------------------------------------------------------------------------------
  26. --Document list (total 31 records):
  27. /*
  28. docNo / process No      docDate     ou_id
  29. "280221041310400002"    "20210413"  33
  30. "280221041311150006"    "20210413"  33
  31. "280221041315160016"    "20210413"  33
  32. "280821041309220002"    "20210413"  15
  33. "280821041309370003"    "20210413"  15
  34. "280821041309440004"    "20210413"  15
  35. "280821041309530005"    "20210413"  15
  36. "280821041310070008"    "20210413"  15
  37. "280821041311150012"    "20210413"  15
  38. "280821041312190020"    "20210413"  15
  39. "280821041313140021"    "20210413"  15
  40. "280821041313520025"    "20210413"  15
  41. "280821041314150026"    "20210413"  15
  42. "280821041314190027"    "20210413"  15
  43. "280821041314300029"    "20210413"  15
  44. "280521041411040001"    "20210414"  39
  45. "280521041411100002"    "20210414"  39
  46. "280521041411120003"    "20210414"  39
  47. "280521041411150004"    "20210414"  39
  48. "280821041410020002"    "20210414"  15
  49. "280821041410430007"    "20210414"  15
  50. "280821041411000011"    "20210414"  15
  51. "280821041414080023"    "20210414"  15
  52. "280821041414090024"    "20210414"  15
  53. "280821041415050028"    "20210414"  15
  54. "280821041415270030"    "20210414"  15
  55. "283421041416310007"    "20210414"  28
  56. "280221041510510003"    "20210415"  33
  57. "280821041509070008"    "20210415"  15
  58. "280821041510170012"    "20210415"  15
  59. "283421041509470002"    "20210415"  28
  60. */
  61.  
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×