Share
ReportI am trying to retreive this data in order to populate a custom field in the sales order table.
but I am having a hard time finding how a sales agreement count its order releases
You’re offline. This is a read only version of the page.
70
I am trying to retreive this data in order to populate a custom field in the sales order table.
but I am having a hard time finding how a sales agreement count its order releases
hope it is useful
select distinct
alr.SALESLINEDATAAREAID
,alr.SALESLINEINVENTTRANSID as SalesOrder
,ah.SALESNUMBERSEQUENCE as SalesAgreement
,ah.CUSTACCOUNT as CustAccount
from AgreementLineReleasedLine as alr
inner join AGREEMENTLINE as al on alr.AGREEMENTLINE = al.RECID
inner join AGREEMENTHEADER as ah on al.AGREEMENT = ah.RECID
where alr.REFERENCERELATIONTYPE = 359
they need just for tracing but on printed sales orders. this is my complete scenario:
I have a custom field that should hold the Sales agrement number plus a serial sub-number eg: if I have a Sales Agreement : 100 .... the first release order would be 100-1. that "100-1" Is what I need, I need to retreive how many releases has an specific SA in order to calculate the number after the dash
Hello and thank you for replying but I dont follow. what Does this query supouse to bring? a table with all SA and their respective qty of releases?on the other hand where can I excecute such? isnt ax forcing developers to acces DB throug code only?
Hi JairoJs,
please reference below table relation.
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
