What Values to Populate in Document Number in Sales & Cr/Dr Memo Processing CSV Import

What Values to Populate in Document Number in Sales & Cr/Dr Memo Processing CSV Import

Release Date: 6/13/2023
Version: 8.0 & Up

Q - We want to use the Sales & Cr/Dr Memo Processing Import tool. What should or shouldn’t we populate column B (Doc#) with? We typically always reference a document # when processing credit or debit memos. The sample layout of the CSV file is not clear on what value to provide in Column B.


A - We suggest that you do not populate any value in column B (Doc#). The system will automatically assign the next Doc# when it is not provided. This process is equivalent to manually adding a credit memo in A/R and pressing the F1 key to assign the next Doc#. If you choose to populate the Doc# yourself, you must ensure that the Doc# is not already in use in the system to avoid duplication. In most cases, there is no benefit for you to assign the Doc# yourself.

Regarding your statement "We typically always reference a document # when processing credit or debit memos," I believe you are referring to column M (Apply To). This column typically contains the invoice number to which the credit or debit memo should be applied. In A/R, each document has a document number and an apply-to number. For an invoice, the apply-to number is the same as the invoice number. For a credit memo or payment, the apply-to number is the invoice number to which the credit memo or payment should be applied.

For a credit memo, you should populate column M (Appl To). If you don't, it will become an open credit. As for a debit memo, it may apply to another invoice or stand alone by itself. If you don't provide a value in column M, the debit memo will apply to its own doc# (Doc# in column B either provided or sequentially assigned by system).


EMK

    • Related Articles

    • ARSLSENT Accounts Receivable Sales and CR/DR Memo Processing

      Sales & CR/DR Memo Processing Application Overview Sales & CR/DR Memo Processing is an application that you will use very often. You will use it whenever you want to record in your Accounts Receivable new transactions that have occurred. For example, ...

    • Avalara - Sales & Cr/Dr Memo Processing

      Release Date: 4/28/23 Version: 8.6 and Above If you are using Avalara Interface, Elliott's A/R Sales & Cr/Dr Memo Processing will force the tax amount 1, 2, and 3 to be zeroes for taxable customers. This is because interfacing with Avalara requires ...

    • ARAPLYCR Accounts Receivable Re-Apply CR/DR Memos

      Re-Apply CR/DR Memos Application Overview Using the Re-Apply CR/DR Memos application, you can apply a credit memo, debit memo, unapplied payment, or “Quick Adjustment” to an invoice. This application allows you to apply one credit memo or payment to ...

    • Feature - Import of Shipment Tracking Number for Sales Order Through CSV File

      Release date: 5/19/2020 Revised: 7/26/24 Version 8.5 and Up You can now import shipment tracking numbers for sales orders through a CSV File. You can find the utility in COP, Processing, Print Pick/Pack Tickets & Lbls, Shipping, and Tracking Number ...

    • V8.5 Alpha Document Number Support

      The primary reason for this feature is because some Elliott users are running out of invoice numbers and are approaching invoice number 999999. In the past, users could use a special archive procedure to reset the invoice number. However, there are ...