Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

Creating an MPF Upload

Overview

You can view examples of the files and upload HERE.

The following is needed to determine the MPF per unit by line:

  • Entry Summary Number
  • Entry Summary Line Number
  • Total Goods Value Amount
  • Line Goods Value Amount
  • Total Paid MPF Amount
  • Invoice Quantity

For each line number, the invoice quantity must be the full quantity from the invoice. You will get an inaccurate, inflated MPF per unit if the full quantity is not used. Any instances where a full invoice was not input should not be included.

If you have ACE access for the client, everything but the invoice quantity can be generated in a custom ACE report. The invoice quantity must come from the import input as ACE will have varying units of measure for their quantity. You can easily get the invoice quantity by doing a by-line lookup to the import input.

Once the data has been collected, you'll calculate the MPF per unit with the following formula:

((Line Goods Value Amount/Total Goods Value Amount)*Total Paid MPF Amount)/Invoice Quantity

 

Creating the upload

The upload for Dutycalc only needs three pieces of data: Entry Summary Number, Entry Summary Line Number, and the MPF per unit. They must have the following headers:

  • FORM_7501
  • LineNumber7501
  • MPF_PER_UNIT_ORIG

MPF Upload Headers

Make sure to remove any #NA's from the upload and overall, just treat it like any other upload into Dutycalc with your checks.

 

Uploading the file

Dutycalc Step 1

Navigate to Utility → 3. Import Data → 23. Update Existing Table from CSV/xlsx.

 

Step 1

For Step 1, choose TBL_A_IMPORT and press 'Next'.

 

Step 2

For Step 2, select the Excel file upload. You may need to explicitly specify .xlsx in the bottom right of the folder pop up. Press 'Next'.

 

Step 3

For Step 3, check 'Match On' for FORM_7501 and LineNumber7501. Check 'Update' for MPF_PER_UNIT_ORIG. Press 'Next'.

 

Step 4

For Step 4, click 'Update'. The loading bar will start to progress until it completes.

 

Last step(1)

You can verify that the upload was complete by spot checking a few records and looking at the Orig MPF/Unit.

 

Creating an ACE claim

ACE MPF

After all records have been updated, you'll need to select the right MPF option when you create the ACE claim. Here is an overview of what each option does:

  • 399a. The MPF calculation is done the old way even if an MPF per unit is specified.
  • 399b. The MPF calculation is done the old way for records where there is no MPF per unit. If there is an MPF per unit, it will use that for the calculations instead.
  • 399c. The MPF calculation is done the new way only. If the MPF per unit is blank, you will get $0 MPF.
  • 399d. MPF is marked as $0 for all records.

399c is what you should use to add MPF and stay compliant. 399a and 399b have limited use cases and should never go on a claim.