cancel
Showing results for 
Search instead for 
Did you mean: 

Freight Amount query

Former Member
0 Kudos

Hello experts,

I have Creating One User Define Table like UPSTABLE

in this Table below Field is available like DeliveryNO, TrackingNO and FreightCHarges

i wants to freight charges in INV3 Table when we creating Invoice base on Delivery,

It Is Possible through FMS, how ?

Dixit Patel

Accepted Solutions (1)

Accepted Solutions (1)

former_member186095
Active Contributor
0 Kudos

Hi,

Do you want the freight charge data from the UDT  or INV3 ?

If there is a print screen, you can attch here.

Rgds,

Jimm

Former Member
0 Kudos

HI Jimm,

Please find the attachment file for that, i want the data from UPStable to INV3 Table

former_member186095
Active Contributor
0 Kudos

Hi,

Thanks for the details.

You can use the following query:

select distinct a.freightcharge from [@upstable] a where a.deliveryNO = $[inv1.baseref]

Put the above query FMS into column 122 row 1 item 38 (Freight 1 (LC))

Good luck

JimM

Former Member
0 Kudos

Hello Jimmy,

I have applied that query in bu system give the error message

1). [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near 'inv1.baseref'.

2). [Microsoft][SQL Native Client][SQL Server]Statement 'Received Alerts' (OAIB) (s) could not be prepared.

See the immage

Dixit Patel

Former Member
0 Kudos

Hi Jimmy,

Thanks , i have taken the Freight amount in INV1 Row level,

So  My Problem is solved,

Thanks Jimmy

Dixit Patel

former_member186095
Active Contributor
0 Kudos

Hi Dixit,

you are welcome. Nice to hear the problem solved now.

Rgds,

JimM

Answers (0)