Print manual  

 NVXBMD BMD


Manuel Interface to BMD.
Current Version: 1.0.38.0 as of Business Central 16.

Manual


Creation date: 2024/05/07
The current version of this manual can be found at:

https://www.navax.app/help.php?AppID=NVXBMD&L=en


☰ Contents



General

  • App BMD
    Contains the general description of the app in 2 - 3 sentences...

Setup

  • BMD Setup
    The basic parameters for data exchange with BMD are defined with the help of the Setup menu item...
  • Vat Posting Setup
    In the VAT Posting Setup, each combination of VAT Bus. Posting Group and VAT Prod. Posting Goup it have to be defined how this tax information is to be transferred to BMD when exporting the G/L items...
  • Country/Region to Cession Note
    In this table you define the standard cession indicators for different countries...
  • Payment Terms
    In the payment terms table, you can define for each payment term code which code should be used for the dunning block in BMD. This can be used for credit card payments, cash payments, etc., for example...
  • Customer Posting Groups
    A separate clientele for BMD can be specified for a customer posting group...
  • Vendor Posting Groups
    You can specify a own clientele for BMD for a Vendor Posting Group...

Tasks

  • Working with the App
    As explained in General, three core functions can be performed using the BMD interface...
  • BMD Menue Card
    Aus dem BMD Menü können alle BMD relevanten Einrichtungen, Aktionen und Daten aufgerufen werden...
  • BMD Customer/Vendor List
    The master data provided for the export can be viewed on the BMD debtors/creditors overview page...
  • BMD Update Customer/Vendor Data
    This function can be used to propose master records for export. It is also possible not only to provide master data that has changed since the last export, but also any data...
  • BMD Posting List
    The BMD Entries Overview page can be used to view the entries made available for export...
  • BMD Provide Postings
    The entries to be exported are transferred to the BMD Postings List using the provide postings function...
  • BMD Import Wage Data
    With this function, a payroll file provided by BMD can be imported into a BC general journal. The journal can then be edited and/or posted...
  • BMD Log List
    All imports and exports are managed with this mask and .csv files can be exported. Individual entries can be processed here...

Appendix

  • Release Notes

Docs  /  NVXBMD BMD  /  General
General

Contains the general description of the app in 2 - 3 sentences.

Docs  /  NVXBMD BMD  /  General
General

The BC BMD interface was developed for customers who map their business processes with Microsoft Business Central, but handle financial accounting via BMD. A frequently seen usage scenario is that customers need the BMD interface to work with tax advisors. BMD is a common program in the field of financial accounting. BC's financial accounting includes the booking of incoming and outgoing documents (purchase and sales invoices/credit memos) and the processing of payment transactions. The BC BMD interface includes three core functions:
  • On the one hand, customer and vendor master data can be exported from BC to transfer changes in BC to BMD.
  • Secondly, all G/L entries can be exported for a defined period of time. For example, if a personal account is involved in the posting record, this information is also taken into account. The payment postings are also assigned to the respective personal account, but there is no automatic linking with open items on the BMD side. However, the G/L entries to be exported can also be filtered if, for example, the payment transactions are made in BMD and only items from sales and/or Purchasing documents (invoices, credit memos) are to be handed over.
  • Lastly, the BC BMD interface includes the option of importing wage data from the BMD to BC.

Docs  /  NVXBMD BMD  /  Setup
BMD Setup

The basic parameters for data exchange with BMD are defined with the help of the Setup menu item.

General, Fields
Show WageData MenueSpecifies the value of the Show WageData Menue field.
Dimension Code Cost CenterSpecifies the value of the Dimension Code Cost Center field.
Dimension Code Cost UnitSpecifies the value of the Dimension Code Cost Unit field.
Autom. Update BMD Customer/Vendor DataSpecifies if the Customer/Vendor table for BMD Export should be updated automatically at change of base data.
Dflt. Cust. Cession NoteSpecifies the default cession note code for the customer. These cession notes can be overwritten by the countries/regions.
Dflt. Vend. Cession NoteSpecifies the default cession note code for the vendor. These cession notes can be overwritten by the countries/regions.

Docs  /  NVXBMD BMD  /  Setup
VAT Posting Setup

In the VAT Posting Setup, each combination of VAT Bus. Posting Group and VAT Prod. Posting Goup it have to be defined how this tax information is to be transferred to BMD when exporting the G/L items.

Fields
BMD Tax Code for SalesSpecifies the tax code for sales. This value will be used for the entry export to BMD.
BMD Tax Code for PurchaseSpecifies the tax code for purchase. This value will be used for the entry export to BMD.

Docs  /  NVXBMD BMD  /  Setup
Country/Region to Cession Note

In this table you define the standard cession indicators for different countries.

Fields
Country/Region CodeSpecifies the code for the country/region.
Customer Cession NoteSpecifies the code for the cession note of customers from this country.
Vendor Cession NoteSpecifies the code for the cession note of vendors from this country.

Docs  /  NVXBMD BMD  /  Setup
Payment Terms

In the payment terms table, you can define for each payment term code which code should be used for the dunning block in BMD. This can be used for credit card payments, cash payments, etc., for example.

Fields
On Hold BMDSpecifies the default value for on hold for a sales document. This field is used to define the on hold value for the bmd interface.

Docs  /  NVXBMD BMD  /  Setup
Customer Posting Groups

A separate clientele for BMD can be specified for a customer posting group.

Fields
Clientele BMDSpecifies the BMD clientele. The account group to which the account is assigned is stored in the customer or supplier group number field. The customers are divided into groups under FIBU - master data - account groups. By default (company 100 standard account framework) there are three customer groups - it can be e.g. For example, a subdivision into domestic, EU and foreign countries can be made. Which account falls into which group is determined in the number groups. The deposits in the fixed accounts decide which group is posted to which collective account. If no suitable account range or number range can be determined, you will receive a corresponding message in the logs.

Docs  /  NVXBMD BMD  /  Setup
Vendor Posting Group

You can specify a own clientele for BMD for a Vendor Posting Group.

Fields
Clientele BMDSpecifies the BMD clientele. The account group to which the account is assigned is stored in the customer or supplier group number field. The customers are divided into groups under FIBU - master data - account groups. By default (company 100 standard account framework) there are three customer groups - it can be e.g. For example, a subdivision into domestic, EU and foreign countries can be made. Which account falls into which group is determined in the number groups. The deposits in the fixed accounts decide which group is posted to which collective account. If no suitable account range or number range can be determined, you will receive a corresponding message in the logs.

Docs  /  NVXBMD BMD  /  Tasks
Working with the App

As explained in General, three core functions can be performed using the BMD interface.

Docs  /  NVXBMD BMD  /  Tasks
Export workflow master data from BC

  1. Open BMD menu
  2. Overview
    • Accounts Receivable/Accounts Payable
      • Enable edit list
      • The BDM debtor/vendor overview is updated automatically. If a vendor or customer is missing, they can be added manually by selecting the three dots on the right side of the tab.
      • Set filter criteria (optional)
      • Check list for completeness
  3. Back to the BMD menu
    • Export
      • Master data

Docs  /  NVXBMD BMD  /  Tasks
Workflow export of G/L entries

  1. Open BMD menu
  2. Overview
    • Entries
      • Enable edit list
      • Set filter criteria (optional)
      • Check list for completeness
      • Select actions
        • Select BMD Provide Postings
          • Fill mask
          • Click OK
    • Back to the BMD menu
      • Export
        • Entries

Docs  /  NVXBMD BMD  /  Tasks
BMD Menü

Aus dem BMD Menü können alle BMD relevanten Einrichtungen, Aktionen und Daten aufgerufen werden.

Actions

  • Einrichtung

    • Einrichtung

      Öffne die BMD Einrichtung.

    • Länder/Region Zessionskennz.

      Öffne die Länder/Region Zessionskennz.

    • MwSt. Buchungsmatrix Einrichtung

      Zeigt Kombinationen aus MwSt.-Geschäftsbuchungsgruppen und MwSt.-Produktbuchungsgruppen an oder bearbeitet sie. Füllt für jede Kombination aus MwSt.-Geschäftsbuchungsgruppe und MwSt.-Produktbuchungsgruppe eine Zeile aus.

    • Zahlungsbedingungen

      Richtet die Zahlungsbedingungen ein, die Sie auf Debitorenkarten auswählen, um die Zahlungsfrist für den Debitor (z. B. innerhalb von 14 Tagen) festzulegen.

    • Debitorenbuchungsgruppen

      Richten Sie Buchungsgruppen ein, die Sie beim Einrichten von Debitorenkarten auswählen können, um Geschäftstransaktionen für den Debitor mit dem entsprechenden Konto in der Finanzbuchhaltung zu verknüpfen.

    • Kreditorenbuchungsgruppen

      Richten Sie Buchungsgruppen ein, die Sie beim Einrichten von Kreditorenkarten auswählen können, um Geschäftstransaktionen für den Kreditor mit dem entsprechenden Konto in der Finanzbuchhaltung zu verknüpfen.

  • Übsersicht

    • Posten

      Öffne die Posten welche nach BMD Exportiert werden sollen.

    • Debitoren/Kreditoren

      Öffne die Debitoren und Kreditoren Daten welche nach BMD exportiert werden sollen.

  • Import

  • Export

    • Stammdaten

      Exportiere die Daten welche in der Debitoren/Kreditoren Seite angezeigt werden.

    • Posten

      Exportiere die Daten welche in der Posten Seite angezeigt werden.

  • Historie

    • Log

      Öffne das BMD Log.
----

Docs  /  NVXBMD BMD  /  Tasks
BMD Menu

All BMD-relevant setups, actions and data can be called up from the BMD menu.

Actions

  • Setup

    • Setup

      Open the BMD setup.

    • Country/Region Cession Note

      Open the Country/Region Cession Notes.

    • VAT Posting Setup

      View or edit combinations of Tax business posting groups and Tax product posting groups.

    • Payment Terms

      Set up the payment terms that you select from on customer cards to define when the customer must pay, such as within 14 days.

    • Customer Posting Groups

      Set up the posting groups to select from when you set up customer cards to link business transactions made for the customer with the appropriate account in the general ledger.

    • Vendor Posting Groups

      Set up the posting groups to select from when you set up vendor cards to link business transactions made for the vendor with the appropriate account in the general ledger.

  • List

    • Entries

      Open the entries which should be exported to BMD.

    • Customer/Vendor

      Open the customer and vendor data which should be exported to BMD.

  • Import

  • Export

    • Master data

      Export the data shown in the Customer/Vendor page.

    • Entries

      Export the data shown in the Entries page.

  • History

    • Log

      Open the BMD log.

Docs  /  NVXBMD BMD  /  Tasks
BMD Customer/Vendor List

The master data provided for the export can be viewed on the BMD debtors/creditors overview page. This list can be filled automatically with every change to the customer and vendor master data or manually via an action. Whether this list is filled automatically can be set in the BMD setup.

Fields
CustomerVendorIDSpecifies the Cust. Vendor Indicator.
Account No.Specifies the Account No..
BMD account no.Specifies the BMD Account No.
NameSpecifies the Name.
MatchcodeSpecifies the Matchcode.
TitleSpecifies the Title.
BranchSpecifies the Branch.
StreetSpecifies the Street.
Post CodeSpecifies the Post Code.
CitySpecifies the City.
PO BoxSpecifies the PO Box.
PO Box Post CodeSpecifies the PO Box Post Code.
Street IndicatorSpecifies the Street Indicator.
Contact PersonSpecifies the Contact Person.
Phone No.Specifies the Phone No.".
Fax No.Specifies the Fax No../td>
E-MailSpecifies the E-Mail.
Home PageSpecifies the Home Page.
Bank Account No.Specifies the Bank Account No..
Bank Branch No.Specifies the Bank Branch No..
SWIFT CodeSpecifies the SWIFT Code.
Bank Country CodeSpecifies the Bank Country Code.
VAT Registration No.Specifies the VAT Registration No..
Cession NoteSpecifies the code for the cession note.
Due DaysSpecifies the Due Days.
Discount %Specifies the Discount %.
Discount 1 DaysSpecifies the Discount Days.
Discount 2 %Specifies the Discount 2 %
Discount 2 DaysSpecifies the Discount 2 Days
Condition 2Specifies the Condition 2.
Tolerance %Specifies the Tolerance %.
Reminder blockSpecifies the Reminder block.
Reminder costsSpecifies the Reminder costs.
Reminder Posting IndicatorSpecifies the Reminder Posting Indicator.
Reminder DateSpecifies the Reminder Date.
Reminder FormSpecifies the Reminder Form.
Credit RatingSpecifies the Credit Rating.
Offsetting AccountSpecifies the Offsetting Account.
Miscellaneous CodeSpecifies the Miscellaneous Code.
KKreisSpecifies the KKreis.
Payables/Receivables AccountSpecifies the Payables/Receivables Account.
Invoice AccountSpecifies the Invoice Account.
VAT Registration DateSpecifies the VAT Registration Date.
Company SalutationSpecifies the Company Salutation.
Personal SalutationSpecifies the Personal Salutation.
For the attention SalutationSpecifies the For the attention Salutation.
Letter SalutationSpecifies the Letter Salutation.
Agent 1Specifies the Agent 1.
Agent 2Specifies the Agent 2.
Shipping MethodSpecifies the Shipping Method.
Sales AreaSpecifies the Sales Area.
Chain of StoresSpecifies the Chain of Stores.
Distance kmSpecifies the Distance km.
Deduction CodeSpecifies the Deduction Code.
Decuction %Specifies the Decuction %.
Order BacklogSpecifies the Order Backlog.
Credit LimitSpecifies the Credit Limit.
Posting blockSpecifies the Posting block.
Deletion FlagSpecifies the Deletion Flag.
CControl FlagSpecifies the Control Flag.
StateSpecifies the State.
IBANSpecifies the IBAN.
DateSpecifies the Date.
Payment blockSpecifies the Payment block.
Payment ExpensesSpecifies the Payment Expenses.
Reason for PaymentSpecifies the Reason for Payment.
ZahlumsatzposSpecifies the Zahlumsatzpos.
Payment Transfer TypeSpecifies the Payment Transfer Type.
Payment BankSpecifies the Payment Bank.
Direct DebitSpecifies the Direct Debit.
External Account No.Specifies the External Account No..
ForeignerSpecifies the Foreigner.
No TaxSpecifies the No Tax.
Reminder StatementSpecifies the Reminder Statement.
Branch IndicatorSpecifies the Branch Indicator.
Bills of ExchangeSpecifies the Bills of Exchange.
State No.Specifies the State No..
Fipkurz ZahlmodusSpecifies the Fipkurz Zahlmodus.
Place Holder 1Specifies the Place Holder 1.
Place Holder 2Specifies the Place Holder 2.
Second CurrencySpecifies the Second Currency.
Varcode 2Specifies the Varcode 2.
FCY CodeSpecifies the FCY Code.
Country CodeSpecifies the Country Code.
Opening Balance Acc.Specifies the Opening Balance Acc..
Opening Balance IndicatorSpecifies the Opening Balance Indicator.
FirstnameSpecifies the First Name.
Name 2Specifies the Name 2.
ProfessionSpecifies the Profession.
LanguageSpecifies the Language

Actions

  • Update Vendor/Customer Data

    Executes the Update Vendor/Customer Data action.
With the system-internal functions Edit List and Delete, this data can still be edited manually before the export. With the system-internal functions Open in Excel or Edit in Excel, the data is transferred to Excel and is available there for viewing or editing.

Docs  /  NVXBMD BMD  /  Tasks
BMD Update Customer/Vendor Data

This function can be used to propose master records for export. It is also possible not only to provide master data that has changed since the last export, but also any data.

Options
Process CustomersSpecifies whether the customers should be processed.
Process VendorsSpecifies whether the vendors should be processed.
By activating the options Process Customers or Process Vendors you can define whether customers and/or vendors should be made available.

Filter
Customers
Vendors
Here you can filter according to one or more parameters. Such as: "Modifeid At" Here you can filter that only master data with a change after a certain date should be provided.

Docs  /  NVXBMD BMD  /  Tasks
BMD Posting List

The BMD Entries Overview page can be used to view the entries made available for export. With the Edit list and Delete functions, data can still be changed manually before the export.

Fields
G/L Entry Lfd. Nr.Specifies the entry number of the G/L Entry.
Transaction No.Specifies the transaction number of the G/L Entry.
Record Typenum. 1 Stelle - 0 = FIBU-Buchungssätze (jeder Buchungstyp möglich (Rechnungen, Zahlungen) / SA 1 - 11 = Folgesatzarten
Account No.num. 10 Stellen - Führendes Konto der Buchung (Personen- oder Sachkonto)
BMD Kontonr.num. 10 Stellen - Führendes BMD Konto der Buchung (Personen- oder Sachkonto)
Bal. Account No.num. 10 Stellen - Gegenkonto (nur Sachkonto)
Posting Datealphanum. 10 Stellen - Buchungsdatum TT.MM.JJJJ
Document No.alphanum. 20 Stellen - Belegnummer
Document Datealphanum. 10 Stellen - Belegdatum TT.MM.JJJJ
VAT Codenum. 4 Stellen - USt. Steuercode lt. MwSt. Buchungsmatrix
VAT Percentnum. 3,3 Stellen - Steuerprozentsatz
Opening Balance Identificationnum. 1 Stelle - EB-Kennzeichen - (1 = EB Buchung)
Debit Credit Codenum. 2 Stellen - 1 = Sollbuchung / 2 = Habenbuchung
Amountnum. 15,2 Stellen - Buchungsbetrag - Brutto oder Netto - richtet sich nach dem führenden Konto - bei Buchcode 1 immer pos. ausser bei Gutschrift
Amount Dec.Specifies the amount as a decimal value.
Currency CodeSpecifies the iso currency code.
VAT Amountnum. 15,2 Stellen - Steuerbetrag - VZ richtet sich nach Steuerart bzw. ob Steuer im Soll oder Haben geb. wird (Umsatzst.: Minus / Vorst. Plus / Erwebsst.: Soll u. Haben Minus)
VAT Amount Dec.Gibt den MwSt. Betrag als Dezimalwert an.
FCY AmountSpecifies the amount in foreign currency.
FCY Discount AmountSpecifies the discount amount in foreign currency.
FCY FactorSpecifies foreign currency factor.
FCY VAT AmountSpecifies the vat amount in foreign currency.
FCY Remaining AmountSpecifies the remaingin amount in foreign currency.
Posting Periodnum. 2 Stellen - Buchungsperiode (dient der Periodenzuordnung bei Saldenlisten und bei der Umsatzsteuer - wenn abweichend vom Belegdatum)
Posting Descriptionalphanum. 255 Stellen - Buchungstext
Posting Symbolalphanum. 4 Stellen - z.B. AR, ER, BK, EB, ... (lt. Anlage in BMD)
External Document No.alphanum. 60 Stellen - Externe Belegnummer
Due Daysnum. 6 Stellen - Zahlungsziel in Tagen (vom Valuta oder Belegdatum)
Due Datealphanum. 10 Stellen - Nettofälligkeitsdatum TT.MM.JJJJ
Discount Percentnum. 4,2 Stellen - Skontoprozentsatz
Discount Amount manuallynum. 15,2 - Skontobetrag - Skontobetrag der Buchung mit umgekehrtem Vorzeichen im Vergleich zum Buchungsbetrag
Discount Daysnum. 4 Stellen - Skototage (vom Valuta oder Belegdatum)
Discount Datealphanum. 10 Stellen - Skontodatum TT.MM.JJJJ
Value Datealphanum. 10 Stellen - Valutadatum TT.MM.JJJJ
Posting Period Typenum. 5 Stellen - Buchungsart - (1001 lfd. Periodenbuchung / 2001 Bilanzbuchung / 3001 EB-Buchung)
VAT Registration No.alphanum. 20 Stellen - UID-Nr. des Kunden oder Lieferanten - kann mit "-" oder "KEINEUID" als leer übergeben werden
Payment Referencealphanum. 30 Stellen - ZV-Kundendaten werden in ZV-Zahlungsreferenz übernommen
Credit Memo Indicatornum. 1 Stelle - Gutschrift/Storno KZ - 1=Gutschrift / 2 = Storno
Posting Typenum. 1 Stelle - Buchungstyp - (1=Rechnung, 2=Zahlung) wird normalerweise vom Buchungssymbol gezogen, nur wenn dort nicht definiert oder abweichend, sonst nicht nötig
Cost Acc. Cost CenterSpecifies the cost center.
Cost Acc. Cost UnitSpecifies the cost unit.
Direct DebitSpecifies if the transaction was a direct debit payment method.

Actions

  • Provide Postings

    Creates the list for postings to be exported.

  • ResetBMDExportEntryNo

    Reset Field BMD Export Entry No. in G/L Entries.
Data can be transferred to Excel using the system-internal functions Open in Excel or Edit in Excel. The data is then available in Excel for viewing or editing.

Docs  /  NVXBMD BMD  /  Tasks
BMD Provide Postings

The entries to be exported are transferred to the BMD Postings List using the provide postings function.

Options
Balance Account No.Entering an "Balance Account No." is necessary if not only entries with a connection to a personal account are to be exported (purchase/sales invoices, credit notes, payments from customers or vendors) but also pure G/L Entries.All G/L Entries are applied against this account. The balance on this account is back to 0 after each complete posting record.The account is necessary for interface-technical reasons.
Incl. already exported entriesSpecifies if already exported entries should be included.

Filter
G/L EntriesYou can filter by one or more parameters here. Such as: Posting Date. This allows the period of time for the items to be provided for the export to be defined

Docs  /  NVXBMD BMD  /  Tasks
BMD Import Wage Data

With this function, a payroll file provided by BMD can be imported into a BC general journal. The journal can then be edited and/or posted.

Options
Gen. Journal TemplateSpecifies the general journal template name where the journal lines should be inserted.
Gen. Journal BatchSpecifies the general journal batch name where the journal lines should be inserted.
Dimension 2 CodeSpecifies the global dimension 2 code which should be used in the journal lines.
Document No.Specifies the document number given to the created journal lines.

Docs  /  NVXBMD BMD  /  Tasks
BMD Log List

All imports and exports are managed with this mask and .csv files can be exported. Individual entries can be processed here.

Fields
Entry No.Specifies the number of the entry.
DirectionSpecifies the direction of the entry.
LogTypSpecifies the type of the entry.
Import/Export Date TimeSpecifies the date and time when the entry was created.
Import/Export FileSpecifies the filename to which the file was written or from which it was imported.
LogstatusSpecifies the status of the entry.
User IDSpecifies the user id which created this entry.

Actions

  • Export

    Export the log.

Docs  /  NVXBMD BMD  /  Appendix
Release Notes

Would you like to know what has changed in the extension?
Below you'll find an overview of the new features and changes made in the updates. Build-Overview in DevOps

NVXBMD 1.0.39.0

  • Corrections

    • no more locking of customer or vendor when creating export table trough report "BMD Update Customer/Vendor Data"

NVXBMD 1.0.38.0

as of Business Central 16
2023/05/26

  • Corrections

    • add BMD Menu actions with visible false for in development compatibility

NVXBMD 1.0.37.0

  • Initial Version

  Print manual  
DE|EN Imprint