Detail Cash Receipt CSV Import with Negative Values Causes Error Message
Version: 8.5 & Up
Q - In the KB article: https://support.elliott.com/knowledgebase/articles/1987624-feature-support-for-discount-amount-and-referenc, I see we can use negative amounts with Detail Cash Receipt CSV Import to create debit memos. The following is the sample of my CSV file:
646521,,123456,123456,123,1/17/2024,1996.2,CYC792,-254.79,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE723,-629,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE722,-149.99,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE718,-490,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE726,-352,,,
646521,,123456,123456,123,1/17/2024,1996.2,CIO927,599.99,,,
646521,,123456,123456,123,1/17/2024,1996.2,CIS050,149.99,,,
646521,,123456,123456,123,1/17/2024,1996.2,CIZ677,451,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJE201,184,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJG695,729,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJM924,514,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJR919,447,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJS675,279,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJU196,518,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE723,-629,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE722,-149.99,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE718,-490,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE726,-352,,,
646521,,123456,123456,123,1/17/2024,1996.2,CIO927,599.99,,,
646521,,123456,123456,123,1/17/2024,1996.2,CIS050,149.99,,,
646521,,123456,123456,123,1/17/2024,1996.2,CIZ677,451,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJE201,184,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJG695,729,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJM924,514,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJR919,447,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJS675,279,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJU196,518,,,
In the pre-interface report, the system complains about those negative value entries with the following message:
*** Error on Line# 999999 : Distribute Amount Is Greater Than Invoice Balance
See sample screen below:
What happened?
A - If you look at the same KB article, it advises you to put the negative values after the positive values. Therefore, you can re-arrange your CSV file as follows:
646521,,123456,123456,123,1/17/2024,1996.2,CIO927,599.99,,,
646521,,123456,123456,123,1/17/2024,1996.2,CIS050,149.99,,,
646521,,123456,123456,123,1/17/2024,1996.2,CIZ677,451,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJE201,184,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJG695,729,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJM924,514,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJR919,447,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJS675,279,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJU196,518,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYC792,-254.79,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE723,-629,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE722,-149.99,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE718,-490,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE726,-352,,,
646521,,123456,123456,123,1/17/2024,1996.2,CIS050,149.99,,,
646521,,123456,123456,123,1/17/2024,1996.2,CIZ677,451,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJE201,184,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJG695,729,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJM924,514,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJR919,447,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJS675,279,,,
646521,,123456,123456,123,1/17/2024,1996.2,CJU196,518,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYC792,-254.79,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE723,-629,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE722,-149.99,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE718,-490,,,
646521,,123456,123456,123,1/17/2024,1996.2,CYE726,-352,,,
Then import again. This time, the pre-interface report will show as follows:
EMK