Arandegeneraatoriga tehtud aruanded
Mine navigeerimisribale
Mine otsikasti
Parim enne nimekiri
See Aruandegeneraatoriga tehtud aruanne parandab olukorra, kus orginaalaruanne ei kuva välja artiklit, kui tollel on ItemStatusVc kirjel Jäänud kogus 0. Aga peaks.
Määramisaken
Tulemus
| Art. nr | Nimetus | Partiinr | Parim Enne | Kogus | Hind | Hind kokku |
|---|---|---|---|---|---|---|
| 1000 | Artikkel 1 | БC876/24.07.2020 | 24.07.2020 | 4594 | 0,8231 | 3781,32 |
| 1001 | Artikkel 2 | БС851/16.06.2020 | 16.06.2020 | 5400 | 0,2585 | 1395,9 |
| 1001 | Artikkel 3 | БС851/21.03.2020 | 21.03.2020 | 605 | 0,2589 | 156,63 |
| 1001 | Artikkel 4 | БС851/25.07.2020 | 25.07.2020 | 7560 | 0,2714 | 2051,78 |
| 1002 | Artikkel 5 | БC850/11.05.2020 | 11.05.2020 | 1481 | 0,2575 | 381,36 |
| 1002 | Artikkel 6 | БC850/16.06.2020 | 16.06.2020 | 3240 | 0,2584 | 837,22 |
| 1002 | Artikkel 7 | БC850/26.07.2020 | 26.07.2020 | 7560 | 0,2714 | 2051,78 |
| 1003 | Artikkel 8 | БС852/24.07.2020 | 24.07.2020 | 856 | 0,7645 | 654,41 |
| 1013 | Artikkel 9 | БС854/08.06.2020 | 08.06.2020 | 112 | 1,1732 | 131,4 |
| 1017 | Artikkel 10 | БC859/04.05.2020 | 04.05.2020 | 1 | 0,7554 | 0,76 |
Kood
format
1 44 1 0 0 0 0 . 0
codepage UTF-8
HansaVersion
8.5 2019-09-15 (build 85321107) StandardBooksExcellent
repgen2
43D38254-974C8533-EA62AF98-1F754035-BE87C78C 0 1 PARIMENNE Seerianumbri ajalugu 6 0 780 0 500 0 00000000-00000000-00000000-00000000-00000000
4 Klass Groupr 1 1 4 0 0 0 0 ITVc INVc 0 130 66 80 0 0 0 0 0
3 testf false 1 1 1 0 0 0 0 ITVc INVc 0 130 66 80 0 0 0 0 0
2 Serbalr SerBalVc 1 1 4 0 0 0 Item 0 Artikkel INVc 0 130 6 80 0 0 0 0 0
14 INr INVc 5 0 1 0 Code 0 Ladu Serbalr.Item 0 130 46 80 0 0 0 0 0
6 Location 5 0 1 0 0 Ladu LocationVc 0 130 86 80 0 0 0 0 0
6 0 Quant 1 2 4 0 1 1 Item 0 0 130 0 0 0 0 0 0
6 Item 5 0 1 0 0 Artikkel INVc 0 130 26 100 0 0 0 0 0
6 NewBestBefore 5 0 1 0 0 Periood PerSClass 0 130 46 140 0 0 0 0 0
7 testf=false; INVc 5 0 1 0 Code 0 Ladu Serbalr.Item 0 130 46 80 0 0 0 0 0
7 if (Blank(Groupr)) then begin testf=true; end; 5 0 1 0 0 0 0 0 0 0 0
7 if (Groupr==INr.Group) then begin testf=true; end; INVc 5 0 1 0 Code 0 Ladu Serbalr.Item 0 130 46 80 0 0 0 0 0
7 if(INr.Terminated==1) then begin testf=false; end; 5 0 1 0 0 0 0 0 0 0 0
10 testf INVc 5 0 1 0 Code 0 Ladu Serbalr.Item 0 130 46 80 0 0 0 0 0
13 5 0 -1 0 0 0 0 0 0 0 0
13 0 0 1 0 0 0 0 0 0 0 0
17 0 0 0 1 0 0 15 0 0 0 0 0 0
18 Art. nr 0 0 80 0 1 0 1 0 0 0 0 0 0 0 0
18 Nimetus 0 90 170 0 1 0 1 0 0 0 0 0 0 0 0
18 Partiinr 0 320 400 0 1 0 1 0 0 0 0 0 0 0 0
18 Parim Enne 0 430 490 0 1 0 1 0 0 0 0 0 0 0 0
18 Kogus 1 500 580 0 1 0 1 0 0 0 0 0 0 0 0
18 Hind 1 590 670 0 1 0 1 0 0 0 0 0 0 0 0
13 1 0 1 0 0 0 0 0 0 0 0
17 0 0 0 1 0 1 15 0 0 0 0 0 0
12 Item 0 0 80 0 0 0 1 0 1 0 0 0 0 0 0
1 INr.Name 0 90 170 0 0 0 1 0 1 0 0 0 0 0 0
12 Serial 0 320 400 0 0 0 1 0 1 0 0 0 0 0 0
12 NewBestBefore 0 430 490 0 2 0 1 0 1 0 0 0 0 0 0
12 Quant 1 500 580 0 0 0 1 0 1 0 0 0 0 0 0
12 CostPrice 1 590 670 0 0 0 1 0 1 0 0 0 0 0 0
1 Serbalr.CostPrice*Serbalr.Quant 1 680 760 0 1 0 1 0 1 2 0 0 0 0 0 0
13 2 0 1 0 0 0 0 0 0 0 0
17 1 3 0 1 0 2 15 0 0 0 0 0 0
13 3 0 1 0 0 0 0 0 0 0 0
17 1 0 0 1 0 3 15 0 0 0 0 0 0
11 Quant 1 500 580 1 0 0 1 0 3 0 1 0 0 0 0
Tellimuste komplekteerimine
See aruanne võimaldab Komplekteerimislehte genereerida ka mitte-lao artiklitele.
Määramisaken
Tulemus
| Artikkel | Nimetus | Lähet. kogus |
|---|---|---|
| 65413 | Lahtine suur tomat 1. klass | 13,00 |
| 12354 | Kirsstomat 1.klass | 443,00 |
| KA | Kaubaalus 800*600 PILBAS | 4,00 |
| KAUP | kaup | 234,00 |
| KIT | Kirsstomat 1.klass | 229,50 |
| KT | Kokteiltomat 1.klass | 251,90 |
| KTK | Kollane kirsstomat 1.kl | 54,00 |
| LIT | Lihatomat 1.klass | 296,70 |
| LT | Lihatomat mittestandardne | 319,10 |
| MPT | Miniploomtomat 1.klass | 341,50 |
| OT | Oranž kirsst. 1.klass | 363,90 |
| PMT | Piklik minit. 1.klass | 5,00 |
| PT | Ploomt 1.klass | 408,70 |
| SPT | Suur ploomtomat 1.klass | 0,00 |
| TKT | Tume-kirju t. 1.klass | 0,00 |
| TO | Lahtine suur tomat 1. klass | 3,00 |
| TRT | Triibuline-kirju tomat 1.klass | 498,30 |
| VT | Vaarikatomat 1.klass | 520,70 |
Kood
format
1 44 1 0 0 0 0 . 0
codepage UTF-8
HansaVersion
8.5 2019-09-15 (build 85321107) StandardBooksExcellent
repgen2
0257B007-92547B3D-FAC35577-34F3717B-6F342937 0 1 TELLKOMP Tellimuste komplekteerimine 6 0 600 0 500 0 00000000-00000000-00000000-00000000-00000000
4 Klient klient 0 1 4 0 -1 0 0 CUVc 0 130 46 80 0 0 0 0 0
4 Läh kp lkp 0 1 4 0 -1 0 0 PasteCurDate 0 130 26 80 0 0 0 0 0
3 itquant 0 0 1 11 0 -1 0 SerNr 0 0 0 0 0 0 0
2 INr INVc 0 1 4 0 -1 0 Code 0 0 0 0 0 0 0
6 Group 4 0 0 0 0 Artikliklass ITVc 0 130 6 80 0 0 0 0 0
7 itquant=0 Group 4 0 0 0 0 Artikliklass ITVc 0 130 6 80 0 0 0 0 0
2 ORr ORVc 1 2 4 0 0 0 SerNr 0 Artikliklass ITVc 0 130 6 80 0 0 0 0 0
6 PlanShip 1 2 4 0 1 0 SerNr 0 lkp 0 130 0 0 0 0 0 0
6 CustCode 4 0 1 0 0 klient 0 130 0 0 0 0 0 0
16 ORrw ORVc 2 3 4 0 1 0 ORr 0 0 130 0 0 0 0 0 0
7 if (ORrw.ArtCode==INr.Code) then begin itquant=itquant+ORrw.Quant; end; 4 0 2 0 0 0 0 0 0 0 0
2 IORr ORVc 3 1 4 0 0 0 SerNr 0 Artikliklass ITVc 0 130 6 80 0 0 0 0 0
6 PlanShip 2 3 4 0 3 0 ORr 0 lkp 0 130 0 0 0 0 0 0
6 CustCode 4 0 3 0 0 klient 0 130 0 0 0 0 0 0
13 4 0 -1 0 0 0 0 0 0 0 0
13 5 0 -1 0 0 0 0 0 0 0 0
13 0 0 0 0 0 0 0 0 0 0 0
17 0 0 0 0 0 0 15 0 0 0 0 0 0
18 Artikkel 0 0 80 0 1 0 0 0 0 0 0 0 0 0 0
18 Nimetus 0 90 170 0 1 0 0 0 0 0 0 0 0 0 0
18 Lähet. kogus 1 390 460 0 1 0 0 0 0 0 0 0 0 0 0
13 1 0 0 0 0 0 0 0 0 0 0
17 0 0 0 0 0 1 15 0 0 0 0 0 0
13 2 0 0 0 0 0 0 0 0 0 0
17 0 0 0 0 0 2 15 0 0 0 0 0 0
12 Code 0 0 80 0 0 0 0 0 2 1 0 0 0 0 0
12 Name 0 90 170 0 0 0 0 0 2 0 0 0 0 0 0
1 itquant 1 380 460 0 1 0 0 0 2 0 0 0 0 0 0
13 3 0 0 0 0 0 0 0 0 0 0
17 0 0 0 0 1 3 15 0 0 0 0 0 0
13 0 0 1 0 0 0 0 0 0 0 0
13 1 0 1 0 0 0 0 0 0 0 0
13 2 0 1 0 0 0 0 0 0 0 0
13 3 0 1 0 0 0 0 0 0 0 0
13 0 0 2 0 0 0 0 0 0 0 0
13 1 0 2 0 0 0 0 0 0 0 0
13 2 0 2 0 0 0 0 0 0 0 0
13 3 0 2 0 0 0 0 0 0 0 0
13 0 0 3 0 0 0 0 0 0 0 0
17 0 0 0 3 0 0 15 0 0 0 0 0 0
18 Tellimus 0 0 80 0 1 0 3 0 0 0 0 0 0 0 0
18 Klient 0 90 170 0 1 0 3 0 0 0 0 0 0 0 0
13 1 0 3 0 0 0 0 0 0 0 0
17 0 0 0 3 0 1 15 0 0 0 0 0 0
12 SerNr 0 0 80 0 2 0 3 0 1 1 0 0 0 0 0
12 CustCode 0 90 170 0 2 0 3 0 1 0 0 0 0 0 0
12 Addr0 0 180 260 0 2 0 3 0 1 0 0 0 0 0 0
13 2 0 3 0 0 0 0 0 0 0 0
13 3 0 3 0 0 0 0 0 0 0 0