5157810 Pmt. Import
5157810_01 Pmt. Import
Use the "Start object" function to select the possible demo scenarios of the "OPP Build Demodata" report. The register Pmt. Import also contains the selection Pmt. Import. This ensures that demo data for the presentation of the automatic allocation with predefined open entries and matching bank statement data is generated.
The result of the execution of the option Pmt. Import via the "OPP Build Demodata DEMO" report can first be seen in the OPplus role center of the demo company via the respective tiles:
After executing the Pmt. Import you can trace the following setup data or transaction data:
Open entries on customers have been created by posting the journal DEMODATA.
A payment import interface has been created
An open payment import journal matching the customer entries was created and the corresponding 16 payment import lines were created.
The 16 payment import lines have been imported into the ext. cash receipt journal.
Created open customer entries
Created Pmt. Import interface
Open Pmt. Import Register
Payment Import lines in the Ext. Cash Receipt Journal
Based on these payment import lines of an imported bank statement, it is now possible to present for the different clearing statuses of column 1. Further procedures for each line in the Ext. Cash Receipt Journal are:
|Column||Account||Document No.||Note||Application Status||Result|
|1||66222||825235||Document no. is given, payment amount = invoice amount||System||Account has been found and entries have been applied.|
|2||66333||824350||Document no. is given, payment amount = invoice amount||System||Account has been found and entries have been applied.|
|3||54888||824722, 824782, 825437, 825438, 825443||Document no. given, payment amount = amount of invoices||System||Documents can be shown throughout the menu item Apply Entries.|
|4||42333||824128, 825457||Document no. is given, payment amount = amount of invoices||System||Documents can be shown throughout the menu item Apply Entries.|
|5||41366||825214, 825856||Document no. is given, payment amount <> invoice amount, corresponding credit note missing||Accounted||Accounted but no application of entries. "Accounted by" viewable in the payment import entry card. Demo manual aftercare.|
|6||43999||825307, 825348||Document no. is given, payment amount <> invoice amount, a wrong document no. is given in the reasons for transfer||Accounted||Accounted but no application of entries. "Accounted by" viewable in the payment import entry card. Demo manual aftercare.|
|7||40454||824124||Document no. is given, payment amount = invoice amount||System||Account has been found and entries have been applied.|
|8||42424||823321||Document no. is given, payment amount = invoice amount||System||Account has been found and entries have been applied.|
|9||44339||822652||Document no. is partially given, credit note as an amount in the reasons for transfer payment amount <> invoice amount||Accounted||Nothing accounted and no application of entries. "Accounted by" viewable in the payment import entry card.|
|10||43822||823146||Document no. is given, payment amount = invoice amount||System||Account has been found and entries have been applied.|
|11||56999||824822||Document no. is given, payment amount = invoice amount||System||Account has been found and entries have been applied.|
|12||77222||Customer no. 077222 given||Open||Entries haven't been found. Demo: OPplus Pmt. Import Setup – Auto Accounting I: „Skip leading zero“|
|13||reasons for transfer empty||Open||No entries found. Demo: Setup of an accounting rule with catchword und given G/L account.|
|14||22133||823523, 823991||Document no. is given,payment amount <> amount of invoices||To Complete||Demo: OPplus Pmt. Import Setup - Auto Application: „Complete if there is a difference“ and Ext. Features Setup – Auto Application: „Pmt. Discount Tolerance Amount“|
|15||22233||Customer no. is given, indicated document no. is not given.||Accounted||Accounted by Account no. "Accounted by" viewable in the payment import entry card.|
|16||40555||824802||document no. is given, payment amount <> invoice amount, Accounted by document no.||Accounted||Demo: Extended Application – Balanced Application|
*If the bank import finds several items, but does not apply them because the payment amount and the amount of the invoices do not match, the items are optionally applied without writing the value "Detailed Ledger Entires" in the "Applies to ID" field. The status in the Gen. Journal line is then set to "to complete". The Payment Import Setup for this is located in the "Auto Application" tab.
Explanation of the demonstrations
For the lines of the Ext. Cash Receipt Journal that have the application status "system" (lines 1-4, 7, 8, 10, 11), the entries marked for application can be reviewed and checked using the menu item Apply Entries. In the Extended Application, an automatic application can be manually removed using the menu item Set/Delete Application. The application status instantly changes to Accounted. If the application is set manually again after changes have been made, the Application Status will change to "Finished".
The import lines marked with "System" or "Finished" can be posted through Ext. Cash Receipt Jounal.
The import line no. 5 is accounted by a document no. By following Actions/Pmt. Import/Show Pmt. Import Line you will get the application details regarding the corresponding line. The mentioned credit note hasn't been posted yet, so that the payment amount doesn't match the invoice total. If you set the application, the customer gets a questioning field with different options of how to handle to remaining amount. E.g. a new entrie on the customer, which can be allocated later with the corresponding credit note.
The import line 6 is accounted by document no. in the reasons for transfer. Other document no.s don't match the entries. The payment amount is <> than the invoice amount. The customer has to decide how to handle the difference.
The import line 9 is accounted by a document no. which is given rudimentary in the reasons for transfer. The no. has been analyzed (review Pmt. Import Setup, Tab Auto Accounting II). The payment amount is <> than the invoice amount, because an existing credit note has been also set for application.
The import line 12 is status "Open". The system wasn't able to account the line, because the customer no. has a leading zero mentioned. In that case, review Pmt. Import Setup, Tab Auto Accounting I, Skip Leading Zero. The setup is also for document numbers and account numbers, which contain a leading zero. After again importing the line, the systems finds the customer no.
The import line 13 is status "Open". The reasons for transfer is blank, not giving any document or customer no. Demo: Setup of a General Accounting Rule with the catchword mentioned in the description and application on a e.g. G/L account.
The import line 14 is status "to Complete". It is set to, when multiple entries have clearly been found (here according to the document numbers), but the payment amount <> than the invoice amount is. This requires that the option "Complete if there is a difference" is set in the "Auto Application" tab of the import setup. In the application mask the customer has to decide how to procede with the difference.
The import line 15 has been accounted via the customer number (see payment import line on the Details tab). The document number specified in the reasons for transfer does not exist. Demo: E.g. in the Extended Application, clear a partial payment via "Process".
The import line 16 has been accounted via the document no. The payment amount doesn't match the invoice amount. Demo: Apply the balance in the Extended Application with "Process/Balance Application". The balance will be posted as a payment discount. In this szenario the field "Pmt. Discount Tolerance Amount" in the Ext. Features Setup is necessary and should be maintained.
Delete Transaction Data
As already described above, you are able to delete the transaction data which has been used for a presentation by setting the checkbox "Delete transaction data" in the report "OPP Build Demodata".
5157810_02: Endcustomer data demo
Throughout this checkbox you can import previously exported data of your end customer into the current database.
Export of customer data
We provide you with the reports required for the export for different NAV versions in a zip file as fob and txt:
Create Customer Data:
- Open the NAV/ BC database of the customer
- Import the report 85000 of the corresponding version
- If necessary renummerize the report 85000
Download the data:
- Give a download folder for NAV 2009 or earlier
- Choose to anonymize the data or not
- Start the export
Confirm the Message
It will be exported:
- All open entries of customers and vendors
- All corresponding names of customers and vendors as clear names or anonymized
- All associated customer and vendor bank accounts
- All bank accounts
Import into the current database
- Switch to the current BC database
- Choose OPplus – General – Object Run:
- Run the report 5157991 OPP Build Demodata DEMO:
- Choose the demo mode and test 5157810_02 Endcustomer data demo. Click OK:
- Following will be created:
- Customer- and vendor accounts
- Bank accounts of customers and vendors
- Bank accounts
- Open entries will be copied in a General Journal
- Post the General Journal
Import of a current bank statement
- Import a bank statement of your customer
- Set up the Pmt. Import Interface
- Import the bank statement again
- Switch to the Ext. Cash Receipt Jounal
- Show the functionalities of OPpplus with the customer data.