Plugin: BX Service DATEV

From iDempiere en

Description

The BX Service DATEV interface is designed as a new accounting schema that creates its own postings to report to DATEV.

Configuration

Accounting Schema and Dimensions

To use the plugin you must configure an Accounting Schema with:

  • GAAP = DATEV (BXService Implementation)
  • Allow Negative Posting = No

And the plugin use the dimensions:

  • Organization
  • Account
  • Product
  • Business Partner

01 DATEV AcctSchema.png

Customer Accounting

The plugin requires the configuration of the Customer Receivables account in Business Partner window.

02 DATEV CustomerAcct.png

Vendor Accounting

The plugin requires the configuration of the Vendor Liability account in Business Partner window.

03 DATEV VendorAcct.png

Product Accounting

The plugin requires the configuration of the Product Revenue and Product Expense accounts in Product window.

04 DATEV ProductAcct.png

Charge Accounting

When charges are used in invoice lines, then the plugin requires the configuration of the Charge Account in Charge window.

05 DATEV ChargeAcct.png

Bank Accounting

The plugin requires the configuration of the Bank Asset account in Bank/Cash window.

06 DATEV BankAcct.png

Usage

The usage is simply posting as any other accounting schema.

For example as usual:

Postings

The plugin generates the following postings for Invoices and Allocations (the other documents don't generate any posting on the DATEV schema):

Document DR/CR Account AmtAcctDr AmtAcctCr Tax ID
Invoice Customer DR Customer Receivable Line Amount without Tax Invoice Line Tax
CR Product Revenue or Charge Account Line Amount without Tax Invoice Line Tax
Customer Credit Note DR Product Revenue or Charge Account Line Amount without Tax Invoice Line Tax
CR Customer Receivable Line Amount without Tax Invoice Line Tax
Vendor Invoice DR Product Expense or Charge Account Line Amount without Tax Invoice Line Tax
CR Vendor Liability Line Amount without Tax Invoice Line Tax
Vendor Credit Note DR Vendor Liability Line Amount without Tax Invoice Line Tax
CR Product Expense or Charge Account Line Amount without Tax Invoice Line Tax
Customer Payment Allocation DR Customer Receivable Payment Amount plus Discount and WriteOff Discount + WriteOff Tax from one of the invoice lines
CR Bank Asset Payment Amount Tax from one of the invoice lines
Vendor Payment Allocation DR Vendor Liability Payment Amount plus Discount and WriteOff Discount + WriteOff Tax from one of the invoice lines
CR Bank Asset Payment Amount Tax from one of the invoice lines

DATEV Export Window

After you have DATEV postings, you can analyze the data in the window DATEV Export, it is based on a view rv_bx_datev that summarizes every two records from accounting fact details into one line:

07 DATEV DATEVExport.png

Exporting to SSV

You can export the DATEV data to SSV (Semicolon separated values) format. For better results you must be logged in with German language:

08 DATEV SSVExport.png

DATEV Print Format

DATEV is very flexible and can manage many different formats, the plugin includes a basic format as a template for reporting:

09 DATEV Format.png

Cookies help us deliver our services. By using our services, you agree to our use of cookies.