Update of flow during data Load

[Former Member]

Hello All,

We have a Flow type -  has been defined in our system in the Model.  We need to post to particular flow type based on accounts.  For Example, we have Short Term Payable and Long Term payable available as Flow Member.

If the Account is X - It will be classified as Short Term Payable.  If the Account is "Y" it should classified as Long Term Payable.  Is there is any possible in Data Manager package to write the logic based on Account.  But if we have large number of accounts then what is the best option to do.

Thanks & Regards,

Ram

[Former Member]

Hello All,

In some fixed assets cases, it will be based on transaction types.  Is it possible to handle both the cases at the same time.  It may having "ADDITION", DISPOSAL.

Thanks & Regards,

Ram

[former_member186338]

Hi Ram,

You are asking theoretical questions... Please explain your source data and the transformation logic to be achieved.

Vadim

[Former Member]

Hello All

Please see the information:

G.L. Account  Time                 TTyp         Amount      FLOW in BPC

1300000          2013.05                              5000         SHORT TERM

1300001          2013.05                               7000         LONGTERM

1500000          2013.05            100             3000        ADDITION

1500000          2013.05             290            5000        DISPOSAL 

It covers both the scenario. 

Hope this information helps.

Thanks,

Ram

[Former Member]

Hi All,

We have the following dimension:

ACCOUNT

AUDITTRAIL

TIME

FLOW

CATEGORY

ENTITY

When the data comes from source system, based on account, logic needs to be written.

Take for example 130000 - Short Term Receivable.  In the Flow we have to update as "Shortterm".

130005-Long Term Receivable - In the flow, we have to update as "LongTerm".

Similarly we have other accounts, that needs to be updated with Different values in the flow.

190000 - Bonus Payable - Flow needs to be updated as "Provision"

Which is the best approach and easiest approach to adopt.

[Former Member]

Hi,

In your transformation file map FLOW = ACCOUNT

use conversion file to do the mapping of

130000      Shortterm

130005        LongTerm

Andy

[former_member186338]

It means that you select flow based on the account number. Simple table in the conversion file will do the job.

Vadim

[Former Member]

Hi Ram,

if you can set a property by account which identifies the flow to be used for this account you could load data to a LOAD flow and then write a simple script to copy the data to the correct flow based on that property.

As Vadim said, please explain the logic you have.

BR,
Arnold

[former_member186338]

Hi Ram,

If you have some logic based on some substring in Account ID - then you can use conversion file with javascript for correct flow selection. Anyway you have to explain the logic!

Vadim