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 ...

    • DN API (Document Number Handling)

      Release: 1/11/2021 Version: V8.5 and higher DN API: Document Number Increase, Roll Back or Validate In Elliott V8.5, the system supports alphabetic document numbers. The logic to sequentially assigning the next document number is complicated. For ...

    • Alpha Document Number Support (V8.5/V9.0)

      V8.5/V9.0 offers support for alpha numeric document numbers. This gives the user more flexibility on the number of alphabetic characters in next document number. For example, in the scenario of the following “Starting Invoice Number” in A/R Setup: ...