Sunday, June 23, 2019

Update status of Purchase Orders from Pending Supervisor Approval to Pending Receipt via CSV Import

On the CSV file, enter the following columns:

Internal ID = Internal ID of the PO
Approval Status = Approved

To do the CSV import:

1.    Navigate to Setup > Import/Export > Import CSV Records.

2.    Import Type = Transactions

3.    Record Type = Purchase Order

4.    Select the csv file.

5.    Next.

6.    Data Handling = Update

7.    Next.

8.    On the Field Mapping:

Internal ID = Internal ID
Approval Status
= Approval Status

9.    Next.

10.  Enter an Import Map Name

11.  Click Save and Run.






No comments:

Post a Comment