Open Forum

Expand all | Collapse all

Positive Pay Amount Problem

Jump to Best Answer
  • 1.  Positive Pay Amount Problem

    Posted 7 days ago
    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
    ------------------------------


  • 2.  RE: Positive Pay Amount Problem

    Posted 7 days ago
    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
    ------------------------------



  • 3.  RE: Positive Pay Amount Problem

    SILVER CONTRIBUTOR
    Posted 7 days ago
    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
    ------------------------------



  • 4.  RE: Positive Pay Amount Problem
    Best Answer

    GOLD CONTRIBUTOR
    Posted 6 days ago
    Edited by Justin Falconer 6 days ago
    We have it setup with a Transformation Rule called "ALPHANUMERIC_ONLY"


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



  • 5.  RE: Positive Pay Amount Problem

    Posted 6 days ago
    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
    ------------------------------



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