Credit memo template excel how to#
Credit memo template excel full#

Credit Memo A is for $50 and being applied to one Invoice. Every line or group of lines per desired credit memo must have a unique external ID.įor example, the desired result of the Import is to create two Credit Memos. This value can be numeric or alpha-numeric. That is how NetSuite knows which lines belong to a given transaction. Its purpose is to define the individual Credit Memos to create.

Credit memo template excel how to#

Following is a detailed description of how to populate the Excel Template, also known as the Import Source File.Įxternal ID: this field is needed in the template. csv file is what the import will use as the source file. The spreadsheet will be saved first as an Excel Workbook. This second Credit Memo is for $150, we are applying $100 one Invoice and $50 to another. The other is being applied to two invoices, therefore it will have two rows. One for $50 being applied to one Invoice. This example is creating 2 Credit Memos being fully Applied. Populate the cells in the following manner. No Tax Code required on Credit Memo LineĬreate an Excel spreadsheet with the following columns/fields:.Item Price Levels are used in this environment.This example assumes one currency, US Dollars.This example assumes the Department and Location are required fields for a Credit Memo.And how to correctly build the field mapping in the CSV Import itself and execute it.

Credit memo template excel full#

This can be helpful in situations where a large volume of credits are processed and it is desired to bypass default functionality and have NetSuite apply the full open amount, and instead dictate how much to apply to each invoice.īelow is a step-by-step description of how to correctly build and populate an import source file. Applied is the Internal ID for the Sales Invoice the Credit is being applied to. The key for the Apply to work is to populate two fields in the template: Apply Applied and Apply Payment. This is very straight-forward as it is exactly like Importing a Credit Memo without applying it, with the exception of two additional fields to populate and include in the import mapping. NetSuite supports being able to import a Credit Memo and apply it to a Sales Invoice in the process.