Currently, the 1099 Miscellaneous form prints the value from the Vendor Check Name. How can I make it print the value from the Vendor Name?
I tried report writer, but the Vendor Name is not an option. We are using GP 2010.
Thanks,
*This post is locked for comments
Naga is absolutely correct. You can achieve this in two way one is naga suggested and anothier is adding table relationship.
1. Go to report writer.
2. Open the table PM_1099_Temp.
3. Click Relationship button and click new to add the table PM Vendor Master file in secondary table field and select the first key then map the vendor id.
4.Click OK to save the table.
5. Open the 1099 Printed report and click the table button and click new to add the table vendor master.
6. In report layout, you can see the table vendor master finally add the vendor name from table vendor master.
Hope this helps!!!
Hi Jay,
Report write will work for this. You can do it by using the Vendor ID available in the report table's (1009s To Print Temporary File) field list in the tool box of report writer.
1. Create a calculated Field 'Vendor Name'
a. Select calculated Fields in the Tool box dropdown and click on New. This opens Caluclated Field Definition window.
b. Enter 'VendorName' in the Name field.
c. Set Result Type dropdown to String
d. Click on Functions tab and select User-define option.
e. Select Core: drop down to Purchasing.
f. In the Function: drop down select function 'RW_Get_Vendor_Name' click on Add.
g. Now select Fields Tab and select '1009s To Print Temporary File' in the Resources: dropdown.
h. Select 'Vendor ID' in the Field: Dropdown. Click on Add.
i. Save this Calc Field Definition by clicking on OK button on the window.
2. Now you can see the new Calc field in the Calc Field List of Tool box>>Calculated Fields
3. Replace 'Vendor Check Name' with this Calc Field.
4. Save the report.
PS: This is a modified report hence need to change the repot to print from Original to Modified using 'Alternate Modified Forms and Reports' window (MS Dynamics GP>>Tools>>Setup>>System>>Alternate/Modified Forms and Reports )
Hope this helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (