By using this website, you agree to our Terms of Use (click here)
i have an existing import scenario that i created for AP Bills.
i would now like to add Debit Adj. as transaction type in the same import.
i added column for TYPE - users will assign 'I' for invoices, or 'C' for credits issued by Vendor.
in reality I = Bills, and C is debit Adjust.
HOwever, for users to balance their entries before sending to Audit for import.
users make the AMOUNT NEGATIVE when Credit (Debit Adj. type) is used.
my formula looks like =IIF( [TYPE] = 'C', ([AMOUNT]*-1), [AMOUNT])
of course the negative isn't necessary for Acumatica.
what are my options. I doing very similar to assign BILL or CREDIT ADJUSTMENT.
Thanks for assistance.
Hi HappGilmore,
Did you put your =IIF( [TYPE] = 'C', ([AMOUNT]*-1), [AMOUNT]) in the import scenario?
Hi Tim,
It did not work for me. I have similar requirement. I want to create credit memos but amount in import sheet is negative. I used formula =([Amount]*-1) it gave me error Cannot perform the '*' operation on System.String and System.Int32. I also tried using CStr but it did not work either.
Did you try CInt([Amount]) * -1 ?
I identified the fix, I changed the data type on data provider to int32 and used cdec in import scenario. It worked.