Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PO Line number shows c...
Microsoft Dynamics GP (Archived)

PO Line number shows comma when over 1000 lines

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

My customer has some PO's that are imported that have over 1000 lines. When viewing one of these documents in an GP window (PO Inquiry, etc.), the line number includes a comma as the thousands separator, which caused the number to not fit in the field completely. From what I have looked so far, I would think I should be able to change the formatting of the field through Modifier to remove the thousands-separator (I have done this in Report Writer), but I can't find which field/format I need to change. What process would I use to determine which format I should change? Any insight to help me with future requests like this is greatly appreciated.

PO-Inquiry.PNG

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: PO Line number shows comma when over 1000 lines

    Thank you so much, Leslie! I literally just needed to double-click on the scroll window and I think I would have got where I needed.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: PO Line number shows comma when over 1000 lines

    Hi Kyle Rehome

    You can for sure doing what you want. Open the Purchase Order Inquiry Zoom window in Modifier (use tools > Customize > Modify Current Window). When the window opens, double click on where the line items would be listed. This is called a scrolling window. In order to access the fields on the scrolling window, you have to first open it. The field you want to modify is called LineNumber. Select the field and then look at the properties window - CTRL + M will open the window if it isn't open. Double click on the DataType item. It says INT. Once the DataType is open, you'll notice there is no format assigned to this DataType. Pick a format or create a new one. I gotta believe there is one you can use.

    That's all there is to it. Here's how it looks in Modifier, it's probably too small to see well.

    format-PO-Line-number.png

    Kind regards,

    Leslie

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans