IntelliMatch – How to import values with (-) Amount / Quantity fields?

Note : Before applying to Production, please test in DEV/QA environments.

Update the FieldDesc Table with below script :

UPDATE         FieldDesc
SET                 ItemTypeField   =  -1
WHERE          TableName        =  ‘Trade/Item’
AND               FieldName         =  ‘UserAmount1/UserQuanity1’

Storing/Loading the amount data with sign is not recommended. Sign should be represented using DCIP. But there could be requirement where user want to see the signed amount and its available in multiple columns for different calculation needs.

  • shreyansh garg

    I have a scenario, wherein I have a csv file and I am also getting comma on my amount notation eg 1,00,000. Is there any way we can import this file without any preprocessing.

    • Manoj Mantoj

      Open the .csv file in notepad and see the amount column. If you see the amount column in double quotes, preprocessing is not reuired before importing it through Recollector. Else, You need to Ask Source team to modify the file for you.

      Example:
      jkl,X4,Y4,150,”1,50,000″,D