BeyondERP.Newsletter
Menu

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

Track import letters of credit

Use this page to follow purchases secured by an import letter of credit, from confirmation to payment, and to print the application.

Used by
Accounts payable clerk, Accounts payable manager, Chief financial officer and 7 more roles
Business process
Procure goods and services
Menu item
BankLCImportGridView
Main table
BankLCImport
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 import letters of credit and import collections, where the company is the buyer.
What you do hereUse this page to follow the status of purchases secured by a letter of credit and to print the letter of credit application.
ExampleFor example, after the vendor invoice is paid, the lines show the import letter of credit status Confirmed and the shipment status Paid.
Import 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 import letters of credit

Use this page to follow purchases secured by an import letter of credit, from confirmation to payment, and to print the application.

Steps from Microsoft

  1. Create a purchase order whose Bank document type is Letter of credit.
  2. On the purchase order, select Manage > Letter of credit / import collection and enter the Application date, Bank document number and Expiration date.
  3. Select the Advising bank and save.
  4. On the lines, select Fetch purchase order shipments.
  5. Confirm the purchase order, and then select Process > Confirm on the letter of credit.
  6. Post the product receipt and the vendor invoice.
  7. Go to Cash and bank management > Letters of credit > Import letter of credit and import collection to check the status.
  8. Select View > Print application to print the letter of credit.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Advising bankThe bank that carries out the transaction on behalf of the applicant.Microsoft Learn ImportAdvisingBank
Shipment statusWhere each shipment is in the process, such as Invoiced or Paid.Microsoft Learn
Bank document numberThe letter of credit number, entered on the purchase order's letter of credit.Microsoft Learn
Import letter of credit statusWhether the letter of credit is confirmed; it must be confirmed again after an amendment.Microsoft Learn Confirmed
Expiration dateThe date after which the bank won't pay under the letter of credit.Microsoft Learn

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 facility balance didn't change after the purchase price was changedAmend the letter of credit (Process > Amend), remove and fetch the purchase order shipments again, then confirm it; the facility balance then reflects the new amount (600.00 on a 10,000.00 limit leaves 9,400.00). Microsoft Learn

Test checklist

  1. Create a purchase order with Bank document type Letter of credit, enter the application date, bank document number, expiration date and advising bank, and fetch the shipments.
  2. Confirm the purchase order and the letter of credit; check that the facility balance dropped by the order amount (500.00 on a 10,000.00 limit leaves 9,500.00).
  3. Post the product receipt and vendor invoice; check Shipment status Invoiced, then print the application.
  4. Pay the invoice in the vendor payment journal; check Import letter of credit status Confirmed and Shipment status Paid.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Track import letters of creditConfirm the letter of credit only after the purchase order is confirmed, and amend and confirm it again whenever the order amount changes.The confirmed letter of credit reduces the facility balance by the purchase amount; Learn shows the balance following each confirmation.Which purchases need an import letter of credit?Changing the purchase price without amending the letter of credit: the facility balance still shows the old amount.Test: Confirming the letter of credit uses the facility

Feature management and licence

Licence or add-inIn this system 11 roles can open this page, among them Chief financial officer, Accounting manager, Financial controller and Accounts payable payments clerk.

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 undoneAmend: A confirmed letter of credit is changed with Amend and confirmed again.
If you change it laterIf the purchase order price changes after confirmation, the letter of credit must be amended and confirmed again so that the facility balance is updated. Microsoft Learn
Technical architect

6Technical

Menu itemBankLCImportGridView Checked in Dynamics 365
FormBankLCImport Checked in Dynamics 365
TableBankLCImportShown as “Letter of credit / import collection import table” in Record infoKey field: PurchTableChecked in Dynamics 365
Who can open itPrivilegesMaintain letter of credit information BankLCImportMaintainView letter of credit information BankLCImportViewDutiesInquire into import letter of credit BankImportLetterOfCreditInquireMaintain import letter of credit BankImportLetterOfCreditMaintain
11 security rolesChief financial officer CompanyChiefFinancialOfficerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialController MCRTestUserRoleAccounts payable payments clerk PaymAccountsPayablePaymentsClerkTreasurer PaymTreasurerBuying agent TradeBuyingAgentPurchasing manager TradePurchasingManagerSales clerk TradeSalesClerkAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itTreasurer PaymTreasurerAccounts payable manager VendInvoiceAccountsPayableManagerAccounts payable clerk VendInvoiceAccountsPayableClerkTo use itChief financial officer CompanyChiefFinancialOfficerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAccounts payable payments clerk PaymAccountsPayablePaymentsClerkPurchasing manager TradePurchasingManagerGive people one of these roles. On this system, 10 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=BankLCImportGridView
Data migrationLoad order: An import letter of credit has no data entity in Data management, so it can't be loaded from a file or a configuration template. Open import letters of credit are entered again on the open purchase orders in the new environment, after facilities, posting profiles and the facility agreement exist.Microsoft Learn
Table definitionBankLCImport columns and relations Microsoft data model
Everyone

8Sources