When importing advanced Intercompany Journal Entries, the user may get this error message. While importing Advanced Intercompany Journals, include a column “Eliminate” in the Import file. This Eliminate column should be populated as either “YES” or “NO”. For the Intercompany accounts at the line level, we should select the “Eliminate” checkbox as “Yes”. Then in… Continue reading CSV Import error – The Due To/From Subsidiary for the From Subsidiary lines must be one of the other subsidiaries used in the transaction.
Tag: csv import
Remove specific item lines from the PO/SO through CSV
Remove specific item lines from the PO/SO through CSV
OPEN BILLS AND CSV IMPORT
A vendor bill lists the quantity received for each line item on the purchase order. In the Vendor Bills form, you can record vendor bills for payment by entering the vendor, items, and expenses. Vendor ID: ID of the vendor for whom the vendor bill is to be created. Open bills mean bills with not paid… Continue reading OPEN BILLS AND CSV IMPORT
Replace transaction sublist via CSV Import
Scenario: The requirement was to completely update the transaction expense/item lines as it was created with incorrect data.Solution:– Prepared CSV import file with the correct expense line data.– Add a column for Line ID.And fill the column starting from 1 for each line that belongsto one record. That is if one record has 3 item… Continue reading Replace transaction sublist via CSV Import
Open invoice and csv import
An open invoice is a detailed document that shows the amount owed and the due date of the payment. Generally the invoice is sent by vendors to the accounting department or accounts payable department of the company that owes them. The invoice can also show if there is any past due amount from previous transactions… Continue reading Open invoice and csv import
Steps to update item prices for the items using CSV import
Steps to update item prices for the items using CSV import
Kit Item Import Possibilities
To import Kit items there are 2 methods available One file Upload Include all the Item details in a single file. When preparing the import file, make sure to add all member item details in a single row for each Kit item. For example, refer to the screenshot below Optionally add an external ID for… Continue reading Kit Item Import Possibilities
CSV Import – Invalid Reference Key
The error occurs because in the Account internal id mapping, not choose the reference type as ” Internal ID”. To resolve this error; Click the pencil icon of the ” Account Internal ID ” and choose the reference key type as ‘ Internal ID ‘. Click Ok.
CSV Import Best Practices
CSV Import Best Practices
Multiple File CSV Import
Some record types include sublist fields, especially most of the transaction records. For example, Sales order and Purchase Order records include Item/Expense sublist data. We can import sublist data for some record types including them in a single file with the body level data or as multiple files. The import assistant provides the “Multiple Files… Continue reading Multiple File CSV Import