Re: Could box 4 "Federal Income Tax Withheld" in Form 1099 generated by Great Plains be filled in automatically?
When you posted the manual checks, did you use different vendor IDs for the trust funds, etc? GP will let you change the name on the check and use a different address ID, then you wouldn't have to worry about that amount going on a 1099. I'm confused about what you need to do, 1099s are filed for income to the vendor. Did the vendor tell you to send the checks somewhere else instead of to him?
I'm going to presume that is the case. If you didn't use the vendor's ID to record the payments, then you need to edit the 1099 details in order for the amounts to appear on the 1099. Don't forget to include the amount paid to the IRS as income too. As far as the withholding is concerned, GP does not handle this well. If you go to company setup options there is information pertaining to withholding. This is not intended for the USA, but it will get the amount to Box 4. Unfortunately, it doesn't put it in Box 7, so you still have to edit the 1099 details.
So, in short - to get the amount of all of the payments to the trust funds and IRS to show up in box 7, use the same vendor ID and different Check Names and address IDs. To get the amount to show up in Box 4 AND Box 7 you have to manually update. GP does not provide for withholding on vendor payments and report it properly.
No matter what, something will need to be edited manually.
Kind regards,
Leslie