Updating Invoicing Trade Discount with VBA

[sqlhotdog2005]

We've got some VBA code that calculates the Trade Discount based on what the user chooses for CommentID. The correct amount goes into the Trade Discount field, but the Distributions screen is not being updated.

Is there some VBA code that would force the Distributions screen to update?

(Note: and here's the kicker... this seems to work fine in 8.0... but the VBA is going into 6.0... maybe that's the problem?)

 

[stef315]

Check the event you're firing on. Maybe you're firing too late...after the distribution window has already been opened. It won't update automatically once it's been opened.

 

[sqlhotdog2005]

Thanks, stef315... we used some Dexterity to make it flow smoothly.