Forum

Welcome Guest! To enable all features please try to register or login.
Zatvaranje otvorenih stavki za dev.konto
Options Go to last post Go to first unread
Previous Topic Next Topic
HD_prijavio
#1 Posted: : 29 November 2012 11:09:00(UTC)
HD_prijavio

Rank: Datalab

You have been a member since:: 14/08/2009(UTC)
Objave: 1

Was thanked: 2 time(s) in 2 post(s)
Kod korisnka se pojavljuju nule na potražnoj strani prilikom zatvaranja otvorenih stavki za konto 43101.
Takodje, pojavljuju se i dokumenta koja su vec ranije zatvorena.
HD_odgovorio
#2 Posted: : 29 November 2012 11:09:00(UTC)
HD_odgovorio

Rank: Datalab

You have been a member since:: 14/08/2009(UTC)
Objave: 0

Was thanked: 1 time(s) in 1 post(s)
Opisana situacija u bazi je nastala jer ne postoji zaključak godine po novom - poslovna godina.
Potrebno je napraviti backup baze
Otvoriti poslovni događaj za zatvaranje godine u šifarniku vrste dokumenata (podešavanje / program / vrste dokumenata / poslovna godina- npr. PSG, povezati predložak za zatvaranje 5 i 6 i označiti usklađivanje scenarija
U modulu Novac / zaključak godine / poslovna godina /u Zaključak stare i otvaranje nove godine kreirati dokument. U našem slučaju 11-PSG-000001 za period od 01.01.2010. do 31.12.2011.
Otvoriti i dokument 12-PSG-000001 za period 01.01.2012. do 31.12.2012.
Pokrenuti script:
insert into tHE_CloseOpenAcctTrans
select `12PSG00000001`, 1, 1, 0, `1240000000001`, 0, null, null, getdate(), 1, getdate(), 1
insert into tHE_CloseOpenAcctTrans
select `11PSG00000001`, 1, 1, 0, `1149000000001`, 0, `12PSG00000001`, 1, getdate(), 1, getdate(), 1
exec pPA_SysSetConInfoRC 2, 1
update tHE_AcctTransItem set acKeyCloseAcctTrans = `1149000000001` where acKey like `10%`
update tHE_AcctTransItem set acKeyCloseAcctTrans = `1149000000001` where acKey like `11%`
exec pPA_SysSetConInfoRC 2, 0
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2025, Yet Another Forum.NET
This page was generated in 0.444 seconds.