![]() To apply credit memos to invoices or other transactions, specify invoice numbers as Apply field values, in the Apply sublist. Selectively updatable based on Employee key field. Selectively updatable based on Partner key field. When Multi-Partner Management feature enabled. See Line Item Updates on Transactions Imports. Selectively updatable based on Order Line or Item key field. Selectively updatable based on Apply or Line key field. The Credit Memo import supports the import of the following sublist data: Supported Credit Memo Sublist Data Imports For information about working with the SOAP Schema Browser, see SOAP Schema Browser. You can use the field definitions here as a basis for creating your own CSV import template file. If this preference is not enabled, values should be account name only, for example: Accounts Payable.įor more details about fields that can be mapped in the credit memo record, see the SOAP Schema Browser’s credit memo reference page. If the Use Account Numbers preference has been enabled at Setup > Accounting > Accounting Preferences, imported values for the Account field should include both account number and name, for example: 11000 Accounts Payable. For more information, see Currency Management. If your customers use currencies other than the currency in which your company manages its financials, you should map the Currency field. Currency values are taken from referenced customers. If your CSV file does not include values for this field, you can set it to a default value. If the Multiple Currencies feature is enabled, you should map the Exchange Rate field. If you do not map the Date field, it is mapped automatically with default values of the current date. You do not have to map the required Date field. If you do not map a reference number field, reference number values are generated automatically. This reference must be a unique identifier NetSuite recommends that you use internal ID or external ID, rather than a name reference. This mapping allows external IDs to be displayed on credit memo forms in the NetSuite user interface.Įach imported credit memo record should include a reference to a NetSuite customer record, mapped to the credit memo's Customer field. On the Import Assistant's Field Mapping page, NetSuite recommends that you map the external ID field from your CSV files to the Credit # field, which serves as a transaction ID for credit memo records. For imports of new data, use external ID. The unique ID should be included in every line of the CSV files. You must map external ID or internal ID to serve as a unique ID per record. Blank values for these fields indicate there is no data. Blank values for these fields indicate there is no data.Īpply and Payment are Apply sublist fields. Item and Quantity are Items sublist fields. Other body field values do not need to be repeated in multiple rows. External ID values are repeated in multiple rows to indicate links for sublist data. See Supported Credit Memo Sublist Data Imports.Įxternal ID and Customer fields are body fields. The invoices are referenced by their internal or external IDs.Ĭredit memo imports may also support the import of data for Partners and Sales Team sublists. Items sublist stores data about the items returned by the customer under this credit memo.Īpply sublist contains unpaid open invoices to which the credit memo amount can be applied partly or in whole, decreasing the amount due to be paid by the customer. Setting the Form for a Credit Memo ImportĬredit memo records include Items and Apply sublists: Supported Credit Memo Subrecord Data Imports Supported CSV File Formats for Credit Memo Imports Review the following guidelines for Credit Memo imports: To enable this feature, go to Setup > Company > Enable Features and on the Accounting tab, check the A/R box. Credit memo imports are not available unless the A/R (Accounts Receivable) feature is enabled in your account. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |