Force Zero Quantity in A/R Invoice

SOLVED

Sage 300 2019 PU 5

How to force a zero quantity in A/R Invoice using item detail type where the Invoice has an Extended Amount  >0?

Using summary detail type is not an option because there are other Items to be loaded on the same Invoice.

Using Quantity 1 will be misreading.

.

Parents
  • 0

    Has to have a qty of 1, no choice.

    Solve it in the Crystal form using Crystal Reports designer

    OPTION 1 (my fave) - a formula in the QTY Field proprieties / suppress

    if ((some rule about the item so you only pick items that should show no qty )
    Then TRUE else FALSE

    OPTION 2 -  Formula  for the QTY field

    If (some rule about the item so you only pick items that should show no  qty )

    then ""

    else totext(qty field)     //     (Use text so you can use the null)

Reply
  • 0

    Has to have a qty of 1, no choice.

    Solve it in the Crystal form using Crystal Reports designer

    OPTION 1 (my fave) - a formula in the QTY Field proprieties / suppress

    if ((some rule about the item so you only pick items that should show no qty )
    Then TRUE else FALSE

    OPTION 2 -  Formula  for the QTY field

    If (some rule about the item so you only pick items that should show no  qty )

    then ""

    else totext(qty field)     //     (Use text so you can use the null)

Children