Change-in Inventory - batch

The Change-in-Invetory- batch evaluates a stock by means of a stock change posting and automatically creates one or more postings. The time intervals are selectable and valuations can take place at the end of a period or even daily. Optionally, a valuation "per product" or per "data slice" can be performed. It is also possible to post goods receipts and goods issues differently.

Possible applications

Individually adjustable valuation of stocks.

Example:

Various stock values are to be mapped in the finance app. In ODOO, the user is now given two choices with the options "automatic" and "manual". Both options are very limited in their usability because the "automatic" function creates a posting in the financials for each individual stock posting, while no further processes take place if the "manual" option is selected. Change-in-Invetory- batch, on the other hand, offers the user a few more options at this point. For example, the valuations can be executed per "data slice". In this way, each warehouse can now be posted separately (even with different accounts). Or, goods receipts can be posted differently than goods issues, allowing the Cost of Goods Sold to be mapped within a total cost procedure.

Loans

An app that allows pre-calculated Excel templates to be uploaded directly to Odoo and their entries to be transferred to postings (draft status). Also, reclassifications (short- to longterm) can be stored in Excel. Incorporation with the apps "Movement Types" and "Topics" is possible as well.  

Possible applications

Repayment- and interest postings for loans.

Example

Loans often generate hundreds of postings across their life cycles. Repayments an interest (if not variable) are usually known from the beginning and a calculation overview is provided by a bank. This overview can be uploaded directly to Odoo via an Excel template, whereupon the app creates postings in draft for all future movements. When using variable interest rates, one can use the draft postings as a template and adjust them on a monthly basis or, alternatively, book a yearly adjustment.

Accrual Standard-Process– Batch

A batch that solves an accounting problem occuring in Odoo-Standard due to unequal posting times of sales invoice and outgoing stock.

Possible applications

P&L - invoice and outgoing stock

Example

In Odoo-Standard the accounting is always incorrect when sales invoice and outgoing stock (the same applies to the purchase side) do not occur at the same time. The basis of this error is that the time of revenue recognition here is made dependent on the time of invoicing. Correctly, however, this should be dependent on the transfer of ownership, which usually takes place at goods issue. This app ensures that the P&L is correct even if the invoice and goods issue are not posted synchronously. In addition, it generates a report showing the status on POs and SOs ("delivered/received" and "invocied/billed") at a given closing date. Posting the accrual itself takes less than a minute (same goes for the goods receipt process).

Additional Postings for Invoices and Bills

An extension through which a specified accrual entry can be automatically generated for each outgoing invoice. In a separate matrix-table, various criteria (for example, products, analytical accounts, salespersons, etc.) can be defined for this purpose, as well as the form and amount of the accounting entry.

Possible applications

Various additional postings when invoices are issued

Example

A sales invoice is posted. Based on the product table stored, in which product-specific warranty rates have already been defined, the posting of the warranty provision is now made automatically via this extension.

Account Description

A field in the posting-frontend that contains a description text and appears whenever an account is selected.

Possible applications

Postings and account information.

Example

An accountant is to be provided with a more detailed view of information about a particular account during the posting process. This information could include, what is actually to be posted or allowed to be posted on the respective account. The corresponding information, that is, the account description, has already been specified in the account master data. As soon as the accountant selects an account during the posting process, this description is displayed in an additional section.

Mandatory Analytic Account

Via "Mandatory Analytic Account" the possibility is given to define for a respective account whether the entry of a cost center is defined as a mandatory field for an entry.

Possible applications

Various postings. Enhancement: In the new version, it is also possible to define whether an analysis account is defined as a mandatory field for purchase or sales orders.​ GuV-Buchungen.
Zusätzlich kann festgelegt werden, ob bei Einkaufs- oder Verkaufsaufträgen ein Analysekonto als Pflichtfeld definiert wird.

Example

An entry is in draft and can be saved as such even if an analysis account is not entered. However, if this booking is then to be validated and the analysis account has still not been entered, it results in an error message.

Balance Reclassification Accounts

When a bank account has a credit balance and needs to be reclassified to payables, reclassification posting and reversal of the same on the following day will be done through this app. In addition, there is an option to define account groups, to check them in bundles and to start the reclassification process only if the total balance of this bundle is negative.

Example

Manche Konten wie bspw. Bankkonten können zu einem Abschluss-Stichtag statt eines Soll-Saldos auch ein Haben-Saldo aufweisen. Diese App bucht diese Positionen über einen Batchrun auf Umgliederungskonten um, ohne dabei Veränderungen an dem eigentlichen Konto vorzunehmen.

Recurring Postings and Bills

A model that creates recurring entries. Similar to the depreciation in Odoo, a "recurring number" is defined. Then all future postings are created in draft and can be automatically converted to validated postings.

Possible applications

Journal entries and purchase invocies (bills).

Example

Each month there is a car-leasing-fee to be paid. To create the open item (bill) you can create a recurring bill over the next 24 month. All recurring bills are shown in a separate register, similar to the asset-register.

Documents - Partner-Tag

When importing or creating a bill/invoice inside the documents app, the partner is not added to the document-tags automatically. Therefore you can not search for the partner inside the document-app. This app closes the gap and allows you to filter/search for partners inside the documents app.  

Possible applications

Odoo-Dokuments-App.

Example

When importing a bill inside the documents app, one validates and books a bill. The moment the bill is booked, the partner/supplier is known! With this app, the parter is directly attached to the document.

Historic Partner Ledger Report (Open Items)

In Odoo there are two standard reports to display open items. The report "Partner Ledger" -Report (in menu item "Accounting") is recommended, as all filter and grouping functions are possible here via the usual list view..

A disadvantage of the Odoo standard reports, however, is that they only ever show you the open items as of "TODAY". For an earlier date it is impossible to display the OP's as they were at that time (Attention: one can filter by date, but then there will be a FALSE results!).  

In the Odoo standard there are only the two reports "aged receivables" and "aged payables" for this possibility. Apart from the fact that here the column selection is very limited, the report is also not usable for analytic purpose as many fields (e.g. foreign-currency-amounts) are not shown at all.

As an alternative, the syscoon Open Items Report can be used. Optically almost identical to the "Partner Account Statement" one is additionally able to enter a historical date in a wizard and thus get a specific historic date.

Possible applications

Open items of receivables LL, payables LL, all "reconciliation accounts" in list format on a specific date.

Example

Open items (unbalanced positions) shall be shown as per 31st of December 2022 wheras current date is 3rd of February 2023. As in the Standard-ODOO report, yone can then filter and group for receivables, payables and all other kind of "allow reconciliation" issues. ​​​​

​

Landed costs with inventory-valuation "manual"

In Standard-ODOO it is not possible to add landed costs, when field "inventory valuation" inside the product category is set on "manual" (all stock-movements are NOT creating any finance-postings). Therefore it is not possible to capitalize costs as freight, custom etc.and those value-additions are not shown inside the stock-main-ledger (stock-valuation-layer). For this technical restriction there is no reason. This app allows to capitalize landed costs. App can/should be used in combination with the syscoon inventory valuation app. 

Possible applications

Capitalization of landed costs, if field "inventory valuation" inside the product categories is set on "manual".

Example

If there are additional costs related to a purchase of products, like freight, custom etc, one can add those costs to the capitalized primary product costs of the item. As a consequence this would lead to an increase of stock.

Improved Assets

An app that provides a detailed, filterable and groupable list view of all assets in the sub-ledger, including all details such as depreciation durations, pending depreciation, acquisition date, depreciation method, etc. In addition, asset numbers are assigned and a report is generated that compares the general ledger with the sub-ledger and points out any differences.
In addition, it is possible to combine the asset postings with the transaction types, so that a) more complex issues (e.g. "unscheduled depreciation") can be mapped and b) exports for consolidation software such as Lucanet can be created. 

Possible applications

Fixed Assets

Landed Costs Accural Calculation

If incidental acquisition costs for inventories (LC) are to be posted promptly, one often encounters the problem of a delayed receipt of the corresponding invoice. This app solves this problem by already showing certain, previously defined incidental acquisition costs with the invoice amount when the inventories are being capitalized. 

Possible applications

Simultaneous display of invoice amount and incidental acquisition costs for inventories.

Example

Before a corresponding invoice for freight/customs is received, the landed costs should be shown as expenses at the time of purchase of a product, while not yet being capitalized. Using this app, these expenses are first posted to an accrual account. At the same time, the possibility of defining a calculation sequence is given, which becomes necessary whenever costs depend on other partial costs to be calculated beforehand. When the LC-invoice is received (at a later date), it now only has to be booked out against the accrual account, while any differences at the end of the period have to be cleared through profit or loss.

Freeze Headlines

Similar to Excel's "Freeze Headlines" one is able to show headers even when scrolling down.