Build 1099 G/L Workfile

This table lists frequently asked questions about the 1099 G/L workfile, and their answers:

Question

Answer

Do I have to clear the 1099 A/P Worktable (F045143) from last year even though I am using the G/L method this year?

Yes, because the Write Media program combines the transactions from both worktables.

Why are taxes included in the totals for my suppliers and how do I exclude these taxes?

Taxes are included in the totals because the tax accounts are included in one of the AAI ranges. To exclude taxes, remove the tax accounts from the AAI ranges and rerun the Build 1099 G/L Workfile program (R04514).

Do I need to rebuild my 1099 G/L Worktable (F045141) if I just cleared the F045143 table?

No. These tables are separate, and not interdependent.

I have accounts that are included in the AAI ranges but are not included when I run the Build 1099 G/L Workfile program (R04514). Why?

Verify that the AAIs for those accounts have a subsidiary of either 99999999 or ZZZZZZZZZ for the ending range, depending on the operating system. If you are not sure whether to use 99999999 or ZZZZZZZZ, contact the system administrator.

Do I have to clear the F045141 table from last year?

No. The Build 1099 G/L Workfile program automatically clears the F045141 table before building it again.

Why is the F045141 table empty? I ran the program to build the table.

This might be caused by these circumstances:

  • The G/L bank account or the A/P trade account is included in the range of AAIs, resulting in a zero balance. Remove the account from the AAI range.

  • The AAIs are missing an object account.

  • The AAI range is missing a subsidiary of either 99999999 or ZZZZZZZZZ, depending on the operating system. The subsidiary causes the system to include all accounts for the object account.