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!
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156