View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000470БухгалтерияGeneralpublic2013-03-06 21:042013-04-17 17:17
Reporterruslan Assigned Tobarry  
PriorityurgentSeveritymajorReproducibilityalways
Status closedResolutionfixed 
PlatformКСАП ГранитOSWindows 
Summary0000470: +/-Бухгалтерский учет-выгрузка реестра налоговых накладных XML новый реестр НН версия 6
DescriptionВышли изменения к реестру НН по приказу МФУ № 1340 от 17.12.2012. Изменения комплексные, в приложенном файле. Список полей и форму рееестра приложи в архиве, образец выгрузки из ОПЗ, тоже приложил.
TagsNo tags attached.

Activities

ruslan

2013-03-06 21:04

manager  

Техническое задание да доработку по реестру НН 2013.doc (87,040 bytes)

ruslan

2013-03-06 21:05

manager  

J1201506.pdf (107,365 bytes)

ruslan

2013-03-06 21:11

manager  

20360023454034J1201506100000000110320132036.xml (5,175 bytes)    
<?xml version="1.0" encoding="windows-1251"?>
<DECLAR xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="J1201506.xsd">
	<DECLARHEAD>
		<TIN>23454034</TIN>
		<C_DOC>J12</C_DOC>
		<C_DOC_SUB>015</C_DOC_SUB>
		<C_DOC_VER>6</C_DOC_VER>
		<C_DOC_TYPE>0</C_DOC_TYPE>
		<C_DOC_CNT>1</C_DOC_CNT>
		<C_REG>20</C_REG>
		<C_RAJ>36</C_RAJ>
		<PERIOD_MONTH>3</PERIOD_MONTH>
		<PERIOD_TYPE>1</PERIOD_TYPE>
		<PERIOD_YEAR>2013</PERIOD_YEAR>
		<C_STI_ORIG>2036</C_STI_ORIG>
		<C_DOC_STAN>1</C_DOC_STAN>
		<LINKED_DOCS xsi:nil="true"></LINKED_DOCS>
		<D_FILL>06032013</D_FILL>
		<SOFTWARE>OPZ 1.30.14</SOFTWARE>
	</DECLARHEAD>
	<DECLARBODY>
		<HZ>1</HZ>
		<HNP>1</HNP>
		<HZY>2013</HZY>
		<HZM>3</HZM>
		<HKV xsi:nil="true"></HKV>
		<HNAME>�� "��"�²�-����"</HNAME>
		<HNPDV>234540320391</HNPDV>
		<HNSPDV>100318800</HNSPDV>
		<T1RXXXXG1 ROWNUM="1">1</T1RXXXXG1>
		<T1RXXXXG1 ROWNUM="2">2</T1RXXXXG1>
		<T1RXXXXG2D ROWNUM="1">01032013</T1RXXXXG2D>
		<T1RXXXXG2D ROWNUM="2">01032013</T1RXXXXG2D>
		<T1RXXXXG3S ROWNUM="1">1</T1RXXXXG3S>
		<T1RXXXXG3S ROWNUM="2">2</T1RXXXXG3S>
		<T1RXXXXG41S ROWNUM="1">���</T1RXXXXG41S>
		<T1RXXXXG41S ROWNUM="2">���</T1RXXXXG41S>
		<T1RXXXXG5S ROWNUM="1">�������� ��</T1RXXXXG5S>
		<T1RXXXXG5S ROWNUM="2">���� ��� "��� ����� ���."</T1RXXXXG5S>
		<T1RXXXXG6 ROWNUM="1">004457710365</T1RXXXXG6>
		<T1RXXXXG6 ROWNUM="2">239182820397</T1RXXXXG6>
		<T1RXXXXG7 ROWNUM="1">43680.00</T1RXXXXG7>
		<T1RXXXXG7 ROWNUM="2">24240.00</T1RXXXXG7>
		<T1RXXXXG8 ROWNUM="1">36400.00</T1RXXXXG8>
		<T1RXXXXG8 ROWNUM="2">20200.00</T1RXXXXG8>
		<T1RXXXXG9 ROWNUM="1">7280.00</T1RXXXXG9>
		<T1RXXXXG9 ROWNUM="2">4040.00</T1RXXXXG9>
		<R011G7>67920.00</R011G7>
		<R011G8>56600.00</R011G8>
		<R011G9>11320.00</R011G9>
		<R011G10 xsi:nil="true"></R011G10>
		<R011G11 xsi:nil="true"></R011G11>
		<R011G12 xsi:nil="true"></R011G12>
		<R011G13 xsi:nil="true"></R011G13>
		<R012G7 xsi:nil="true"></R012G7>
		<R012G8 xsi:nil="true"></R012G8>
		<R012G9 xsi:nil="true"></R012G9>
		<R012G10 xsi:nil="true"></R012G10>
		<R012G11 xsi:nil="true"></R012G11>
		<R012G12 xsi:nil="true"></R012G12>
		<R012G13 xsi:nil="true"></R012G13>
		<T2RXXXXG1 ROWNUM="1">1</T2RXXXXG1>
		<T2RXXXXG1 ROWNUM="2">2</T2RXXXXG1>
		<T2RXXXXG1 ROWNUM="3">3</T2RXXXXG1>
		<T2RXXXXG1 ROWNUM="4">4</T2RXXXXG1>
		<T2RXXXXG2D ROWNUM="1">01032013</T2RXXXXG2D>
		<T2RXXXXG2D ROWNUM="2">04032013</T2RXXXXG2D>
		<T2RXXXXG2D ROWNUM="3">04032013</T2RXXXXG2D>
		<T2RXXXXG2D ROWNUM="4">04032013</T2RXXXXG2D>
		<T2RXXXXG3D ROWNUM="1">01032013</T2RXXXXG3D>
		<T2RXXXXG3D ROWNUM="2">04032013</T2RXXXXG3D>
		<T2RXXXXG3D ROWNUM="3">04032013</T2RXXXXG3D>
		<T2RXXXXG3D ROWNUM="4">04032013</T2RXXXXG3D>
		<T2RXXXXG4S ROWNUM="1">10</T2RXXXXG4S>
		<T2RXXXXG4S ROWNUM="2">4</T2RXXXXG4S>
		<T2RXXXXG4S ROWNUM="3">12</T2RXXXXG4S>
		<T2RXXXXG4S ROWNUM="4">11</T2RXXXXG4S>
		<T2RXXXXG51S ROWNUM="1">���</T2RXXXXG51S>
		<T2RXXXXG51S ROWNUM="2">���</T2RXXXXG51S>
		<T2RXXXXG51S ROWNUM="3">���</T2RXXXXG51S>
		<T2RXXXXG51S ROWNUM="4">���</T2RXXXXG51S>
		<T2RXXXXG52S ROWNUM="2">�</T2RXXXXG52S>
		<T2RXXXXG52S ROWNUM="3">�</T2RXXXXG52S>
		<T2RXXXXG52S ROWNUM="4">�</T2RXXXXG52S>
		<T2RXXXXG53S ROWNUM="3">�</T2RXXXXG53S>
		<T2RXXXXG6S ROWNUM="1">��������� ���</T2RXXXXG6S>
		<T2RXXXXG6S ROWNUM="2">����� Բ�� ���</T2RXXXXG6S>
		<T2RXXXXG6S ROWNUM="3">���� ��� "��� ����� ���."</T2RXXXXG6S>
		<T2RXXXXG6S ROWNUM="4">����� Բ�� ���</T2RXXXXG6S>
		<T2RXXXXG7 ROWNUM="1">324381520348</T2RXXXXG7>
		<T2RXXXXG7 ROWNUM="2">317662120387</T2RXXXXG7>
		<T2RXXXXG7 ROWNUM="3">239182820397</T2RXXXXG7>
		<T2RXXXXG7 ROWNUM="4">317662120387</T2RXXXXG7>
		<T2RXXXXG8 ROWNUM="1">1319.76</T2RXXXXG8>
		<T2RXXXXG8 ROWNUM="2">2072.65</T2RXXXXG8>
		<T2RXXXXG8 ROWNUM="3">1492.98</T2RXXXXG8>
		<T2RXXXXG8 ROWNUM="4">192.00</T2RXXXXG8>
		<T2RXXXXG9 ROWNUM="1">1099.80</T2RXXXXG9>
		<T2RXXXXG9 ROWNUM="2">1714.65</T2RXXXXG9>
		<T2RXXXXG9 ROWNUM="3">1234.15</T2RXXXXG9>
		<T2RXXXXG9 ROWNUM="4">150.00</T2RXXXXG9>
		<T2RXXXXG10 ROWNUM="1">219.96</T2RXXXXG10>
		<T2RXXXXG10 ROWNUM="2">340.00</T2RXXXXG10>
		<T2RXXXXG10 ROWNUM="3">246.83</T2RXXXXG10>
		<T2RXXXXG10 ROWNUM="4">30.00</T2RXXXXG10>
		<T2RXXXXG11 ROWNUM="2">15.00</T2RXXXXG11>
		<T2RXXXXG12 ROWNUM="2">3.00</T2RXXXXG12>
		<T2RXXXXG13 ROWNUM="3">10.00</T2RXXXXG13>
		<T2RXXXXG14 ROWNUM="3">2.00</T2RXXXXG14>
		<T2RXXXXG15 ROWNUM="4">12.00</T2RXXXXG15>
		<R021G8>5077.39</R021G8>
		<R021G9>4198.60</R021G9>
		<R021G10>836.79</R021G10>
		<R021G11>15.00</R021G11>
		<R021G12>3.00</R021G12>
		<R021G13>10.00</R021G13>
		<R021G14>2.00</R021G14>
		<R021G15>12.00</R021G15>
		<R021G16>2.40</R021G16>
		<R022G8>1492.98</R022G8>
		<R022G9>1234.15</R022G9>
		<R022G10>246.83</R022G10>
		<R022G11 xsi:nil="true"></R022G11>
		<R022G12 xsi:nil="true"></R022G12>
		<R022G13>10.00</R022G13>
		<R022G14>2.00</R022G14>
		<R022G15 xsi:nil="true"></R022G15>
		<R022G16 xsi:nil="true"></R022G16>
		<HFILL>06032013</HFILL>
		<HBOS>������� �.�.</HBOS>
		<HKBOS>2748911612</HKBOS>
		<HBUH>������ �.�.</HBUH>
		<HKBUH>2802900660</HKBUH>
	</DECLARBODY>
</DECLAR>
20360023454034J1201506100000000110320132036.xml (5,175 bytes)   

ruslan

2013-03-13 17:09

manager   ~0001160

Last edited: 2013-03-13 17:28

View 2 revisions

 1.В модуле Расчеты с Кредиторами-Журнал учета покупок-В функции Отмена пересчета НН(справа от кнопки Печерсчет НН) - в обработчике добавь, чтоб при отмене пересчета снимало флаг Разделение суммы НК.
2. В Журнале учета Покупок переименуй заголовки колонок:
"Форма Оплаты" в "Вид док."
Дата н/н в Дата получ.н/н
Дата оплаты в Дата вып.н/н
3. Добавь колонки в Журнал учета покупок в список документов:
- Вкл. в уточ. расчет(флаг в форме)
- Раздел.сум.НК(флаг Разделение суммы налогового кредита в форме )

ruslan

2013-03-13 17:21

manager   ~0001161

В модуле Расчеты с Дебиторами в Журнал учета продаж в список документов добавь поля:
- Номер корректировки
- Тип причины
- Вкл. в ут.расч.(включена в уточняющий расчет)
И переименуй заголовок колонки "Ф.плат" в "Вид.док"

ruslan

2013-03-25 16:24

manager   ~0001167

Я немного подправил процедуру для корректного расчета ситуации с разделяемым кредитом, исправь и у себя...
alter procedure BOOKSLKT_JOURNAL1 (
    ID integer)
returns (
    RECALC integer,
    NK1 integer,
    S8 double precision,
    S9 double precision,
    S10 double precision,
    S11 double precision,
    S12 double precision,
    S13 double precision,
    S14 double precision,
    S15 double precision,
    S16 double precision)
as
declare variable SUMMA double precision;
declare variable NDS double precision;
declare variable NSUMMA double precision;
declare variable KSUMMA double precision;
declare variable KNDS double precision;
declare variable NNDS integer;
declare variable FNDS integer;
declare variable FFNDS integer;
declare variable NEW_CHECK integer;
declare variable CBNDS integer;
begin
  s8 = 0.0; s9 = 0.0; s10 = 0.0;
  s11 = 0.0; s12 = 0.0; s13 = 0.0;
  s14 = 0.0; s15 = 0.0; s16 = 0.0;

  select NNds, FNds, FFNds, Summa, Nds, NSumma, KSumma, New_Check, cbNds, ReCalc, Nk1
  from BookSlKt K
  where ID = :ID
  into :NNds, :FNds, :FFNds, :Summa, :Nds, :NSumma, :KSumma, :new_check, :cbNds, :ReCalc, :Nk1;
  if (:NNds is null) then NNds = 0;
  if (:FNds is null) then FNds = 0;
  if (:FFNds is null) then FFNds = 0;
  if (:Summa is null) then Summa = 0.0;
  if (:Nds is null) then Nds = 0.0;
  if (:NSumma is null) then NSumma = 0.0;
  if (:KSumma is null) then KSumma = 0.0;
  KNds = KSumma / 6.00;
  s8 = :Summa;
  if (:kSumma <> 0.0) then s8 = :kSumma;
  if (New_Check = 0) then begin -- у господарськой діяльності 20%, 0%
     if (:Nds <> 0.0) then begin
       if (:cbNds = 1) then s9 = :Summa-:Nds;
       else s9 = :Nds * 5;
     end
     else begin
       s9 = :Summa;
     end
     s10 = :Nds;
  end
  if (:New_Check = 1) then begin -- звільнені, не є об'єктами
     if (:Nds <> 0.0) then begin
       if (:cbNds = 1) then s11 = :Summa-:Nds;
       else s11 = :Nds * 5;
     end
     else begin
       s11 = :Summa;
     end
     s12 = :Nds;
  end
  if (:New_Check = 2) then begin -- не призначаються у госп. діяльності
     if (:Nds <> 0.0) then begin
       if (:cbNds = 1) then s13 = :Summa-:Nds;
       else s13 = :Nds * 5;
     end
     else begin
       s13 = :Summa;
     end
     s14 = :Nds;
  end
  if (:New_Check = 3) then begin -- для поставки послуг по пункту 6.5 статті 6
     if (:Nds <> 0.0) then begin
       if (:cbNds = 1) then s15 = :Summa-:Nds;
       else s15 = :Nds * 5;
     end
     else begin
       s15 = :Summa;
     end
     s16 = :Nds;
  end
  if (:ffNds=5 and :nSumma <> 0.0) then begin
    s11 = s11 + :nSumma * 5;
    s12 = s12 + :nSumma;
    s9 = s9 - :nSumma * 5;
    s10 = s10 - :nSumma;
  end
  if (:ffNds=6 and :nSumma <> 0.0) then begin
    s13 = s13 + :nSumma * 5;
    s14 = s14 + :nSumma;
    s9 = s9 - :nSumma * 5;
    s10 = s10 - :nSumma;
  end
  if (:ffNds=7 and :nSumma <> 0.0) then begin
    s15 = s15 + :nSumma * 5;
    s16 = s16 + :nSumma;
    s9 = s9 - :nSumma * 5;
    s10 = s10 - :nSumma;
  end
  if (:kSumma <> 0) then begin
        s9 = :kSumma / 6 * 5;
        s10 =:kSumma / 6;
  end
  suspend;
end

Issue History

Date Modified Username Field Change
2013-03-06 21:04 ruslan New Issue
2013-03-06 21:04 ruslan File Added: Техническое задание да доработку по реестру НН 2013.doc
2013-03-06 21:05 ruslan File Added: J1201506.pdf
2013-03-06 21:11 ruslan File Added: 20360023454034J1201506100000000110320132036.xml
2013-03-13 17:09 ruslan Note Added: 0001160
2013-03-13 17:21 ruslan Note Added: 0001161
2013-03-13 17:28 ruslan Note Edited: 0001160 View Revisions
2013-03-25 16:24 ruslan Note Added: 0001167
2013-04-03 18:59 barry Status new => resolved
2013-04-03 18:59 barry Resolution open => fixed
2013-04-03 18:59 barry Assigned To => barry
2013-04-17 17:17 ruslan Status resolved => closed