Cash Discount in D365

Cash Discount

1.                Go to Accounts payable > Invoices > Invoice journal.

2.                Click New.

3.                In the list, mark the selected row.

4.                In the Name field, enter or select a value.

5.                In the list, click the link in the selected row.

6.                Click Lines.

7.                Click New.

8.                In the list, mark the selected row.

 

 

9.                In the Account field, specify the desired values.

10.             In the list, mark the selected row.

11.             In the Invoice date field, enter a date.

12.             In the Invoice field, type a value.

13.             In the Credit field, enter a number.

14.             In the Offset account type field, select an option.

15.             In the Offset account field, specify the desired values.

16.             Click the Invoice tab.

17.             In the Approved by field, enter or select a value.

18.             Click Select.

19.             Click the Project tab.

20.             In the Category field, enter or select a value.

 

21.             In the list, select row 4.

22.             In the list, click the link in the selected row.

23.             In the Activity number field, enter or select a value.

24.             In the list, select row 9.

25.             In the list, click the link in the selected row.

26.             Click the Cash discount tab.

27.             Click Add.

28.             In the list, mark the selected row.

29.             In the Cash discount date field, enter a date.

30.             In the Cash discount amount field, enter a number.

31.             Click the List tab.

32.             Click Post.

33.             Click Print.

34.             Click Print.

35.             Click Journal.

36.             Click OK.

37.             Close the page.

38.             Close the page.

 

39.             Go to Accounts payable > Payments > Vendor payment journal.

40.             Click New.

41.             In the Name field, type a value.

42.             Click Lines.

43.             In the list, mark the selected row.

44.             In the Date field, enter a date.

45.             In the Account field, specify the desired values.

46.             Click Settle transactions.

47.             In the list, find and select the desired record.

48.             Select the Mark check box.

49.             Click OK.

50.             In the list, mark the selected row.

51.             In the list, unmark the selected row.

52.             In the Offset account field, specify the desired values.

53.             In the list, mark the selected row.

54.             In the Method of payment field, enter or select a value.

55.             In the list, click the link in the selected row.

56.             Click Generate payments.

57.             In the Method of payment field, type a value.

58.             In the Bank account field, enter or select a value.

59.             In the list, click the link in the selected row.

60.             Click OK.

61.             Click OK.

62.             Click Post.

63.             Click Print.

 

64.             Click Posted transactions by Journal.

 

65.             Click OK.

66.             Close the page.

 

Test the bank statement import in Dynamic 365

Part-2

In the first part, I showed how to configure the BAI2. Now we test the Import Process

The final step is to test that you can import your bank statement.

1. Go to Cash and bank management > Bank accounts.
2. Select the bank account that Advanced bank reconciliation functionality is enabled for.
3. On the Reconcile tab, click Bank statements.
4. On the Bank statement page, click Import statement.
5. Set the Bank account field to the selected bank account. The Statement format field will be set automatically, based on the setting on the bank account.
6. Click Browse, and select your electronic bank statement file.
7. Click Upload.
8. Click OK.

If the import is successful, you will receive a message that states that your statement was imported. If the import wasn't successful, in the Data management workspace, in the Job History section, find the job. Click Execution details for the job to open the Execution summary page, and then click View execution log to view the import errors.