Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Jet Reports - Table Builder - Last Direct Cost

Posted on by 63

We use Jet Reports for many of our financial reporting needs. The specific report I am working on is pulling the "Last Direct Cost" from the Stockkeeping Unit Card, by Customer and Item. For many of our SKU cards, there are multiple locations for a single item. When I am pulling the Last Direct cost, Jet is pulling from the first SKU card that is listed under "Stockkeeping Unit Exists". I am wondering if there is a way that Jet can recognize which location the customer is buying the product from, and pull the Last Direct Cost from that location's SKU card. I use the following tables in my report - Sales Price - Item - Stockkeeping Unit - Customer. I tried linking the Item Ledger Entry table to the SKU but Jet is still pulling the first Last Direct Cost it can find. 

All help/thoughts are greatly appreciated! 

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: Jet Reports - Table Builder - Last Direct Cost

    Hi

    I think you need to use NL("Last") . See below article. In your case you need to filter for location and customer using NL(Last)

    support.jetglobal.com/.../218953408-Sorting-NL-Last-and-NL-First-functions

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans