home *** CD-ROM | disk | FTP | other *** search
- VERSION 2.00
- Begin Report VATPL-C.REP
- Caption = "VATPL-C.REP"
- Width = 11175
- Height = 15915
- Reportheader = 1545
- Header = 465
- Transaction = 12360
- SubTotal = 0
- Footer = 1020
- Pagefooter = 15660
- Replicate = 420
- Style = 0
- Query = "VATCASH "
- Macro = "2CD:When VATCASH.VCVALUE<>0 then REPTOT(0)=VATCASH.VCVALUE-VATCASH.VCVAT"
- Macro = "2CD:When VATCASH.VCTYPE="V" then REPTOT(0)=VATCASH.VCVALUE"
- Macro = "2CD:When VATCASH.VCMODULE<>"P" then skip 3"
- Macro = "2OF:@REPVARS.REPTOT(2) = REPTOT(2)+REPTOT(0)"
- Macro = "2OF:@REPVARS.REPTOT(3) = REPTOT(3)+VATCASH.VCVAT"
- Macro = "2CD:When VATCASH.VCMODULE<>"P" then NOPRINT()"
- Macro = "2PP:@REPVARS.REPTOT(0) = 0"
- Macro = "4PP:@REPVARS.REPTOT(0) = 0"
- Macro = "4PP:@REPVARS.REPTOT(1) = 0"
- Macro = "4PP:@REPVARS.REPTOT(2) = 0"
- Macro = "4PP:@REPVARS.REPTOT(3) = 0"
- End
- Begin Control LABEL
- Type = "Label"
- Style = 4
- Caption = "VAT Analysis Of Purchases"
- Font = "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Reportheader Block"
- Height = 420
- Left = 0
- Top = 675
- Width = 11025
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "DTOC(DATE())"
- Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Reportheader Block"
- Height = 285
- Left = 135
- Top = 705
- Width = 3285
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "PAGENUM()"
- Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Reportheader Block"
- Height = 285
- Left = 10395
- Top = 720
- Width = 585
- End
- Begin Control LABEL
- Type = "Label"
- Style = 2
- Caption = "Page:"
- Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Reportheader Block"
- Height = 285
- Left = 9720
- Top = 720
- Width = 585
- End
- Begin Control LABEL
- Type = "Label"
- Style = 12
- Caption = "TRIM(SYSTEM.COMPNAME))"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Reportheader Block"
- Height = 270
- Left = -15
- Top = 405
- Width = 11070
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "For The Period Ending"
- Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Reportheader Block"
- Height = 270
- Left = 3780
- Top = 1080
- Width = 2160
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "REPSTR(0)"
- Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Reportheader Block"
- Height = 270
- Left = 6210
- Top = 1080
- Width = 1215
- End
- Begin Control LABEL
- Type = "Label"
- Style = 2
- Caption = "Goods"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 5115
- Top = 75
- Width = 960
- End
- Begin Control LABEL
- Type = "Label"
- Style = 2
- Caption = "VAT"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 6330
- Top = 75
- Width = 960
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "Supplier ID"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 135
- Top = 75
- Width = 1410
- End
- Begin Control LABEL
- Type = "Label"
- Style = 4
- Caption = "Date"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 1875
- Top = 75
- Width = 645
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "Type"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 2925
- Top = 75
- Width = 465
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "Reference"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 3510
- Top = 75
- Width = 1140
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "VAT Code"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 7545
- Top = 75
- Width = 960
- End
- Begin Control VCACCOUNT
- Type = "Text"
- Style = 0
- Fieldname = "VCACCOUNT"
- Filename = "VATCASH"
- Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 135
- Top = 150
- Width = 1350
- End
- Begin Control VCDATE
- Type = "Text"
- Style = 0
- Fieldname = "VCDATE"
- Filename = "VATCASH"
- Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 1620
- Top = 150
- Width = 1080
- End
- Begin Control VCTYPE
- Type = "Text"
- Style = 0
- Fieldname = "VCTYPE"
- Filename = "VATCASH"
- Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 2970
- Top = 150
- Width = 270
- End
- Begin Control VCREF
- Type = "Text"
- Style = 0
- Fieldname = "VCREF"
- Filename = "VATCASH"
- Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 3510
- Top = 150
- Width = 1350
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "STR(REPTOT(0),10,2)"
- Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 4995
- Top = 150
- Width = 1125
- End
- Begin Control VCVAT
- Type = "Text"
- Style = 0
- Fieldname = "VCVAT"
- Filename = "VATCASH"
- Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 6210
- Top = 150
- Width = 1125
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(TRIM(VATCASH.VCTYPE)="V","VAT Adjustment due to unallocated cash"," "+VATCASH.VCALLOC)"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 7560
- Top = 150
- Width = 3645
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "STR(REPTOT(2),10,2)"
- Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Footer Block"
- Height = 270
- Left = 4995
- Top = 750
- Width = 1125
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "STR(REPTOT(3),10,2)"
- Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Footer Block"
- Height = 270
- Left = 6210
- Top = 750
- Width = 1125
- End
- Begin Control LABEL
- Type = "Label"
- Style = 2
- Caption = "Totals"
- Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Footer Block"
- Height = 270
- Left = 3510
- Top = 750
- Width = 1350
- End
-