Hi all, has anyone been able to do a csv upload wh...
# csvimportsn
neerajrtiwari
04/22/2019, 8:24 PMHi all, has anyone been able to do a csv upload which closes expense POs? I am working with support and they told me to follow the steps for mapping as shown below. -Map the following fields to the NetSuite Fields
Internl ID = Purchase Order : Internal ID
Closed = Purchase Order Items : Closed
Line ID = Purchase Order Items : Line Id
r
rustyshackles
04/22/2019, 8:28 PMWhat type of import are you doing? Is it an update?
n
neerajrtiwari
04/22/2019, 8:28 PMYes
r
rustyshackles
04/22/2019, 8:28 PMDid you check if you have amount mapped? Sometimes if the csv headers are the same as the field name, NetSuite auto maps them.
n
neerajrtiwari
04/22/2019, 8:29 PMI am only mapping the headers of Internal ID, Line ID and Close
neerajrtiwari
04/22/2019, 8:31 PMI also thought of another possibility - that may be instead of mapping Closed = Purchase Order Items : Closed - instead of this, I need to do Closed = Purchase Order Expenses: Closed - but problem is I don't see a Closed field on the right in NetSuite fields to map to.
r
rustyshackles
04/22/2019, 8:32 PMDo you see a closed column for the Expense sublist? If not, you probably can't close Expense lines. I know there is one for line items but not sure for expense lines.
n
neerajrtiwari
04/22/2019, 8:33 PMYep, I don't see the closed column for Expense sublist
neerajrtiwari
04/22/2019, 8:33 PMI mean during the csv import, I don't see the column
neerajrtiwari
04/22/2019, 8:34 PMBut I can see the closed column under Expense sublist on the actual PO
r
rustyshackles
04/22/2019, 8:38 PMhmm, might be that field is not exposed to csv imports. Don't know of any workarounds