ÄÚÈÝ·¢²¼¸üÐÂʱ¼ä : 2024/6/15 14:08:16ÐÇÆÚÒ» ÏÂÃæÊÇÎÄÕµÄÈ«²¿ÄÚÈÝÇëÈÏÕæÔĶÁ¡£
1¡¢½áÕÊʱ³öÄÉÓë»á¼ÆÓвîÒ죬µ«³öÄɵÄÊý¾ÝÓë×Ü·ÖÀàÕÊÀïµÄÊý¾ÝÊÇÒ»Ö Èí¼þ°æ±¾£º²ÆÎñϵÁÐV6.0 ½â¾ö·½·¨£º
A¡¢³öÄÉÕʽøÐз´ÒýÈë
B¡¢select * from aa_creditem where credit<>rawcredit and happendate>'³ö´íµÄÆðʼÈÕÆÚ' and happendate<'³ö´íµÄ½áÊøÈÕÆÚ' and subjectid=¡¯Òø´æ¡¢ÏÖ½ð»òÆäËû»õ±Ò×ʽðµÄsubjectid¡¯
/*²éѯƾ֤´Ó±íÖб¾Î»±ÒºÍÔ±Ò½ð¶î²»ÏàµÈµÄ¼Ç¼*/ C¡¢Èç¹ûÓмǼ·µ»Ø£¬ÔòÔËÐÐ
update aa_creditem set rawcredit=credit where credit<>rawcredit and happendate>'³ö´íµÄÆðʼÈÕÆÚ' and happendate<'³ö´íµÄ½áÊøÈÕÆÚ' and subjectid=¡¯Òø´æ¡¢ÏÖ½ð»òÆäËû»õ±Ò×ʽðµÄsubjectid¡¯ D¡¢ÔËÐÐÍê±Ï£¬ÔÚ³öÄÉÕʽøÐÐÒýÈë
2¡¢ÔÚ´ò¿ª»á¼Æ¿ÆĿʱ£¬Ìáʾ¡°ÄãÊäÈëµÄÊýÖµ²»¹æ·¶£¬ÇëÊäÈëÕûÊý¡± Èí¼þ°æ±¾£º²ÆÎñϵÁÐV5.9
ÎÊÌâ·ÖÎö£º¿ÆÄ¿±àÂëÌ«³¤»òÕßΪ¿Õ ½â¾ö·½·¨£º
A¡¢select * from al_subject order by subcode
B¡¢ ½«»á¼Æ¿ÆÄ¿½øÐÐÅÅÐò.È»ºó¿´µ½ÓÐsubcode»á¼Æ±àÂë¹ý³¤µÄ»òÕßΪ¿ÕµÄ.Ö±½Óɾ³ý»òÕßÐ޸ľͿÉÒÔÁË.
3¡¢ÔÚ³õʼ»¯½×¼¶£¬ÒѶÔijÕË»§½øÐÐÁ˸¨ÖúºËË㣬²¢Â¼ÈëÁ˸ø¨ÖúºËËãµÄÆÚ³õÊý£¬ÆôÓÃÕËÌ׺󣬴ò¿ª¿ÆÄ¿¸¨Öú»ã×ܱíʱ£¬·¢ÏÖÆÚ³õ½á´æ½ð¶îÈ«²¿ÏÔʾΪ0¡£ Èí¼þ°æ±¾£º²ÆÎñϵÁУ¨²ÆÎñSTD¡¢²ÆÎñPRO¡¢²ÆÎñXP£©V5.8-V6.0°æ±¾ ½â¾ö·½·¨£º
A¡¢Éý¼¶µ½V6.0»ò6.0ÒÔÉÏ°æ±¾£¬²¢¶ÔÔÕËÌ×½øÐÐÐÞ¸´¡£ B¡¢·´½áÕ˵½ÆÚ³õ£¬²¢¶ÔÕËÌ×½øÐз´½áÕË
C¡¢ÖØмÈ븨ÖúºËËã¿ÆÄ¿µÄÆÚ³õÓà¶î£¬½¨ÒéÊäÈëÍê±Ïºó£¬ÔÙÔËÐÐÈçÏÂÓï¾ä£º Update aa_creditem set unclearamt=debit+credit
B¡¢ÆôÓÃÕËÌ×£¬²¢½øÐÐÏà¹ØµÄÇ©×Ö¡¢ÉóºË¡¢µÇÕË¡¢½áÕ˵ȲÙ×÷¡£
4¡¢´ò¿ªÄ³¼ÇÕËƾ֤ʱ£¬ÏµÍ³³öÏÖ¡°abnormal terminal program¡±µÄÌáʾÐÅÏ¢£¬È»ºóÈí¼þ×Ô¶¯Í˳ö¡£
Èí¼þ°æ±¾£º²ÆÎñϵÁУ¨²ÆÎñSTD¡¢²ÆÎñPRO¡¢²ÆÎñXP£©V5.8-V6.0°æ±¾ ½â¾ö·½·¨£º
A¡¢select * from al_subject where allsubname is null
/*ͨ¹ý¸Ã²éѯÓï¾ä£¬²éÕÒ»á¼Æ¿ÆÄ¿±íµ¥ÖУ¬ÊÇ·ñ´æÔÚÈ«³ÆΪ¿ÕµÄ»á¼Æ¿ÆÄ¿*/ B¡¢update al_subject set allsubname=' '+name where allsubname is null /*°Ñ»á¼Æ¿ÆÄ¿È«³ÆΪ¿ÕµÄ¿ÆÄ¿Ç°£¬²åÈëÒ»¿Õ¸ñ£¬Ö´ÐиÃÓï¾äºó£¬¿ÆÄ¿È«³Æ½«°´´¥·¢Æ÷×Ô¶¯µØ½øÐиüÐÂ*/
C¡¢update al_subject set name=ltrim(name)
/*¸ÃÓï¾ä¿ÉÈ¥³ý»á¼Æ¿ÆÄ¿Ç°µÄ¿Õ¸ñ*/
5¡¢¡°³õʼÊý¾Ý¼È롱µÄ¸¨ÖúºËËã»õÆ·ÆÚ³õÊýÁ¿Óë¡°ÊÕ·¢´æ×Ü±í¡±µÄÆÚ³õÊýÁ¿ÎÞ·¨¶ÔÓ¦¡£ ²úÆ·ÐÅÏ¢£ºËÙ´ï²ÆÎñXP °æ±¾ÐÅÏ¢£ºV6.1 Ä£¿éÃû³Æ£º±¨±íϵͳ ½â¾ö·½·¨£º
SET QUOTED_IDENTIFIER OFF GO
SET ANSI_NULLS OFF GO
/*********************************************************************************************** author: awens
last updated: 2005-10-26, awens remark:
***********************************************************************************************/
ALTER function ac_cost_balance( @bnyear integer, @bnmonth integer, @subid integer, @goodsid integer )
returns @local_tab table( balanceamt numeric(18,8), balanceprice numeric(18,8), balanceqty numeric(18,8) ) as begin
declare @initamt numeric(18,8), @amt numeric(18,8), @initqty numeric(18,8), @qty numeric(18,8),
@unitprice numeric(18,8), @tmpamt numeric(18,8), @tmpqty numeric(18,8), @startyear int, @startmonth int, @crntaccyear int,
@crntaccmonth int,
@startaccyearmonth varchar(10), @crntaccyearmonth varchar(10), @yearmonth varchar(10)
declare @credyearmonthbegin varchar(10) declare @costtype integer declare @todebit integer declare @IsSpecAcc integer
declare
@subjectid integer
set @initamt = 0 set @initqty = 0 set @amt = 0 set @qty = 0
set @unitprice = 0
set @yearmonth = '190001'
select @IsSpecAcc=cast(datavalue as int) from am_sysparam where paramid=906 or upper(name)=upper('IsUpdateFromOther')
select @startyear = cast(datavalue as int) from am_sysparam where lower(name)='startyear'
select @startmonth = cast(datavalue as int) from am_sysparam where lower(name)='startmonth'
select @crntaccyear = cast(datavalue as int) from am_sysparam where lower(name)='curraccyear'
select @crntaccmonth = cast(datavalue as int) from am_sysparam where lower(name)='curraccmonth' select @startaccyearmonth=credyearmonth from dbo.fn_aa_getcredyearmonthstr(@startyear,@startmonth) select @crntaccyearmonth=credyearmonth from dbo.fn_aa_getcredyearmonthstr(@crntaccyear,@crntaccmonth) select @credyearmonthbegin=credyearmonth from dbo.fn_aa_getcredyearmonthstr(@bnyear,@bnmonth) set @subjectid=@subid
select top 1
@yearmonth=m.credyearmonth,@tmpamt=isnull(liveamt,0),@tmpqty=isnull(liveqty,0) from aa_creditem d
inner join aa_cred m on d.credid=m.credid
inner join al_subject s on s.subjectid=d.subjectid where substock=@subjectid and goodsid=@goodsid