1
00:00:00,919 --> 00:00:03,220
i'm ok taxes 2013 tutorials

2
00:00:03,220 --> 00:00:07,378
in this video I'm gonna be continuing talking about invoices

3
00:00:07,378 --> 00:00:11,209
a shame this is the seventh figure in that little mini series

4
00:00:11,210 --> 00:00:14,710
and and in this video were gonna be creating

5
00:00:14,710 --> 00:00:17,830
the I'll just cleary

6
00:00:17,829 --> 00:00:22,099
that will be based off of the union query made in a previous videos

7
00:00:22,100 --> 00:00:25,160
rather than me try to explain I'll show you so

8
00:00:25,160 --> 00:00:29,480
if you I wanna play along funneling blood video to them a section website

9
00:00:29,480 --> 00:00:31,099
teletext 2013

10
00:00:31,099 --> 00:00:35,058
the B-fifty an open at one up in

11
00:00:35,058 --> 00:00:38,890
2013 take passwords password

12
00:00:38,890 --> 00:00:43,620
now we are in mid love making an invoicing

13
00:00:43,619 --> 00:00:47,199
City Africa invoices

14
00:00:47,200 --> 00:00:50,700
a you can see we've got the invoice study she

15
00:00:50,700 --> 00:00:53,969
here time we've got an invoice

16
00:00:53,969 --> 00:00:58,789
at that arent reform period we fix it charges and payments just great

17
00:00:58,789 --> 00:01:03,530
how we can add up paying by clicking on make payment will probably add a column

18
00:01:03,530 --> 00:01:04,900
in there some point too says

19
00:01:04,900 --> 00:01:08,299
print which says print actually so we can print the invoice

20
00:01:08,299 --> 00:01:12,860
to now we've got the soda data entry Parveen voices without any to move to

21
00:01:12,859 --> 00:01:13,739
making actual

22
00:01:13,739 --> 00:01:17,609
invoice itself which is basically a a report in access

23
00:01:17,609 --> 00:01:21,060
and it will contain a supper for at more minutes do

24
00:01:21,060 --> 00:01:24,700
is we need to take a look at wary

25
00:01:24,700 --> 00:01:29,200
which carry on cost payments Union so we're gonna do is we're going to take

26
00:01:29,200 --> 00:01:30,759
the square each

27
00:01:30,759 --> 00:01:35,728
we're gonna drop into another query and reagan new and use couple the lookup

28
00:01:35,728 --> 00:01:36,259
function

29
00:01:36,259 --> 00:01:40,879
messaging expand on their and used as the basis for the sub before

30
00:01:40,879 --> 00:01:44,670
Sonus five straight into that's a closer close to

31
00:01:44,670 --> 00:01:49,219
gonna create click concrete design and

32
00:01:49,219 --> 00:01:52,489
from show table click on query costs

33
00:01:52,489 --> 00:01:56,000
payments Union and close to and let me just

34
00:01:56,000 --> 00:02:00,340
prime ice cream which you cannot see

35
00:02:00,340 --> 00:02:05,130
I think LP bit strange she could correct we want firm

36
00:02:05,129 --> 00:02:08,549
query costs payments Union well everything

37
00:02:08,550 --> 00:02:15,150
as it happens but there is

38
00:02:15,150 --> 00:02:18,950
I something i wanna show you chuckle the multiplier I'm

39
00:02:18,949 --> 00:02:22,699
which is if we run it when we create the

40
00:02:22,699 --> 00:02:27,369
subir por and this supposed to be based the for this query work rating now

41
00:02:27,370 --> 00:02:30,759
we wanted to have a little running some and

42
00:02:30,759 --> 00:02:34,878
so what we wanted to do is needs to identify whether

43
00:02:34,878 --> 00:02:39,018
an amount should be added to the run it running some or subtracted

44
00:02:39,019 --> 00:02:44,730
from running some and so at the moment all the amounts a positive for what we

45
00:02:44,729 --> 00:02:45,689
want to do

46
00:02:45,689 --> 00:02:49,789
is we wanna make payments positive

47
00:02:49,789 --> 00:02:53,159
you wanna make anything else negatives

48
00:02:53,159 --> 00:02:56,310
a.m. still idea being to

49
00:02:56,310 --> 00:03:02,680
ish said made any payment at all the transaction hero this is just a

50
00:03:02,680 --> 00:03:07,810
four nights in a room because 480 that should be minus 480

51
00:03:07,810 --> 00:03:11,598
I'm so -4 eighty means that the hotel's out for 80

52
00:03:11,598 --> 00:03:15,780
and if you go down to payment which has 840 that's definitely a plus cuz that's

53
00:03:15,780 --> 00:03:17,250
money been given to the hotel

54
00:03:17,250 --> 00:03:20,310
if that's not too clear don't worry I

55
00:03:20,310 --> 00:03:24,068
this video next video you get very clear I deformed trying to do

56
00:03:24,068 --> 00:03:27,810
so anyway miss going to designed you clicking here

57
00:03:27,810 --> 00:03:30,870
to build a and coolest to

58
00:03:30,870 --> 00:03:34,319
multiply your she an

59
00:03:34,318 --> 00:03:37,589
very simple just put open close but a shoebox

60
00:03:37,590 --> 00:03:41,539
money to make his property she and we are looking at item

61
00:03:41,539 --> 00:03:45,389
I'm gonna say if and SC

62
00:03:45,389 --> 00:03:48,759
I F which is the major if a.m.

63
00:03:48,759 --> 00:03:52,979
item for in open/close

64
00:03:52,979 --> 00:03:56,199
square brackets if item equals

65
00:03:56,199 --> 00:04:00,378
and then open/close single quotation marks payment

66
00:04:00,378 --> 00:04:04,158
its payment payments payment thing

67
00:04:04,158 --> 00:04:07,829
comma the troop are should be

68
00:04:07,830 --> 00:04:11,069
one magic was payment yes one

69
00:04:11,068 --> 00:04:14,988
comma -1 clothes off

70
00:04:14,989 --> 00:04:19,709
an empress run so when a cruise payment

71
00:04:19,709 --> 00:04:25,590
we get a1 and when it anything else is in a payment we return -1

72
00:04:25,589 --> 00:04:29,769
then what we do got another column

73
00:04:29,769 --> 00:04:34,310
to build a man who dis amount and just it

74
00:04:34,310 --> 00:04:38,129
McCullum and its sequel to

75
00:04:38,129 --> 00:04:43,019
multiplier which weren't playing Wii safest

76
00:04:43,019 --> 00:04:47,339
know me accept that okay sega's clarion call query

77
00:04:47,339 --> 00:04:50,339
costs payments

78
00:04:50,339 --> 00:04:54,539
Union salted

79
00:04:54,540 --> 00:04:57,550
I was one pick up most like to go back in there

80
00:04:57,550 --> 00:05:02,240
builder amount just it

81
00:05:02,240 --> 00:05:05,389
and its multiplier

82
00:05:05,389 --> 00:05:09,900
times amount

83
00:05:09,899 --> 00:05:14,638
Emerson to now said showing 480

84
00:05:14,639 --> 00:05:18,930
texture -4 eighty so showing 6 is shown -0600

85
00:05:18,930 --> 00:05:24,280
for the payments hair shiny for you here still show in 843

86
00:05:24,279 --> 00:05:27,279
done exactly what we wanted to do for the

87
00:05:27,279 --> 00:05:30,819
a amount to just it next

88
00:05:30,819 --> 00:05:34,250
we need to you and get the VAT rate she

89
00:05:34,250 --> 00:05:38,478
and restoring the VAT rate in

90
00:05:38,478 --> 00:05:42,168
table invoices think

91
00:05:42,168 --> 00:05:45,799
note your tale in which is VAT

92
00:05:45,800 --> 00:05:49,250
amico booking ID FK which we've also got here okay

93
00:05:49,250 --> 00:05:52,370
so we're going to use the booking ID from here

94
00:05:52,370 --> 00:05:55,918
to return the VAT rate

95
00:05:55,918 --> 00:06:00,318
so taken next problem I'm call this one VAT

96
00:06:00,319 --> 00:06:03,979
rate city aka says can look up

97
00:06:03,978 --> 00:06:07,168
the value i'm looking up

98
00:06:07,168 --> 00:06:11,818
I am things just VAT rate

99
00:06:11,819 --> 00:06:14,949
hospital VAT remember to in

100
00:06:14,949 --> 00:06:18,449
open/close square brackets

101
00:06:18,449 --> 00:06:24,970
an table invoices

102
00:06:24,970 --> 00:06:31,740
I am where

103
00:06:31,740 --> 00:06:36,120
looking ID FK

104
00:06:36,120 --> 00:06:40,149
peak rules ampersand booking ID if you know

105
00:06:40,149 --> 00:06:44,299
exactly 12 enough cover dislike quite a few times and other

106
00:06:44,300 --> 00:06:47,889
tutorials a.m. so yeah

107
00:06:47,889 --> 00:06:53,150
okay okay rhonda and nothing changed the wrong

108
00:06:53,149 --> 00:06:56,638
yes just VAT so back to design the

109
00:06:56,639 --> 00:06:59,949
VAT rate so just changed

110
00:06:59,949 --> 00:07:05,009
VAT takes an hour work fine

111
00:07:05,009 --> 00:07:08,060
weakens your point two minutes leaving the rest is no

112
00:07:08,060 --> 00:07:11,310
which is good I think

113
00:07:11,310 --> 00:07:17,639
okay so now what we need to do is you need to multiply the amount adjusted

114
00:07:17,639 --> 00:07:22,370
by already at the VAT to do not adjust its okay what would a

115
00:07:22,370 --> 00:07:27,209
for the design view to you too VAT rate

116
00:07:27,209 --> 00:07:30,948
let's just that in an ends at function so ends that

117
00:07:30,949 --> 00:07:34,060
from bracket not the end comma

118
00:07:34,060 --> 00:07:37,598
0 close brackets and now anything that's no

119
00:07:37,598 --> 00:07:41,949
have a zero and we're gonna say

120
00:07:41,949 --> 00:07:48,949
a.m. amount including VAT here

121
00:07:50,550 --> 00:07:55,579
and that's gonna be I am

122
00:07:55,579 --> 00:08:00,149
well should be mounted just that amount adjusted

123
00:08:00,149 --> 00:08:04,560
huto don't do that just the amount

124
00:08:04,560 --> 00:08:10,030
she can amount times

125
00:08:10,029 --> 00:08:15,038
and then in brackets one plus VAT rate

126
00:08:15,038 --> 00:08:18,269
came first Ron

127
00:08:18,269 --> 00:08:21,709
so that's 576

128
00:08:21,709 --> 00:08:27,408
she's 1960 okay and that's just

129
00:08:27,408 --> 00:08:30,560
in case that in CC you are

130
00:08:30,560 --> 00:08:34,250
which is going to change that currency say

131
00:08:34,250 --> 00:08:38,908
6 better and Lawson we're gonna do is amount including VAT

132
00:08:38,908 --> 00:08:44,009
adjusted riches amount including VAT time multiply

133
00:08:44,009 --> 00:08:47,419
amount Inc

134
00:08:47,419 --> 00:08:50,870
VA she bad

135
00:08:50,870 --> 00:08:55,409
just did just mmm wanna see you dance

136
00:08:55,409 --> 00:08:59,328
mount including VAT times multipliers

137
00:08:59,328 --> 00:09:05,179
down there runner from key dough key

138
00:09:05,179 --> 00:09:08,448
fuck so that's actually the for query on

139
00:09:08,448 --> 00:09:13,588
okay so we're going to use dis query cost fame she is so it is the basis for

140
00:09:13,589 --> 00:09:14,260
the

141
00:09:14,259 --> 00:09:18,198
I am summer for I still be involved

142
00:09:18,198 --> 00:09:22,078
a.m. just to recap everything that we did we've got on the mound

143
00:09:22,078 --> 00:09:25,179
which is overpayment for I

144
00:09:25,179 --> 00:09:28,250
an extra charge for charge for punitive

145
00:09:28,250 --> 00:09:32,269
nights in a room ven como supplies for determining whether

146
00:09:32,269 --> 00:09:35,299
we wanna minus this amount plus it to running some

147
00:09:35,299 --> 00:09:38,859
I meet on a maladjusted I'm used to taking the VAT rate

148
00:09:38,860 --> 00:09:42,800
working out the initial amount plus the VAT

149
00:09:42,799 --> 00:09:47,169
is a man including VAT and we're also birkenau amount including VAT

150
00:09:47,169 --> 00:09:50,819
adjusted for the multiplier that's it okay

151
00:09:50,820 --> 00:09:54,350
Park living things a bit confusing for free watch video again but

152
00:09:54,350 --> 00:09:58,470
I maybe futures fall onto next video you'll actually see why

153
00:09:58,470 --> 00:10:02,060
he's done some these things I'm unknowable

154
00:10:02,059 --> 00:10:05,399
so okay I think abortion and subsea nexidia