Part of the Year end process for Dynamics GP Payables is to check for Vendors that are eligible for 1099 tax forms. A user can quickly identify which vendors are eligible by by dragging in the Vendor, Vendor Name, Tax Id Number and 1099 Type parameters into BI360 Composer.
Note: The documentation provided is solely intended to provide a general understanding of the author’s interpretation of viewing documentation associated with GP transactions. The author reserves the right, at his discretion, to change or modify the documentation as deemed appropriate.
First open up BI360 Composer and select the GP Integration.
After choosing the Integration, drag in the following parameters: Vendor, Vendor Name, Tax Id Number and 1099 Type. This can be found in the Purchasing module.
Click the Refresh button and the field will populate with the Vendors that are and are not 1099 Type.
These results can be further sorted to distinguish between 1099 Vendors and Not a 1099 Vendor by sorting the results by 1099 Type.
- BI360 Composer