This section describes the general process used to apply items received as part of a van line statement import.
Applying Items from a Van Line Statement
1. In MoversSuite,
2. Access Payment Management,
3. Select a batch, or split sub batch, imported from a van line from the Batch Management data grid. Refer to the Importing Statements from a Van Line section for details on importing the statement file,
It is recommended to split a statement batch by matching transactions to increase workflow efficiencies. Refer to the Splitting a Batch section for detail,
Figure 52: Sample van line statement split
4. Access Detail Processing by pressing the Process button,
5. Select the first record and press Apply to evoke one of the wizards,
6. Apply items as indicated below:
ACCOUNT RECEIVABLES
For account receivables (Payment Code of “M” and a positive Amount) records, the Apply Wizard will appear (see Using the Apply Wizard). Verify and correct the following:
• If the item is related to an order, then verify the Order or use Find to locate the correct order. Note: Changing the order will not affect distribution at the van line,
• If the item is to be applied to a vendor, then switch the item to a payable by changing the Payment Code to a “P.” Refer to Switching Payment Codes section for details,
• If the item is not related to an order then apply the amount to a general ledger,
• If there is a Payment Balance, then access the Unapplied Cash amounts and apply the balance to the customer. See Using the Unapplied Amounts Dialog for details,
CHARGEBACK ITEMS
For chargeback items (Payment Code of “M” and a negative Amount) records, the Chargeback Apply will appear (see Using the Chargeback Apply). Verify and correct the following:
• If the item is not related to an order, then change the item to a payable item by switching the Payment Code to “P.” Refer to Switching Payment Codes section for details,
• If the Order is incorrect, then choose Select Original customer and make corrections to the transaction through Revenue Entry before processing further,
• If the Customer is incorrect, then select New Customer or use the Customer Find dialog to locate the correct customer account. Important: Verify that the correlating transactions are correct in Revenue Entry,
• If Order and Customer are correct place a check next to Original Customer,
ACCOUNT PAYABLES
For account payable items (Payment Code of “P” and a positive or negative Amount), the Modify Wizard will appear (see Using the Modify Wizard). Verify and correct the following:
• If the item is related to an order then switch the item to a receivable by changing the Payment Code to a “M.” Refer to Switching Payment Codes section for details,
• If payments are to be manually applied to a vendor or van line then select either Contest Entire Charge or Van Line Refund. This will create necessary related MoversSuite transaction documents that can be applied in Microsoft Dynamics GP after payment is received,
• If the item is applied to more than one vendor or general ledger account, then use the Allocate Wizard to create necessary allocation records. Refer to the Using the Allocate Wizard for details,
CLAIMS
For claim items that are for a positive amount, the Apply Wizard will be used (see Using the Apply Wizard). Verify and perform the following:
• If processing claim items using the Claims module, then either apply to the claim customer using the data grid or through Unapplied cash.
If not processing claims items using the Claims module, then only apply the item using the Unapplied Cash,
• For claim items that are for a negative amount, the Modify Wizard will be used. Verify and perform the following:
• Apply to Vendor and/or Main Account (GL). If more than one vendor or general account is needed, then use the Allocate Wizard to make specifications,
7. Access the next record to apply by using the wizard navigation. Refer to the Using Payment Management Wizards section for more information,
8. Repeat the above step to process other payments and charges,
9. Press Done to close the wizard,
10. When all transactions have been fully applied
as denoted by a checkmark (
) in
the first column, then the batch or sub-batch can be posted through the
Generate Transaction option. Pressing Generate Transactions
will produce a confirmation dialog,
11. Press Yes to generate accounting transactions for the statement. The batch or sub-batch will be in a “Posted” status.
Note: A posted batch or sub-batch will only display in the Batch Management data grid when the Show All option is selected.
RELATED TOPICS:
Importing Statements from a Van Line
Payment Management Import Statement Formats
Using Payment Management Wizards
Using the Unapplied Amounts Dialog