Personalization, Customization and Productivity Tools

[bpoole]

I have a custom office script that runs during shipping data entry.  It does some additional freight calculations and poulates the freight amount field based on the logic in the script.  Evrything works great except when I need the freight amount to be zero.

Am I missing a special syntax that is required to clear a valu from a field?

This works:

SO_Shipping_bus_FreightAmt = 10

This does not:

SO_Shipping_bus_FreightAmt = 0

Anyone had any sucess clearing a value from a script in custom office?

PS:  it is not relegated to the freight amounf field, but to all the fields.  It makes me think that either I am missing some syntax or it is "working as designed"

[DFeller]

I have had issues with setting fields to zero in the past as well.

Dawn

[bpoole]

Did you ever get a resolution to this or did you find out it could not be done?

Sage says it should be possible, but cannot tell me how.

[DFeller · Accepted solution]

SO_SalesOrder_bus_FreightAmt = 1/1000

Dawn

[bpoole]

nice.

that worked.

[bpoole]

Correction.  This method worked on my installation, but not on my client's installation.

My install is MAS90 4.3.0.18

Their install is MAS200 EES 4.3.0.18

In order to set a value to zero, I had to change the script to run on the server not the client.

[BigLouie]

So boys and girls do we know why this is? That's right because 90 does the processing at the client and 200 does the processing at the server!

[bpoole]

I understand client/server architecture, but why would that make a difference as to why the field will or will not accept a zero value, but will accept any other numeric value?