(NOR) Payment lines report (CustVendPaymJournal)

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

The Payment lines report displays a summary of the vouchers that are generated for a customer payment or vendor payment, along with the payment status of the vouchers. This report is typically used by accounts payable payments clerks and accounts receivable payments clerks to maintain customer payments and vendor payments.

Before you can generate this report, you must set up a method of payment that uses the BBS Direkte Remittering (NO) or TelePay 2,01 (NO) return file format. You can select the required return file format in the Return format field in the Methods of payment - customers or Methods of payment - vendors form.

Note

(NOR) This report is available only to legal entities whose primary address is in Norway.

How to filter the data on this report

When you generate this report, the following default parameters are displayed. You can use these parameters to filter the data that will be displayed on the report. For more information, see Filter the data on a report.

Field

Description

Specification

Select this check box to print the payment specifications of the vouchers.

Sum up currency/date

Select this check box to print the sum of the payments by payment currency and payment date.

Journal batch number

The ledger journal batch number that is used to generate the report.

Payment status

The status of the payment. One of the following options is displayed:

  • None – The payment proposal has been generated.

  • Sent – The payment or check has been generated.

  • Received – The bank has received the payment file.

  • Approved – The payment has been approved.

  • Rejected – The payment has been rejected.

  • Delete – A payment deletion file has been sent to Bankenes BetalingsSentral (BBS).

  • Sent delete – A payment file that has a Delete status has been sent to the bank.

  • Deleted – The payment file has been deleted.

How to work with reports

The following topics explain how to print a report and how to filter and sort the data on a report.

Details of this report

The following table explains where to find the report in the Application Object Tree (AOT) and how to navigate to the report in the Microsoft Dynamics AX client.

Detail

Description

Name of report in the AOT

CustVendPaymJournal

Location of report in the AOT

SSRS Reports\Reports\CustVendPaymJournal

Menu item of the report

CustVendPaymReportJournalRun

Navigation to the report

Click Accounts payable > Journals > Payments > Payment transfer. Click Return file - customer. In the Load diskette with payments form, in the Method of payment field, select the method of payment that uses the return file format that is required to generate the report, and then click OK. Enter the required details, and then click Payment lines.

–or–

Click Accounts receivable > Journals > Payments > Payment transfers. Click Return file - vendor. In the Load diskette with payments form, in the Method of payment field, select the method of payment that uses the return file format that is required to generate the report, and then click OK. Enter the required details, and then click Payment lines.

Where the data in this report comes from

The data on this report comes from the following sources:

  • CustVendPaymJournalTmp table

    Note

    To find out where the data in the temp table comes from, view the cross-references for the CustVendPaymJournalDP.processReport class.

If you are a developer, you can learn more about where the data on a report comes from by using the following procedure.

  1. Open the AOT.

  2. Locate the report in the SSRS Reports\Reports node.

  3. Right-click the report and click Add-Ins > Cross-reference > Using (instant view).