POS (Point Of Sales) - Revision history

Asp-agus: /* 2. SO tidak terbentuk */

2022-08-12T02:30:11Z

‎2. SO tidak terbentuk

Asp-agus: /* 2. SO tidak terbentuk */

2022-08-12T02:28:43Z

‎2. SO tidak terbentuk

Asp-agus: /* Troubleshooting */

2022-08-12T02:26:34Z

‎Troubleshooting

Asp-agus: /* Troubleshooting */

2022-08-12T02:25:07Z

‎Troubleshooting

Asp-agus: /* Promo Reguler */

2022-01-18T05:57:40Z

‎Promo Reguler

Asp-agus: /* Promo Reguler */

2022-01-18T05:38:05Z

‎Promo Reguler

Asp-agus: /* 2. Struk dari local double di server */

2022-01-18T05:31:48Z

‎2. Struk dari local double di server

Asp-agus: /* 2. Struk dari local double di server */

2022-01-18T05:31:02Z

‎2. Struk dari local double di server

Asp-agus: /* Sales Order Tidak Balance */

2022-01-18T05:30:00Z

‎Sales Order Tidak Balance

Asp-agus: /* 1. Struk dari Local tidak Masuk Ke Server */

2022-01-18T05:28:28Z

‎1. Struk dari Local tidak Masuk Ke Server

@@ Line 31: / Line 31: @@
 Cek di menu [https://pos.idolmart.co.id/#ad_table.html?fm=3b05a9b3-b0bb-4075-9e7d-8bfd5d54b52e Fail Bill], Delete Struk yg Double
-=== 2. SO tidak terbentuk ===
+=== 3. SO tidak terbentuk ===
 . cek document so di table pos_dsalessum dan pos_dsalesorder
 . jika document so tidak ditemukan di pos_dsalesorder
@@ Line 38: / Line 38: @@
 . jika tidak ada di pos_dsalesorder, cek data struk di table pos_dsalesbilltoday, jika tidak ada pindahkan sementara data dari table pos_dsalesbill ke pos_dsalesbilltoday
     query : select * from pos_dsalesorder where documentno like 'BOS88-CASH-2022-08-06';
-select * from pos_dsalessum where documentno like 'BOS88-CASH-2022-08-06';
+           select * from pos_dsalessum where documentno like 'BOS88-CASH-2022-08-06';
-INSERT INTO public.pos_dbilltoday
+          INSERT INTO public.pos_dbilltoday
-(isactived, insertdate, insertby, postby, postdate, ad_org_id, billno, billamount, paymentmethodname, membercard, cardno, approvecode, edcno, serialno, billstatus, paycashgiven, pos_mbank_key, pos_dcashierbalance_key, paygiven, printcount, bankname, pos_medc_key, billcode, point)
+          (isactived, insertdate, insertby, postby, postdate, ad_org_id, billno, billamount, paymentmethodname, membercard, cardno, approvecode, edcno, serialno, billstatus, paycashgiven, pos_mbank_key, pos_dcashierbalance_key,
-SELECT isactived, insertdate, insertby, postby, postdate, ad_org_id, billno, billamount, paymentmethodname, membercard, cardno, approvecode, edcno, serialno, billstatus, paycashgiven, pos_mbank_key, pos_dcashierbalance_key, paygiven, printcount, bankname, pos_medc_key, billcode, point
+           paygiven, printcount, bankname, pos_medc_key, billcode, point)
-FROM public.pos_dbill
+         SELECT isactived, insertdate, insertby, postby, postdate, ad_org_id, billno, billamount, paymentmethodname, membercard, cardno, approvecode, edcno, serialno, billstatus, paycashgiven, pos_mbank_key,
-where billno like 'BOS88-060822S%' and paymentmethodname like 'CASH'
+         pos_dcashierbalance_key, paygiven, printcount, bankname, pos_medc_key, billcode, point
---delete from pos_dbilltoday where billno like 'BOS88-060822S%' and paymentmethodname like 'CASH';
+        FROM public.pos_dbill
-INSERT INTO public.pos_dbilllinetoday
+       where billno like 'BOS88-060822S%' and paymentmethodname like 'CASH'
-(isactived, insertdate, insertby, postby, postdate, billno, seqno, sku, qty, price, discount, amount, ad_org_id, discountname)
+       --delete from pos_dbilltoday where billno like 'BOS88-060822S%' and paymentmethodname like 'CASH';
-SELECT isactived, insertdate, insertby, postby, postdate, billno, seqno, sku, qty, price, discount, amount, ad_org_id, discountname
+      INSERT INTO public.pos_dbilllinetoday
-FROM public.pos_dbillline
+     (isactived, insertdate, insertby, postby, postdate, billno, seqno, sku, qty, price, discount, amount, ad_org_id, discountname)
-where billno in (select billno from pos_dbill where billno like 'BOS88-060822S%' and paymentmethodname like 'CASH');
+     SELECT isactived, insertdate, insertby, postby, postdate, billno, seqno, sku, qty, price, discount, amount, ad_org_id, discountname
---delete from pos_dbilllinetoday
+    --delete from pos_dbilllinetoday
---where billno in (select billno from pos_dbill where billno like 'BOS88-060822S%' and paymentmethodname like 'CASH');
+    --where billno in (select billno from pos_dbill where billno like 'BOS88-060822S%' and paymentmethodname like 'CASH');
+    SELECT public.proc_pos_dsalesorder_manual_insert('D089DFFA729F4A22816BD8838AB0813C','AD05B790FB144FDA9704320962710058','06-Aug-22','ASP');
 = [[:Category:POS-HowTo | How-To]] =

@@ Line 39: / Line 39: @@
     query : select * from pos_dsalesorder where documentno like 'BOS88-CASH-2022-08-06';
 select * from pos_dsalessum where documentno like 'BOS88-CASH-2022-08-06';
 INSERT INTO public.pos_dbilltoday
@@ Line 48: / Line 45: @@
 FROM public.pos_dbill
 where billno like 'BOS88-060822S%' and paymentmethodname like 'CASH'
 --delete from pos_dbilltoday where billno like 'BOS88-060822S%' and paymentmethodname like 'CASH';
 INSERT INTO public.pos_dbilllinetoday
 (isactived, insertdate, insertby, postby, postdate, billno, seqno, sku, qty, price, discount, amount, ad_org_id, discountname)

@@ Line 31: / Line 31: @@
 Cek di menu [https://pos.idolmart.co.id/#ad_table.html?fm=3b05a9b3-b0bb-4075-9e7d-8bfd5d54b52e Fail Bill], Delete Struk yg Double
-=== 2. SO tidak terbentuk
+=== 2. SO tidak terbentuk ===
 . cek document so di table pos_dsalessum dan pos_dsalesorder
 . jika document so tidak ditemukan di pos_dsalesorder

@@ Line 30: / Line 30: @@
 === 2. Struk dari local double di server===
 Cek di menu [https://pos.idolmart.co.id/#ad_table.html?fm=3b05a9b3-b0bb-4075-9e7d-8bfd5d54b52e Fail Bill], Delete Struk yg Double
 = [[:Category:POS-HowTo | How-To]] =

@@ Line 6: / Line 6: @@
 = Fitur POS =
 == [https://pos.idolmart.co.id/#ad_table.html?fm=d244fd83-f816-4d58-9955-a946a074b49d Promo Reguler] ==
 Promo yang tidak bersyarat
 == Promo Tebus Murah==

@@ Line 26: / Line 26: @@
 === 1. Struk dari Local tidak Masuk Ke Server ===
-. Cari struk yang belum masuk ke web di menu "Loss Bill" atau cek manual di menu [https://pos.idolmart.co.id/#ad_table.html?fm=ce256b8c-2dfc-4bec-9185-1b809caaaa7f bill today]
+. Cari struk yang belum masuk ke web di menu [https://pos.idolmart.co.id/#ad_table.html?fm=022300e1-204c-4bd1-9e25-f41fb700249f Loss Bill] atau cek manual di menu [https://pos.idolmart.co.id/#ad_table.html?fm=ce256b8c-2dfc-4bec-9185-1b809caaaa7f bill today]
 . sync manual bill yg tidak masuk dari PC local toko