15.6.3.2 Importing Adjustments

Use the Import option to upload the Microsoft Excel workbook with modified adjustment values.

Partial Adjustments: You have the flexibility to tag one or more adjustments while importing the adjustments into the application. You can enter the keywords Publish or P in the PUBLISH_STATUS column of the Microsoft Excel workbook. Only adjustments that are marked for publish will be posted to the Product Processor.

Sometimes, the exported Microsoft Excel sheet has a column called PUBLISH_STATUS with no values initially. You can either enter Publish or P against the records you want to post to the Product Processor table.

To Import the Microsoft Excel file, follow these steps:

1. On the AFCS Home page, click the My Profile icon on the top-right corner and click Administration. From the LHS menu, click File Operations.
2. Click Upload File. Enter the following details:
   • Enter the File Name.
   • Select the File Type as XLSX File.
   • Enter the size of file.
3. Click Generate.
4. Copy Pre-Authenticated Request URL and execute it using Postman or Swagger as Service Type= PUT.
5. Click Import icon. Select the recent file from the pop up after clicking on the upload. It uploads the file back to the server.
6. Click Approve icon.
   Only the approved records get published in the target table.
7. Refresh the UI using Refresh icon.