I have to say...
You do consistently have the most accurate and simplest answers to technical subjects. I think I am well rounded myself, but do learn a lot from your knowledge and common sense experience. many would gain more by listening and paying attention instead of trying to disprove the words of those posting or just ignoring what is plainly stated.

That said, can you elaborate on the difference between dot's per inch vs pixels when printing to end the confusion.

From what I understand PPi determines the physical size of a print, and DPI the color and quality that can be printed from the PPi data. In that, pixels are picture elements, or the smallest unit a screen can display and dots per inch are the smallest thing a printer can print.

The answer needed to illustrate...

How would an image from lets say from a Fuji GFX 100 cropped to 20 megapixels, then sized and printed to 48" x 36" with the maximum 1200 dpi... compared to the full 100 mpxl image at the same print size, but with only 100 dpi? ...

re @ Bill_de
While I responded to this earlier Bill raises a good point which I also alluded to in my comment.
Photography and photographic Prints Both begin and end with looking. If the results pleas you thats a good thing.
All the math came second, from reverse engineering the numbers involved from good looking Prints.
They are all guidelines, they guarantee nothing. Because printing processes and opinions about what constitutes a good print vary quite widely. The same print viewed at different distances, might be judged quite differently.
There is a reason that a picture with insufficient pixels according to 'guidelines' can make a beautiful print.
A scene without lots of small detail does not require as much pixel resolution to look good. Likewise a wide Gamut inkjet printer on fine paper has a better chance of producing an attractive print than a commercial 4 color offset on cheap paper. Then there is file preparation, in experienced skilled hands doing file prep and editing your picture has a much better chance of looking good as a print. It is a completely mistaken notion that "If I meet these criteria, I get a good print.
Because Digital Photography has created and encouraged Pixel peepers, sharper & contrastier pictures have become the new normal, tastes change. Look back to the pictorialists and Gertrude Kasebier for a different definition of Good Print.
Printing can be enjoyed on many levels, if it is of your new grandchild you are going to automatically love it.

My point here is "Will xyzzy make a good print" is another of those unanswerable questions, that we all keep trying, (mostly in vein) to answer. Because there is always too little information, and we have no Idea of what the questioner would judge to be good
The real answer to that question is "TRY IT , AND SEE" Do the work, it is how we learn best.

Most of us genuinely would like to be helpful, so we "Walk down the same street, and fall in the same Hole"

Once again, ppi is the number of pixels contained in one inch of a digital image. Dpi is a measure of the distance apart of drops of ink on paper. A pixel has a border—you can magnify your image and view individual pixels and they will be square, exactly the same size, and exactly border the neighboring pixel. Ink dots will vary in size depending on the printer, are measured in picoliters (which I believe is a measure of volume of ink and not physical size of the drop; someone can correct me if I misunderstand that) and under a microscope would look more like a blob with rough edges, because when the ink hits the paper, it soaks in and spreads depending on the surface of the paper. That is why your choice of paper for a print is so important when printing. Ink will spread less and soak in less on high gloss paper than on matte or rag, and the look will be very different.

An electronic picture element and an ink drop are completely different things and cannot and should not be directly compared.

I have to say...
You do consistently have the most accurate and simplest answers to technical subjects. I think I am well rounded myself, but do learn a lot from your knowledge and common sense experience. many would gain more by listening and paying attention instead of trying to disprove the words of those posting or just ignoring what is plainly stated.

That said, can you elaborate on the difference between dot's per inch vs pixels when printing to end the confusion.

From what I understand PPi determines the physical size of a print, and DPI the color and quality that can be printed from the PPi data. In that, pixels are picture elements, or the smallest unit a screen can display and dots per inch are the smallest thing a printer can print.

The answer needed to illustrate...

How would an image from lets say from a Fuji GFX 100 cropped to 20 megapixels, then sized and printed to 48" x 36" with the maximum 1200 dpi... compared to the full 100 mpxl image at the same print size, but with only 100 dpi? ...

There's a comment above that says something along the lines: dots are an attribute of ink on paper. Pixels are an attribute of an electronic display device. There is ZERO relationship between these two display methods. If there was a relationship, someone -- anyone -- could answer just once this basic non sequitur: how many pixels are in a dot? Or, the corollary: how many dots are in a pixel?

To your question about pixels and dpi, the question is as nonsensical as asking how many inches are in a liter of water? They have no relationship. The printer has an attribute of how many dots it will print on paper. But, those 'dots' have nothing to do with any specific image file sent to that printer.

When considering the physical printing of a pixel-based image, you want to perform some basic arithmetic steps:

1, prepare your image file (edited, cropping, etc).

2, determine your target physical print size, in inches for us here in the US.

3, review the pixel dimensions of your edited image file.

4, calculate the ppi ratio of your image file to the target print size.

5a, If the calculated ratio is 300 ppi or higher, send the file to print.

5b, if the calculated ratio is less than 300 ppi, decide if i) the target print is too large, or ii) the ratio is 'fine' for the intended print size, or iii) is there a software solution that might increase the ppi ratio? Send the file to print, when ready and / or to test ideas i, ii, and iii.

My point...
pixels have a physical size, border and dimension that determines resolution for everything. Dots per inch in printing is a physical display of digital data in that same inch on paper. DPI is a variable that can then affect print quality beyond resolution.

A printer will use a number of different colored inks in order to create the right color. The more dots it can print per inch, the more accurate the colors will be in translating the digital data to paper. If you print at 1200 DPI, you won’t end up with distortion and the scale won’t be affected, you’ll just end up with a higher quality print than if you had you used less DPI.

Most displays with a max resolution of 96 PPI will have a bottleneck much smaller than print size and simply are a direct reading of PPI... PPI is a physical translation for PPI to create an image on paper from a printing machine.

My original question put forward was about the final print... which will most effect the actual print outcome, PPI or DPI when compared from a professional printer?

Not to argue with anyone about the technical differences, just a question about print quality...

The number of dots per inch as well as color channels available/used is going to be a function of the printer's driver/RIP etc. based on the instructions from the paper profile being used, which is why printing on paper that has been profiled to your specific printer is so important. Of course if you're using a professional print service, they should take care of all that for you. I quote from an article on Wikipedia:

"Up to a point, printers with higher DPI produce clearer and more detailed output. A printer does not necessarily have a single DPI measurement; it is dependent on print mode, which is usually influenced by driver settings. The range of DPI supported by a printer is most dependent on the print head technology it uses. A dot matrix printer, for example, applies ink via tiny rods striking an ink ribbon, and has a relatively low resolution, typically in the range of 60 to 90 DPI (420 to 280 μm). An inkjet printer sprays ink through tiny nozzles, and is typically capable of 300–720 DPI.[3] A laser printer applies toner through a controlled electrostatic charge, and may be in the range of 600 to 2,400 DPI."