Lowe's Invoice Reconciler

Setup

Values used by new runs. A run keeps the setup it was started with, so changing this does not alter a run already processed.

GL Mapping

Which GL each deduction line posts to. This is the part that changes when Lowe's adds a fee.

Fee Detail → GL RTV Stand lines

Matched against the remit's Comments2, then Comments, then the Chargeback Reason: at least two words in common and a quarter of the fee's words.

Fee DetailGLGL DetailRemove
No GL: lines matched here wait for one in Review.
Same text as Not a fee (320050) above, which wins ties, so this row never matches.

RTV Method → GL RTV Return lines

Exact match on the RTM file's RTV method, ignoring case.

RTV MethodGLRemove
An RTM Return file with several lines is flagged when its Σ Extended Cost and the Deduction Amount differ by more than this.

Debit and Credit Memos

Accounts and descriptions written into TemplateCM.

Accounts

The macro had it fixed at 320050.
The macro had it fixed at 320100.
Credit memo Stand lines, and the base for Return lines.

Descriptions

Reads as Deduction from Lowes applied on remit# 700041092
Reads as Recapture funds on Lowes applied in the remit# 700041092
Payment defaults C100002100234ACHMain Customer, cash account, method and branch for TemplatePM. Rarely changed.
PM Branch column.