1099 Report, Management
All vendors which will be 1099 must have the 1099 form and 1099 box filled in on the BP Master data window. The system will then bring that default information over into any AP Invoices you created after you have set this up on the BP Master data. If you need to see which boxes correspond to each 1099 setup, you can click the dropdown and define new to open the existing setup window. If you double click on the line number, in the following image line 2. It will open the boxes for that specific 1099.
At the end of the year, or at a time of your choosing, you can then go to Modules – Financial – Financial Reporting – Accounting – 1099/1096 Report. A report wizard will open asking you for the selection criteria. Select your criteria here and press ok to run the report. This will open a results window called 1099 Form Printing. You will see entries for your vendors. From here you can click the generate preview button to view the print preview, or just print it.
Now it’s entirely possible that the BP’s were not setup before all of the AP invoices started being input and paid in SAP. In this case you will have to review which invoices did not get the 1099 attribute placed on them in the SAP system for the time period you are running the report for. SAP provides a functionality called Drag and Relate. The idea is that you can select a BP, draw their code over to the AP Invoices section, and that will list all the AP Invoices for that BP. From here you would need to open them and check whether these Invoices had the 1099 attributes. If they did not have the attribute, and are in the date range that you need. Please record the document total of that invoice on a spreadsheet. You will repeat this until all the affected invoices are found, sum up the document totals because we are going to use those to add to the opening balance of that BP.
In this next image you can see that this invoice from 2015 did not have the information filled in and its grayed out, that’s because we setup 1099 information on this BP’s Master Data, after the invoice was created. We need to record this total to add to our sum of opening balances. Otherwise, when we run our report, only the invoices that this have this data will be summed up for the total on the 1099.
With our summed value in hand we can go and edit the 1099 opening balance for the BP so that the system adds up this opening balance ( a real opening balance if you had it + the sum of the invoices that didn’t have the attribute set in time ) with the totals on the invoices that did have the attributes set.
In our example, we took the invoice from 2015 that didn’t have the 1099 information (727.23) and set it in opening balance. Now when we run the 1099 report, the system will calculate the 727.23 + the invoice that did have the 1099 info: 1376.73 for a total of 2,103.96 as we can see on our 1099 report. To run the 1099 report, simply go to Modules – Financials – Financial Reports – Accounting – 1099/1096 Report. Fill in the criteria and choose OK, you will then have the 1099 form printing report again that you can print.
