i'm ok taxes 2013 tutorials
in this video I'm gonna be continuing talking about invoices
a shame this is the seventh figure in that little mini series
and and in this video were gonna be creating
the I'll just cleary
that will be based off of the union query made in a previous videos
rather than me try to explain I'll show you so
if you I wanna play along funneling blood video to them a section website
teletext 2013
the B-fifty an open at one up in
2013 take passwords password
now we are in mid love making an invoicing
City Africa invoices
a you can see we've got the invoice study she
here time we've got an invoice
at that arent reform period we fix it charges and payments just great
how we can add up paying by clicking on make payment will probably add a column
in there some point too says
print which says print actually so we can print the invoice
to now we've got the soda data entry Parveen voices without any to move to
making actual
invoice itself which is basically a a report in access
and it will contain a supper for at more minutes do
is we need to take a look at wary
which carry on cost payments Union so we're gonna do is we're going to take
the square each
we're gonna drop into another query and reagan new and use couple the lookup
function
messaging expand on their and used as the basis for the sub before
Sonus five straight into that's a closer close to
gonna create click concrete design and
from show table click on query costs
payments Union and close to and let me just
prime ice cream which you cannot see
I think LP bit strange she could correct we want firm
query costs payments Union well everything
as it happens but there is
I something i wanna show you chuckle the multiplier I'm
which is if we run it when we create the
subir por and this supposed to be based the for this query work rating now
we wanted to have a little running some and
so what we wanted to do is needs to identify whether
an amount should be added to the run it running some or subtracted
from running some and so at the moment all the amounts a positive for what we
want to do
is we wanna make payments positive
you wanna make anything else negatives
a.m. still idea being to
ish said made any payment at all the transaction hero this is just a
four nights in a room because 480 that should be minus 480
I'm so -4 eighty means that the hotel's out for 80
and if you go down to payment which has 840 that's definitely a plus cuz that's
money been given to the hotel
if that's not too clear don't worry I
this video next video you get very clear I deformed trying to do
so anyway miss going to designed you clicking here
to build a and coolest to
multiply your she an
very simple just put open close but a shoebox
money to make his property she and we are looking at item
I'm gonna say if and SC
I F which is the major if a.m.
item for in open/close
square brackets if item equals
and then open/close single quotation marks payment
its payment payments payment thing
comma the troop are should be
one magic was payment yes one
comma -1 clothes off
an empress run so when a cruise payment
we get a1 and when it anything else is in a payment we return -1
then what we do got another column
to build a man who dis amount and just it
McCullum and its sequel to
multiplier which weren't playing Wii safest
know me accept that okay sega's clarion call query
costs payments
Union salted
I was one pick up most like to go back in there
builder amount just it
and its multiplier
times amount
Emerson to now said showing 480
texture -4 eighty so showing 6 is shown -0600
for the payments hair shiny for you here still show in 843
done exactly what we wanted to do for the
a amount to just it next
we need to you and get the VAT rate she
and restoring the VAT rate in
table invoices think
note your tale in which is VAT
amico booking ID FK which we've also got here okay
so we're going to use the booking ID from here
to return the VAT rate
so taken next problem I'm call this one VAT
rate city aka says can look up
the value i'm looking up
I am things just VAT rate
hospital VAT remember to in
open/close square brackets
an table invoices
I am where
looking ID FK
peak rules ampersand booking ID if you know
exactly 12 enough cover dislike quite a few times and other
tutorials a.m. so yeah
okay okay rhonda and nothing changed the wrong
yes just VAT so back to design the
VAT rate so just changed
VAT takes an hour work fine
weakens your point two minutes leaving the rest is no
which is good I think
okay so now what we need to do is you need to multiply the amount adjusted
by already at the VAT to do not adjust its okay what would a
for the design view to you too VAT rate
let's just that in an ends at function so ends that
from bracket not the end comma
0 close brackets and now anything that's no
have a zero and we're gonna say
a.m. amount including VAT here
and that's gonna be I am
well should be mounted just that amount adjusted
huto don't do that just the amount
she can amount times
and then in brackets one plus VAT rate
came first Ron
so that's 576
she's 1960 okay and that's just
in case that in CC you are
which is going to change that currency say
6 better and Lawson we're gonna do is amount including VAT
adjusted riches amount including VAT time multiply
amount Inc
VA she bad
just did just mmm wanna see you dance
mount including VAT times multipliers
down there runner from key dough key
fuck so that's actually the for query on
okay so we're going to use dis query cost fame she is so it is the basis for
the
I am summer for I still be involved
a.m. just to recap everything that we did we've got on the mound
which is overpayment for I
an extra charge for charge for punitive
nights in a room ven como supplies for determining whether
we wanna minus this amount plus it to running some
I meet on a maladjusted I'm used to taking the VAT rate
working out the initial amount plus the VAT
is a man including VAT and we're also birkenau amount including VAT
adjusted for the multiplier that's it okay
Park living things a bit confusing for free watch video again but
I maybe futures fall onto next video you'll actually see why
he's done some these things I'm unknowable
so okay I think abortion and subsea nexidia