transcribe pls

0:00

S… Speaker 3 (transcribe pls)

How's the automation?

0:01

S… Speaker 3 (transcribe pls)

Any progress?

0:03

Oh,

0:04

S… Speaker 1 (transcribe pls)

yeah, yeah.

0:05

S… Speaker 2 (transcribe pls)

I've been working on it nonstop.

0:07

S… Speaker 2 (transcribe pls)

So I've just been plugging through

0:11

S… Speaker 2 (transcribe pls)

it, you know,

0:11

S… Speaker 2 (transcribe pls)

fixing the problems and such.

0:13

S… Speaker 2 (transcribe pls)

Just a minute,

0:14

S… Speaker 1 (transcribe pls)

my cat wants to be left out.

0:15

S… Speaker 3 (transcribe pls)

So how can we help you?

0:17

S… Speaker 3 (transcribe pls)

By the way,

0:18

S… Speaker 3 (transcribe pls)

here's Lani.

0:19

S… Speaker 3 (transcribe pls)

She's part of the team.

0:21

S… Speaker 3 (transcribe pls)

She's working with me with Groovana staff.

0:24

S… Speaker 3 (transcribe pls)

Hi,

0:25

S… Speaker 1 (transcribe pls)

David.

0:25

S… Speaker 1 (transcribe pls)

Hello.

0:28

S… Speaker 3 (transcribe pls)

So again,

0:29

S… Speaker 3 (transcribe pls)

how can we help you today?

0:31

S… Speaker 2 (transcribe pls)

Let me spare my screen.

0:33

S… Speaker 1 (transcribe pls)

Okay,

0:46

S… Speaker 2 (transcribe pls)

so here's the main

0:51

S… Speaker 2 (transcribe pls)

display.

0:52

S… Speaker 1 (transcribe pls)

Give it a second.

0:54

S… Speaker 1 (transcribe pls)

Sometimes it

0:59

S… Speaker 2 (transcribe pls)

times out because I'm connected to it with code,

1:02

S… Speaker 1 (transcribe pls)

hopefully.

1:09

S… Speaker 3 (transcribe pls)

I've heard

1:13

S… Speaker 3 (transcribe pls)

from Mason that you guys encountered some messages.

1:19

S… Speaker 3 (transcribe pls)

something with Grovanna?

1:21

S… Speaker 1 (transcribe pls)

Yeah,

1:23

S… Speaker 2 (transcribe pls)

right now,

1:24

S… Speaker 2 (transcribe pls)

Grovanna is,

1:25

S… Speaker 2 (transcribe pls)

I'm trying to send them files,

1:27

S… Speaker 2 (transcribe pls)

but apparently they haven't tested their ability to do that.

1:31

S… Speaker 1 (transcribe pls)

So what's going

1:36

S… Speaker 1 (transcribe pls)

on now?

1:36

S… Speaker 1 (transcribe pls)

Sorry,

1:46

S… Speaker 2 (transcribe pls)

I tried to send them a file,

1:50

S… Speaker 2 (transcribe pls)

a communication file from this application to Grovanna.

1:54

S… Speaker 2 (transcribe pls)

But they haven't tested that part of the communication at all.

1:58

S… Speaker 1 (transcribe pls)

So it's

2:03

S… Speaker 2 (transcribe pls)

very frustrating because,

2:04

S… Speaker 2 (transcribe pls)

you know,

2:06

S… Speaker 2 (transcribe pls)

I set this whole system up and there's

2:11

S… Speaker 2 (transcribe pls)

a lot of bugs on their end.

2:12

S… Speaker 2 (transcribe pls)

So I need to,

2:14

S… Speaker 2 (transcribe pls)

I'm just waiting on them to get them to figure

2:19

S… Speaker 2 (transcribe pls)

out how to connect to their own system.

2:20

S… Speaker 3 (transcribe pls)

I see,

2:22

S… Speaker 1 (transcribe pls)

I see.

2:26

S… Speaker 3 (transcribe pls)

work on it so that we can move forward.

2:29

S… Speaker 2 (transcribe pls)

They're going to set up a sender just like

2:33

S… Speaker 2 (transcribe pls)

me and send to themselves,

2:35

S… Speaker 2 (transcribe pls)

which should have happened from the beginning.

2:38

S… Speaker 2 (transcribe pls)

So before we onboarded,

2:42

S… Speaker 2 (transcribe pls)

that should have been done,

2:43

S… Speaker 2 (transcribe pls)

but that's okay.

2:43

S… Speaker 1 (transcribe pls)

Okay,

2:47

S… Speaker 2 (transcribe pls)

so here's an order that's been received.

2:49

S… Speaker 2 (transcribe pls)

And this is the main

2:53

S… Speaker 2 (transcribe pls)

lookup on the main page.

2:59

S… Speaker 2 (transcribe pls)

there's also let me see on here let's do find

3:04

S… Speaker 1 (transcribe pls)

orders anything

3:10

S… Speaker 2 (transcribe pls)

on these pages can change like if you want different button positions different

3:14

S… Speaker 2 (transcribe pls)

you know displays we

3:19

S… Speaker 1 (transcribe pls)

can do all that and

3:35

S… Speaker 2 (transcribe pls)

here's the work items so

3:39

S… Speaker 2 (transcribe pls)

if you don't like anything in this or you want you know if

3:43

S… Speaker 2 (transcribe pls)

there's a better display that we can use just give it to me and it's fairly easy

3:47

S… Speaker 2 (transcribe pls)

to change this

3:48

S… Speaker 3 (transcribe pls)

Okay, we'll see.

3:49

S… Speaker 3 (transcribe pls)

When would we be able to gain

3:54

S… Speaker 3 (transcribe pls)

access to that so that I can check it on my

3:58

S… Speaker 2 (transcribe pls)

end? You should be able to do it right now if I leave it on.

4:02

S… Speaker 1 (transcribe pls)

So let me give you the IP.

4:08

S… Speaker 1 (transcribe pls)

See

4:13

S… Speaker 2 (transcribe pls)

if you can connect to that.

4:14

S… Speaker 1 (transcribe pls)

Checking.

4:17

S… Speaker 1 (transcribe pls)

I

4:29

S… Speaker 1 (transcribe pls)

can. You connected?

4:33

S… Speaker 3 (transcribe pls)

No.

4:34

S… Speaker 3 (transcribe pls)

It says here.

4:38

S… Speaker 3 (transcribe pls)

Your connection is private.

4:39

S… Speaker 3 (transcribe pls)

How can I move forward?

4:42

S… Speaker 3 (transcribe pls)

Let me share this to you.

4:43

S… Speaker 1 (transcribe pls)

Do

4:48

S… Speaker 2 (transcribe pls)

you want to share your screen?

4:49

S… Speaker 1 (transcribe pls)

Click

4:54

S… Speaker 2 (transcribe pls)

advanced and yeah,

4:57

S… Speaker 2 (transcribe pls)

just share your screen and I can walk you through that.

5:01

S… Speaker 4 (transcribe pls)

That's because there's no certificate on the website yet.

5:04

S… Speaker 2 (transcribe pls)

And to do that,

5:07

S… Speaker 4 (transcribe pls)

I need to move it over to the production servers.

5:09

S… Speaker 8 (transcribe pls)

I see.

5:10

S… Speaker 8 (transcribe pls)

Let me share my screen.

5:12

S… Speaker 6 (transcribe pls)

Proceed

5:18

S… Speaker 4 (transcribe pls)

at the bottom.

5:18

S… Speaker 6 (transcribe pls)

Oh,

5:28

S… Speaker 5 (transcribe pls)

there. The credentials that you've used.

5:31

S… Speaker 2 (transcribe pls)

Admin.

5:32

S… Speaker 4 (transcribe pls)

Admin.

5:32

S… Speaker 3 (transcribe pls)

I believe it is.

5:34

S… Speaker 6 (transcribe pls)

How

5:46

S… Speaker 5 (transcribe pls)

about a password?

5:46

S… Speaker 5 (transcribe pls)

Could you please set it?

5:48

S… Speaker 3 (transcribe pls)

Admin.

5:48

S… Speaker 1 (transcribe pls)

Admin as well?

5:50

S… Speaker 3 (transcribe pls)

I think so.

5:51

S… Speaker 6 (transcribe pls)

That's

5:56

S… Speaker 5 (transcribe pls)

it. How about this part?

5:58

S… Speaker 4 (transcribe pls)

No tenant ID.

5:59

S… Speaker 4 (transcribe pls)

That would be when we have multiple people.

6:02

S… Speaker 1 (transcribe pls)

Okay.

6:03

S… Speaker 1 (transcribe pls)

Password

6:08

S… Speaker 1 (transcribe pls)

incorrect. Yeah,

6:09

S… Speaker 6 (transcribe pls)

just checking for

6:21

S… Speaker 6 (transcribe pls)

it. It

6:27

S… Speaker 4 (transcribe pls)

might be OFBIZ.

6:29

S… Speaker 1 (transcribe pls)

All small letters?

6:31

S… Speaker 7 (transcribe pls)

Yeah.

6:34

S… Speaker 4 (transcribe pls)

But let me...

6:36

S… Speaker 6 (transcribe pls)

Yeah,

6:37

S… Speaker 4 (transcribe pls)

it is OFBIZ.

6:39

S… Speaker 2 (transcribe pls)

OFBIZ.

6:44

S… Speaker 5 (transcribe pls)

E -I -Z.

6:46

S… Speaker 7 (transcribe pls)

Yeah.

7:09

S… Speaker 1 (transcribe pls)

Oh,

7:09

S… Speaker 6 (transcribe pls)

there.

7:22

S… Speaker 6 (transcribe pls)

Okay.

7:25

S… Speaker 5 (transcribe pls)

I can check the interface,

7:28

S… Speaker 5 (transcribe pls)

and if I have suggestions or any changes

7:32

S… Speaker 5 (transcribe pls)

we would like to do,

7:34

S… Speaker 5 (transcribe pls)

I'll send it to you on a group chat.

7:36

S… Speaker 3 (transcribe pls)

Okay.

7:37

S… Speaker 4 (transcribe pls)

Click on main.

7:38

S… Speaker 6 (transcribe pls)

Also,

7:42

S… Speaker 4 (transcribe pls)

the displays in this can change to anything.

7:45

S… Speaker 2 (transcribe pls)

So,

7:46

S… Speaker 4 (transcribe pls)

I just need...

7:47

S… Speaker 4 (transcribe pls)

What you want it to look like.

7:49

S… Speaker 4 (transcribe pls)

Okay, so order 1234 is the one

7:53

S… Speaker 4 (transcribe pls)

that's been downloaded from Grovana.

7:57

S… Speaker 1 (transcribe pls)

This one?

8:01

S… Speaker 3 (transcribe pls)

Yeah.

8:02

S… Speaker 1 (transcribe pls)

Can I click on

8:06

S… Speaker 7 (transcribe pls)

this? Yeah.

8:07

S… Speaker 2 (transcribe pls)

The amount,

8:10

S… Speaker 4 (transcribe pls)

I think, is off.

8:11

S… Speaker 3 (transcribe pls)

That needs to be fixed.

8:12

S… Speaker 6 (transcribe pls)

So

8:26

S… Speaker 4 (transcribe pls)

please take a screenshot and flag any items

8:30

S… Speaker 4 (transcribe pls)

that are defects.

8:33

S… Speaker 4 (transcribe pls)

because I have nobody to test this.

8:35

S… Speaker 4 (transcribe pls)

I've

8:39

S… Speaker 4 (transcribe pls)

been doing testing what I can,

8:42

S… Speaker 4 (transcribe pls)

but it takes a long time to verify everything while

8:47

S… Speaker 4 (transcribe pls)

I'm trying to get the programming done.

8:49

S… Speaker 5 (transcribe pls)

I'll take time to check

8:55

S… Speaker 5 (transcribe pls)

this,

8:56

S… Speaker 5 (transcribe pls)

everything,

8:58

S… Speaker 5 (transcribe pls)

then I'll just send you a screenshot of if I found anything.

9:03

S… Speaker 5 (transcribe pls)

or if we need to update anything.

9:05

S… Speaker 6 (transcribe pls)

Okay.

9:07

S… Speaker 4 (transcribe pls)

Now, if you click on the order number,

9:09

S… Speaker 4 (transcribe pls)

I'll show you some additionals.

9:12

S… Speaker 2 (transcribe pls)

The one,

9:15

S… Speaker 1 (transcribe pls)

two, three, four.

9:15

S… Speaker 1 (transcribe pls)

Okay.

9:16

S… Speaker 6 (transcribe pls)

And

9:23

S… Speaker 4 (transcribe pls)

click on PO worksheet.

9:24

S… Speaker 6 (transcribe pls)

If

9:29

S… Speaker 4 (transcribe pls)

you click approve order,

9:30

S… Speaker 4 (transcribe pls)

it tries to send the order to Grovana,

9:35

S… Speaker 2 (transcribe pls)

or it will.

9:38

S… Speaker 2 (transcribe pls)

And it's

9:43

S… Speaker 4 (transcribe pls)

not going to be this slow when it's in production.

9:45

S… Speaker 4 (transcribe pls)

The problem is I've got my debugger attached to

9:50

S… Speaker 4 (transcribe pls)

it, so it's really slowing it down.

9:52

S… Speaker 8 (transcribe pls)

I see.

9:53

S… Speaker 5 (transcribe pls)

This BO worksheet,

9:57

S… Speaker 5 (transcribe pls)

is this a BO file?

10:01

S… Speaker 4 (transcribe pls)

that yeah i see now what

10:07

S… Speaker 3 (transcribe pls)

i need from you is i need to know first

10:12

S… Speaker 3 (transcribe pls)

of all is if everything here is what you need um

10:16

S… Speaker 3 (transcribe pls)

and looks like you know if it's good enough to for

10:21

S… Speaker 1 (transcribe pls)

you to use it um as

10:25

S… Speaker 3 (transcribe pls)

well as like the import and export from excel needs

10:30

S… Speaker 1 (transcribe pls)

to function um

10:33

S… Speaker 3 (transcribe pls)

If there's anything missing,

10:35

S… Speaker 3 (transcribe pls)

like I believe it was mentioned that you

10:39

S… Speaker 3 (transcribe pls)

get a worksheet from the warehouse.

10:42

S… Speaker 2 (transcribe pls)

I get the worksheet from the Grovanna portal

10:46

S… Speaker 2 (transcribe pls)

and I'm giving it to the warehouse.

10:48

S… Speaker 2 (transcribe pls)

What I'm doing is I'm

10:53

S… Speaker 1 (transcribe pls)

downloading.

10:53

S… Speaker 2 (transcribe pls)

Go on,

10:55

S… Speaker 1 (transcribe pls)

I'm sorry.

10:55

S… Speaker 3 (transcribe pls)

Are the dimensions loaded from the warehouse?

10:59

S… Speaker 4 (transcribe pls)

Yeah,

11:00

S… Speaker 2 (transcribe pls)

the dimension is coming from the warehouse.

11:03

S… Speaker 2 (transcribe pls)

They provided it.

11:05

S… Speaker 2 (transcribe pls)

I believe I have given you that bio.

11:08

S… Speaker 1 (transcribe pls)

Yeah.

11:09

S… Speaker 4 (transcribe pls)

Okay.

11:10

S… Speaker 3 (transcribe pls)

So all that should be

11:14

S… Speaker 1 (transcribe pls)

in here.

11:15

S… Speaker 1 (transcribe pls)

If it's not,

11:18

S… Speaker 3 (transcribe pls)

you should be able to import it from Excel.

11:21

S… Speaker 1 (transcribe pls)

And I don't

11:25

S… Speaker 3 (transcribe pls)

know if that's working yet.

11:26

S… Speaker 4 (transcribe pls)

So

11:31

S… Speaker 3 (transcribe pls)

what I need in that worksheet is to get,

11:34

S… Speaker 4 (transcribe pls)

well,

11:36

S… Speaker 3 (transcribe pls)

actually, let me share.

11:38

S… Speaker 4 (transcribe pls)

Okay.

11:58

S… Speaker 3 (transcribe pls)

Okay, I need to know what exactly in this is

12:02

S… Speaker 3 (transcribe pls)

being imported from the warehouse and what are you filling

12:07

S… Speaker 4 (transcribe pls)

out? Oh,

12:11

S… Speaker 2 (transcribe pls)

the information that is coming

12:15

S… Speaker 2 (transcribe pls)

from the warehouse is the dimension only

12:19

S… Speaker 2 (transcribe pls)

and all of those.

12:20

S… Speaker 1 (transcribe pls)

So this one?

12:22

S… Speaker 1 (transcribe pls)

yeah that one package to mention okay yeah that is that's

12:26

S… Speaker 2 (transcribe pls)

the one that's coming from the warehouse and uh go back to the

12:30

S… Speaker 2 (transcribe pls)

vo info the the first sheet

12:35

S… Speaker 2 (transcribe pls)

And the information from the fulfillment

12:40

S… Speaker 2 (transcribe pls)

center up until the order quantity,

12:43

S… Speaker 2 (transcribe pls)

those are the things that is coming from the

12:47

S… Speaker 1 (transcribe pls)

portal.

12:48

S… Speaker 2 (transcribe pls)

Then the only thing that us,

12:52

S… Speaker 2 (transcribe pls)

that we fill up is the total.

12:56

S… Speaker 2 (transcribe pls)

We only need to sum it up.

12:58

S… Speaker 1 (transcribe pls)

Okay,

12:59

S… Speaker 1 (transcribe pls)

so you're giving,

13:02

S… Speaker 3 (transcribe pls)

which part are you filling out exactly?

13:07

S… Speaker 2 (transcribe pls)

This one,

13:08

S… Speaker 2 (transcribe pls)

the total.

13:09

S… Speaker 2 (transcribe pls)

And the total weight,

13:11

S… Speaker 2 (transcribe pls)

the total cup,

13:14

S… Speaker 2 (transcribe pls)

and the quantity,

13:16

S… Speaker 2 (transcribe pls)

the warehouse case quantity,

13:17

S… Speaker 2 (transcribe pls)

we just need to run a certain formula,

13:21

S… Speaker 2 (transcribe pls)

be look up formula for us to be able to get those information from the product

13:25

S… Speaker 2 (transcribe pls)

dimension file,

13:26

S… Speaker 2 (transcribe pls)

the package dimension.

13:29

S… Speaker 2 (transcribe pls)

And then

13:31

S… Speaker 2 (transcribe pls)

what we manually do you said product dimension file is

13:35

S… Speaker 1 (transcribe pls)

that the package dimension or is that yeah the package dimension no

13:40

S… Speaker 1 (transcribe pls)

external file or anything no external file that's

13:44

S… Speaker 1 (transcribe pls)

all and what's what what's

13:48

S… Speaker 4 (transcribe pls)

this page uh that

13:53

S… Speaker 2 (transcribe pls)

page um the that that one is the

13:57

S… Speaker 2 (transcribe pls)

file that um we are downloading from grovana

14:01

S… Speaker 1 (transcribe pls)

portal

14:04

S… Speaker 2 (transcribe pls)

And that is the list of POs or the orders that came in that

14:08

S… Speaker 2 (transcribe pls)

is coming in weekly,

14:10

S… Speaker 2 (transcribe pls)

on a weekly basis.

14:11

S… Speaker 2 (transcribe pls)

We need to download this.

14:12

S… Speaker 2 (transcribe pls)

Then we just need to...

14:16

S… Speaker 2 (transcribe pls)

The information from the...

14:19

S… Speaker 2 (transcribe pls)

What do you call that?

14:20

S… Speaker 2 (transcribe pls)

The fulfillment center and the rest is coming from that page.

14:23

S… Speaker 2 (transcribe pls)

We just need to run a pivot table to get those.

14:27

S… Speaker 4 (transcribe pls)

Okay,

14:29

S… Speaker 1 (transcribe pls)

let me...

15:00

S… Speaker 3 (transcribe pls)

yeah um what's the sheet i'm

15:07

S… Speaker 1 (transcribe pls)

not seeing your screen what happened before uh that's

15:11

S… Speaker 1 (transcribe pls)

also uh those in that information is also coming from that

15:16

S… Speaker 1 (transcribe pls)

um the the po the first

15:20

S… Speaker 1 (transcribe pls)

part the the one that we're downloading from this one yes

15:27

S… Speaker 1 (transcribe pls)

Because we need that information.

15:29

S… Speaker 1 (transcribe pls)

We are running a people table as well.

15:32

S… Speaker 1 (transcribe pls)

For that,

15:33

S… Speaker 1 (transcribe pls)

we need that information for us to be able to determine how many ASINs

15:37

S… Speaker 1 (transcribe pls)

will be shipped that we would be shipping out for that

15:42

S… Speaker 1 (transcribe pls)

week.

15:42

S… Speaker 1 (transcribe pls)

The number of ASINs or the number of products that we

15:46

S… Speaker 1 (transcribe pls)

will be shipping out for that week.

15:47

S… Speaker 3 (transcribe pls)

Okay,

15:48

S… Speaker 2 (transcribe pls)

so it takes this and creates a summary.

15:50

S… Speaker 2 (transcribe pls)

And you're sending this to who?

15:54

S… Speaker 1 (transcribe pls)

Fairhouse.

15:55

S… Speaker 3 (transcribe pls)

Okay.

16:06

S… Speaker 1 (transcribe pls)

So technically,

16:07

S… Speaker 1 (transcribe pls)

we are sending two separate,

16:09

S… Speaker 1 (transcribe pls)

or we need to send those to the PO file or

16:13

S… Speaker 1 (transcribe pls)

the PO info sheet that quantity

16:18

S… Speaker 1 (transcribe pls)

ordered summary to the warehouse team.

16:20

S… Speaker 3 (transcribe pls)

Okay.

16:27

S… Speaker 3 (transcribe pls)

Who's

16:32

S… Speaker 2 (transcribe pls)

filling this in?

16:34

S… Speaker 3 (transcribe pls)

That from?

16:37

S… Speaker 1 (transcribe pls)

What part?

16:39

S… Speaker 1 (transcribe pls)

That would be the fulfillment center.

16:44

S… Speaker 1 (transcribe pls)

Yeah.

16:44

S… Speaker 1 (transcribe pls)

Up until the other quantity,

16:46

S… Speaker 1 (transcribe pls)

it's from the file that we downloaded from Grovana.

16:50

S… Speaker 3 (transcribe pls)

Okay,

16:53

S… Speaker 2 (transcribe pls)

from this file?

16:54

S… Speaker 2 (transcribe pls)

Yes.

16:56

S… Speaker 2 (transcribe pls)

And how are you taking this?

16:59

S… Speaker 2 (transcribe pls)

So this is only what you get from Grovana?

17:03

S… Speaker 1 (transcribe pls)

Yeah, this is only what we get from Rukovana.

17:05

S… Speaker 1 (transcribe pls)

Then for the summary to the warehouse of the number

17:10

S… Speaker 1 (transcribe pls)

of ASINs that is ordered for that week,

17:12

S… Speaker 1 (transcribe pls)

we run a PBA table and a separate PBA table so

17:18

S… Speaker 1 (transcribe pls)

that we can obtain those information

17:22

S… Speaker 1 (transcribe pls)

that we need for the PO file or the PO info,

17:25

S… Speaker 1 (transcribe pls)

the fulfillment center up until the order quantity.

17:29

S… Speaker 3 (transcribe pls)

Okay,

17:33

S… Speaker 2 (transcribe pls)

so you're using a VLOOKUP to generate this?

17:35

S… Speaker 1 (transcribe pls)

Pbot,

17:36

S… Speaker 1 (transcribe pls)

actually.

17:37

S… Speaker 2 (transcribe pls)

Can you type that?

17:40

S… Speaker 1 (transcribe pls)

Oh,

17:41

S… Speaker 3 (transcribe pls)

there.

17:51

S… Speaker 2 (transcribe pls)

I'm not sure I'm hearing it right.

17:52

S… Speaker 1 (transcribe pls)

I'll pivot.

17:53

S… Speaker 1 (transcribe pls)

And

17:57

S… Speaker 2 (transcribe pls)

what about this one?

17:59

S… Speaker 3 (transcribe pls)

That's

18:03

S… Speaker 1 (transcribe pls)

the same info.

18:04

S… Speaker 3 (transcribe pls)

Yeah,

18:09

S… Speaker 1 (transcribe pls)

that's this.

18:10

S… Speaker 2 (transcribe pls)

No,

18:11

S… Speaker 2 (transcribe pls)

that's something slightly different.

18:12

S… Speaker 1 (transcribe pls)

This

18:18

S… Speaker 2 (transcribe pls)

will go to the warehouse also?

18:19

S… Speaker 1 (transcribe pls)

No.

18:25

S… Speaker 1 (transcribe pls)

So what table results?

18:27

S… Speaker 1 (transcribe pls)

Then I'm copying it,

18:29

S… Speaker 1 (transcribe pls)

just pasting the values on the PO info file.

18:32

S… Speaker 3 (transcribe pls)

And

18:45

S… Speaker 2 (transcribe pls)

then, OK.

18:47

S… Speaker 3 (transcribe pls)

Another

19:09

S… Speaker 2 (transcribe pls)

thing that would help is creating the pivot table.

19:12

S… Speaker 2 (transcribe pls)

What exactly are you using

19:16

S… Speaker 2 (transcribe pls)

to do?

19:16

S… Speaker 2 (transcribe pls)

What columns and rows?

19:19

S… Speaker 1 (transcribe pls)

Sorry?

19:21

S… Speaker 2 (transcribe pls)

For the pivot tables.

19:24

S… Speaker 1 (transcribe pls)

Oh.

19:25

S… Speaker 2 (transcribe pls)

If you want to just take a screenshot

19:29

S… Speaker 1 (transcribe pls)

of.

19:31

S… Speaker 2 (transcribe pls)

But you're selecting the columns in rows and such.

19:33

S… Speaker 1 (transcribe pls)

I see the fields that we're

19:39

S… Speaker 1 (transcribe pls)

choosing.

19:39

S… Speaker 1 (transcribe pls)

OK,

19:40

S… Speaker 1 (transcribe pls)

I'll do that.

19:41

S… Speaker 1 (transcribe pls)

I'll be sending it to you.

19:43

S… Speaker 1 (transcribe pls)

I just need to open.

19:45

S… Speaker 1 (transcribe pls)

I'll be sending it to you for later.

19:48

S… Speaker 1 (transcribe pls)

I'll just need to open a nose PO file that we have on our end.

19:52

S… Speaker 1 (transcribe pls)

Then I'll mark all those.

19:55

S… Speaker 1 (transcribe pls)

I'm sorry.

19:57

S… Speaker 1 (transcribe pls)

I'll mark the.

20:00

S… Speaker 2 (transcribe pls)

the fields that we are choosing when we are running the PBOT table.

20:04

S… Speaker 1 (transcribe pls)

Is the

20:08

S… Speaker 1 (transcribe pls)

only thing that you're actually filling out is the carton label quantity?

20:11

S… Speaker 1 (transcribe pls)

Because these are formulas.

20:13

S… Speaker 1 (transcribe pls)

So the only thing you

20:17

S… Speaker 1 (transcribe pls)

do manually is the carton label?

20:18

S… Speaker 2 (transcribe pls)

Yes.

20:19

S… Speaker 3 (transcribe pls)

Now,

20:21

S… Speaker 1 (transcribe pls)

what about the ARN and carrier?

20:22

S… Speaker 2 (transcribe pls)

The ARN,

20:25

S… Speaker 2 (transcribe pls)

it will be generated from the Graboana portal.

20:29

S… Speaker 2 (transcribe pls)

The courier,

20:30

S… Speaker 2 (transcribe pls)

don't mind that.

20:31

S… Speaker 2 (transcribe pls)

We are not really using that.

20:34

S… Speaker 2 (transcribe pls)

The ARN,

20:36

S… Speaker 2 (transcribe pls)

once we're able to create the shipment,

20:39

S… Speaker 2 (transcribe pls)

the ARN will be generated from the

20:44

S… Speaker 2 (transcribe pls)

Grovano portal,

20:45

S… Speaker 2 (transcribe pls)

and we are entering it manually or inputting

20:49

S… Speaker 2 (transcribe pls)

it manually into that PO file,

20:52

S… Speaker 2 (transcribe pls)

that PO info file.

20:55

S… Speaker 1 (transcribe pls)

Okay,

20:56

S… Speaker 1 (transcribe pls)

so you do fill out the ARM carrier,

20:58

S… Speaker 1 (transcribe pls)

but this comes from?

20:59

S… Speaker 2 (transcribe pls)

The portal.

21:01

S… Speaker 1 (transcribe pls)

Yeah.

21:02

S… Speaker 2 (transcribe pls)

Once the shipment is successfully created.

21:06

S… Speaker 3 (transcribe pls)

So

21:14

S… Speaker 2 (transcribe pls)

if there's a way,

21:15

S… Speaker 2 (transcribe pls)

question,

21:17

S… Speaker 2 (transcribe pls)

shipment creation,

21:19

S… Speaker 2 (transcribe pls)

is it part of the automation?

21:22

S… Speaker 1 (transcribe pls)

Yeah,

21:24

S… Speaker 1 (transcribe pls)

everything is.

21:25

S… Speaker 2 (transcribe pls)

So is there a way that once the shipment is

21:29

S… Speaker 2 (transcribe pls)

created,

21:30

S… Speaker 2 (transcribe pls)

is there a way that ARN will be automatically

21:35

S… Speaker 2 (transcribe pls)

populate on that said PO file that we could?

21:39

S… Speaker 2 (transcribe pls)

Good thing.

21:41

S… Speaker 3 (transcribe pls)

Yeah,

21:42

S… Speaker 1 (transcribe pls)

all this can be populated.

21:45

S… Speaker 1 (transcribe pls)

It's all available.

21:46

S… Speaker 2 (transcribe pls)

Good thing.

21:47

S… Speaker 2 (transcribe pls)

That's good to hear.

21:49

S… Speaker 1 (transcribe pls)

Now,

21:50

S… Speaker 1 (transcribe pls)

I need to also verify the...

21:58

S… Speaker 1 (transcribe pls)

exactly exact order give me a minute i

22:02

S… Speaker 1 (transcribe pls)

have so many hundreds thousands

22:06

S… Speaker 1 (transcribe pls)

of files it's really i know really hard to just you

22:11

S… Speaker 2 (transcribe pls)

know what at times i'm just reading all your messages on

22:16

S… Speaker 2 (transcribe pls)

the group chat and it makes my headache i

22:20

S… Speaker 1 (transcribe pls)

need

22:29

S… Speaker 3 (transcribe pls)

the onboarding this will

22:43

S… Speaker 1 (transcribe pls)

probably hurt um

22:45

S… Speaker 2 (transcribe pls)

Yeah,

22:46

S… Speaker 2 (transcribe pls)

codes again.

22:47

S… Speaker 1 (transcribe pls)

We are in network.

22:51

S… Speaker 3 (transcribe pls)

Yeah,

23:00

S… Speaker 1 (transcribe pls)

the 754 ARN update is

23:04

S… Speaker 3 (transcribe pls)

based on

23:11

S… Speaker 1 (transcribe pls)

this flowchart.

23:13

S… Speaker 3 (transcribe pls)

So the

23:21

S… Speaker 1 (transcribe pls)

confirmation of the order via Grovana portal is going to be when you accept

23:26

S… Speaker 1 (transcribe pls)

an order in here.

23:32

S… Speaker 1 (transcribe pls)

I need to verify that we're getting all the steps.

23:36

S… Speaker 3 (transcribe pls)

And

23:40

S… Speaker 1 (transcribe pls)

pick back and shift,

23:44

S… Speaker 1 (transcribe pls)

confirm order of eventual center.

23:45

S… Speaker 1 (transcribe pls)

At this point,

23:46

S… Speaker 1 (transcribe pls)

I imagine you have,

23:48

S… Speaker 1 (transcribe pls)

let me record this.

23:51

S… Speaker 3 (transcribe pls)

Okay,

24:07

S… Speaker 1 (transcribe pls)

where's the record?

24:07

S… Speaker 1 (transcribe pls)

I can't record.

24:08

S… Speaker 1 (transcribe pls)

Okay, can you record it?

24:09

S… Speaker 3 (transcribe pls)

Or

24:15

S… Speaker 1 (transcribe pls)

set me as the moderator,

24:16

S… Speaker 1 (transcribe pls)

if that's possible,

24:17

S… Speaker 3 (transcribe pls)

so

24:21

S… Speaker 1 (transcribe pls)

that you don't have to send it.

24:22

S… Speaker 2 (transcribe pls)

I actually don't know how.

24:26

S… Speaker 1 (transcribe pls)

Oh, me neither.

24:28

S… Speaker 1 (transcribe pls)

It's just available in other programs.

24:31

S… Speaker 2 (transcribe pls)

I don't know how to set you as a moderator,

24:34

S… Speaker 2 (transcribe pls)

but let me check.

24:37

S… Speaker 3 (transcribe pls)

Okay,

24:44

S… Speaker 2 (transcribe pls)

I'll record it.

24:45

S… Speaker 3 (transcribe pls)

It's

24:56

S… Speaker 2 (transcribe pls)

now being recorded.

25:00

S… Speaker 4 (transcribe pls)

me a second okay I'm

25:22

S… Speaker 4 (transcribe pls)

back okay once

25:28

S… Speaker 1 (transcribe pls)

they confirm it at this point we

25:33

S… Speaker 1 (transcribe pls)

should have this is where you generate this Excel spreadsheet correct once

25:38

S… Speaker 1 (transcribe pls)

I yeah and that's before they start picking

25:43

S… Speaker 1 (transcribe pls)

packing and shipping the order not

25:47

S… Speaker 1 (transcribe pls)

yet

25:52

S… Speaker 3 (transcribe pls)

Picking,

25:53

S… Speaker 3 (transcribe pls)

packing, and shipping the order once.

25:55

S… Speaker 3 (transcribe pls)

Because once we confirm this,

25:57

S… Speaker 3 (transcribe pls)

that's the time that I will be able to do

26:02

S… Speaker 3 (transcribe pls)

the PO file.

26:03

S… Speaker 3 (transcribe pls)

And once I'm able to do the PO file and send it to

26:08

S… Speaker 3 (transcribe pls)

them, they will be preparing the order,

26:11

S… Speaker 3 (transcribe pls)

the warehouse team.

26:13

S… Speaker 3 (transcribe pls)

Then while they are preparing

26:17

S… Speaker 3 (transcribe pls)

the order,

26:18

S… Speaker 3 (transcribe pls)

I need to create the shipment.

26:24

S… Speaker 1 (transcribe pls)

Okay.

26:25

S… Speaker 3 (transcribe pls)

Once I created the shipment,

26:27

S… Speaker 3 (transcribe pls)

the ARN would be generated.

26:30

S… Speaker 3 (transcribe pls)

Then there's a certain turnaround time before

26:34

S… Speaker 3 (transcribe pls)

the shipping labels will be available for me to

26:38

S… Speaker 1 (transcribe pls)

download.

26:39

S… Speaker 3 (transcribe pls)

Once it's downloaded,

26:41

S… Speaker 3 (transcribe pls)

I'll be sending it to the warehouse team,

26:44

S… Speaker 3 (transcribe pls)

and that's the time that they would start shipping the order.

26:47

S… Speaker 4 (transcribe pls)

Okay,

26:48

S… Speaker 1 (transcribe pls)

so they get the worksheet

26:52

S… Speaker 1 (transcribe pls)

before?

26:54

S… Speaker 1 (transcribe pls)

you start creating the shipment?

26:55

S… Speaker 6 (transcribe pls)

Yeah,

26:56

S… Speaker 3 (transcribe pls)

I'm able to give them the worksheet before I start creating the shipment so that

27:00

S… Speaker 3 (transcribe pls)

they'll be able to prepare all the package or all

27:05

S… Speaker 3 (transcribe pls)

the items that needs to be shipped.

27:07

S… Speaker 1 (transcribe pls)

So after they receive the worksheet,

27:09

S… Speaker 1 (transcribe pls)

do you wait for them before you start

27:13

S… Speaker 1 (transcribe pls)

creating the shipment?

27:14

S… Speaker 5 (transcribe pls)

No,

27:16

S… Speaker 3 (transcribe pls)

I wait for the Grubana portal before I start creating the shipment because there's...

27:22

S… Speaker 3 (transcribe pls)

Once I confirm an order,

27:24

S… Speaker 3 (transcribe pls)

we need to wait for approximately 24

27:30

S… Speaker 3 (transcribe pls)

hours or less at times.

27:33

S… Speaker 3 (transcribe pls)

But once an ARN is,

27:37

S… Speaker 5 (transcribe pls)

I'm sorry,

27:38

S… Speaker 3 (transcribe pls)

once I confirm the order,

27:39

S… Speaker 3 (transcribe pls)

we wait for approximately 24 hours or

27:44

S… Speaker 3 (transcribe pls)

less, but mostly 24 hours before we can create a

27:48

S… Speaker 1 (transcribe pls)

shipment.

27:48

S… Speaker 4 (transcribe pls)

Okay.

27:52

S… Speaker 1 (transcribe pls)

And so it's not dependent on the warehouse having

27:57

S… Speaker 1 (transcribe pls)

the worksheet?

27:58

S… Speaker 1 (transcribe pls)

Okay.

transcribe pls

摘要

询问 AI 有关此分页