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
Common Issues with Importing CSV Files Into Elliott
Release Date: 12/18/2020 Version: 7.0 & Up Elliott Business Software has extensive features with CSV file export and import. It provides a gateway to view Elliott's data in Excel spreadsheets and optionally allow users to edit the data in ...Feature - Support for Discount Amount and Reference in Cash Receipts Detail Interface
Date Released: 2/15/22 Updated: 3/29/22 Version: 8.5 and Above In this enhancement, we improve A/R cash receipt detail CSV file interface in the following ways: Discount Amount and Reference columns are now supported. We now allow negative amounts ...APINVIMS Accounts Payable Invoice Import Utility
A/P Invoice Import Utility Introduction This utility is similar to the COP Sales Order Import Utility. It will allow vendor invoices created through an external source to be imported and become New A/P Transactions in Elliott. Traditionally, if a ...AP08S1 Accounts Payable Pre-Check Writing Report
Pre-Check Writing Report Application Overview The Pre‑Check Writing Report shows you exactly what is going to be paid to each vendor and how much cash and discounts are going to be taken for each of the invoices to be paid. It also shows you the ...ARCSHENT Accounts Receivable Cash Receipts Processing
Cash Receipts Processing Application Overview Cash Receipts Processing is an application that you will use quite often. You will use it whenever you have received payments from any of your customers and want to apply those payments to the customer's ...