Pre-loading Department/Account information for AP invoicing

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

You can modify the dropdown list to show different fields by setting FieldGroup. Please refer to the below link

msdn.microsoft.com/.../dd354969.aspx

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

hi,

Do you mean that you want to include the Purchaser Code in the vendor Drop Down?

Best Regards,

MMV

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

"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.

Was this reply helpful? Yes No