1C:Enterprise (OData) and Lexware Office Integration
Demonstration of how apps are integrated in WEXTL workflow builder[4]
Connect 1C:Enterprise (OData) and Lexware Office to automate finance workflows. Trigger events from one app, run actions in the other and use AI to make smart decisions. Integrate apps in 3 simple steps - no code required.
- 3-day trial
- Cancel anytime
- Up to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about 1C:Enterprise (OData) and Lexware Office
Detailed info you need to know about 1C:Enterprise (OData) and Lexware Office integrations in WEXTL. Explore which modules apps support and how you connect them.
1C:Enterprise (OData)

Business management platform for accounting, trade, and manufacturing.[5]
Lexware Office

Cloud bookkeeping and invoicing software for small businesses in Germany.[6]
How to connect 1C:Enterprise (OData) to Lexware Office
Set up your 1C:Enterprise (OData) and Lexware Office integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect 1C:Enterprise (OData) and Lexware Office
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow[3]. No coding or API skills required.
STEP 2
Build a workflow
Paste selected 1C:Enterprise (OData) and Lexware Office nodes onto the canvas[4], or describe what you want and WEXTL wires the flow together with AI Builder.
STEP 3
Map your data
Choose which fields need to sync between 1C:Enterprise (OData) and Lexware Office. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between 1C:Enterprise (OData) and Lexware Office work in WEXTL?
WEXTL exposes actions and triggers for 1C:Enterprise (OData) and Lexware Office that help you connect apps and automate repetitive tasks[1]. A trigger is an event that happens, and an action is a step that performs when the event has occurred.
1C:Enterprise (OData) triggersLexware Office actions
1C:Enterprise (OData) modules
- Call an HTTP Service Reaches an HTTP service defined in your 1C configuration. Use Body Type with Body to send data in the format your service expects. Output includes Headers and Body.
- Cancel a Document Posting Reverses posting for a document in 1C. Use Operational Mode to cancel in operational mode, or leave it blank for your configuration default.
- Complete a Task Marks a task as completed in 1C and returns Completed with its Record Key.
- Confirm Exchange Plan Changes Tells 1C that an exchange plan message arrived at a node, using the Message Number you received from Get Exchange Plan Changes. Output includes Confirmed.
- Count Records Counts the records in an object list in 1C and returns the Count. Use Filter with an OData expression to count only matching records.
- Create a Business Process Creates a business process record in 1C. Output includes the Number and Date. Use Additional Fields for values that are not listed.
- Create a Calculation Type Registers a calculation type in a chart of calculation types, returning its Code and Description. Use Exchange Load Mode to skip the write-time handlers in 1C.
- Create a Catalog Item Saves an item into a catalog in 1C. Use Data Load Mode to save it the way a data exchange does, skipping the usual save checks, and Additional Fields for unlisted fields.
- Create a Characteristic Type Defines a characteristic type in a chart of characteristic types. Output includes its Code, Description and Is Group value.
- Create a Document Creates a document in unposted state. Output includes its Number and Date, plus the Posted flag. Use Post a Document afterwards to post it.
- Create a Task Creates a task in 1C. Output includes its Number and Date, plus its Completed flag.
- Create an Account Records an account in a chart of accounts in 1C. Turn on Exchange Load Mode to write the way an exchange does, skipping write-time handlers, and use Additional Fields for unlisted fields.
- Create an Exchange Plan Node Inserts a node into an exchange plan, returning its Code, Description, This Node flag and Sent Message Number.
- Create an Information Register Record Writes a record into an information register in 1C and returns its Period. Use Data Load Mode to write it the way an exchange load does, skipping write-time handlers.
- Delete a Business Process Removes a business process record. Set Expected Data Version to stop the removal if the process was modified after you read it. No rollback exists.
- Delete a Calculation Type Deletes a calculation type from its chart in 1C and returns Deleted along with the Record Key. There is no going back.
- Delete a Catalog Item Deletes a catalog item in 1C. Use Expected Data Version to have 1C refuse the delete when the item changed after you read it. No going back.
- Delete a Characteristic Type Removes a characteristic type from its chart in 1C and reports the Record Key of the removed entry. Nothing is recoverable afterwards.
- Delete a Document Removes a document. Use Expected Data Version to have 1C refuse it if the document changed since you read it. Recovery is not possible.
- Delete a Task Removes a task record and returns Deleted with the Record Key. Nothing can be recovered.
- Delete an Account Deletes an account, with Expected Data Version available to make 1C refuse the delete when the account changed since you read it. No rollback is available.
- Delete an Exchange Plan Node Deletes an exchange plan node in 1C and returns Deleted with its Record Key. No recovery is possible.
- Delete an Information Register Record Removes an information register record in 1C. Nothing restores it afterwards.
- Get a Business Process Looks up one business process and shows its Number and Date.
- Get a Calculation Type Fetches one calculation type from its chart, with Code, Description and Predefined Name values.
- Get a Catalog Item Retrieves one catalog item. Use Fields to list the fields to return, such as Ref_Key and Description.
- Get a Characteristic Type Loads one characteristic type, with its Is Group flag, Code and Description.
- Get a Constant Reads the Value of a constant in 1C, such as Company Name.
- Get a Document Fetches one document with its Number, Date and Posted value. Add field names to Fields to limit the result.
- Get a Register Record Set Reads every record a given document wrote to a register, with Recorder, Recorder Type and Records.
- Get a Register Slice Takes the latest or earliest slice of an information register. Use Slice to choose between them, and Period for the date to take it at.
- Get a Task Retrieves one task with its Number, Date and Name.
- Get Account Turnovers Reads debit and credit turnovers of an accounting register between Start Period and End Period. Use Group By Dimensions to break them down, and Debit Account Condition to focus on one debit account.
- Get an Account Reads one account from a chart of accounts, with its Code, Description and Account Type.
- Get an Exchange Plan Node Pulls one node of an exchange plan, with its Code, Description and Sent Message Number.
- Get an Information Register Record Reads a single record of an information register, addressed by every dimension plus the Period. Output includes Period.
- Get Exchange Plan Changes Forms an exchange message for a node and sends the changes recorded since the last confirmed message. Output includes the Changes Feed. Use Confirm Exchange Plan Changes with the same Message Number afterwards.
- Get Extra Dimension Types Shows the extra dimension types defined on an accounting register. Use Limit to restrict the rows.
- Get Recalculations Reads recalculation records of a calculation register, filtered by Condition on the register fields and trimmed by Limit.
- Get Records with Extra Dimensions Queries accounting register records together with their extra dimensions. Bound it with Start Period and End Period, and ask 1C for only the first N records with First Records.
- Get Register Balance and Turnovers Queries balance and turnover figures for a register, bounded by Start Period and End Period. Use Group By Dimensions to split the rows.
- Get Register Turnovers Queries turnovers over the span from Start Period to End Period for accumulation or accounting registers. Use Group By Dimensions to break the totals down.
- Get Scheduled Data Pulls scheduled data for a calculation register. Use Condition to filter by the register fields and Limit to trim the rows.
- Get the Actual Action Period Gets actual action period data for a calculation register. Use Condition to filter by the register fields and Limit to cap the rows.
- Get the Calculation Base Reads base data behind calculation register entries, shaped by View Points and by the main and base register dimensions.
- Get the Register Balance Takes register balances at one date. Use Period for that date, or leave it blank for the current date, and Group By Dimensions to split the balances.
- List Accounts Lists accounts in a chart. Use Filter to keep only matching accounts, and Limit to cap the count, with at most 10,000 read in one run.
- List Business Processes Finds business processes of one type. Use Order By to sort them by a field, and Expand to load reference fields in full instead of just their key.
- List Calculation Types Shows the entries of a chart of calculation types. Turn on Only Records You May Read to skip the ones hidden by access rules, which otherwise make 1C refuse the whole request.
- List Catalog Items Reads catalog items. Use Fields to name the ones to return, and Filter with DeletionMark eq false to hide items marked for deletion.
Lexware Office modules
- Create a Bookkeeping Voucher Records a receipt as a bookkeeping voucher, with sales types for income and purchase types for expenses. Set Status to Unchecked to finish the voucher in Lexware later.
- Create a Contact Adds a company or a person to Lexware as a customer, a vendor or both. Lexware assigns the customer and vendor numbers itself. Use Company Name when the contact is a company.
- Create a Credit Note Writes a credit note from a Credit Note Date, Line Items and a Tax Type, left as a draft unless Status After Creation says otherwise. Use Refunds to link the invoice being refunded.
- Create a Delivery Note Prepares a delivery note with a Shipping Type and Line Items. Delivery notes carry no totals. Use Follows From to base it on an earlier sales document.
- Create a Dunning Drafts a payment reminder dated by Reminder Date, with Line Items and a Tax Type. Use Tax Sub Type for reminders to private customers in the EU.
- Create a Quotation Creates a quotation dated by Quotation Date and expiring at Valid Until, with Line Items that may be marked as Optional Item. Leave Status After Creation empty for a draft.
- Create an Article Saves an article under a Title, Type, Unit and Tax Rate. Use Leading Price to say whether the Net Price or the Gross Price is entered, and Lexware calculates the other.
- Create an Invoice Creates an invoice from up to 300 Line Items. Leave Status After Creation empty to get a draft, because a finalized invoice can no longer be changed through the API.
- Create an Order Confirmation Creates an order confirmation from an Order Confirmation Date, Line Items and a Shipping Type. Use Follows From to link the quotation behind it.
- Delete an Article Deletes an article from Lexware. Deleting cannot be undone.
- Download a Bookkeeping File Fetches a receipt or further bookkeeping file. A Format the file cannot be turned into gives an error.
- Download a Credit Note File Fetches the file for a credit note once finalized. Leave Format empty for the default file, which is the PDF.
- Download a Delivery Note File Delivers the document file of a delivery note. Drafts have no file yet. Output includes the File Name and Content Type.
- Download a Down Payment Invoice File Pulls a down payment invoice as a file. Only e-invoices have an XML file, which Format can request.
- Download a Dunning File Retrieves the file of a payment reminder, using the Dunning ID from Create a Dunning. Lexware has no list of payment reminders.
- Download a Quotation File Obtains a finalized quotation as a PDF by default, since a draft has no file yet.
- Download an Invoice File Downloads a finalized invoice. With the default Format you receive the XML for XRechnung invoices and the PDF for all others.
- Download an Order Confirmation File Saves the order confirmation document as a file, in the default PDF unless Format asks for another value Lexware accepts.
- Get a Bookkeeping Voucher Reads a bookkeeping voucher with its Voucher Status, Voucher Date, Total Gross Amount and Contact Name.
- Get a Contact Opens a contact, including its Roles, Addresses and Email Addresses.
- Get a Credit Note Looks up a credit note and shows the Voucher Status, Voucher Number and Total Price.
- Get a Delivery Note Looks up a delivery note, showing its Voucher Number, Shipping Conditions and Line Items.
- Get a Down Payment Invoice Returns a down payment invoice, including the Due Date and Electronic Document Profile.
- Get a Dunning Fetches a payment reminder by its Dunning ID, with its Voucher Status and Line Items.
- Get a Quotation Reads a quotation and reports its Expiration Date and Line Items.
- Get a Recurring Invoice Template Retrieves a recurring invoice template, giving its Title, Payment Conditions and Line Items.
- Get an Article Reads one article from Lexware, showing its Title, Type, Article Number and Price.
- Get an Invoice Reads an invoice and reports the Voucher Status, Due Date, XRechnung details and Electronic Document Profile.
- Get an Order Confirmation Pulls an order confirmation, including its Voucher Number, Line Items and Tax Amounts.
- Get Payment Status Shows how an invoice, credit note or voucher stands on payment, with the Payment Status, Open Amount, Paid Date and Payment Items.
- Get the Company Profile Returns who the connected Lexware account belongs to, with the Company Name, Subscription Status and Tax Type.
- List Articles Returns articles, narrowed by Article Number, GTIN or Type. Lexware returns results 250 at a time.
- List Contacts Searches contacts by part of a Name or Email, by Contact Number, or by role with Is Customer and Is Vendor.
- List Countries Shows the countries Lexware knows, giving each Country Code and Tax Classification.
- List Payment Conditions Retrieves the payment terms set up in Lexware, with the Payment Term Duration (Days) and which term is the Organization Default.
- List Posting Categories Finds the posting categories, with their Type and whether Split Allowed applies.
- List Print Layouts Lists the print layouts by Name and flags which one is the Default. Use Limit to cap the number returned.
- List Recurring Invoice Templates Lists recurring invoice templates with their Recurring Template Settings. The default order is most recently updated first, which Sort By can change.
- Make an API Call Makes an authorized free-form request to the Lexware Office REST API with your saved credential.
- Search Vouchers Finds sales documents, receipts and other vouchers by Voucher Types and Voucher Statuses. Add Voucher Date From and Voucher Date To to limit them by date.
- Update a Bookkeeping Voucher Edits a bookkeeping voucher. Use Status to move an unchecked voucher to Open, the only move Lexware allows, and keep Total Gross Amount equal to the sum of the items plus tax.
- Update a Contact Changes a contact. Use Add Customer Role or Add Vendor Role to give it a role, since roles cannot be removed through the API.
- Update an Article Edits an article. Change its Title, Unit or Tax Rate, or any other article value.
- Upload a Bookkeeping File Uploads a PDF, JPG, PNG or XML receipt of up to 5 MB, which Lexware turns into a bookkeeping voucher in the background. Output includes the File ID and Voucher ID.
- Upload a File to a Voucher Attaches a receipt file to an existing bookkeeping voucher. Each file can be attached only once.
- Watch Events Starts the workflow the instant Lexware Office sends a webhook event. Output includes the Event Type, Resource ID and Event Date.
- Watch Vouchers Polls Lexware on a schedule for vouchers that are created or updated. Use Voucher Types and Voucher Statuses to narrow what is watched, and Limit to cap the vouchers per run.
Explore alternative integrations
There are other apps[9] supported by WEXTL that can be paired with 1C:Enterprise (OData) and Lexware Office integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting 1C:Enterprise (OData) and Lexware Office.
References
List of sources used to gather information about the 1C:Enterprise (OData) and Lexware Office integration.
- 1C:Enterprise (OData) and Lexware Office integration source code, module specs and credentials implementation.
- Our 1C:Enterprise (OData) and Lexware Office integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for 1C:Enterprise (OData) and Lexware Office, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
- WEXTL® visual workflow builder, anonymized data from our technical support team.
- 1C:Enterprise (OData) integration information
- Lexware Office integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library
How we write our apps documentation
Explore how WEXTL® crafted 1C:Enterprise (OData) and Lexware Office integration page documentation. Used sources, the role of AI, and how the team validates the result.