9 Replies Latest reply on May 28, 2015 8:14 AM by SH_INT

    FDMEE not taking parentheses in amount as negative

    Roshin

      Hi All ,

       

      I am having below TB sample  file , When i load it using fixed import format the rows with amount having parentheses are not taken in . Only Positive values are imported .

       

                          Ledger:  XXXXXX

                Reporting Entity:  XXXXXX

      Account     Description          Account                    Beginning Balance      Period Activity    

      ----------- -------------------- ----------------------    ------------------  ------------------

      44455       XXXXX 33-000-44455-0000-00000-00-0000-000-0000   (345,777,777.63)    (36,094,714.13)   

      44444       XXXXX 33-000-44444-0000-00000-00-1045-000-0000         14,086.55             655.19        

      66666       XXXXX 33-000-66666-0000-00000-11-0000-000-0000         (7,396.15)         (1,264.45)       

      88888       XXXXX 33-333-88888-0000-00000-00-0000-000-0000        136,537.09          41,602.31       

      11232       XXXXX 33-333-11232-0000-00000-00-0000-000-0000          9,000.00           3,000.00

       

      In log file it say NN against these rows

       

      Log :

       

      NN................ Non-Numeric, Amount field contains non numeric characters.

       

      [TC] - [Amount=NN]  66666      Int. Inc. - General  33-000-66666-0000-00000-11-0000-000-0000         (7,396.15)         (1,264.45)         (8,660.60)

       

      Please advise why FDMEE is taking like this and how can i take amounts in parentheses as negative .

       

      Regards,

      Roshi