Detail Cash Receipt CSV Import with Negative Values Causes Error Message
Release Date: 01/19/2024
Version: 8.5 & Up
Q - In the KB article: https://support.netcellent.com/portal/en/kb/articles/feature-support-for-discount-amount-and-reference-in-cash-receipts-detail-interface, 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
Related Articles
Feature - Import A/R Cash Receipt Detail -- Add Ability to Process Multiple Customers for One Check
Release Date: 2/3/2017 In AR --> Processing ---> Cash Receipts processing --> Interface --> Detail, the current program does not allow processing records that have the same check number but have 2 or more customers. The reason this can happen is ...Feature - AR Cash Receipt to Support CS (Cash) Payment Type
Release Date: 03/03/2022 Version: 8.5 & Up In the A/R Cash Receipt screen, when entering a batch, the system prompts for a payment type. The possible values were: CK=Cash or Check GC=Gift Certificate CC=Credit Card WR=Wired AC=ACH We have now added ...Feature - Customer CSV Import
Release date: 9/25/2019 Version: 8.5 and up For the Customer CSV Import, select AR --> Utility --> Customer/eContact import --> customer/econtact Import --> Customer import This new screen program will have three menu options: Pre-Interface, ...Feature - New Item Import Through CSV File
Program Original Release Date: 05/15/2007 Document Release Date: 08/21/2020 Version: 7.5 & Up The feature can be accessed in I/M, Utility, and New Item Import. It allows you to import new items from either an ASCII or CSV file. This document only ...Feature - Inventory Transfer Management Batches Using CSV Import
Release date: 8/3/2018 "Free" Inventory Transfer Management batches are batches that have been entered by hand through the Inventory Transfer Management application and not automatically generated by Elliott when inventory needs to be transferred. ...