https://www.youtube.com/watch?v=nAuKTpORFG8
SAP B1 - How to setup 1099
( from 8:43 ~ to 30:36 )
08:46 SAP Business One 1099 Table Setup
11:03 1099 Openning Balance
15:50 Reporting Options
18:53 1099-MISC Layout Designer
19:46 Reporting Non-Employee Compensation
25:46 How to Save Layout
28:56 Query Generator
1. 1099 Table - Form, Box
Administration > Setup > Financial > 1099 Table
1099 Openning Balance
Administration > System Initialization > Openning Balance > 1099 Openning Balance
2. BP > [Accounting] > 1099 Form, 1099 Box
BP > Federal Tax ID
3. A/P Invoice > [Accounting] > 1099 Form, 1099 Box
4. 1099 Editing (☞ only Invoice & Credit Memo)
Financial > 1099 Editing
5. 1099/1096 Report (☞ include Openning Balance)
Financial > Financial Reports > Accounting > 1099/1096 Report
Reports > Financial > Accounting > 1099/1096 Report
5-1) 1099 Form Printing > 'Layout Designer' > [Manage Layout]
> 'Preview' > Print
6. How to upload 1099 Data to website (tax1099.com)
6-1) SAP Query > Download
6-2) Login site > Upload
select OPCH.CardCode
,OPCH.CardName
,OCRD.LicTradNum as 'Vendor Tax ID'
,SUM(OPCH.Doctotal) as '1099 Amount Invoiced'
,SUM(VPM2.SumApplied) as 'Paid Amount on Outgoing Payment'
,CASE WHEN OPCH.Form1099 = 1 THEN 'Year 2019 1099-MISC' ELSE 'Other 1099-Form' END as 'Existing 1099-Form Assignment'
,OPCH.Box1099 as 'Year 2019 1099-MISC Box Assignment'
,CASE WHEN OPCH.Form1099 = 1 AND OPCH.Box1099 = 07 AND SUM(OPCH.DocTotal) >= 600.00 THEN '1099-NEC Box 01'
WHEN OPCH.Form1099 = 1 AND OPCH.Box1099 = 07 AND SUM(OPCH.DocTotal) < 600.00 THEN 'Less than $600.00, Do NOT REPORT'
ELSE CONCAT('1099-MISC', + ' ', + 'Box', + ' ', OPCH.Box1099)
END as '2020 Form selection'
,CONCAT(CRD1.Street, + ' ', CRD1.City, + ' ', CRD1.State, + ' ', CRD1.ZipCode) as 'Vendor BP Default Bill To'
,OADM.CompnyName as 'Company Name'
,OADM.CompnyAddr as 'Company Address'
,OADM.TaxIdNum as 'Company Tax ID'
from OADM
,OPCH
JOIN VPM2 ON ( VPM2.DocEntry = OPCH.DocEntry )
JOIN OVPM ON ( OVPM.DocEntry = VPM2.DocNum )
JOIN OCRD ON ( OCRD.CardCode = OPCH.CardCode AND OCRD.CardCode = OVPM.CardCode )
JOIN CRD1 ON ( CRD1.CardCode = OCRD.CardCode AND CRD1.Address = OCRD.BillToDef AND CRD1.Adrestype = 'B' )
where 1=1
and ( OPCH.Form1099 IS NOT NULL and OPCH.Box1099 IS NOT NULL )
and ( OVPM.Canceled <> 'Y' )
and ( OVPM.DocDate between '1/1/2024' and '12/31/2024' )
and ( OPCH.submitted = 'N' )
group by OPCH.CardCode
,OPCH.CardName
,OCRD.LicTradNum
,OPCH.Form1099
,OPCH.Box1099
,CRD1.Street
,CRD1.State
,CRD1.ZipCode
,OADM.CompnyName
,OADM.CompnyAddr
,OADM.TaxIdNum
< Video >
https://www.youtube.com/watch?v=nAuKTpORFG8
< Text >
https://www.taxbandits.com/1099-forms/form-1099-misc-vs-nec-information/
https://www.dwytax.com/ko/difference_between_1099-nec_and_1099-misc/