Skip to main content
Solved

Import scenario condition - importing bank transactions

  • Jan 21, 2026 5:54 AM UTC
  • 5 replies
  • 106 views
  • Translate All
Semi-Pro I
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]) 😊

View original

5 replies

npetrosov31
Jr Varsity I
Forum|alt.badge.img+2
  • npetrosov31
  • Jr Varsity I
  • Jan 21, 2026 10:04 AM UTC

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

Translate
    Freshman II
    • hoaw
    • Freshman II
    • Jan 21, 2026 2:58 PM UTC

    Hi ​@MarkD ,

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

    Translate
      Semi-Pro I
      Forum|alt.badge.img
      • MarkD
      • Author
      • Semi-Pro I
      • Jan 22, 2026 12:00 AM UTC

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

       

      Translate
      Semi-Pro I
      Forum|alt.badge.img
      • MarkD
      • Author
      • Semi-Pro I
      • Jan 22, 2026 1:35 AM UTC

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

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

      Translate
        Semi-Pro I
        Forum|alt.badge.img
        • MarkD
        • Author
        • Semi-Pro I
        • Answer
        • Jan 22, 2026 1:36 AM UTC

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

        Translate
          Terms & ConditionsAccessibility 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