You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to default Sales Account using item Rules

in Product Management 5 comments

Summary:

We are attempting to default Sales Account using Item rules but the system is not defaulting it.

Content (please ensure you mask any confidential information):

Setup done:

Association Type: Item class, Type: Assignments

Under Rules:

Return type: Generic

Target Business Entity: Item

Target Attribute: Sales Account

Primary IF Expression: [Item].[Item Basic].[Organization Code] == "<ORG CODE>" (Since Sales Account is needed at item org level, not at master level)

Secondary IF Expression: false

Return Value: "1010" + "0000" + "1012" + "0000" + "0000" + "000" + "000000" + "0000"

Also tried with Return value as below:

"1010." + "0000." + "1012." + "0000." + "0000." + "000." + "000000." + "0000"

Both the above options did not work.

With above rule, if any item has any existing sales account value, and if we try to update value manually, it tends to remove the value as well. So the rule is not defaulting for records which don't have value, and existing ones if updated are getting nulled out.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!