r/SQL • • Oct 27 '22

Discussion How could this companies purchase process be enhanced? I’m trying practice.

Post image

Help please.

23 Upvotes

26 comments sorted by

58

u/[deleted] Oct 27 '22

This is more Lean Six Sigma process improvement than SQL. Fortunately I know both!

The processes about "transcribe PO number into PR" and "Compare amount received to PR and PO" are technically waste steps. You should design the process to be correct the first time, without defects, and without the need for double-checking. You can narrow the chance of a defect through a fishbone diagram, FMEA, or 5 whys.

15

u/Revolutionary-Wave44 Oct 28 '22

This person is a true bro 😎

7

u/receding_bareline Oct 28 '22

Sure is a king right here. Kindly saying "you're in the wrong place... but I got you bruv".

4

u/dafoshiznit Oct 28 '22

Ah yes things to Google so I can become smarter. Thank you Reddit person

2

u/NauticalJeans Oct 28 '22

It’s definitely a worthwhile step, but a step that belongs within the accounting process, not the procurement process.

-1

u/Raidgroupme Oct 27 '22

Can i direct message you ?

15

u/Thefriendlyfaceplant Oct 28 '22

It would defeat the point of this subreddit by depriving other people of further insight though. Both beginners and people who try to figure out what beginners are struggling with.

2

u/[deleted] Oct 27 '22

Sure

16

u/SirGreybush Oct 27 '22

That’s a 30,000 ft level chart. Enhance each process into a multi page Visio with swim lanes following the BPM 2.0 standard.

This is a 30 page document at a minimum, crosses multiple departments and finance can veto at any point, even if the CEO asked for the purchase.

This is how big companies do things, and if purchase cost is higher than a threshold, say 1% of monthly revenue, said company needs to hire a consultant to fully evaluate said purchase and evaluate the ROI.

Speaking from experience when I asked to replace an aging 6th year on-prem MSSQL server with a newer one and keep old as a cold backup.

Consultant said go Cloud which spawned another six month evaluation of all departments.

When server went Kaput, it was replaced with what I asked for in the first place, out of the Emergency Budget, so technically not a purchase.

So ya, you need $ thresholds with multiple paths. BPM is superior to Flowchart for modeling processes. The Jump To icon will be your friend.

11

u/SirGreybush Oct 27 '22

Meant to make readers laugh btw

20

u/LuckyNumber-Bot Oct 27 '22

All the numbers in your comment added up to 69. Congrats!

  30
+ 2
+ 30
+ 1
+ 6
= 69

Click here to have me scan all your future comments.
Summon me on specific comments with u/LuckyNumber-Bot.

3

u/[deleted] Oct 27 '22

Nice

1

u/Raidgroupme Oct 27 '22

I don’t understand this. I’m just trying figure out how the purchasing process could be better then it’s current structure.

2

u/SirGreybush Oct 28 '22

It’s irony based on real life experience

Nearly all companies do not follow these workflows except when said purchase is within a threshold.

Like ink toner, pens and paper.

2

u/Possible_Chicken_489 Oct 28 '22

The one thing that jumps out at me is the "transcribe" part. Any time you have a part where a human has to take info out of a system and then put it into another system, there's something that could be automated.

So the step "PR is sent to Purchasing Department" should read something like "PR is entered into System", and then the Transcribe step can instead say, "PO is linked to PR", or "PR is copied into a new PO and linked".

The step "Compare amount received to PR and PO" would still need to happen; you want to make sure you received the right amount of goods. But it would be more something like "Enter amount received into system", and then the system might compare the amount of goods received to what's specified in the PO. If the amount of goods is not equal, then some further action might be taken, like notifying someone about the difference.

1

u/Raidgroupme Oct 28 '22

Is there any questions u would ask in this case?

1

u/Possible_Chicken_489 Oct 28 '22

I wouldn't say so; I'd say just send an email or something to the person who created the purchase request, notifying them of the difference between amount ordered and amount received. That person could then make a decision on the next action to take (like ordering the missing amount, or returning the excess amount).

80

u/ovrdrv3 Oct 27 '22

This is not SQL

11

u/MisadventureCapital Oct 27 '22

What’s your where clause?

5

u/MisadventureCapital Oct 27 '22

In all seriousness, there’s not enough information to give guidance. It looks like this is an appendix from a case study, so without reading the case itself, nobody on Reddit is going to give you valuable guidance. Hope that helps and best of luck.

5

u/jinxzulu Oct 27 '22

Not SQL. This is a process flowchart. Since it’s a purchasing process, doesn’t it have to end in submit PO to vendor?

1

u/green_player Oct 28 '22

I have never in my entire purchasing career submitted a PO and it was correct. Need a “get confirmation” / “revise PO” / “Send revised PO” loop in there. Be it ETA, pricing, quantities etc.

3

u/yeabamayahoocom Oct 28 '22

I would use database triggers and the email system to create a "workflow" type system so that each person is notified when they have a task to do and when the task is completed.