Formatted Search : Order Weight to Order Freight Window

[Former Member]

Greetings:

I have the following scenario:

I have created a UDT that has 3 columns - code, name, price. Client has pre-defined freight cost based on the total weight of the order (example - 5 lbs. = $4.56). UDT.Name = weight, UDT.price = freight charge. Is it possible to put a FMS on the amount field of the Freight Charges window that looks at the total weight of the associated Sales Order and selects the proper price based on weight?

Thanks in advance,

Aaron

[Former Member]

NO.

[Former Member]

Gordon,

OK, Thanks for the help. I can make it work, but it would have to be a 2-step process of adding the sales order first and then updating it with the freight charges.

[Former Member]

That is right process. It cannot be combined to one step only.

[Former Member]

I guess the other option is to use the SDK to 'Push' the freight costs into the RDR3 table associated with the order.

Thanks again.

Aaron

[Former Member]

By SDK, you have more options for sure.

[Former Member]

I don't think your UDF is there. There is no way that you can access the form that is not current.

[Former Member]

I think there is some confusion again. I don't have a UDF created anywhere except on my UDT.

Forget my specific scenario, I can figure out the fields myself. Is it possible to create a FMS on the freight charges screen that pulls information from the sales order you are working with that has not yet been added?

[Former Member]

Which form is your active form? This query will only work on the Sales Order main form. You can not run it under query manager directly.

[Former Member]

I start on the Sales Order form then drill into the Freight Charges screen. Within this screen there is the "amount" field, I am trying to attach the FMS here. This is where I am receiving the error message.

[Former Member]

That would not be possible even by SDK codding. The fact is: you have to assign price for each item FIRST before you got the document total. How could be possibly predict for the future event?

[Former Member]

Gordon,

I don't understand your response... The workflow would be (1) add all items to the order (2) drill into the freight and in the amount field (3) run the Formatted Search manually to return the shipping charge associated with the total weight of the order from my UDT table.

Does your response still hold in this scenario? If so can you explain further?

Thanks,

Aaron

[Former Member]

That is because the term Price misleading me. Well, if it is on the same document level, it should be possible. Have you tried any queries already? Post it here so that others can troubleshoot.

[Former Member]

Thanks Gordon,

I think it has to do with linking the freight screen to the order screen. Do I need multiple field references to make it work?

SELECT T0.[U_Price} FROM [dbo}.[@FREIGHTCHARGES} T0 , ORDR T1 INNER JOIN RDR3 T2 ON T1.DocEntry = T2.DocEntry WHERE T0.[Name} = $[ORDR.Weight.0}

Note - I had to change the brackets so everything did not become hyperlinks

[Former Member]

You may not need RDR3 and ORDR. Try this one to see:

SELECT T0.[U_Price\] FROM [dbo\].[@FREIGHTCHARGES\] T0

WHERE T0.[Name\] = $[ORDR.Weight\]

[Former Member]

I get a message saying "Internal error (-1004) Occured" when I try to run this.

[Former Member]

It would be at the document level (ORDR.Weight)

[Former Member]

Aaron,

Are you talking about line level total for each item or for document level?

Thanks,

Gordon