TIPTOP ERP 常用業務計算邏輯總結

TIPTOP ERP  常用業務計算邏輯總結

一、制造

1、訂單未交量：(oeb12-oeb24+oeb25-oeb26)*oeb05_fac

                    (訂單量  - 出貨量 +銷退量(折讓且原訂單出貨)-被結案數量)* 銷售/庫存機關換算率

                    條件：oea00<>'0' AND oeb70 = 'N' AND oeaconf = 'Y'

2、請購未轉采購量：(pml20-pml21)*pml09

[原料一般請購]       (請購量-累計已轉采購量)* 請購機關/庫存機關的轉換率

                         條件：pml011 !='SUB' AND pmk18 != 'X' AND ( pml16 <='2' OR pml16='S' OR pml16='R' OR pml16='W')

3、一般采購未交量：(pmn20-pmn50+pmn55+pmn58)*pmn09

[原料一般采購]        (采購量-已交量+驗退量+倉退[折讓且原采購單換貨])* 采購機關/料件庫存機關的轉換率

                               條件：pmn011 !='SUB' AND pmm18 != 'X' AND ( pmn16 <='2' OR pmn16='S' OR pmn16='R' OR pmn16='W')

4、采購結案時才計算的超/短交交量：pmn57=(pmn50-pmn20-pmn55)*pmn09

   [>0則為超交；<0則為短交]        (已交量-采購量-驗退量)* 采購機關/料件庫存機關的轉換率

                                           條件：采購單已結案

5、一般工單在制量：(sfb08-sfb09-sfb10-sfb11-sfb12)*ima55_fac

                         (生産數量-完工數量-再加工數量-FQC在驗量-報廢數量)* 生産機關/庫存機關換算率

                         條件：sfb04 <'8' AND sfb87!='X' AND ( sfb02 !='7' AND sfb02 !='8' AND sfb02 !='11' AND sfb02 != '15' )

6、委外在制量=委外工單在制量+委外IQC在驗量

   委外工單在制量：(sfb08-sfb09-sfb10-sfb11-sfb12)*ima55_fac

                        (生産數量-完工數量-再加工數量-FQC在驗量-報廢數量)* 生産機關/庫存機關換算率

                        條件：sfb04 <'8' AND sfb87!='X' AND ( sfb02='7' OR sfb02='8')

   委外IQC在驗量：(rvb07-rvb29-rvb30)*pmn09

                       (實收數量-驗退量-入庫量)* 生産機關/庫存機關換算率

                       條件：rvb04 = pmn01 AND rvb03 = pmn02 AND rvaconf='Y' AND rva10 ='SUB' AND pmn43 = 0

7、工單備料欠料量：(sfa05-sfa06-sfa065+sfa063-sfa062)*sfa13

                         (應發數量-已發數量-委外代買量+下階報廢-超領)* 發料機關/庫存機關換算率

                         條件：sfb04 !='8' AND  sfb87!='X' AND sfb02 != '15'

                        注意：因為GP5.20以上版本欠料時也可以先不補欠料就超領，會造成上述計算式可能為負數

                                 則計算出的備料欠料量應修正為0

8、工單已發欠料量：CALL s_shortqty(p_sfa01,p_sfa03,p_sfa08,p_sfa12,p_sfa27,p_sfa012,p_sfa013)

            RETURNING g_short_qty（即傳回已發欠料量），再*sfa13

                        條件：sfb04 !='8' AND  sfb87!='X' AND sfb02 != '15'

                        說明： p_sfa01：工單号碼

                                  p_sfa03：料件編号

                 p_sfa08：作業編号

                 p_sfa12：發料機關

                 p_sfa27：被替代料号

                 p_sfa012：工藝段号 GP 5.20以下版本不需要

                 p_sfa013：工藝序  GP 5.20以下版本不需要

            大緻邏輯：工單已發欠料量=已發套數*實際QPA-已發數量   (其中：實際QPA=應發/生産數量)

 9、最小發料套數：  CALL s_minp(p_wono,p_check,p_percent,p_opseq,p_prcocess,p_sequence)

            RETURNING l_stat,l_minp (l_stat結果碼:0.OK、1.Fail；l_minp:最小發料套數值)

                        條件：sfb04 !='8' AND  sfb87!='X' AND sfb02 != '15'

                        說明： p_wono：工單号碼  sfb01

                                  p_check：是否檢查最小套數  sma73

                 p_percent：檢查完工誤差率  ima153

                                (CALL s_get_ima153(sr.sfb05) RETURNING l_ima153)

                 p_opseq：作業編号 一般傳空值''，表示不檢查作業編号

                 p_prcocess：一般傳空值''

                 p_sequence：一般傳空值''

            大緻邏輯：最小發料套數 = ((已發-報廢+超領)/應發)*生産數量*(1+完工誤差率)(1+發料誤差率)

10、一般退料可退量：[不考慮發料誤差]：sfa06-((sfb09 + sfb11)* sfa161)-g_sfs05

    [asfi528]                             已發-((完工數量+FQC量)*實際QPA)-目前退料單其他項次已退量和

                                               說明：FQC量指的是"有FQC單但是該FQC還沒有完工入庫的量

                                                         (即FQC單沒有在完工入庫單sfv17裡面)"

11、IQC在驗量=已收貨待IQC驗+IQC已驗待入庫/驗退

     IQC在驗量：(rvb07-rvb29-rvb30)*pmn09

                      (實收數量-驗退量-入庫量)* 生産機關/庫存機關換算率

                      條件：rvb04 = pmn01 AND rvb03 = pmn02 AND rvaconf='Y' AND rva10 !='SUB'

     已收貨待IQC驗：上述IQC在驗量增加條件：

                AND (rvb39='Y'  AND

                     (SELECT COUNT(*) FROM qcs_file WHERE qcs01=rvb01 AND qcs02=rvb02 AND qcs14='Y' AND qcs00<'5')=0)

     IQC已驗待入庫/驗退：上述IQC在驗量增加條件：

          AND (rvb39='N'  OR

                     (rvb39='Y' AND (SELECT COUNT(*) FROM qcs_file WHERE qcs01=rvb01 AND qcs02=rvb02 AND qcs14='Y' AND qcs00<'5')>=1)

                    )

12、FQC在驗量：sfb11*ima55_fac

                     工單FQC量* 生産機關/庫存機關換算率

                     條件：sfb02 <> '7' AND sfb87!='X' AND sfb02 <> '8' AND sfb02 <> '11' AND sfb04 <'7' 

13、預計可用量=可用庫存量 - 訂單受訂量 - 工單備料量 + 請購未轉采購量 + 采購未交量 + IQC在驗量 + 工單在制量 +　委外在制量　＋ＦＱＣ在驗量

二、财務

1、應付期末餘額(貸方)=曆史累計和(貸-借)+本期貸方發生額-本期借方發生額

        曆史累計和(貸-借)：SUM(apm07f-apm06f) WHERE apm04=年 AND apm05<月 GROUP BY 科目,客戶...

        本期貸方發生額：   SUM(apm07f)               WHERE apm04=年 AND apm05=月 GROUP BY 科目,客戶...

        本期借方發生額：   SUM(apm06f)               WHERE apm04=年 AND apm05=月 GROUP BY 科目,客戶...

2、應收期末餘額(借方)=曆史累計和(借-貸)+本期借方發生額-本期貸方發生額

        曆史累計和(借-貸)：SUM(ooo08d-ooo08c) WHERE ooo06=年 AND ooo07<月 GROUP BY 科目,客戶...

        本期借方發生額：   SUM(ooo08d)               WHERE ooo06=年 AND ooo07=月 GROUP BY 科目,客戶...

        本期貸方發生額：   SUM(ooo08c)                WHERE ooo06=年 AND ooo07=月 GROUP BY 科目,客戶...

3、入庫/退貨未比對量=rvv87-rvv23       暫估數量=rvv88

                           (計價數量-已請款比對量)

         條件：rvv03!='2' AND rvv89!='Y' AND ((B.rvv87 > B.rvv23+B.rvv88) OR  (A.rvu00='3' AND B.rvv87=0))                  

                計價數量-已請款比對量-暫估數量>0  且含  倉退折讓(需判斷是否有做待抵)

4、原币未付=apc08-apc10-apc14-apc16

                (原币合計-原币已付金額-原币直接沖帳金額-原币留置金額)

                條件：apa42 = 'N' AND  apa34f > (apa35f+apa20)

    本币未付=apc09-apc11-apc15-apc16*apa14   (g_apz.apz27 = 'N'時)

                (本币合計-本币已付金額-本币直接沖帳金額-原币留置金額*立賬匯率)

                條件：apa42 = 'N' AND  apa34f > (apa35f+apa20)

    本币未付=apc13-apc16*apa72                          (g_apz.apz27 = 'Y'時)

                (本币未沖金額-原币留置金額*重估匯率)

                條件：apa42 = 'N' AND  apa34f > (apa35f+apa20)

http://blog.csdn.net/yihuiworld