web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Add Bin to Suggested P...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Add Bin to Suggested Purchase Order Report

(1) ShareShare
ReportReport
Posted on by Accounting Department 1,552

Our warehouse uses a specific bin for special order items, and they want to see items for this bin on the PO Generator report before creating the PO's.

We tried to add Bin Number to the report by adding the Item/Site table and also tried adding the Item Site/Bin table to the report.

I even added a Bin Section. We also played around with relationships and restrictions.

The Bin Number just won't print on the report.

Permissions are fine because I added a label to the report that says "test test test" and that prints.

Any suggestions?

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: Add Bin to Suggested Purchase Order Report

    Hi Barb,

    I don’t think you’ll be able to add the bin to this report in out of the box GP. There is a one-to-many relationship between the item master and the item/site bin quantities master table. As such, more than one bin may be returned when this report is printed and there’s not a good way to do that on this report.

    We tested this report internally and came up with the same results you’re getting – it just doesn’t show up.

    I suspect you’d need a customization of some kind to get this to work. If you’re savvy in Dexterity and/or you use GP Power Tools you may be able to write a RW function that will return the value you’re looking for. Dave Musgrave has a good blog about this:

    #GPPT Adding data from any SQL table to SOP Documents | David Musgrave's Winthrop Development Consultants Blog (wordpress.com)

    The logic here can be used for any report.

    Others in the community may have ideas as well. Good luck!

    Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP

  • Accounting Department Profile Picture
    Accounting Department 1,552 on at
    RE: Add Bin to Suggested Purchase Order Report

    Thank-you for the answer.   I'll check GPPT - the only question would be the SQL table in this report is a temp table.

    In the meantime I created a Smartlist for the user to view items in this bin and the Order Policy in case they want to change it so that it doesn't use PO Gen.

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at
    RE: Add Bin to Suggested Purchase Order Report

    Regarding you question related to temp table, since non of the tables have bin field so it doesn't make any difference if its a temp table or the other one. With dexterity code field can be add easily on report.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 683 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 563 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans