Advertisement
abirama62

fix data journal_pos

Apr 19th, 2021
1,308
0
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.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement