Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Tracking Numbers
Microsoft Dynamics GP (Archived)

Tracking Numbers

(0) ShareShare
ReportReport
Posted on by Ed Merkle 40

I have automated sending out invoices by using Crystal Reports and a third party software. I have duplicated the custom invoice report in Crystal Reports and everything looks identical to the GP form except I am having trouble with the tracking numbers. It is common for our customers to enter multiple release line items, where one line will ship today and the next line will ship next week, etc. Each time we invoice, the new tracking number plus all the old ones populate in the SOP10107 table. It appears that GP is listing the tracking numbers in alphabetical order so when doing a querry, it is difficult to grab the most recent tracking number. To complicate matters, if there are two tracking numbers for the same invoice it is difficult to know which two tracking numbers are for the most recent invoice. I have seen the scripts that take care of the tracking numbers in Report Writer but with table SOP10107, there are no date fields and nothing else to link to except the SOPNUMBE. The DEX_ROW_INDEX is also not useful since it appears that the multiple tracking numbers are listed in alphabetical order.

Any Suggestions would be appreciated.

Thanks

Ed

*This post is locked for comments

  • Verified answer
    Belinda Allen Profile Picture
    Belinda Allen 2,652 on at
    Re: Tracking Numbers

    Hi Ed,

    I have 2 thoughts for you off the top of my head.

    1-If you can get away with changing the Description Name (which works with some clients if their Item Number itself is descriptive enough...  Replace the Item Name with the tracking Number (or use the the Line Item Comment) then use VBA to copy it over to the tracking screen (if you need this.)

    The above covers providing the customer with the Tracking Number and managing tracking number to line item.  It does not cover ability to drill down to a carrier's site (like UPS).

    2-Consider the use of Extender.  This would allow you to add an additional field for each line of the invoice without comprising the Item Name or the Line Item Comment.  You can still use your Crystal invoices and VBA if you want to insert the tracking number into the tracking field.

    What works and doesn't work with these ideas?  Thoughts?

    Belinda, the GP CSI

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans