Sp_financialClosing_BtnEventCheckout (procedure)
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sProInParam |
varchar(10000) |
| 2 | IN | sMakePerson |
varchar(100) |
| 3 | IN | sBrId |
varchar(100) |
| 4 | IN | sSuId |
varchar(100) |
| 5 | OUT | sReturn |
varchar(1000) |
| 6 | OUT | sCode |
int |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpfinancialClosing_BtnEventCheckout'._
Narrative
Business context: 系统设置 → 系统参数 → 财务结账 — 财务结帐 form's 结帐 (period-close) toolbar button. Closes the selected sysaccountperiod row, after running the per-period material-price calculation and posting estimate (暂估) inventory rows into the next period.
What it does: Parses $.params[0].value[0].sId from sProInParam for the period sId. Reads sysaccountperiod to look up the chosen sPeriodId and the period covering NOW. Refuses to close the current month (p_sPeriod = p_sNowPeriod → ThisNoSettleAccounts) and refuses if the prior period isn't yet frozen (PriorNoSettleAccounts). Calls Sp_financialClosing_BtnEventCalcMaterialPrice to recompute material cost prices; if that returns sCode<0 or =2 the run aborts. On success sets bFrozen=1, tForzenDate=NOW(), sMakePerson on sysaccountperiod and calls Sp_Insert_EstimateInstore(p_sPeriod, …) to generate the estimate-instore (暂估入库) carry-over.
Invocation: Dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() from the 财务结帐 form's 结帐 button. Inverse is Sp_financialClosing_BtnEventReCheckout. Also called from DB by Sp_Calc_sPdt and by Sp_financialClosing_BtnEventCheckoutCheckNew / Sp_financialClosing_BtnEventCheckout_Check (pre-close validators). xly-src ships script/标版/30100101/Sp_financialClosing_BtnEventCheckout.sql.