Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SOP Pick Ticket Form & RF Shipping Weight Sum Doubles

(0) ShareShare
ReportReport
Posted on by 305

Hi,

 I have been working with SOP's Picking Ticket Form.  I have created a calculated field that takes the item master shipping weight and multiplies it times the qty field in the picking ticket form to provide a total line item weight for what is being "picked." The individual line item calculation is working correctly. 

However, the bottom line sum of this field at the report footer is incorrect.  It is doubled. 

I have checked and changed table linking.  I have added the item master table and the shipping methods table to this standard report linked to the sales trx amounts work table, and the sales trx work tables.  I have tried linking to the temp table this report uses as well.  Nothing fixes the bottom line total.

 Does anyone have any suggestions for other areas of the report definition that I could check?

 

Louis Cooper

*This post is locked for comments

  • Jeff Bloch Profile Picture
    95 on at
    RE: SOP Pick Ticket Form & RF Shipping Weight Sum Doubles

    Louis

    Did this ever get fixed?  Would you be able to share the formula for coming up with the line item shipping weight?

    Jeff

  • Janice Woytek Profile Picture
    330 on at
    Re: Re: Re: Re: Re: SOP Pick Ticket Form & RF Shipping Weight Sum Doubles

    I worked with Microsoft support about a year ago and they could not come up with a fix but did not refer to it as a bug. PS,beware of trying to divide the total by 2. We had instances where not all quantities doubled and could not find any differences in items that doubled and those that did not double.

  • Suggested answer
    Community Member Profile Picture
    on at
    Re: Re: Re: Re: Re: SOP Pick Ticket Form & RF Shipping Weight Sum Doubles

    connect.microsoft.com/.../Feedback

    Please copy and paste the above link into you ie search bar and looke for SOP Blank Picking Ticket Entered item weight is doubling and vote to get our issue fixed in a service pack or hot fix.  It took the problem to support and they could not fix it either.

    The issue has been pushed up at this point and is being looked at by the Professional Services Team to see if they can do anything with it.  They are looking to see if something in SSRS might solve the problem.  It could help some of you but maybe not all.  Please vote to help all of us.  I will continue to share my findings.

  • Suggested answer
    Community Member Profile Picture
    on at
    Re: Re: Re: Re: Re: SOP Pick Ticket Form & RF Shipping Weight Sum Doubles

    If this is still an issue and no one has resolved it it appears to me that it needs to be logged with Microsoft as a bug not an issue with a report.  I will call them today and open up a case, I have another customer that would also like to do.

  • cap.zadi Profile Picture
    925 on at
    Re: Re: Re: Re: Re: SOP Pick Ticket Form & RF Shipping Weight Sum Doubles

    Hi,

    i am also looking to add up shipping weight into packing slip for our export purpose. please advise the solution.

  • Community Member Profile Picture
    on at
    Re: Re: Re: Re: Re: SOP Pick Ticket Form & RF Shipping Weight Sum Doubles

    Joanne - if you wanted to email me a reports.dic with just that report in it - or a customisation export - I can take a look. It should be possible to get exactly what you want.

  • Joanne Seymour Profile Picture
    235 on at
    Re: Re: Re: Re: Re: SOP Pick Ticket Form & RF Shipping Weight Sum Doubles

    Unfortunately I was never able to resolve this problem.

  • Janeece Moreland Profile Picture
    270 on at
    Re: Re: Re: Re: Re: SOP Pick Ticket Form & RF Shipping Weight Sum Doubles

    I was wondering if you would share your report for this?  I have a customer that would like to have the shipping weight on the packing slip also.

  • Joanne Seymour Profile Picture
    235 on at
    Re: Re: Re: Re: Re: SOP Pick Ticket Form & RF Shipping Weight Sum Doubles

    Was a solution ever found for this?  I am having the same problem.  Using GP 2010.

    Thanks,

    Joanne Seymour

  • Community Member Profile Picture
    on at
    Re: Re: Re: Re: Re: SOP Pick Ticket Form & RF Shipping Weight Sum Doubles

    What you describe seems right. If you want to email me your reports.dic, I'll take a look. What version of 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,863 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans