You’re offline. This is a read only version of the page.
I’ve looked through the Vendor area of NAV and can’t find a way to set up department/account assignments by vendor other than using the Standard Purchase Code somehow. Will it matter that "department" will be a mandatory global dimension in NAV; how can we still include it as part of the pre-loaded assignment of expenses?
How can I produce a Vendor Listing showing the Standard Purchase Code assigned to that vendor? I currently can only tell if a vendor has a Code assigned by opening the vendor's card, and Navigating to Purchase Codes. It doesn't even show up on the main card view.
Thank you.
*This post is locked for comments
"Regarding dimensions it does override based what you setup on other master data like item, location... i think you can set priorities i have not used it but please check out below link. You can do same for PURCHASES"
You make this sound like something we want to do. We DON'T want the line specified locations and departments overwritten.
Not sure what the logic is to have Standard Purchase Codes set up (assuming we can get global dimensions added to them) that just get overwritten by the Vendor defaults.
Thank you for your help.
Yes you can open the development environment and run the table 175 and copy over all the data from there to excel or you can modify the page 178 to include vendor no. field and then run the page 178 and from the page you can use Print & Send to Excel.
Regarding dimensions it does override based what you setup on other master data like item, location... i think you can set priorities i have not used it but please check out below link. You can do same for PURCHASES
www.clientsfirst-us.com/.../dimension-priorities-in-microsoft-dynamics-nav-navision
There's no way for me to create this easy report without a $1,500 call to our 'partner'?
The Standard Purchase Codes can't be exported to Excel? Don't know what 'Table 175' is, but can I just export it?
The global dimensions assigned to the vendor seem to override whatever departments and locations are entered on the lines of the Purchase Invoice, is this the way it is supposed to work?
Thanks
Unfortunately there is no standard report for this, you need to create a new report using table 175 and then group by Vendor No.
I am not sure if you have access to development environment and to create new report, but this is very easy report. If you don't have license please contact your partner.
Report.
either:
Vendor (number and/or name) | Purchase Code
OR
Purchase Code | Vendor(s) (number and/or name)
I assigned department and locations (both global dimensions) to the vendor, but it only allows ONE department and ONE Location to be used for that vendor. We have vendors that need to have invoices entered that apply to MULTIPLE locations and departments....is that not possible?
Slightly off-topic, but why must the invoice total be entered on every purchase invoice line that is subject to one of these Standard Purchase Codes? for example, purchase code allocates 27% and 63% of an expense to two different accounts; why does every line of the purchase invoice need to have the invoice total entered in order to get allocated? What exactly is this supposed to speed up other than math?
Do you need a report to list vendors with purchase code? or do you want to display the purchase code in the dropdown when you select the vendor ?
It is little confusing what you describing.
You cannot assign dimensions to purchasing code, you need to do that at vendor level.
I'd like to get a clean list (export to excel or print a tree of a report) of all vendors with the Standard Purchase Codes that are assigned to each vendor. Whether they have a Purchase Code or not.
Otherwise, is there a way to get a list of Standard Purchase Codes with the Vendors assigned to each code?
Will I be able to add the global dimension "department" to these Standard Purchase Codes"?
Thank you.
Note: the link provided above only applies to the "Classic Client". How would I do that in 2013?
You can modify the dropdown list to show different fields by setting FieldGroup. Please refer to the below link
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (