BeyondERP.Newsletter
Menu

Setup step on the Export letter of credit and import collection page · Cash and bank management

Track export letters of credit

Use this page to follow each export letter of credit from shipment to payment received.

Used by
Chief financial officer, Accounts receivable clerk, Accounts receivable manager and 5 more roles
Business process
Create export letters of credit in Dynamics 365 Finance
Menu item
BankLCExportGridView
Main table
BankLCExport
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA list page where you track export letters of credit, where the company is the seller, together with their shipments.
What you do hereUse this page to follow the shipment status and balance of each export letter of credit through invoicing and payment.
ExampleFor example, after the customer pays the invoice, the export letter of credit shows the shipment status Payment received and a balance of 0.00.
Export letter of credit and import collection page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Track export letters of credit

Use this page to follow each export letter of credit from shipment to payment received.

Steps from Microsoft

  1. Create a sales order and set the Bank document type field to Letter of credit.
  2. On the sales order, select Manage > Letter of credit and enter the Bank document number and Expiration date.
  3. Select the Issuing bank and the Advising bank.
  4. On the lines, select Fetch sales order shipments, and then select Issue bank document.
  5. Post the packing slip and the sales invoice.
  6. Go to Cash and bank management > Letters of credit > Export letter of credit and import collection and check that the shipment status is Invoiced.
  7. Post the customer payment, settling the invoice, and check that the balance is 0.00.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Issuing bankThe customer's bank that issues the letter of credit.Microsoft Learn IssuingBank
Shipment statusWhere each shipment is in the process, such as Invoiced or Payment received.Microsoft Learn
Document submittedShows that the shipping documents were submitted.Microsoft Learn
Bank document numberThe letter of credit number from the issuing bank, entered on the sales order's letter of credit.Microsoft Learn
Advising bankThe bank that carries out the transaction for the applicant.Microsoft Learn
Balance amountWhat is still to be paid under the letter of credit; 0.00 after the customer payment is settled.Microsoft Learn 0.00

Common errors and fixes

MessageWhat to do
Letter of credit can't be selected as the bank document type on the orderTurn on Enable import letter of credit or Enable export letter of credit in the Bank document section of Cash and bank management parameters. Microsoft Learn
The shipment status stays Invoiced after the customer paidSettle the payment against the invoice in the customer payment journal and check that the Bank document number and Shipment number are filled on the Payment tab. Microsoft Learn

Test checklist

  1. Create a sales order with Bank document type Letter of credit, enter the bank document number, expiration date, issuing bank and advising bank, fetch the shipments and select Issue bank document.
  2. Post the packing slip and the invoice for the shipment; check that Document submitted is Yes and the shipment status is Invoiced on this page.
  3. Post the customer payment and mark the invoice with the bank document number and shipment number.
  4. Check that the shipment status is Payment received and the balance amount is 0.00.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Track export letters of creditEnter the letter of credit on the sales order before the first shipment, and settle each payment against the invoice with the bank document and shipment numbers filled.The shipment status and balance on this page are updated only from the shipment, invoice and settled payment that carry the letter of credit.Use letters of credit for export sales?Posting the customer payment without settling it against the invoice: the letter of credit keeps an open balance.Test: An export letter of credit reaches Payment received

Feature management and licence

Licence or add-inIn this system 8 roles can open this page, among them Chief financial officer, Accounts receivable clerk, Accounts receivable manager and Accounting manager.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneFollows the sales order: Corrections are made on the sales order, its invoice and payment.
If you change it laterThe export letter of credit follows the sales order: shipments, invoices and the settled customer payment update its shipment status and balance. Import and export letters of credit are turned on per legal entity in the Bank document section of Cash and bank management parameters (Enable import letter of credit, Enable export letter of credit). Microsoft Learn
Technical architect

6Technical

Menu itemBankLCExportGridView Checked in Dynamics 365
FormBankLCExport Checked in Dynamics 365
TableBankLCExportShown as “Letter of credit / import collection export table” in Record infoKey field: SalesTableChecked in Dynamics 365
Who can open itPrivilegesExport letters of credit BankLCExportMaintainView letters of credit BankLCExportViewDutiesInquire into export letter of credit BankExportLetterOfCreditInquireMaintain export letter of credit BankExportLetterOfCreditMaintain
8 security rolesChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkTreasurer PaymTreasurerSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itTreasurer PaymTreasurerAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkTo use itChief financial officer CompanyChiefFinancialOfficerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkSales manager TradeSalesManagerGive people one of these roles. On this system, 8 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=BankLCExportGridView
Data migrationLoad order: An export letter of credit has no data entity in Data management, so it can't be loaded from a file or a configuration template. Open export letters of credit are entered again on the open sales orders in the new environment (Manage > Letter of credit), after the parameters are set.Microsoft Learn
Table definitionBankLCExport columns and relations Microsoft data model
Everyone

8Sources