mapping journal fields

[Former Member]

Hi All,

I have an requirement of mapping these fields ,what are the functions i can use for these fields while mapping,please let me explain in detail..

/Journal/JournalRef HQnnnnn (sequentially generated)

/Journal/JournalSourceLedger u2018GENu2019

/Journal/JournalHeaderType u2018Ju2019

/Journal/JournalDate System Date

/Journal/JournalName u2018HR Chequesu2019

/Journal/JournalPeriod NULL

/Journal/JournalYear NULL

/Journal/JournalMoneyTotal Sum of /Journal/JournalLine/JournalLineBaseValue u2013 must be 0.00

/Journal/JournalQuantityTotal NULL

/Journal/JournalVolumeTotal NULL

/Journal/JournalTarget u2018Gu2019

/Journal/JournalSubType u2018HQu2019

[baskar_gopalakrishnan2 · Accepted solution]

If i understand properly the above field values from the source data structure.

>/Journal/JournalRef HQnnnnn (sequentially generated)

If the sequencing is within the same message for different occurences then use count function. If the sequencingfor every different message then use sequencer in the backend and call that during mapping or just store in the table the last value and pull the next item for every individual message.

> SourceLedger and HeaderType map the source values to target element

>Journal/JournalDate System Date

Use date or calendar standard function

> NULL values don't need to mapping or purely based on the requirement

>/Journal/JournalMoneyTotal use Standard Sum function

>Target and SubType Use direct mapping to map the source to target

[Former Member]

can i have more explain in terms different ways of mapping