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 - Add Links Import to System Files Setup
Release date: 5/8/2019 Version 8.5 and up Added a new menu option, System Utilities-> System File Setup-> Import-> Links. The menu has three options: Pre-Interface, Interface, and Layout. The Layout screen has the following columns: the Pre-interface ...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 ...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 ...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 ...