Using NAV2016 is it possible to allocate an item by purchaser to split items among multiple buyers? Moved from SAP where items could be split by purchasing group and MRP controller. Looking for an equivalent in NAV2016. Thank you for any help.
*This post is locked for comments
Additional entries added to the Item Categories field and maintained on the item card. This allows separation of responsibilities and inventory on reporting by pulling this field into Jet reports.
Thank you Suresh, I was leaning towards defining the items via the product group code.
You can setup different Vendor Item No. for an item using Item/Vendor on the item card and then when you order on the purchase order you can setup Purchaser on the document or there is a category code, product group code on the item card you to group them.
There is e.g. a report "Vendor/Item Purchases" (313). There you can add a filter by Purchaser and get the results, filtered by certain purchaser.
If you are familiar with NAV tables, some information you can get directly from the Item Ledger Entry table (32). There is a Document No. field which relates to the same field in the Purch. Rcpt. Header table. Purch. Rcpt. Header table contains the Purchaser code, so for each positive adjustment of the item you can try to find a purchaser code through this relation.
In Value Entry table (where the items amount is basically registered for items transactions) there is User ID field. This would give you the information about the user who made a posting of the item if your filter by "positive adjustment" type and Item Ledger Entry Quantity field not zero (otherwise here you will also have transaction of e.g. items charges allocation to already existing purchases, which you most likely do not need). However the person who posted the document is not necessarily the purchaser, defined in the Purchase Order.
I do not recall quickly a ready out-of-the-box report that would show the purchases made by each purchaser... Perhaps, other members will recall that.
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (