![\"\"](\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/1099-Extract-1024x256.png\" "\\"\\"")
<\/figure>\n\n\n\nBusiness Rules<\/strong><\/h2>\n\n\n\n\n- Cut Date defaults to the current system date if left blank.<\/li>\n\n\n\n
- Only vendors that are Active, Vendor = Yes, and 1099 Vendor = Yes are included.<\/li>\n\n\n\n
- Only Purchase Invoices that are Paid and Completed or Closed are processed.<\/li>\n\n\n\n
- Each invoice line must have a 1099 Box assigned to be included.<\/li>\n\n\n\n
- Invoices are selected from the first day of the Cut Date year through the Cut Date.<\/li>\n\n\n\n
- Bucket amounts are calculated for all 16 IRS reporting buckets.<\/li>\n\n\n\n
- Extracted data is inserted into T_1099Extract only; no source records are updated.<\/li>\n<\/ul>\n\n\n\n
Prerequisites<\/strong><\/h2>\n\n\n\n\n- 1099 Box categories configured.<\/li>\n\n\n\n
- Vendor Business Partners marked as 1099 Vendor with a Default 1099 Box.<\/li>\n\n\n\n
- Purchase Invoices completed, paid, and dated within the reporting year.<\/li>\n<\/ul>\n\n\n\n
Configuration Steps<\/strong><\/h2>\n\n\n\nStep 1: Configure the 1099 Box Categories<\/strong><\/h3>\n\n\n\nEvery extracted amount needs a reporting category to group into, so the relevant 1099 Boxes must exist before invoices reference them.<\/p>\n\n\n\n
Create the required 1099 Box records, such as Nonemployee Compensation, before recording qualifying Purchase Invoices.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Search Key<\/td> 1099-NEC-01<\/td> Unique identifier for the 1099 Box<\/td><\/tr> Name<\/td> Nonemployee Compensation<\/td> IRS reporting category name<\/td><\/tr> Bucket<\/td> 1<\/td> IRS box number this category reports under<\/td><\/tr> Note: <\/strong>1099 Boxes become available for Purchase Invoice Lines once created and Active.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 2: Configure the Vendor as a 1099 Vendor<\/strong><\/h3>\n\n\n\nOnly vendors explicitly flagged as 1099 Vendors are considered, so this setting determines who appears in the extract at all.<\/p>\n\n\n\n
Open the Vendor Business Partner, enable 1099 Vendor, and assign a Default 1099 Box.<\/p>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>1099 Vendor<\/td> Yes<\/td> Marks the Business Partner as eligible for 1099 reporting<\/td><\/tr> Default 1099 Box<\/td> Nonemployee Compensation<\/td> Category used when invoice lines do not specify their own box<\/td><\/tr> Active<\/td> Yes<\/td> Business Partner must be active to be included<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 3: Record a Qualifying Purchase Invoice<\/strong><\/h3>\n\n\n\nAn invoice only counts toward the extract once it is fully paid, completed, and tagged with a 1099 Box on its line.<\/p>\n\n\n\n
Create and complete the Purchase Invoice, assign a 1099 Box on the Invoice Line, then process the payment to Paid status.<\/p>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsSOTrx<\/td> N<\/td> Confirms the document is a Purchase Invoice, not a Sales Invoice<\/td><\/tr> Document Status<\/td> Completed<\/td> Invoice must be Completed or Closed to qualify<\/td><\/tr> Paid<\/td> Yes<\/td> Invoice must be fully paid to qualify<\/td><\/tr> Invoice Line 1099 Box<\/td> Nonemployee Compensation<\/td> Category the line amount reports under<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 4: Run the 1099 Extract Process<\/strong><\/h3>\n\n\n\nRunning the process is what actually scans invoices and builds the reporting data; nothing is extracted until it is executed.<\/p>\n\n\n\n
Open 1099 Extract, enter the Cut Date, optionally check Run as Job, then click OK.<\/p>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Cut Date<\/td> 31-Dec-2026<\/td> End date of the reporting period; defaults to today if left blank<\/td><\/tr> Run as Job<\/td> Unchecked<\/td> Runs the process in the background<\/td><\/tr> Note: <\/strong>Invoices are considered from the first day of the Cut Date year through the Cut Date itself, for example 01-Jan-2026 through 31-Dec-2026.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 5: Review the Extracted Output<\/strong><\/h3>\n\n\n\nA final check confirms the extract captured every qualifying vendor and amount before the data is used for IRS filing.<\/p>\n\n\n\n
Review the records populated in T_1099Extract and confirm amounts are grouped correctly by vendor and 1099 Box.<\/p>\n\n\n\n
Expected Result<\/strong><\/h3>\n\n\n\n\n- Eligible payments are collected and classified under the assigned 1099 Box.<\/li>\n\n\n\n
- Bucket amounts (1 through 16) reflect only qualifying invoices.<\/li>\n\n\n\n
- No Purchase Invoice, Payment, or Business Partner record is modified.<\/li>\n<\/ul>\n\n\n\n
Common Issues and Resolutions<\/strong><\/h2>\n\n\n\nIssue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>Vendor not extracted<\/td> 1099 Vendor not enabled<\/td> Enable 1099 Vendor on the Business Partner<\/td><\/tr> No extracted amount<\/td> Invoice Line has no 1099 Box<\/td> Assign a valid 1099 Box to the Purchase Invoice Line<\/td><\/tr> Vendor missing<\/td> Invoice not paid<\/td> Complete payment before running the extract<\/td><\/tr> Invoice ignored<\/td> Document Status is Draft or In Progress<\/td> Complete or Close the Purchase Invoice<\/td><\/tr> Missing invoices<\/td> Accounting Date outside the reporting year<\/td> Verify the Cut Date and Accounting Date range<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nNext Steps<\/strong><\/h2>\n\n\n\n\n- Review the generated data in T_1099Extract.<\/li>\n\n\n\n
- Validate bucket totals for each vendor.<\/li>\n\n\n\n
- Generate or print the 1099 reporting output.<\/li>\n\n\n\n
- Use the extracted data for IRS year-end filing.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
The 1099 Extract process collects eligible vendor payment information for IRS Form 1099 reporting by scanning paid Purchase Invoices for […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,10],"tags":[],"class_list":["post-20648","post","type-post","status-publish","format-standard","hentry","category-idempiere-accounting","category-idempiere-product"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=20648"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20648\/revisions"}],"predecessor-version":[{"id":20650,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20648\/revisions\/20650"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Prerequisites<\/strong><\/h2>\n\n\n\n\n- 1099 Box categories configured.<\/li>\n\n\n\n
- Vendor Business Partners marked as 1099 Vendor with a Default 1099 Box.<\/li>\n\n\n\n
- Purchase Invoices completed, paid, and dated within the reporting year.<\/li>\n<\/ul>\n\n\n\n
Configuration Steps<\/strong><\/h2>\n\n\n\nStep 1: Configure the 1099 Box Categories<\/strong><\/h3>\n\n\n\nEvery extracted amount needs a reporting category to group into, so the relevant 1099 Boxes must exist before invoices reference them.<\/p>\n\n\n\n
Create the required 1099 Box records, such as Nonemployee Compensation, before recording qualifying Purchase Invoices.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Search Key<\/td> 1099-NEC-01<\/td> Unique identifier for the 1099 Box<\/td><\/tr> Name<\/td> Nonemployee Compensation<\/td> IRS reporting category name<\/td><\/tr> Bucket<\/td> 1<\/td> IRS box number this category reports under<\/td><\/tr> Note: <\/strong>1099 Boxes become available for Purchase Invoice Lines once created and Active.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 2: Configure the Vendor as a 1099 Vendor<\/strong><\/h3>\n\n\n\nOnly vendors explicitly flagged as 1099 Vendors are considered, so this setting determines who appears in the extract at all.<\/p>\n\n\n\n
Open the Vendor Business Partner, enable 1099 Vendor, and assign a Default 1099 Box.<\/p>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>1099 Vendor<\/td> Yes<\/td> Marks the Business Partner as eligible for 1099 reporting<\/td><\/tr> Default 1099 Box<\/td> Nonemployee Compensation<\/td> Category used when invoice lines do not specify their own box<\/td><\/tr> Active<\/td> Yes<\/td> Business Partner must be active to be included<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 3: Record a Qualifying Purchase Invoice<\/strong><\/h3>\n\n\n\nAn invoice only counts toward the extract once it is fully paid, completed, and tagged with a 1099 Box on its line.<\/p>\n\n\n\n
Create and complete the Purchase Invoice, assign a 1099 Box on the Invoice Line, then process the payment to Paid status.<\/p>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsSOTrx<\/td> N<\/td> Confirms the document is a Purchase Invoice, not a Sales Invoice<\/td><\/tr> Document Status<\/td> Completed<\/td> Invoice must be Completed or Closed to qualify<\/td><\/tr> Paid<\/td> Yes<\/td> Invoice must be fully paid to qualify<\/td><\/tr> Invoice Line 1099 Box<\/td> Nonemployee Compensation<\/td> Category the line amount reports under<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 4: Run the 1099 Extract Process<\/strong><\/h3>\n\n\n\nRunning the process is what actually scans invoices and builds the reporting data; nothing is extracted until it is executed.<\/p>\n\n\n\n
Open 1099 Extract, enter the Cut Date, optionally check Run as Job, then click OK.<\/p>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Cut Date<\/td> 31-Dec-2026<\/td> End date of the reporting period; defaults to today if left blank<\/td><\/tr> Run as Job<\/td> Unchecked<\/td> Runs the process in the background<\/td><\/tr> Note: <\/strong>Invoices are considered from the first day of the Cut Date year through the Cut Date itself, for example 01-Jan-2026 through 31-Dec-2026.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 5: Review the Extracted Output<\/strong><\/h3>\n\n\n\nA final check confirms the extract captured every qualifying vendor and amount before the data is used for IRS filing.<\/p>\n\n\n\n
Review the records populated in T_1099Extract and confirm amounts are grouped correctly by vendor and 1099 Box.<\/p>\n\n\n\n
Expected Result<\/strong><\/h3>\n\n\n\n\n- Eligible payments are collected and classified under the assigned 1099 Box.<\/li>\n\n\n\n
- Bucket amounts (1 through 16) reflect only qualifying invoices.<\/li>\n\n\n\n
- No Purchase Invoice, Payment, or Business Partner record is modified.<\/li>\n<\/ul>\n\n\n\n
Common Issues and Resolutions<\/strong><\/h2>\n\n\n\nIssue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>Vendor not extracted<\/td> 1099 Vendor not enabled<\/td> Enable 1099 Vendor on the Business Partner<\/td><\/tr> No extracted amount<\/td> Invoice Line has no 1099 Box<\/td> Assign a valid 1099 Box to the Purchase Invoice Line<\/td><\/tr> Vendor missing<\/td> Invoice not paid<\/td> Complete payment before running the extract<\/td><\/tr> Invoice ignored<\/td> Document Status is Draft or In Progress<\/td> Complete or Close the Purchase Invoice<\/td><\/tr> Missing invoices<\/td> Accounting Date outside the reporting year<\/td> Verify the Cut Date and Accounting Date range<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nNext Steps<\/strong><\/h2>\n\n\n\n\n- Review the generated data in T_1099Extract.<\/li>\n\n\n\n
- Validate bucket totals for each vendor.<\/li>\n\n\n\n
- Generate or print the 1099 reporting output.<\/li>\n\n\n\n
- Use the extracted data for IRS year-end filing.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
The 1099 Extract process collects eligible vendor payment information for IRS Form 1099 reporting by scanning paid Purchase Invoices for […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,10],"tags":[],"class_list":["post-20648","post","type-post","status-publish","format-standard","hentry","category-idempiere-accounting","category-idempiere-product"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=20648"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20648\/revisions"}],"predecessor-version":[{"id":20650,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20648\/revisions\/20650"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Configuration Steps<\/strong><\/h2>\n\n\n\nStep 1: Configure the 1099 Box Categories<\/strong><\/h3>\n\n\n\nEvery extracted amount needs a reporting category to group into, so the relevant 1099 Boxes must exist before invoices reference them.<\/p>\n\n\n\n
Create the required 1099 Box records, such as Nonemployee Compensation, before recording qualifying Purchase Invoices.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Search Key<\/td> 1099-NEC-01<\/td> Unique identifier for the 1099 Box<\/td><\/tr> Name<\/td> Nonemployee Compensation<\/td> IRS reporting category name<\/td><\/tr> Bucket<\/td> 1<\/td> IRS box number this category reports under<\/td><\/tr> Note: <\/strong>1099 Boxes become available for Purchase Invoice Lines once created and Active.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 2: Configure the Vendor as a 1099 Vendor<\/strong><\/h3>\n\n\n\nOnly vendors explicitly flagged as 1099 Vendors are considered, so this setting determines who appears in the extract at all.<\/p>\n\n\n\n
Open the Vendor Business Partner, enable 1099 Vendor, and assign a Default 1099 Box.<\/p>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>1099 Vendor<\/td> Yes<\/td> Marks the Business Partner as eligible for 1099 reporting<\/td><\/tr> Default 1099 Box<\/td> Nonemployee Compensation<\/td> Category used when invoice lines do not specify their own box<\/td><\/tr> Active<\/td> Yes<\/td> Business Partner must be active to be included<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 3: Record a Qualifying Purchase Invoice<\/strong><\/h3>\n\n\n\nAn invoice only counts toward the extract once it is fully paid, completed, and tagged with a 1099 Box on its line.<\/p>\n\n\n\n
Create and complete the Purchase Invoice, assign a 1099 Box on the Invoice Line, then process the payment to Paid status.<\/p>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsSOTrx<\/td> N<\/td> Confirms the document is a Purchase Invoice, not a Sales Invoice<\/td><\/tr> Document Status<\/td> Completed<\/td> Invoice must be Completed or Closed to qualify<\/td><\/tr> Paid<\/td> Yes<\/td> Invoice must be fully paid to qualify<\/td><\/tr> Invoice Line 1099 Box<\/td> Nonemployee Compensation<\/td> Category the line amount reports under<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 4: Run the 1099 Extract Process<\/strong><\/h3>\n\n\n\nRunning the process is what actually scans invoices and builds the reporting data; nothing is extracted until it is executed.<\/p>\n\n\n\n
Open 1099 Extract, enter the Cut Date, optionally check Run as Job, then click OK.<\/p>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Cut Date<\/td> 31-Dec-2026<\/td> End date of the reporting period; defaults to today if left blank<\/td><\/tr> Run as Job<\/td> Unchecked<\/td> Runs the process in the background<\/td><\/tr> Note: <\/strong>Invoices are considered from the first day of the Cut Date year through the Cut Date itself, for example 01-Jan-2026 through 31-Dec-2026.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 5: Review the Extracted Output<\/strong><\/h3>\n\n\n\nA final check confirms the extract captured every qualifying vendor and amount before the data is used for IRS filing.<\/p>\n\n\n\n
Review the records populated in T_1099Extract and confirm amounts are grouped correctly by vendor and 1099 Box.<\/p>\n\n\n\n
Expected Result<\/strong><\/h3>\n\n\n\n\n- Eligible payments are collected and classified under the assigned 1099 Box.<\/li>\n\n\n\n
- Bucket amounts (1 through 16) reflect only qualifying invoices.<\/li>\n\n\n\n
- No Purchase Invoice, Payment, or Business Partner record is modified.<\/li>\n<\/ul>\n\n\n\n
Common Issues and Resolutions<\/strong><\/h2>\n\n\n\nIssue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>Vendor not extracted<\/td> 1099 Vendor not enabled<\/td> Enable 1099 Vendor on the Business Partner<\/td><\/tr> No extracted amount<\/td> Invoice Line has no 1099 Box<\/td> Assign a valid 1099 Box to the Purchase Invoice Line<\/td><\/tr> Vendor missing<\/td> Invoice not paid<\/td> Complete payment before running the extract<\/td><\/tr> Invoice ignored<\/td> Document Status is Draft or In Progress<\/td> Complete or Close the Purchase Invoice<\/td><\/tr> Missing invoices<\/td> Accounting Date outside the reporting year<\/td> Verify the Cut Date and Accounting Date range<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nNext Steps<\/strong><\/h2>\n\n\n\n\n- Review the generated data in T_1099Extract.<\/li>\n\n\n\n
- Validate bucket totals for each vendor.<\/li>\n\n\n\n
- Generate or print the 1099 reporting output.<\/li>\n\n\n\n
- Use the extracted data for IRS year-end filing.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
The 1099 Extract process collects eligible vendor payment information for IRS Form 1099 reporting by scanning paid Purchase Invoices for […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,10],"tags":[],"class_list":["post-20648","post","type-post","status-publish","format-standard","hentry","category-idempiere-accounting","category-idempiere-product"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=20648"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20648\/revisions"}],"predecessor-version":[{"id":20650,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20648\/revisions\/20650"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Every extracted amount needs a reporting category to group into, so the relevant 1099 Boxes must exist before invoices reference them.<\/p>\n\n\n\n
Create the required 1099 Box records, such as Nonemployee Compensation, before recording qualifying Purchase Invoices.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Search Key<\/td> 1099-NEC-01<\/td> Unique identifier for the 1099 Box<\/td><\/tr> Name<\/td> Nonemployee Compensation<\/td> IRS reporting category name<\/td><\/tr> Bucket<\/td> 1<\/td> IRS box number this category reports under<\/td><\/tr> Note: <\/strong>1099 Boxes become available for Purchase Invoice Lines once created and Active.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 2: Configure the Vendor as a 1099 Vendor<\/strong><\/h3>\n\n\n\nOnly vendors explicitly flagged as 1099 Vendors are considered, so this setting determines who appears in the extract at all.<\/p>\n\n\n\n
Open the Vendor Business Partner, enable 1099 Vendor, and assign a Default 1099 Box.<\/p>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>1099 Vendor<\/td> Yes<\/td> Marks the Business Partner as eligible for 1099 reporting<\/td><\/tr> Default 1099 Box<\/td> Nonemployee Compensation<\/td> Category used when invoice lines do not specify their own box<\/td><\/tr> Active<\/td> Yes<\/td> Business Partner must be active to be included<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 3: Record a Qualifying Purchase Invoice<\/strong><\/h3>\n\n\n\nAn invoice only counts toward the extract once it is fully paid, completed, and tagged with a 1099 Box on its line.<\/p>\n\n\n\n
Create and complete the Purchase Invoice, assign a 1099 Box on the Invoice Line, then process the payment to Paid status.<\/p>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsSOTrx<\/td> N<\/td> Confirms the document is a Purchase Invoice, not a Sales Invoice<\/td><\/tr> Document Status<\/td> Completed<\/td> Invoice must be Completed or Closed to qualify<\/td><\/tr> Paid<\/td> Yes<\/td> Invoice must be fully paid to qualify<\/td><\/tr> Invoice Line 1099 Box<\/td> Nonemployee Compensation<\/td> Category the line amount reports under<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 4: Run the 1099 Extract Process<\/strong><\/h3>\n\n\n\nRunning the process is what actually scans invoices and builds the reporting data; nothing is extracted until it is executed.<\/p>\n\n\n\n
Open 1099 Extract, enter the Cut Date, optionally check Run as Job, then click OK.<\/p>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Cut Date<\/td> 31-Dec-2026<\/td> End date of the reporting period; defaults to today if left blank<\/td><\/tr> Run as Job<\/td> Unchecked<\/td> Runs the process in the background<\/td><\/tr> Note: <\/strong>Invoices are considered from the first day of the Cut Date year through the Cut Date itself, for example 01-Jan-2026 through 31-Dec-2026.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 5: Review the Extracted Output<\/strong><\/h3>\n\n\n\nA final check confirms the extract captured every qualifying vendor and amount before the data is used for IRS filing.<\/p>\n\n\n\n
Review the records populated in T_1099Extract and confirm amounts are grouped correctly by vendor and 1099 Box.<\/p>\n\n\n\n
Expected Result<\/strong><\/h3>\n\n\n\n\n- Eligible payments are collected and classified under the assigned 1099 Box.<\/li>\n\n\n\n
- Bucket amounts (1 through 16) reflect only qualifying invoices.<\/li>\n\n\n\n
- No Purchase Invoice, Payment, or Business Partner record is modified.<\/li>\n<\/ul>\n\n\n\n
Common Issues and Resolutions<\/strong><\/h2>\n\n\n\nIssue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>Vendor not extracted<\/td> 1099 Vendor not enabled<\/td> Enable 1099 Vendor on the Business Partner<\/td><\/tr> No extracted amount<\/td> Invoice Line has no 1099 Box<\/td> Assign a valid 1099 Box to the Purchase Invoice Line<\/td><\/tr> Vendor missing<\/td> Invoice not paid<\/td> Complete payment before running the extract<\/td><\/tr> Invoice ignored<\/td> Document Status is Draft or In Progress<\/td> Complete or Close the Purchase Invoice<\/td><\/tr> Missing invoices<\/td> Accounting Date outside the reporting year<\/td> Verify the Cut Date and Accounting Date range<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nNext Steps<\/strong><\/h2>\n\n\n\n\n- Review the generated data in T_1099Extract.<\/li>\n\n\n\n
- Validate bucket totals for each vendor.<\/li>\n\n\n\n
- Generate or print the 1099 reporting output.<\/li>\n\n\n\n
- Use the extracted data for IRS year-end filing.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
The 1099 Extract process collects eligible vendor payment information for IRS Form 1099 reporting by scanning paid Purchase Invoices for […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,10],"tags":[],"class_list":["post-20648","post","type-post","status-publish","format-standard","hentry","category-idempiere-accounting","category-idempiere-product"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=20648"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20648\/revisions"}],"predecessor-version":[{"id":20650,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20648\/revisions\/20650"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Field<\/strong><\/td>| Sample Value<\/strong><\/td> | Description<\/strong><\/td><\/tr><\/thead> | Search Key<\/td> | 1099-NEC-01<\/td> | Unique identifier for the 1099 Box<\/td><\/tr> | Name<\/td> | Nonemployee Compensation<\/td> | IRS reporting category name<\/td><\/tr> | Bucket<\/td> | 1<\/td> | IRS box number this category reports under<\/td><\/tr> | Note: <\/strong>1099 Boxes become available for Purchase Invoice Lines once created and Active.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n | Step 2: Configure the Vendor as a 1099 Vendor<\/strong><\/h3>\n\n\n\n
|