305
Hello
I need to add ItemId min price and newest price from trade agreements in Pending vendor Invoices in Preview Detail window.
but no work.
I join the PriceDiscTable to VendInvoiceInfoLine Table, I try innerjoin / ourterjoin /exitjoin to get min(Amount) in VendInvoiceInfoListPagePreview Query,
but just show the min(Amount), others field is empty ...
Please help and Thanks a lot.
Br, Jen
*This post is locked for comments
If you need the fields for information purposes only, you can consider using display method where you can interact with the trade agreements.
You may have partial deliveries and invoices or consolidated.
The price will be both by Vendor on PO, PO quantity, and PO line date, and the agreement quantity breaks and date effectivity, so you need to link to the PO to get the right parameters to pull data from the agreement.
Hello Ben,
Can you explain why this is needed?
Is this for information only?
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (