A/P Invoice Upload Values (H69)
Purpose: Use this screen to specify how to handle invoices uploaded from an external system.
This screen includes the following values which control how the system handles uploaded invoices. You should use this screen to set these values, rather than selecting each system control value individually.
Additional required system control values: In addition to the following fields, you must also select these system control values to use the A/P invoice interface to create invoices:
• Use Purchase Order/Drop Ship Matching (D21)
• Batch Entry of A/P Invoices (F02)
See Working with A/P Invoice Upload Errors (WAPU) for an overview of the A/P invoice upload process.
A/P Invoice Upload Division (H70)
The system uses this division for invoices you create through the invoice upload from an external system. This division corresponds to the Division field at the Enter A/P Invoices Screen (When Using Batching). Your entry is validated against the Division table.
Required if you are using the A/P invoice interface to create invoices.
Used by periodic function: The GLRESET periodic function uses this division as a parameter. This periodic function clears the General Ledger Interface table and recreates postings based on updated or corrected information. See Resetting the General Ledger Interface Table (RGLI) for background.
The system uses this bank for invoices you create through the invoice upload from an external system. This bank corresponds to the Bank field at the Enter A/P Invoices Screen (When Using Batching). Your entry is validated against the Bank table.
Required if you are using the A/P invoice interface to create invoices.
Used by periodic function: The GLRESET periodic function uses this bank as a parameter. This periodic function clears the General Ledger Interface table and recreates postings based on updated or corrected information. See Resetting the General Ledger Interface Table (RGLI) for background.
A/P Invoice Upload Default Detail General Ledger Number (H72)
The system uses this general ledger number when creating an A/P invoice detail line for any detail line that does not have a matching A/P Transaction record with a general ledger number. The A/P Transaction record normally gets its general ledger number from the purchase order detail line; the purchase order detail line gets its general ledger number from the R inventory transaction code, if the Default Receipt General Ledger Number (D95) system control value is selected.
Required if you are using the A/P invoice interface to create invoices, unless the general ledger number will always default from the purchase order detail line.
A/P Invoice Upload Unit Variance Percent (H74)
Indicates the percentage by which the units on an uploaded invoice detail line can exceed or fall short of the unit quantity on the matching A/P Transaction record without preventing the batch from processing automatically, if the A/P Invoice Upload Auto Accept Batch (H73) system control value is selected.
Example: |
If the uploaded invoice detail quantity is: |
variance percent = 10.00% A/P transaction quantity = 10 |
11: Exceeds the transaction quantity by 10%. It does not breach the variance percentage and will not prevent the batch from processing automatically. |
|
12: Exceeds the transaction quantity by 20%. It breaches the variance percentage, and the batch will be suspended. |
|
8: Falls short of the transaction quantity by 20%. It breaches the variance percentage, and the batch will be suspended. |
Credit invoices are not evaluated for invoice variance.
This is a five-position numeric field with two decimal places.
Leave this field blank if:
• you are not using the invoice upload, or
• you want all invoice detail quantities that do not match the A/P transaction quantity exactly to prevent the batch from processing automatically, or
• the A/P Invoice Upload Auto Accept Batch (H73) field is set to unselected.
A/P Invoice Upload Cost Variance Percent (H75)
Indicates the percentage by which the cost of an uploaded invoice detail line can exceed or fall short of the unit cost on the matching A/P Transaction record without preventing the batch from processing automatically, if the A/P Invoice Upload Auto Accept Batch (H73) system control value is selected.
Example: |
If the uploaded invoice detail cost is: |
variance percent = 10.00% A/P transaction cost = 10.00 |
11.00: Exceeds the transaction cost by 10%. It does not breach the variance percentage and will not prevent the batch from processing automatically. |
|
12.00: Exceeds the transaction cost by 20%. It breaches the variance percentage, and the batch will be suspended. |
|
8.00: Falls short of the transaction cost by 20%. It breaches the variance percentage, and the batch will be suspended. |
Credit invoices are not evaluated for invoice variance.
This is a five-position numeric field with two decimal places.
Leave this field blank if:
• you are not using the invoice upload, or
• you want all invoice detail quantities that do not match the A/P transaction quantity exactly to prevent the batch from processing automatically, or
• the A/P Invoice Upload Auto Accept Batch (H73) field is set to unselected.
A/P Invoice Upload Terms Code Usage (H76)
Select this field to have the system uses the A/P terms information included in the invoice upload when creating the A/P invoice; otherwise, leave it unselected to have the system check the purchase order for A/P terms information. Selecting the Terms Code for an overview of how the system determines which terms code to use on an uploaded invoice.
A/P Invoice Upload Auto Accept Batch (H73)
Indicates whether the system should automatically accept and process A/P invoice batches if all required information is available and the invoices do not breach the A/P Invoice Upload Unit Variance Percent (H74) or the A/P Invoice Upload Cost Variance Percent (H75).
If this field is set to selected, the system accepts batches automatically if they include all required information and do not breach either of the variances or any dollar limits specified for additional charges; however, any batches that do not meet these criteria will be suspended.
If this field is unselected, the system suspends all batches without checking whether the variances and dollar limits have been breached.
You use A/P entry to review and approve suspended batches. See Enter A/P Invoices Screen (When Using Batching) for more information.
