DATA EXCHANGE DEFINITION - Multiplier

(0) Share

Report

Posted on by Rajendra sahu

130

Hi all,

Can anyone assist how to set multiplier in data exchange definition - field mapping (using Table no.274) ? As i can see there is no option of multiplier. Thank you.

Note: Need to convert positive sign into negative while importing bank statement.

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Vanessa Garcia on at

Like (0)

Report

Hi Rajendra,

I think you can use the Multiplier, but you need to Personalize the page.

Go to the Data Exchange Definition, Line Definition, Manage, Field Mapping.

The "Multiplier" field is not visible, but available, and you need to Personalize the Page:

You click on the ribbon on the +Field:

Then you can see the Multiplier field in the list (put the cursor over the LINES), and you can add it:

Then you can use it normally , and put it as -1 to get a negative amount:

I hope it helps,

Was this reply helpful? Yes No
Rajendra sahu 130 on at

Like (0)

Report

Hi Vanessa,

Even that also tried but still not able to fix in personalization field. see below screen shot.

Was this reply helpful? Yes No
Verified answer

Vanessa Garcia on at

Like (1)

Report

Hi Rajendra! :-)

yes, this is because you have the cursor on the header.

As I put earlier, you need to click over the lines during personalization to get the available fields for the lines (the 2 shown are for the header).

I hope it helps,

Was this reply helpful? Yes No
Rajendra sahu 130 on at

Like (1)

Report

Yes, you absolutely right. got it. Thank you.

Was this reply helpful? Yes No