Open Forum

Expand all | Collapse all

Positive Pay Amount Problem

Jump to Best Answer
  • 1.  Positive Pay Amount Problem

    Posted Sep 09, 2019 03:08 PM
    I am trying to create a Data Exchange Def for Positive Pay in NAV 2017.  Our bank requires the amount to exclude the decimal point (i.e. - 100.25 should show in the file as 10025).  I cannot find a way to remove the decimal point?  Currently, I have the amount line setup as Data Type = Decimal, Data Formatting = en-US.

    One attempted solution I tried was changing the Data Type to "Text", but that inserted "," as the thousands separator and still included the decimal point.

    I've tried using the Data Format column, but have yet to find the correct format.

    Does anyone have a solution to removing the decimal point in the exported file?

    Appreciate any help!




    ------------------------------
    Ryan Porter
    Controller
    Milgro Nursery
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Positive Pay Amount Problem

    Posted Sep 10, 2019 08:30 AM
    Ryan,

    You could try creating a transformation rule in the field mapping for the amount field.  Find and replace. (Find the decimal and replace with blank). I have seen this used and it appears to work.

    ------------------------------
    Mary Carrero
    Velosio
    apopka NJ
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Positive Pay Amount Problem

    SILVER CONTRIBUTOR
    Posted Sep 10, 2019 08:47 AM
    In the Data Exchange Definition, we have the check amount set up as follows
    &Column No. (2) (PK) is 4
    &Constant (12) is blank
    &Data Exch. Def Code (1) (PK) is POSITIVEPAY
    &Data Exch. Line Def Code (10) (PK) is DEFAULT
    &Data Format (6) is blank
    &Data Formatting Culture (7) is en-US
    &Data Type (5) is Decimal
    &Description (8) is blank
    &Length (11) is 12
    &Name (3) is Check Amount
    &Negative-Sign Identifier (14) is blank
    &Pad Character (16) is 0
    &Path (13) is blank
    &Show (4) is No
    &Text Padding Required (15) is Yes

    And what we are sending to the bank is a list of number with no decimal point showing


    ------------------------------
    Theresa Davis
    Systems Analyst
    Group O
    Rock Island IL
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Positive Pay Amount Problem
    Best Answer

    GOLD CONTRIBUTOR
    Posted Sep 10, 2019 11:17 AM
    Edited by Justin Falconer Sep 10, 2019 12:00 PM
    We have it setup with a Transformation Rule called "ALPHANUMERIC_ONLY"


    ------------------------------
    Justin Falconer
    IT Manager
    Tender Corporation
    Littleton NH
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Positive Pay Amount Problem

    Posted Sep 10, 2019 12:06 PM
    Thanks to all for your help!

    For anyone in the future that might be searching for a solution to the same question I had, Justin's recommendation to add a "Transformation Rule called 'ALPHANUMERIC_ONLY' " worked for me.

    ------------------------------
    Ryan Porter
    Controller
    Milgro Nursery
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role