Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Business Central forum

Look up last purchase cost when using G/L Account type

(0) ShareShare
ReportReport
Posted on by 76

How do you quickly look up a purchase order based on a specific description?  Most of our purchases have been made using the G/L Account type on the Purchase Order so I was thinking I could do some kind of lookup on the first Description field.  Any ideas?

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    13,622 Moderator on at
    RE: Look up last purchase cost when using G/L Account type

    If you are using G/L, you will need to customize the BC using extension to get the data from Purchase Invoice Line table.

  • DollarDave Profile Picture
    76 on at
    RE: Look up last purchase cost when using G/L Account type

    Thanks for the quick response, but I do not have a type called "flowfield" that I can find.  I am using Business Central online and waiting for the April 2019 release to be done.

  • Suggested answer
    I Gusti Made Ari Profile Picture
    3,594 on at
    RE: Look up last purchase cost when using G/L Account type

    You can add a new field in Purchase Header with type flowfield looking up description from  purchase line . then pulled out this field on your purchase order list screen

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans