You are looking the correct place.  They should be there but there will not be a distinction between the manual vs the automatic.

It's not showing - it only shows the standard rate but not any additional entered amount added or separate. However, the perpetual history report that comes with Sage100 does show it. We wonder if it is getting it from another table.

Should not be a separate table.  The one you are looking at should be showing exactly what was taken on the checks.

Are you absolutely sure that these manual amounts actually made it to the checks issued?   There is a recalc feature for automatically calculated deductions that someone may have tripped and deleted the manual changes before the checks were printed.

Yes, checks reflect all the amounts.

What table houses the actual deductions rates?

PRD.

I'm beginning to suspect we are not talking about the same thing.  We are out of sync somewhere.

Because Anaco says "It's not showing - it only shows the standard rate", I must add that PR_23 does not have a standard deduction Rate,  I must point out that the Rate in PR_23 does not matter, the filed you should be looking at is "Amount", because the rate is the rate all day long, but if at data entry the Payroll person clicks over to Amount, and enters a different amount, you will only see it in the Amount Field.  Ignore the Rate filed and stick only to the Amount field.

I think this may be the issue.

The PR_23 indeed does not have a deduction rate; it has amount rate which is the field we've been using so far. However, Sage showed us that this is not the table we should be using. This table shows only what is deducted which is drawn from the standard rate set in the system but this rate is obviously not set in this table. However, what are recorded  here are automatically deducted amounts but if later manual amounts are entered, they don't show up in this table.