When using exchange, I am entering data for purchase contracts from one company to another, and I need to get the next free number to do an insert. Currently exchange is writing the contract number from the exporting company, into the importing company, even if the number series is not set up.

I am trying to figure out how to get the exchange scheme to grab the next free number.

Itannous,

In the Maintain Field Relations (import) session, instead of linking the contract number to a data field, leave that blank and instead create a condition. In the condition, do a lookup on tcmcs047 for the next free contract table, lock it and update it with the next contract number and return the original free number.

Cheers,

-Dennis