Kada fiskalna RS ne vrati ispravno podatke, zaglavi racun

 

update tHE_Move 

set acFiscStatus = '4', adDateTimePrint = GetDate()

where acKey in ('25F0200001849', '25F0200001848')

 

 

delete tHE_MoveFiscalisation where acKey = '25F0200001849'

 

insert into tHE_MoveFiscalisation  (anMoveQid, acKey,acWorkPlace,anFiscalDevice,anFiscalNumber,acZIK,acJIR,acDocType,acYearInv,adTimeIns,anUserIns,adTimeChg,anUserChg,acError,adFiscalDate,acFiscalDevice,acBarcode,anFiscVersion,anQIdTemplate,acCustomTemplate,acIICSignature,acTCRCode,acWorkPlaceCode,adSDCTime,acCompanyTaxNumber,anInvoiceAmount,acInvoiceCounter,acLocation,acAddress,acDistrict,acZIKEC,adDateTimePrintEC,acUniqueID,acBusinessName,adSDCTimeCopy,acQRCode,acInvoiceText,acFiscalNumber,acRequestId,acDataSent)

select (select anQid from tHE_Move where acKey = '25F0200001849'), '25F0200001849', acWorkPlace,anFiscalDevice,anFiscalNumber,acZIK,acJIR,acDocType,acYearInv,adTimeIns,anUserIns,adTimeChg,anUserChg,acError,adFiscalDate,acFiscalDevice,acBarcode,anFiscVersion,anQIdTemplate,acCustomTemplate,acIICSignature,acTCRCode,acWorkPlaceCode,adSDCTime,acCompanyTaxNumber,anInvoiceAmount,acInvoiceCounter,acLocation,acAddress,acDistrict,acZIKEC,adDateTimePrintEC,acUniqueID,acBusinessName,adSDCTimeCopy,acQRCode,acInvoiceText,acFiscalNumber,acRequestId,acDataSent 

from tHE_MoveFiscalisation 

where acKey = '25F0200001848'

Detalji članka

ID članka:
172
Kategorija:
Ocjena :

Vezani članci