Usersite
»
UserSite SR
»
Novac
»
Zaključak godine
»
Zatvaranje otvorenih stavki za dev.konto
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.
|
|
|
|
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
|
|
|
|
Usersite
»
UserSite SR
»
Novac
»
Zaključak godine
»
Zatvaranje otvorenih stavki za dev.konto
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.NETThis page was generated in 0.365 seconds.