Poštovani Ratko,

Pantheon 5.5 već nekoliko godina se ne razvija i ne možemo Vam pružiti pomoć na tako starim verzijama.

LP,
MELISA

Poštovani Ratko,

pokušat ću što detaljnije da napišem, da i drugi učesnici u temi imaju koristi.

Što se tiče nadogradnje, na Pantheon-u X nije potrebno ići build po build kada se radi nadogradnja, kakav je slučaj bio sa Pantheon-om 5.5. U Vašem primjeru, mogli ste ići na Pantheon verziju 10.00.00, zatim 10 03.00, zatim 10.07, 10.011. te odmah na zadnju verziju. Jako nam je žao što ste proveli cijeli dan na nadogradnji i da prije niste imali ove informacije.

RT licenca ima svoj poseban .exe file, pa ću Vas zamoliti da mi javite da li na verziji 5.5. u RE ili SE licenci, na POS dokumentima postoji isti problem?

Što se tiče HERMES POS-a, situacija je takva da se on više ne razvija, kako sam već prije pisala. Razvoj je fokusiran na POSX i privodimo kraju rješenja fiskalizacije, te se nadam da ćemo ubrzo imati release sa Mikroelektronika fiskalnim uređajima.

Molim Vas da mi javite odgovor na moj upit, pa da znamo u kom pravcu da tražimo rješenje.
Hvala,
LP,
MELISA

Ratko,

pisala sam upravo do kolega iz Razvoja.
Kada dobijem info što možemo napraviti, pisat ću Vam.

Hvala na Vašem strpljenju i izdvojenom vremenu.

LP,
MELISA

Malo sam testirao, ponovo sam sa 5.5 išao do poslednje verzije, ali na način kako ste vi naveli (10.00.00, zatim 10 03.00, zatim 10.07, 10.011. te odmah na zadnju verziju), primjetio sam da se kroz verzije 10.00.00, 10 03.00, 10.07, 10.011 dešava sve isto kao i u verziji 5.5, a to sam već opisao u prvoj poruci i ne mogu de vjerujem da to sve ove godine niko nije prijavio, a isto tako da niko se nije sjetio riješiti ovaj problem, poslije pretrage po broju računa kao da se mijenja način na koji se vrši listanje računa i ako se i tada sve radi po broju računa....poslije verzije 10.011 išao sam na poslednju verziju 10.0.19.0 (sinoć sam testirao i verziju prije ove i isto se ponaša) i tu je stanje najgore tj. u ovoj verziji listanje računa je odmah po startu užasno sporo kao da sam prije toga vršio već spomenutu pretragu po broju računa i sam RT se užasno sporo startuje...

Već sam naveo da u poslednjih nekoliko verzija ne radi i funkcija za dodavanje indexa koji nedostaju!

Takođe, za razliku od prolaska kroz sve verzije do poslednje verzije, vaš način dolaska do poslednje verzije ne prolazi baš glatko, prilikom prelaska sa 10 03.00 na 10.07 imao sam grešku:

Greška: 'Msg 208, Level 16, State 6, Procedure pPA_SysUpgObjects, Line 40. Description: Msg 208, Level 16, State 6, Procedure pDE_BalancePrintForBanks, Line 1. Description: Invalid object name 'dbo.pDE_BalancePrintForBanks'.'
SQL: 'ALTER procedure [dbo].[pDE_BalancePrintForBanks](
@p_cBalanceSheet1 CHAR(3),
@p_cBalanceSheet2 CHAR(3),
@p_dDateFrom DateTime,
@p_dDateTo DateTime,
@p_dDateFromCmp DateTime,
@p_dDateToCmp DateTime,
@p_cDocTypeList varchar(4000),
@p_cAcctBuyer varchar(4000),
@p_cAcctBuyerMinus varchar(4000),
@p_cAcctSupplier varchar(4000),
@p_cAcctSupplierMinus varchar(4000),
@p_nPackageB int Output,
@p_nPackageS int Output,
@p_cAOP003 varchar(4000),
@p_cAOP010 varchar(4000),
@p_cAOP020 varchar(4000),
@p_cAOP024 varchar(4000),
@p_cAOP027 varchar(4000),
@p_cAOP034 varchar(4000),
@p_cAOP041 varchar(4000),
@p_cAOP045 varchar(4000),
@p_cAOP050 varchar(4000),
@p_cAOP051 varchar(4000),
@p_cAOP053 varchar(4000),
@p_cAOP056 varchar(4000),
@p_cAOP072 varchar(4000),
@p_cAOP076 varchar(4000),
@p_cAOP080 varchar(4000),
@p_cAOP087 varchar(4000),
@p_cAOP093 varchar(4000),
@p_cAOP094 varchar(4000),
@p_cAOP095 varchar(4000)
)
as
begin

Declare
-- spremenljivke bruto bilanca
@p_cAcct2 varchar(max),
@p_cIsRangeAcct char(1),
@p_cEvidKey varchar(13),
@p_cKey varchar(13),
@p_cForeignDoc varchar(35),
@p_cOnlyApproved char(1),
@p_cUseUserLang char(1),
@p_cIsAcctWholeLen char(1),
@p_cIsAcctLen2 char(1),
@p_cIsAcctLen3 char(1),
@p_cGroupOnAcctName char(1),
@p_cAcctLangID varchar(2),
@p_nSearchDateForFXRate tinyint,
@p_nSearchDateForOpening tinyint,
@p_nDateField tinyint,
@p_nGroupBy tinyint,

-- spremenljivke bilance
@cBalance char(3),
@cDurationType char(1),
@cAcct varchar(13),
@cAcct2 varchar(13),
@cAcctList varchar(max),
@cCurrency varchar(3),
@cCurrencyOut varchar(3),
@cMonthlyFxRate char(1),
@cSubject varchar(30),
@cUseDeptCostDrv char(1),
@cDept varchar(max),
@cCostDrv varchar(max),
@cSKIS varchar(max),
@cTransKey char(13),
@cDocList varchar(4000),
@nSearchDateForFXRate tinyint,
@dDateFrom datetime,
@dDateTo datetime,
@dDateDocFrom datetime,
@dDateDocTo datetime,
@dDate2From datetime,
@dDate2To datetime,
@dDate2DocFrom datetime,
@dDate2DocTo datetime,
@dDateCmpFrom datetime,
@dDateCmpTo datetime,
@dDateCmpDocFrom datetime,
@dDateCmpDocTo datetime,
@dDateCmp2From datetime,
@dDateCmp2To datetime,
@dDateCmp2DocFrom datetime,
@dDateCmp2DocTo datetime,
@cZEUS char(1),
@cZEUSCode varchar(13),
@nErrorPos int,
@nSearchDateForOpening tinyint = 0,
@cOnlyChecked char(1),
@cBalanceExtraDatesEntered char(1),
@dDate3From datetime,
@dDate3To datetime,
@dDate3DocFrom datetime,
@dDate3DocTo datetime,
@dDate4From datetime,
@dDate4To datetime,
@dDate4DocFrom datetime,
@dDate4DocTo datetime,
@dDate5From datetime,
@dDate5To datetime,
@dDate5DocFrom datetime,
@dDate5DocTo datetime,
@dDate6From datetime,
@dDate6To datetime,
@dDate6DocFrom datetime,
@dDate6DocTo datetime,
@dDate7From datetime,
@dDate7To datetime,
@dDate7DocFrom datetime,
@dDate7DocTo datetime,
@dDate8From datetime,
@dDate8To datetime,
@dDate8DocFrom datetime,
@dDate8DocTo datetime,
@dDate9From datetime,
@dDate9To datetime,
@dDate9DocFrom datetime,
@dDate9DocTo datetime,
@dDate10From datetime,
@dDate10To datetime,
@dDate10DocFrom datetime,
@dDate10DocTo datetime,
@p_cOnlyNotional char(1),

@nPlanID int,

--spremenljivke odprte postavke
@p_AcctBetweenOr char(1), -- collect all accounts from @p_cAcctFrom to @p_cAcctTo
@p_cAcct varchar(255), -- not used anymore
@p_cAcctFrom varchar(255), -- first account number
@p_cAcctTo varchar(255), -- second account number
@p_cSubject varchar(30), -- subject
@p_cLinkDoc varchar(35), -- link document
@p_cDept varchar(30), -- departmen
@p_nInCurrency int, -- collect posts in currency
@p_cCostDrv varchar(16), -- cost drive
@p_cCurrency varchar(3), -- currency of the posts
@p_cPrimCurrency varchar(3), -- primary currency
@p_dDate datetime, -- date of outstanding items
@p_nNon_0_Or_0 tinyint, -- 1 - opened, 0 - closed, 2 - both
@p_cDateType char(1), -- collect data from according to document date or general ledger document date
@p_cSubjType varchar(16), -- type of subjects
@p_cSubjActive char(1), -- active subjects
@p_cUseSetOff char(1), -- should compensations be included or excluded (compensations are posts without datedue entered)
@p_cCloseTrans char(1), -- should GL document for yearending be included
@p_cPayDelayCheck char(1), -- should allowed delays be included
@p_nClerk int, -- user on posts
@p_dDateFromOI datetime, -- document date from
@p_dDateToOI datetime, -- document date to
@p_dDateDueFrom datetime, -- documents datedue from
@p_dDateDueTo datetime , -- documents datedue to
@p_cDoc Varchar(35), -- document number
@p_cCountry Varchar(20), -- country
@p_cbStatusi Varchar(30), -- status on the posts
@p_nPackage int, -- returned number of the package for selecting posts in vHE_GLOutStandingItems view
@p_nTypeSuppBuy integer, -- type subjects (buyer or supplyer - field acSubjAcct in tHE_SetAccount table)
@p_nMinSum money, -- minimal sum of opened document
@p_cTypeOfSale char(1),
@p_cAcctList varchar(max),
@p_chkOnlyOpened char(1),
@p_chkSaldoDebit char(1),
@p_chkSaldoCredit char(1),
@p_chkPrepayments char(1),
@p_chkOnlyDocs char(1),
@p_cNote varchar(255),
@p_chkShowCreditNote char(1),
@p_cFgndoc varchar(35),
@p_chkOnlyDoc char(1),

--spremenljivke struktura odprtih postavk
@p_byDoc integer,
@p_cOverPay Char(1),
@p_cType Char(1),
@p_cStatus Char(1),
@p_acAcct Varchar(max),
@p_acAcct2 Varchar(max),
@p_cDocType Varchar(1000),
@p_IsFgnCurrency Char(1),
@p_cInCurrency Varchar(3),
@p_dDatePostFrom DateTime,
@p_dDatePostTo DateTime,
@p_dDateDocFrom DateTime,
@p_dDateDocTo DateTime,
@p_Obd1 integer,
@p_Obd2 integer,
@p_Obd3 integer,
@p_Obd4 integer,
@p_Obd5 integer,
@p_nPeriod6 integer,
@p_nPeriod7 integer,
@p_nPeriod8 integer,
@p_nPeriod9 integer,
@p_nPeriod10 integer,
@p_cStatusi Varchar(30),
@p_cSubjTypeSupp Varchar(max),
@p_cSubjTypeBuyer Varchar(max),
@p_cReportType VarChar(6),
@p_cSign Money,
@p_nFXRateType integer,
@p_nNoteClerk integer,
@p_nDateLimitTo smallint,

--spremenljivke kupci po prometu
@cGLDocTypeOpen Char(4),
@cGLDocTypeClose Char(4),
@dDateOpening DateTime,
@cPrimCurr Char(3),
@cAcctListGB varchar(max),
@nCount int,
@cAOP varchar(4000)

select @nPlanID = dbo.fDE_AcctPlanForDate(@p_dDateTo)
Set @cPrimCurr = dbo.fHE_GetPrimCurrency(@p_dDateFrom)
Set @dDateOpening = dbo.fHE_FindDateOpening(@cPrimCurr)
Set @nCount = 1

if @p_dDateFromCmp = 0
Set @p_dDateFromCmp = dateadd(yyyy, -1, @p_dDateFrom)
if @p_dDateToCmp = 0
Set @p_dDateToCmp = dateadd(yyyy, -1, @p_dDateTo)


select @cGLDocTypeOpen = acGLDocTypeOpen, @cGLDocTypeClose = acGLDocTypeClose from tPA_SysParam

-- Bruto bilanca

-- AOP003, AOP0010, AOP020, AOP024, AOP027, AOP034, AOP041, AOP045, AOP050, AOP053

set @cAOP = ''
While @nCount <= 19
begin
set @p_nGroupBy = 0
if @nCount = 1
begin
Set @cAOP = @p_cAOP003
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '003', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('005', '006', '007', '008', '009') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 2
begin
Set @cAOP = @p_cAOP010
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '010', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('011', '012', '013', '014', '015', '016', '017') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 3
begin
Set @cAOP = @p_cAOP020
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '020', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('021', '022', '023') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 4
begin
Set @cAOP = @p_cAOP024
set @p_nGroupBy = 1
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '024', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('025', '026') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 5
begin
Set @cAOP = @p_cAOP027
set @p_nGroupBy = 1
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '027', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('028', '029', '030') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 6
begin
Set @cAOP = @p_cAOP034
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '034', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('035', '036', '037', '038', '039') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 7
begin
Set @cAOP = @p_cAOP041
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '041', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('042', '043', '044') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 8
begin
Set @cAOP = @p_cAOP045
set @p_nGroupBy = 1
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '045', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('046', '047') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 9
begin
Set @cAOP = @p_cAOP050
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '050', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) = '050' and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 10
begin
Set @cAOP = @p_cAOP051
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '051', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) = '051' and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 11
begin
Set @cAOP = @p_cAOP053
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '053', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) = '051' and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 12
begin
Set @cAOP = @p_cAOP056
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '056', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('058', '059', '060', '062', '063', '064', '065', '066', '068', '067', '069', '070', '071') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 13
begin
Set @cAOP = @p_cAOP072
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '072', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('073', '074') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 14
begin
Set @cAOP = @p_cAOP076
set @p_nGroupBy = 1
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '076', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('077', '078', '079') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 15
begin
Set @cAOP = @p_cAOP080
set @p_nGroupBy = 1
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '080', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('081', '082', '083') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 16
begin
Set @cAOP = @p_cAOP087
set @p_nGroupBy = 1
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '087', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) in ('088', '089', '090') and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 17
begin
Set @cAOP = @p_cAOP093
set @p_nGroupBy = 1
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '093', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) = '093' and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 18
begin
Set @cAOP = @p_cAOP094
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '094', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) = '094' and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end
if @nCount = 19
begin
Set @cAOP = @p_cAOP095
insert into #lDE_BankExportAOPs(acAOPGroup, acAOP, acAcct)
Select '095', I.acAOP, F.acAcct
from tHE_FinReportItem I
cross apply dbo.fPA_DecomposeFormulaBilance(I.acFormula1) F
join tDE_SetAccount A on A.acAcct = F.acAcct
where I.acBalanceOfAcct = @p_cBalanceSheet1 and RIGHT('000'+ISNULL(I.acAOP,''),3) = '095' and A.acPermitPost <> 'N' and A.anPlanID = @nPlanID and I.anPlanID = @nPlanID
group by F.acAcct, I.acAOP
end

set @cAcctListGB = ''
select @cAcctListGB = Coalesce(@cAcctListGB + ',', '') + acItem
from dbo.fPA_SplitString(@cAOP, ',')
where acItem <> ''
group by acItem

if OBJECT_ID('tempDB..#lDE_Dept') is not null
truncate table #lDE_Dept
if OBJECT_ID('tempDB..#lDE_CostDrv') is not null
truncate table #lDE_CostDrv
if OBJECT_ID('tempDB..#lHE_GrossBalance') is not null
truncate table #lHE_GrossBalance
if OBJECT_ID('tempDB..#lHE_GrossBalanceDet') is not null
truncate table #lHE_GrossBalanceDet

--Bruto bilanca konti aktive
set @p_cPrimCurrency = @cPrimCurr
set @p_cCurrency = ''
set @p_cAcct = ''
set @p_cAcct2 = ''
set @p_cAcctList = @cAcctListGB
set @p_cIsRangeAcct = 'F'
set @p_cEvidKey = ''
set @p_cKey = ''
set @p_cSubject = ''
set @p_cSubjType = ''
set @p_cCostDrv = ''
set @p_cDept = ''
set @p_cDoc = ''
set @p_cLinkDoc = ''
set @p_cForeignDoc = ''
set @p_cOnlyApproved = 'F'
set @p_cUseUserLang = 'F'
set @p_cIsAcctWholeLen = 'T'
set @p_cIsAcctLen2 = 'T'
set @p_cIsAcctLen3 = 'T'
set @p_cGroupOnAcctName = 'F'
set @p_cAcctLangID = ''
set @p_nClerk = 0
set @p_nSearchDateForFXRate = 0
set @p_nSearchDateForOpening = 0
set @p_nDateField = 0

if @cAcctListGB <> ''
begin

execute [dbo].[pDE_GrossBalance]
@p_cPrimCurrency,
@p_cCurrency,
@p_cAcct,
@p_cAcct2,
@p_cAcctList,
@p_cIsRangeAcct,
@p_cEvidKey,
@p_cKey,
@p_cSubject,
@p_cSubjType,
@p_cCostDrv,
@p_cDept,
@p_cDoc,
@p_cLinkDoc,
@p_cForeignDoc,
@p_cDocTypeList,
@p_cOnlyApproved,
@p_cUseUserLang,
@p_cIsAcctWholeLen,
@p_cIsAcctLen2,
@p_cIsAcctLen3,
@p_cGroupOnAcctName,
@p_cAcctLangID,
@p_nClerk,
@p_nSearchDateForFXRate,
@p_nSearchDateForOpening,
@p_nDateField,
@p_nGroupBy,
@p_dDateFrom,
@p_dDateTo,
'F'

if @nCount = 1 --003
begin
insert into #lDE_BankExportAOP (acAcct, anInitialValue, anIncrease, anDecrease, anEndValue)
select substring(acAcct, 1, 3), SUM(ZacetekDB-ZacetekKR), SUM(PrometDB), SUM(PrometKR), SUM(SaldoDB-SaldoKR) from #lhe_grossbalance
group by substring(acAcct, 1, 3)

Update I set acSheet = '003 Neopred.OS',
anRow = case when S.acAOP = '006' then 7 when S.acAOP = '007' then 8 when S.acAOP = '005' then 9 when S.acAOP = '008' then 10 when S.acAOP = '009' then 11 end
from #lDE_BankExportAOP I join #lDE_BankExportAOPs S on I.acAcct = substring(S.acAcct, 1, 3)
Where S.acAOPGroup = '003'

end
if @nCount = 2 --010
begin
insert into #lDE_BankExportAOP (acAcct, anInitialValue, anIncrease, anDecrease, anEndValue)
select substring(acAcct, 1, 3), SUM(ZacetekDB-ZacetekKR), SUM(PrometDB), SUM(PrometKR), SUM(SaldoDB-SaldoKR) from #lhe_grossbalance
group by substring(acAcct, 1, 3)
end
if @nCount = 3 --020
begin
insert into #lDE_BankExportAOP (acAcct, anInitialValue, anIncrease, anDecrease, anEndValue)

select substring(acAcct, 1, 3), SUM(ZacetekDB-ZacetekKR), SUM(PrometDB), SUM(PrometKR), SUM(SaldoDB-SaldoKR) from #lhe_grossbalance
group by substring(acAcct, 1, 3)

Update I set acSheet = '020 Dolg.fin.naložbe',
anRow = case when S.acAOP = '021' then 7 when S.acAOP = '022' then 8 when S.acAOP = '023' then 9 end
from #lDE_BankExportAOP I join #lDE_BankExportAOPs S on I.acAcct = substring(S.acAcct, 1, 3)
Where S.acAOPGroup = '020'

end
if @nCount = 4 --024
begin
insert into #lDE_BankExportAOP (acAcct, anInitialValue, anIncrease, anDecrease, anEndValue)
select substring(acAcct, 1, 3), SUM(ZacetekDB-ZacetekKR), SUM(PrometDB), SUM(PrometKR), SUM(SaldoDB-SaldoKR) from #lhe_grossbalance
group by substring(acAcct, 1, 3)
end
if @nCount = 5 --027
begin
insert into #lDE_BankExportAOP (acAcct, anInitialValue, anIncrease, anDecrease, anEndValue)
select substring(acAcct, 1, 3), SUM(ZacetekDB-ZacetekKR), SUM(PrometDB), SUM(PrometKR), SUM(SaldoDB-SaldoKR) from #lhe_grossbalance
group by substring(acAcct, 1, 3)
end
if @nCount = 6 --034
begin
insert into #lDE_BankExportAOP (acAcct, anInitialValue, anIncrease, anDecrease, anEndValue)
select substring(acAcct, 1, 3), SUM(ZacetekDB-ZacetekKR), SUM(PrometDB), SUM(PrometKR), SUM(SaldoDB-SaldoKR) from #lhe_grossbalance
group by substring(acAcct, 1, 3)

Update I set acSheet = '034 Zaloge',
anRow = case when S.acAOP = '035' then 7 when S.acAOP = '036' then 8 when S.acAOP = '037' then 9 when S.acAOP = '038' then 10 when S.acAOP = '039' then 11 end
from #lDE_BankExportAOP I join #lDE_BankExportAOPs S on I.acAcct = substring(S.acAcct, 1, 3)
Where S.acAOPGroup = '034'

end
if @nCount = 7 --041
begin
insert into #lDE_BankExportAOP (acAcct, anInitialValue, anIncrease, anDecrease, anEndValue)
select substring(acAcct, 1, 3), SUM(ZacetekDB-ZacetekKR), SUM(PrometDB), SUM(PrometKR), SUM(SaldoDB-SaldoKR) from #lhe_grossbalance
group by substring(acAcct, 1, 3)

Update I set acSheet = '041 Krat.fin.naložbe',
anRow = case when S.acAOP = '041' then 7 when S.acAOP = '042' then 8 when S.acAOP = '043' then 9 when S.acAOP = '044' then 10 end
from #lDE_BankExportAOP I join #lDE_BankExportAOPs S on I.acAcct = substring(S.acAcct, 1, 3)
Where S.acAOPGroup = '041'

end
if @nCount = 8 --045
begin
insert into #lDE_BankExportAOP (acAcct, anInitialValue, anIncrease, anDecrease, anEndValue)
select substring(acAcct, 1, 3), SUM(ZacetekDB-ZacetekKR), SUM(PrometDB), SUM(PrometKR), SUM(SaldoDB-SaldoKR) from #lhe_grossbalance
group by substring(acAcct, 1, 3)
end
if @nCount = 9 --050
begin
insert into #lDE_BankExportAOP (acAcct, anInitialValue, anIncrease, anDecrease, anEndValue)
select substring(acAcct, 1, 3), SUM(ZacetekDB-ZacetekKR), SUM(PrometDB), SUM(PrometKR), SUM(SaldoDB-SaldoKR) from #lhe_grossbalance
group by substring(acAcct, 1, 3)
end
if @nCount = 10 --051
begin
insert into #lDE_BankExportAOP (acAcct, anInitialValue, anIncrease, anDecrease, anEndValue)
select substring(acAcct, 1, 3), SUM(ZacetekDB-ZacetekKR), SUM(PrometDB), SUM(PrometKR), SUM(SaldoDB-SaldoKR) from #lhe_grossbalance
group by substring(acAcct, 1, 3)

Update I set acSheet = '051 Krat.ter.drugi',
anRow = case when S.acAOP = '051' then 7 end
from #lDE_BankExportAOP I join #lDE_BankExportAOPs S on I.acAcct = substring(S.acAcct, 1, 3)
where I.acAcct like '165%'
and S.acAOPGroup = '051'
Update I set acSheet = '051 Krat.ter.drugi',
anRow = case when S.acAOP = '051' then 8 end
from #lDE_BankExportAOP I join #lDE_BankExportAOPs S on I.acAcct = substring(S.acAcct, 1, 3)
where I.acAcct like '165%' and I.acAcct not like '165%'
and S.acAOPGroup = '051'

end
if @nCount = 11 --053
begin
insert into #lDE_BankExportAOP (acAcct, anInitialValue, anIncrease, anDecrease, anEndValue)
select substring(acAcct, 1, 3), SUM(ZacetekDB-ZacetekKR), SUM(PrometDB), SUM(PrometKR), SUM(SaldoDB-SaldoKR) from #lhe_grossbalance
group by substring(acAcct, 1, 3)

Update I set acSheet = '053 Krat.AČR',
anRow = case when S.acAOP = '053' then 7 end
from #lDE_BankExportAOP I join #lDE_BankExportAOPs S on I.acAcct = substring(S.acAcct, 1, 3)
where I.acAcct like '190%'
and S.acAOPGroup = '053'

Update I set acSheet = '053 Krat.AČR',
anRow = case when S.acAOP = '053' then 8 end
from #lDE_BankExportAOP I join #lDE_BankExportAOPs S on I.acAcct = substring(S.acAcct, 1, 3)
where I.acAcct like '191%'
and S.acAOPGroup = '053'

Update I set acSheet = '053 Krat.AČR',
anRow = case when S.acAOP = '053' then 9 end
from #lDE_BankExportAOP I join #lDE_BankExportAOPs S on I.acAcct = substring(S.acAcct, 1, 3)
where I.acAcct like '192%'
and S.acAOPGroup = '053'

Update I set acSheet = '053 Krat.AČR',
anRow = case when S.acAOP = '053' then 10 end
from #lDE_BankExportAOP I join #lDE_BankExportAOPs S on I.acAcct = substring(S.acAcct, 1, 3)
where I.acAcct like '195%'
and S.acAOPGroup = '053'

end


............

log sam morao skratiti zbog limita u broju znakova...

Melisa,
da li vi ili ko već treba da pogleda stanje kod mene može da to radi poslije 18h i da li može da pristupi preko TeamViewer-a? Ako je to moguće, a i inače, zamolio bih vas da mi ostavite e-mail na koji mogu da pošaljem podatke za pristup...

POS X kada gledam ovako na slikama izgleda bolje nego trenutno rješenje, drago mi je da ste uzeli u obzir i neke moje prijedloge i ako mislim da je potrebno dodati i još neke funkcije za ubrzavanje i pojednostavljivanje rada kao i na to da je potrebno puno više da se misli na to da POS rješenja koriste i radnici koji nisu stručnjaci za pantheon, windows i ništa slično...konkretno, radnik na kasi u prodavnici nije nikakav stručnjak, često je samo sa osnovnom školom i jednostavno je nemoguće da mu se objasne neke stvari ako su malo složenije tj. potrebno je da sve bude što je više moguće jednostavno i da radi skoro pa perfektno, bilo kakva greška koja se pojavi, ako se zaledi prozor, ako počne program da se ponaša drugačije nego što je normalno...je katastrofa, znam to iz ličnog iskustva u poslednjih 10+ godina i to pantheon sa raznoraznim bubicama + moji radnici...

Hvala.

Melisa,
poslao sam e-mail, hvala.

Pozdrav Ratko,

jesmo, da. I o tome smo razmišljali, sada Pantheon ne provjerava odgovor, u POS X-u radimo na tome da Pantheon čeka odgovor od drivera. U slučaju da se desi error, račun ne prelazi u Potvrđen, no moram biti iskrena i reći da je dokumentacija dosta oskudna..

LP,
MELISA

Ratko,

ja sam Vama pisala 3 puta za fix, da mi javite kakva je situacija?
U prilogu screnshot s Help desk-a na kom sam evidentirala radni nalog.
Jeste li Vi probali brzu popravku ili?
Ja zapravo čekam odgovor od Vas :).

LP,
MELISA

Ratko,

jeste probali? Ako niste uspjeli naći email, slaću Vam privatno na email, mimo Help desk-a.

Hvala,
LP,
MELISA

Ratko,

hvala Vama na saradnji.
Ono što moram napomenuti jeste da sam 22.4. poslala na email Vama obavijest da sam provjerila sa programerom vezano za nedpstajuće primarne ključeve, te da imamo napismeno da isti ne utječu na Vaš rad.
"U FA_% tabelama (prvih 6 redova) i onda o 2 reda odnosno tabele koje nisu u PA standardu, ovi indexi ne utječu na rad ovog korisnika.
Ove zadnje 2 tabele Q_ZZI_EStoritve i Q_ZZI_EStoritve_Filter, ove 2 su samo u Sloveniji u upotrebi, tako da sve iz ovog ekrana nema utjecaja na rad ovog korisnika."

Slika u prilogu.

LP,
MELISA