Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Add Bin to Suggested Purchase Order Report

Posted on by 1,540

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:
  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 10,996 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.

  • Accounting Department Profile Picture
    Accounting Department 1,540 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
    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

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans