Auto news on Youtube Sep 27 2017

60% of Veterans are affected by preventable diseases

and other preventable health conditions…

Cancer, heart disease, infections, obesity, substance abuse,

mental health and other conditions…

Research shows that Veterans can reduce the risk of disease

and maintain good health through preventive care

including the early detection and treatment of diseases and conditions.

Clinical preventive services, such as disease screening and immunizations,

are key to reducing premature death and disability, and improving the health of our nation's Veterans.

Yet how can VA ensure that both patients and providers

have the right preventive information and tools?

The VA National Center for Health Promotion and Disease Prevention

– or NCP –

provides recommendations on dozens of clinical preventive services that can prevent or reduce

the risk for heart disease, cancer, infectious diseases,

and other conditions that impact the health of Veterans.

NCP is VA's central resource for evidence-based, clinical preventive services, guidance and resources.

NCP CPS Guidance Statements provide clinicians with recommendations based on the best available

evidence on such topics as disease-specific screening,

counseling, and preventive medications.

NCP maintains and regularly updates more than 30 guidance documents

as sources for making clinical decisions about preventive services.

The guidance statements consider the scientific evidence

on each topic as well as the recommendations from the

U.S. Preventive Services Task Force (USPSTF), American Cancer Society and the

Advisory Committee on Immunization Practices (ACIP).

The evidence and recommendations are carefully considered by

VA's Preventive Medicine Field Advisory Committee in

the development of VA's guidance on preventive services.

NCP ensures that VA clinicians have access to the critical information they need to deliver

the best health care possible including:

Clinical Preventive Service Guidance Statements

Clinician fact sheets to guide practice of prevention methods

National clinical reminders such as reminders for breast cancer screening,

cervical cancer screening, and pneumococcal immunizations

Review of information for safety alerts

Monthly updates on prevention.va.gov, and National Health Promotion and Disease Prevention call to

address the latest evidenced based information and resources

NCP also delivers Clinical Preventive Services (CPS)-aligned information to

Veterans through support tools such as MyHealtheVet

and the NCP website www.prevention.va.gov.

Healthy Living Messages including "Get Immunizations and Screenings"

and "Be Involved in Your Health Care" provide Veterans with

the tips and tools to take charge of their health and wellbeing.

What are the benefits?

Prevention Works!

VA prevention guidance and tools are helping clinicians

deliver evidenced-based preventive care to Veterans.

Due in part to NCP's Clinical Preventive Service guidance,

VHA is the recipient of

the National Colorectal Cancer Roundtable's 80% by 2018 National Achievement Award.

To learn more about NCP, Clinical Preventive Services

and available resources

go to: http://vaww.prevention.va.gov/CPS.

For more infomation >> Clinical Preventive Services - Duration: 3:41.

-------------------------------------------

Using Web Services in Dynamics 365 for Financials for reporting - Duration: 12:37.

Hey everyone, Chris here from the Support Team,

I wanted to create a quick video to demonstrate how you can use the Financials Web Services for Reporting.

You don't have to have any developer knowledge to make use of the OData v4 M points,

you can pull data into Excel or Power BI and build reports right now.

So let's take a look at the Web Services page.

The Web Services page is where you can expose pages queries

that you want to be able to pull information out of Financials

and down to Excel or Power BI to build reports.

It's very easy to do, you can use these links over here

and you can pick new pages to expose depending on the data that you need to pull

and the reports that you want to build.

Let's start of by taking a look at the Sales Document lines

and Sales Documents Web Services.

First thing I want to do is make sure

that your user has a Web Service access key generated,

so let's navigate to the user screen,

I'll select my user and what you're looking for here

is that you have a Web Service access key for the user generated,

if you don't, you can use this button at the top to generate one,

but you will want to have a copy of your user name here

and your Web Service access key here,

as these will be used as your user name and password when you go to Connect to the Web Service M Points.

Now that I have my user name and password, I am going to navigate to Excel.

In Excel we can go to Data, Get Data From Other Sources,

from OData Feed and this will pull up a prompt asking for the URL.

Back in Financials I will select my Sales Documents,

OData v4 URL, I'm going to copy that shortcut,

come back to Excel and paste that in.

Now it's going to come up for authentication.

For the authentication we'll go to Basic

and we will use the password that we just got off the user card.

Once I paste that in here and hit Connect,

we should be getting a preview of the data that we are pulling from that OData feed.

There we go, this is our purchase header information, I'll go ahead and load that,

I'm going to navigate to a new sheet and do the same thing, I'll go to Data, Get Data, From Other Sources, From OData Feed

and this time we will copy our Sales Document Lines OData v4 Feed URL,

I'll to plug that in and this time Excel will remember our credentials

and should just load up the preview immediately.

You can edit here if you want to, I'm just going to load it all in

and now I have a refreshable set of data,

header and line data that I could slice and dice and build reports of in Excel,

if you have an Excel power user that you can give this to,

a refreshable report, they can start making reports of this immediately.

Let's take a look at another example and how we can add new web services.

I once had someone ask me if there was a report that showed you the Inventory on Jobs versus the Inventory quantity on hand,

they wanted to be able to see if they were going to have enough inventory on hand to fulfill jobs in real time.

I don't think we have a report like this,

but I said we can build one of the web services.

On the Web Services page, if you want to add a new page,

to expose that for building reports you can do so by using this Create Data Set wizard.

Now, for the report that I'm talking about we will need to have Items page and Job Planning Lines page exposed.

Items page is already exposed, so we just need to expose the Job Planning Lines.

We'll just go to the wizard to create a new data set, this Data Source ID section;

you can click the ellipses to do the lookup,

and I can do a search here on 'job',

I'll do 'job', and I then should be able to find the Job Planning Lines page, here it is right here,

so that's the one I'll add, give it a name

hit Next and then it will allow you to filter the data that you want to pull,

this doesn't really matter, so we'll just publish it.

It finished, and I should get a Job Planning Lines web service published now.

Here it is right here.

So now I have Items and Job Planning lines, I should have the Web Services I need to build the report,

so let's jump into the Power BI desktop,

I am going to be pulling the data into Power BI desktop in almost the exact same way that I did with Excel.

I am going to Get Data, OData feed, and I am going to grab my URLs, we'll go with Items,

plug that in,

and then it will ask for credentials where we will use our username and the web service access key

and this should give us a preview of the data just as Excel did;

there's my Inventory and my Quantity on hand.

Now, I know the data that I need to build this report, so I'm going to add it,

because I really only need to bring in the Number, the Description, the Type and the Inventory Count,

I don't need any of this other data coming in, so we can simply remove those columns.

Now this makes the query a little more clean if I'm not pulling all that data down that I don't need,

the query should considerably run faster, so let's close and apply that.

Now we can get the data for the Job Planning Lines the same way,

I'll just jump ahead here to save time,

so here I am with my Job Planning Lines data,

I'm just going to load this editing to save time;

I now have the queries that I need to build my report;

the first thing I'm going to do is to rename my queries so that they're easier to identify,

so I will rename this one to 'Items'

and I will rename this one to 'Job Planning Lines'.

The next thing I am going to do is setup a relationship between the two sets of data,

I can go to the Manage Relationships button here at the top and set up a new relationship

and I want the relationship to be between the numbers,

so the Item Number and the numbers on the Job Planning Lines.

Now Job Planning lines can contain Resources, Text or Items,

so if I have an Item Type on the Job Planning line it should have an Item Number here,

so I do want those to tie together with the One to Many relationship.

Next thing I am going to do is rename my Quantity field to Job Quantity,

just so I can differentiate that, to know that that's my Job Quantity and not Quantity on hand.

Now let's start adding some columns from the items to our report: Description, Inventory, to start off,

I can see now the full list of my Inventory and how much I have on hand,

now let's add the Job Quantity column.

So now it filters down to just to the matchup and both have values;

I do have a blank one here which I can easily remove by setting a filter,

if I go to Description and Select All and Remove Blank, that will take care of that.

Now I only have inventory items that are listed that are actually on.

Job Planning Lines.

So this is fine, this is showing me how many I have on jobs and how many I have on hand,

but if this got bigger, it would be harder to read, so let's get a third column going,

we want to calculate a column that actually shows us the difference,

so I'm going to right click over here on Items, I'm going to add a new measure;

now, the measure that I'm about to put in here I'm just going to copy paste in,

I'm not an expert on creating measures in Power BI,

but I was able to create this one after about five minutes of looking on Bing,

essentially all it's doing is subtracting the Job Quantity from the inventory QOH

and if we add that, it will help;

if we add that we know get a difference as a third column,

the problem is it added all the items back, not just the ones that we have on jobs,

so let's do another filter

and we will show Job Quantity only where it is greater than zero

and apply that filter and now we're back to see.

So this is great, this is fine.

But the final thing that we would want to do is maybe add some kind of a visual indicator

for when we have a negative difference,

so let's go over to the difference value and do conditional formatting

and we'll do a diverging, we will do the lowest value of zero

and then make it a reddish color I guess,

middle value can be one and the highest value can be nine

and we'll hit OK

and we don't see anything changed and we shouldn't,

because we don't have any negative values,

but, if we go into Financials now

and add some more tables or some chairs to a job,

we should see that change.

So, let's go to one of our jobs and you can see how this updates in real time;

going to this job,

we'll go to the Job Planning lines and instead of eight BERLIN guest chairs,

we'll do a hundred and five BERLIN guest chairs

and I can immediately go back to my report,

hit Refresh and we should see a change.

Now I have a report with a visual indicator allowing me to know if there's a problem

that I am going to have a negative inventory based on the number of chairs I currently have a sign on Jobs.

Now, you can get columns filling in which job is on,

obviously there's a lot of power here, for basic, ugly reporting this is just an example.

You can build up as many report as you want, put them on a Power BI Dashboard,

give those to your users to do their job more effectively.

I hope this video helps you to get more value out of the Financials product

and as always if there is any questions you should head over to the community forms and ask away.

Thanks!

For more infomation >> Using Web Services in Dynamics 365 for Financials for reporting - Duration: 12:37.

-------------------------------------------

Human Services Secretary Tom Price Took $17K Private Flight For 90 Min Of Work | All In | MSNBC - Duration: 2:58.

For more infomation >> Human Services Secretary Tom Price Took $17K Private Flight For 90 Min Of Work | All In | MSNBC - Duration: 2:58.

-------------------------------------------

Reimagining the customer experience in financial services - Duration: 46:07.

For more infomation >> Reimagining the customer experience in financial services - Duration: 46:07.

-------------------------------------------

View the status of an invoice file in online services for providers - Duration: 2:26.

ReturntoWorkSA's online services for providers makes it easy to search for, view and understand the status of your invoice file upload.

In this video, I'll show you how to search for invoice file upload history and understand the invoice submission status and invoice payment status, and download invoice search results.

To view the status of an invoice file, go to Invoice upload (bulk).

Here you'll find the Invoice search box. Let's search for invoice files uploaded successfully during the last week.

You may experience a bit of a wait time depending on the amount of information the system needs to display.

Let's take a closer look at the Invoices submission status, and Invoice payment status columns.

The first column of the Invoices submission status, Received, indicates the number of invoices that were received in the invoice upload.

The second and third columns, Valid (yes) and Valid (no), indicate how many of the invoices were accepted for processing or not. To view the details, I simply click the numbers under each column.

When we look at the invoices that were valid and accepted for processing, you can see a filtered view of the Invoice search, including:

The Payee and ReturntoWorkSA invoice numbers, which clicking allows you to download the Provider Invoice details as a PDF.

The ePay reference number.

The Claimant name and Claim number.

The Invoice date and status.

The Claims agent.

The Invoice amount, the Amount paid.

As well as the ability to view the Remittance information.

Also notice the little arrow. This handy feature allows you to download the search results as a CSV file.

Let's now look at the Invoice payment status columns. Again we have three columns.

The first column, Paid, indicates invoices that have been paid, which when you click this you get the same filtered view of the Invoice search screen.

Column two, Denied, indicates invoices that were reviewed but the payment rejected. Clicking this number provides additional information that can be printed off.

And column three, Pending, indicates any invoices that are still being processed.

For more infomation >> View the status of an invoice file in online services for providers - Duration: 2:26.

-------------------------------------------

Claim check tool in online services for providers - Duration: 1:23.

ReturntoWorkSA's online services for providers makes it easy to search for and view if a claimant has a current claim and who is handling the claim.

In this video, I'll show you how to: • Search for a claim using the claim number. • Search for a claim using claimant details, and • View who is handling the claim.

To check claim numbers and who is handling them, simply click Claim check or select the same item from the Search menu.

On the Claim check search screen you can find the information using either the Claim number above the line or the Claimant details below the line.

If you don't have the claim number, you'll need to complete all of the other details.

Notice at the bottom there is a declaration that you have the Claimant's consent to search for the claim related to the injury.

I'll go ahead and perform a claim check using claimant details.

Great, now you can see the claim is active and who to contact if you require more information.

For more infomation >> Claim check tool in online services for providers - Duration: 1:23.

-------------------------------------------

Overview of navigation, help and settings in online services for providers - Duration: 2:12.

It's easy to find what you need on ReturnToWorkSA's online services for providers.

In this short video, I'll give you an overview, including the: • Home screen, • Help and Feedback functions, • Change password function, and • Notification preferences function.

The home screen can be divided into four main areas.

On the top you can view your provider details as well as the Help and Logout functions.

In the main area, you'll access your functions.

In this area, you'll see any communication from ReturntoWorkSA

and in the footer, you can view ReturntoWorkSA's contact information and policies.

In the Help function, you'll find lots of useful information such as customising your view.

Remember, when in doubt, you can contact ReturntoWorkSA by email or phone.

ReturntoWorkSA also encourages you to send feedback, to help improve the service.

To view your account details, click the arrow next to your name or provider ID.

Straight away you can see the organisation details you're logged in under.

If you're registered as a user with more than one organisation you can switch organisations here.

You can also view and update your account settings, such as: • Changing your password, and • Modifying your notification preferences.

To change your password, simply enter your current and create and confirm your new password while being mindful of the password rules.

After changing your password, you'll need to login with your new password.

Notification preferences allows you to turn on or off notifications,

change the frequency with which you'll receive notifications as well as add up to three email addresses.

It's important to remember that these notification preferences are only for the organisation you're logged in under.

For more infomation >> Overview of navigation, help and settings in online services for providers - Duration: 2:12.

-------------------------------------------

Upload an invoice file to online services for providers - Duration: 1:45.

Uploading an invoice file to ReturnToWorkSA's online services for providers is a much more efficient way to send multiple invoices for processing. In this short video, I'll show you how to upload an invoice file.

To upload an invoice file, simply click Invoice upload (bulk), or click the same item from the Invoices menu.

Remember to check that the invoice file meets ReturnToWorkSA's file format requirements.

When ready, there are two ways to upload an invoice file.

First is to click Select file, which will open your computer's file explorer window and from here you can find your file and click Open.

Second is the drag & drop method, where you can drag your invoice file directly from your computer's file explorer window and drop it into the grey dotted drop area. Note that you may select multiple files to upload.

Note that you may select multiple files to upload.

To get this far, the invoice file must be in the correct csv or txt format and not exceed one-megabyte in size.

At this stage, you could also Remove a file.

Let's click Upload and see what happens.

Now you can see the message indicating the file was uploaded successfully.

However, to check if there were no format errors, you'll need to check the status of your invoice file using the Invoice search.

Let's click Search and display the status of the file just uploaded.

Great, no format errors are reported and ReturntoWorkSA will now process the invoices.

For more infomation >> Upload an invoice file to online services for providers - Duration: 1:45.

-------------------------------------------

Health Services - Duration: 1:08.

My name is Nadine Miller I am the Director of Health Services, Audiology, and

Homebound. We support student success by helping our kids meet their medical

needs whether that's a medication at school, a procedure that they need,

helping with their chronic illness, we do vision screenings and hearing screenings.

W look at everything that that child needs to make that child successful. I

really think that my teams out in the schools and my team here at student

services, we really work for those kids every day. Watch my nose. Very good. Look over here. Good. One more eye. Hey, I heard you're having a

rough morning. Tell me a little bit of what's going on. I love being a school

nurse because I love the opportunity that I have to really make a difference

in a child's life. Not only will their medical needs be taken care of, they have

a safe environment to come to, but they also have that resource in that health

office every day to support them, to be there for them, to make that child

successful.

For more infomation >> Health Services - Duration: 1:08.

-------------------------------------------

How do grocery delivery services work? | How do online bulk stores work? - Duration: 8:45.

hey guy! Shawn here from shawnmhowell.com. what is the deal with home delivery

grocery services like instacart specifically and boxed? so i have some

thoughts and if you are a bit curious about home delivery services like

instacart and big box services like boxed keep watching. having just had a

baby it has been hard to get to the grocery store. my husband has been doing

an excellent job of going to the grocery store but i was curious about the home

delivery services that the grocery stores in my area have been pushing and

advertising. the Food Lion is the closest one to my house so I looked online and

they use a service called instacart. and I have done two orders with them both

with free delivery because the first one is free and I will post a link on how

you can also get free delivery on your first service with instacart in the links

down below. you go online and you pick out the groceries that you want to get

and they get delivered by a person..an actual person... from a local grocery store.

in my case my Food Lion is closest. so you could pick what grocery store you

want them to come from. the prices are are kind of weird.

the instacart sets the prices. you don't necessarily get the prices that are at

Food Lion but they do have a section of sale items and coupons that you can also

add to your cart. that's kind of where I tend to shop first is from the sale

items. but I've found that it saves me money because I don't have any of those

impulse buys. so I put together my grocery list and normally I'd take it into

the store and I find other things to just add to the card and before you know it I

bought a hundred dollars in groceries. well these days having an infant I need

to start saving money on our grocery bill. we are trying to spend fifty

dollars a week. so with instacart that really helped us. I think it's at $55 both

times but it really helped me stay focused on what I needed to get and

making choices. and the really cool, another cool thing about it, it will tell

you how long it will take for you to get your groceries delivered based on the

time of day. both times, well the first time I ordered it didn't

take but an hour to get to me. for them to deliver the second time

on the Saturday night and so I could set what time I wanted it to be delivered on

Sunday morning which was really cool. and then you have a personal shopper who

gets paid to go and shop for your groceries that you've picked out.

and they will contact you if something is not in stock when they can't find it they will

text you or text you through the instacart app and let you know they

couldn't find it. or could they substitute with something similar.

a recent example is I had there was a bag of, a box of Ritz crackers that I

had wanted and they found a box but the box was split open and the guy looked

and sure enough the bags inside of the crackers were ok. they were fine so I

said yeah I don't mind a damaged box as long as the inside is

fine. well alright so guys I am recording a video: I just got my second order

from instacart that came from Food Lion but my shopper was so awesome he found

that the Ritz cracker crackers that I ordered were damaged so he drove to

Publix and replaced them. which is pretty cool .and had this news but they keep in

constant communication with you .if you need to add something to your order you

can text them. oh I forgot you know I forgot milk or I forgot to order toilet paper or

something. you can add that to your order very easily. so I don't know how much

delivery charges are. they do charge some kind of fee or the name of the fee is

but some kind of a fee that they say pays the employees but you can

choose not to do that fee I think we said at 10% so I choose

not to do that but then they have an option for tipping your actual delivery

person and you can tip different percentages so I usually transfer that

10% and do a 10% tip for the person who's delivering my groceries because I

feel like, I don't know, I feel better about that. I like that they're very

speedy. and coming over like I said I don't know what delivery fees are and I

know there's some kind of a fee a yearly subscription you can sign up for

it. I haven't done that. so the first one I did I got free delivery. the second one

they sent me an email saying if you use

this coupon code within the next week you get a free delivery. so I ordered

that again. so if they send me another delivery, free delivery option... what's up

with us? we love free delivery and free shipping...

us Americans. then I will do that again so definitely worth it. definitely

worth looking into. definitely worth doing once to see if you like it. so I'm

going to insert some footage that I took the day that the groceries arrived so

you can kind of see what I bought. so here are the groceries that I ordered.

I only spent like fifty five dollars and I got free delivery. and I've been very

impressed because you can talk with your shopper to make sure you know that you

get the things you want. or if they don't have something in stock then you can

request a different thing. so I got some yogurt, yoplait whips. let's

say I got the chocolate and also got the key lime. and we got macaroni and cheese

over here and some lemon juice and some cheese nips. huge bottle of vinegar.

the prices you don't get to pick but they tell you the prices up front and

sometimes they'll change like to two thirds. and I got a whole bunch of

chicken and vegetarian options. we need some cream cheese. veggies. you can

get fresh vegetables too. bananas. what else? we got Oreos. but anyway I just

bought like my regular things that we needed and they were here at ordered

them a lot of times that you can order them in an hour.

but I ordered last night and then they shopped this morning and delivered them and

pretty cool instacart. so while we talk about groceries and saving money I

thought that I would also talk about boxed.com. so I've been using boxed for probably

a year ,maybe a little over a year now but I haven't been going through boxed.com.

actually didn't even put that together. I have been a user of Zulily.com

which is a discount website and occasionally probably once or twice a

month show boxed offers free shipping if you purchase $50 through the

Zulily app. and they have tons of things that are even further discounted than on

boxed.com. household goods and snack items. so I stock up on toilet paper, paper

towels, they're paper towel brands really good, they're napkin brand, they have

their own it's called Prince and spring. really good products. I purchased their

soap before but then I also have big-name products. they have Charmin

toilet paper. they have Bounty paper towels.

they have occasionally... they have razors on there.

I buy tons of snack items: granola bars, nutrigrain bars, chips,

fruit snacks, Gatorades, anything that you would buy like at a Costco or a Sams they

have those items. so I will usually spend anywhere from fifty to eighty five

dollars on Zulily app and get the two day free shipping. and so that's how

an ordering box. well I recently ordered through boxed.com, the actual website,

because again they were doing the free shipping deal and I think I ordered a

little over a hundred dollars maybe like one hundred fifteen, hundred twenty

dollars worth of stuff. and it came it was really great and everything but I

still feel like going through the Zulily app is the way to go because I feel like

they further discount stuff on the Zulily app. But if you just go through

boxed.com but it's worth going through boxed.com to get that free shipping and

to see the variety of stuff that they have if you don't already use Zulily. they're Zulily app so I will put the Zulily app down below I will also

put the boxed.com link down below and I think they also have like an affiliate

thing where I can get you free shipping and like $10 or $15 off and then I get

10 or 15 something like that. so I'll put that below. again you don't have to use

that code or you can if you want. I hope that you found this video useful when

you are thinking about using a grocery delivery service like instacart or a big

box service like boxed.com. I hope that you found my review helpful

to you in some way. if you did please give me a thumbs up, share it with your

friends, and don't forget to subscribe. and I will see you in my next video.

thanks for watching. bye!

For more infomation >> How do grocery delivery services work? | How do online bulk stores work? - Duration: 8:45.

-------------------------------------------

Build an intelligent and secure app with Azure managed service for MySQL and PostgreSQL - Duration: 1:20:53.

For more infomation >> Build an intelligent and secure app with Azure managed service for MySQL and PostgreSQL - Duration: 1:20:53.

-------------------------------------------

Learn about our vision and upcoming innovations for Microsoft Remote Desktop Services - Duration: 1:07:23.

For more infomation >> Learn about our vision and upcoming innovations for Microsoft Remote Desktop Services - Duration: 1:07:23.

-------------------------------------------

Cert Exam Prep: Exam 70-347: Enabling Office 365 Services - Duration: 1:21:25.

For more infomation >> Cert Exam Prep: Exam 70-347: Enabling Office 365 Services - Duration: 1:21:25.

-------------------------------------------

Committee on Human Services Reform, September 21 - Duration: 3:05:50.

For more infomation >> Committee on Human Services Reform, September 21 - Duration: 3:05:50.

-------------------------------------------

Rodriguez Musical Services - Duration: 0:21.

Premium, hand-selected Buffet clarinets

Artist level overhauls and repair work

Visit our shop in Atlanta

Let us send you a selection to try

Or meet us at a convention

Premium products and services

For your best performance

For more infomation >> Rodriguez Musical Services - Duration: 0:21.

-------------------------------------------

Create an invoice file to upload to online services for providers - Duration: 5:23.

Creating an invoice file, either manually or using finance software, and uploading it direct to ReturnToWorkSA's online services for providers,

is a much more efficient way to send multiple invoices for processing. In this short video, I'll show you how to manually prepare an invoice file.

To upload and validate your invoices, you'll need to prepare an invoice file in a specific format.

Invoices that do not meet the format requirements will not process successfully. Let's go to Invoice upload (bulk).

Here it highlights that files must be: • Comma delimited and in one of two formats; csv or txt, and • Provides the link to the file format requirements.

I'll step you through a csv invoice file in Microsoft Excel.

An invoice file must contain only one header row and then any number of detailed record rows.

The header row must include eight attributes that describe the practice or payee details and the total value of the invoices being submitted.

In cell A1, you'll always enter 00 to identify this as the header row.

In B1, you'll enter the date the invoice file was created.Dates in an invoice file can only be in one of these two formats: • DD/MM/YYYY, or • YYYYMMDD.

In C1, you'll enter the total number of detailed record rows included in the invoice file.

In D1, you'll enter the total value of the invoices being submitted. Which is basically the total of column O, which you'll learn more about soon.

In E1, you'll enter the name of your practice or the payee. This field can contain letters, numbers, ampersands and forward slashes but it cannot exceed 50 characters.

In F1, you'll enter the practice address. The length of this field cannot exceed 100 characters and can include letters, numbers and special characters like comma, dash and forward slash.

If you do use commas you'll need to include double quotes around the contents.

In G1, you'll enter your Australian Business Number or ABN. This can be no more than 11 characters and can only contain numbers.

In H1, you'll enter the words Tax Invoice.

Now let's look at a detailed record, starting on row 2.

A detailed record contains 16 attributes, most of which are required.

In A2, you'll always enter 01 to signify a detailed record hence it is repeated on every row for multiple records.

In B2, you'll enter the payee's invoice number. This invoice number cannot exceed 15 characters and can only contain letters and numbers.

In C2, you'll enter the date the payee generated the invoice.

In D2, you'll enter the claimant's claim number. This cannot exceed 8 numbers, leaving out any leading zeros, followed by a forward slash and then an additional two numbers.

In E2, you'll enter the ReturnToWorkSA service provider number, or if you're a medical or allied health provider, the Medicare provider number for the provider who performed the service. This field cannot exceed 8 numbers.

In F2, you'll enter the date the service was provided, or commenced if over more than one date.

In G2, if the same service was performed on the same date, you'll enter the time the service was provided; otherwise it can be left blank.

For time, you'll use the hour colon minute 24-hour format. For example for a service provided at four forty-five in the afternoon you'll enter 16:45.

In H2, you'll enter the end date of the service, provided it's different to the date commenced, otherwise it can be left blank.

In I2, you'll enter the service item code. This cannot exceed 6 characters and can only contain letters and numbers.

You'll leave J2 blank.

In K2, you'll enter the description of service provided. This cannot exceed 60 characters and can only contain letters and numbers.

In L2, you'll enter the standard rate for the service. Where a service attracts a GST component the rate recorded here must be the rate plus GST.

In M2 and N2, you'll enter the quantity of service provided and the unit of measurement.

Bear with me while I explain this...

If you enter an H in N2, then the unit of measurement is hours. So if you enter 2.5 in M2 then this is equivalent to two and a half hours.

If you enter an M in N2 and then twenty-four in M2, then this is equivalent to twenty-four minutes.

Finally, if you enter a U in N2 and then a four in M2, then this would be recorded as four units.

In O2, you'll enter the value of service being invoiced. This should be equivalent to the standard rate entered in L2 multiplied by quantity of service entered in M2.

In P2, you'll enter the GST inclusive flag. Enter Y if the value in L2 includes a GST component, otherwise enter N.

Now save the Excel spreadsheet as a csv and with a relevant filename.

Finally, ensure the file size is less than one-megabyte.

For more infomation >> Create an invoice file to upload to online services for providers - Duration: 5:23.

-------------------------------------------

SMS to Emergency Services - Duration: 2:49.

For more infomation >> SMS to Emergency Services - Duration: 2:49.

-------------------------------------------

Search for invoices in online services for providers - Duration: 2:19.

ReturntoWorkSA's online services for providers makes it easy to search for and view invoice information.

In this video, I'll show you how to: • Perform a simple and advanced invoice search, and • Download invoice search results.

To view invoices, go to Invoice search, or click the same item from either the Invoices or Search menu.

By default the simple search will return all invoices created in the last 30 days. However, there is a maximum number of invoices that can be displayed, so you can narrow the simple search using the three filters...

Invoice or ePay reference number.

Invoice status.

Invoice history, which allows you to view invoices created up to a maximum of 90 days in the past.

Let's look at the Advanced search.

The Advanced search provides more options to help improve the efficiency of your search, including...

Invoice date range, which is restricted to 90 days.

Date of service.

Paid date range, also restricted to 90 days.

Provider number or name.

Agent name.

Claim number, and Claimant.

Let's do a search for invoices paid in the last week.

When we look at the invoices that were valid and accepted for processing, you can see a filtered view of the Invoice search, including...

The Payee and ReturntoWorkSA invoice numbers, which clicking allows you to download the Provider Invoice details as a PDF.

The ePay reference number.

The Claimant name and Claim number.

The Invoice date and status.

The Claims agent.

The Invoice amount, the Amount paid.

As well as the ability to view the Remittance information.

Also notice the little arrow. This handy feature allows you to download the search results as a CSV file.

For more infomation >> Search for invoices in online services for providers - Duration: 2:19.

-------------------------------------------

Get access to online services for providers - Duration: 1:38.

Registering for ReturnToWorkSA's online services for providers, is easy.

In this short video, I'll show you how to: • Find the Registration form on the ReturnToWorkSA website, and • Complete the form based on Entity and User type.

Let's find the Registration form on the ReturnToWorkSA website.

Download and save the form to your computer and start completing it straight away, no need to print.

I'll demonstrate as a staff member using the online services on behalf of my practice, beginning with the User details.

To ensure the business details are correct in the Type of access section, it's best for an authorised officer of the business to provide the information.

This can be the owner, proprietor, director or partner.

The Entity type is a description of the business and the User type determines how the user will use online services.

In my case, I work for an allied health provider as a practice manager

and I require Master user access so that I can access remittances and payment history.

You'll also use this form to remove access for a user.

If you ever forget your username or password and need to contact ReturnToWorkSA, they'll use the secret question in the Validation section to identify you.

Now all that needs to be done is the declarations including the authorised officer before sending it off to ReturnToWorkSA.