Skip to Content

Syntax Assistance

Hi,

I am trying to learn how to use SYNTAX and having a bit of difficulty linking tables for what I need.

Essentially I am trying to create a formatted search that calculates the total cubic metres of each line of a sales order.

The customer wants this detail on a proforma invoice.

I need the formatted search to calculate [RDR1.Quantity * OITM.SVolume]

Can anyone help?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 24, 2018 at 08:21 AM

    Hi,

    Try $[RDR1.Quantity.number] * $[OITM.SVolume.number]

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 22, 2018 at 11:27 PM

    Hi,

    Try this syntax directly from sales order,

    SELECT $[$38.11.number] * $[$38.56.number]

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded