Skip to main content
Solved

Import scenario condition - importing bank transactions

  • January 21, 2026
  • 5 replies
  • 31 views
M
Jr Varsity II
Forum|alt.badge.img

Hi, I am trying to import bank transactions with a csv file data provider. I have established the import scenario, but my condition doesn’t seem to work. It is for the amount column in my CSV file where if it’s positive, it should be a receipt and disbursement if negative:

CSV file
Import scenario condition

 


This is my error when importing: An error occurred while executing the Abs(Identifier(Amount)) function. Type mismatch in the argument 1 of the Abs() function: Expected one of the Integer types.

 

Looks like ABS function isn’t accept by the system. Can someone help please?

Best answer by MarkD

I’ve worked it out now using: =IIf([Amount] < 0, Replace([Amount], '-', ''), [Amount]) 😊

5 replies

npetrosov31
Jr Varsity I
Forum|alt.badge.img
  • npetrosov31
  • Jr Varsity I
  • January 21, 2026

hi ​@MarkD,

 

You can change the function and instead of ABS([Amount]) use [Amount] * -1. It will make your negative amount positive and does not have a problem with acceptance with the system

    H
    Freshman II
    • hoaw
    • Freshman II
    • January 21, 2026

    Hi ​@MarkD ,

    I would also check the Commit check boxes for both Receipt and Disbursement rows.

      M
      Jr Varsity II
      Forum|alt.badge.img
      • MarkD
      • Author
      • Jr Varsity II
      • January 22, 2026

      Hi ​@npetrosov31 - I now get this error. Looks like * isn’t accepted either. Any other way?

       

      M
      Jr Varsity II
      Forum|alt.badge.img
      • MarkD
      • Author
      • Jr Varsity II
      • January 22, 2026

      I’ve worked it out. I used this condition:

      =IIf([Amount] < 0, Replace([Amount], '-', ''), [Amount])

      M
      Jr Varsity II
      Forum|alt.badge.img
      • MarkD
      • Author
      • Jr Varsity II
      • Answer
      • January 22, 2026

      I’ve worked it out now using: =IIf([Amount] < 0, Replace([Amount], '-', ''), [Amount]) 😊

        Terms & ConditionsCookie settingsAccessibility statement
        About Acumatica ERP system
        Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
        © 2008 — 2024  Acumatica, Inc. All rights reserved