Difference between revisions of "POS (Point Of Sales)"

From InfiniteERP Wiki
Jump to: navigation, search
(2. SO tidak terbentuk)
 
(24 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
= Introduction =
 
= Introduction =
 
InfiniteERP memiliki aplikasi POS yang digunakan untuk beberapa klien industri retail.
 
InfiniteERP memiliki aplikasi POS yang digunakan untuk beberapa klien industri retail.
 
== sub heading ==
 
=== sub sub heading ===
 
  
 
= Client Specific =
 
= Client Specific =
  
 
= Fitur POS =
 
= 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==
 +
TESTING :
 +
<pre>
 +
CCCCC
 +
</pre>
  
 
= Troubleshooting =
 
= Troubleshooting =
 +
 +
{{ManualDoc:POS-Troubleshooting}}
 +
 +
Berikut beberapa problem ditemukan dan cara menyelesaikan pada link ini [[:Category:POS-HowTo|POS Troubleshooting How-To]]
 +
== Sales Order Tidak Balance ==
 +
Total Penjualan di Local Pos tidak sama dengan hasil kalkulasi struk di server:
 +
 +
=== 1. Struk dari Local tidak Masuk Ke Server ===
 +
1. 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]
 +
 +
2. sync manual bill yg tidak masuk dari PC local toko
 +
  query : update pos_dsales set issync=false where billno like 'BILL YANG TIDAK MASUK'
 +
 +
=== 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
 +
 +
=== 3. SO tidak terbentuk ===
 +
1. cek document so di table pos_dsalessum dan pos_dsalesorder
 +
2. jika document so tidak ditemukan di pos_dsalesorder
 +
  jalankan query : SELECT public.proc_pos_dsalesorder_manual_insert('CODE CLIENT','CODE ORG','06-Aug-22','ASP');
 +
3. cek lagi di table pos_dsalesorder
 +
4. 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';
 +
 +
          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)
 +
        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
 +
        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)
 +
    SELECT isactived, insertdate, insertby, postby, postdate, billno, seqno, sku, qty, price, discount, amount, ad_org_id, discountname
 +
    FROM public.pos_dbillline
 +
    where billno in (select billno from pos_dbill where billno like 'BOS88-060822S%' and paymentmethodname like 'CASH');
 +
 +
    --delete from pos_dbilllinetoday
 +
    --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]] =

Latest revision as of 09:30, 12 August 2022

Introduction

InfiniteERP memiliki aplikasi POS yang digunakan untuk beberapa klien industri retail.

Client Specific

Fitur POS

Promo Reguler

Promo yang tidak bersyarat

Promo Tebus Murah

TESTING :

CCCCC

Troubleshooting

Dokumentasi setiap masalah, bug fixed dan problem yang ditemukan selama maintenance support

Berikut beberapa problem ditemukan dan cara menyelesaikan pada link ini POS Troubleshooting How-To

Sales Order Tidak Balance

Total Penjualan di Local Pos tidak sama dengan hasil kalkulasi struk di server:

1. Struk dari Local tidak Masuk Ke Server

1. Cari struk yang belum masuk ke web di menu Loss Bill atau cek manual di menu bill today

2. sync manual bill yg tidak masuk dari PC local toko

  query : update pos_dsales set issync=false where billno like 'BILL YANG TIDAK MASUK'

2. Struk dari local double di server

Cek di menu Fail Bill, Delete Struk yg Double

3. SO tidak terbentuk

1. cek document so di table pos_dsalessum dan pos_dsalesorder 2. jika document so tidak ditemukan di pos_dsalesorder

  jalankan query : SELECT public.proc_pos_dsalesorder_manual_insert('CODE CLIENT','CODE ORG','06-Aug-22','ASP');

3. cek lagi di table pos_dsalesorder 4. 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';
         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)
        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
       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)
    SELECT isactived, insertdate, insertby, postby, postdate, billno, seqno, sku, qty, price, discount, amount, ad_org_id, discountname
    FROM public.pos_dbillline
   where billno in (select billno from pos_dbill where billno like 'BOS88-060822S%' and paymentmethodname like 'CASH');
   --delete from pos_dbilllinetoday
   --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');

How-To