Skip to main content

Accrued and prepaid expense/revenue from pickings

Project description

Beta License: AGPL-3 OCA/account-closing Translate me on Weblate Try me on Runboat

This module generates expense/revenue accruals and prepaid expense/revenue based on the status of orders, pickings and invoices. The module is named account_cutoff_accrual_picking because it initially only supported accruals ; support for prepaid expense/revenue was added later (it should be renamed in later versions).

To understand the behavior of this module, let’s take the example of an expense accrual. When you click on the button Re-Generate Lines of an Expense Accrual:

  1. Odoo will look for all incoming picking in Done state with a Transfer Date <= Cut-off Date. For performance reasons, by default, the incoming picking dated before Cut-off Date minus 90 days will not be taken into account (this limit is configurable via the field Picking Analysis). It will go to the stock moves of those pickings and see if they are linked to a purchase order line.

  2. Once this analysis is completed, Odoo has a list of purchase order lines to analyse for potential expense accrual.

  3. For each of these purchase order lines, Odoo will:

    • scan the related stock moves in done state and check their transfer date,

    • scan the related invoices lines and check their invoice date.

  4. If, for a particular purchase order line, the quantity of products received before the cutoff-date (or on the same day) minus the quantity of products invoiced before the cut-off date (or on the same day) is positive, Odoo will generate a cut-off line.

Now, let’s take the example of a prepaid expense. When you click on the button Re-Generate Lines of a Prepaid Expense:

  1. Odoo will look for all vendor bills dated before (or equal to) Cut-off Date. For performance reasons, by default, the vendor bills dated before Cut-off Date minus 90 days will not be taken into account (this limit is configurable via the field Picking Analysis). It will go to the invoice lines of those vendor bills and see if they are linked to a purchase order line.

  2. Once this analysis is completed, Odoo has a list of purchase order lines to analyse for potential prepaid expense.

  3. For each of these purchase order lines, Odoo will:

    • scan the related stock moves in done state and check their transfer date,

    • scan the related invoices lines and check their invoice date.

  4. If, for a particular purchase order line, the quantity of products invoiced before the cutoff-date (or on the same day) minus the quantity of products received before the cut-off date (or on the same day) is positive, Odoo will generate a cut-off line.

This module should work well with multiple units of measure (including products purchased and invoiced in different units of measure) and in multi-currency.

Table of contents

Configuration

For configuration instructions, refer to the README of the module account_cutoff_base.

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.

Credits

Authors

  • Akretion

Contributors

Maintainers

This module is maintained by the OCA.

Odoo Community Association

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

Current maintainer:

alexis-via

This module is part of the OCA/account-closing project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

File details

Details for the file odoo14_addon_account_cutoff_accrual_picking-14.0.2.0.1-py3-none-any.whl.

File metadata

File hashes

Hashes for odoo14_addon_account_cutoff_accrual_picking-14.0.2.0.1-py3-none-any.whl
Algorithm Hash digest
SHA256 5a14637928e26c17abe681d13d051d081fcab6482cc9bc0666d521ba76cabc76
MD5 9626c5cdf0db44c04ffbdee5e288db52
BLAKE2b-256 2cef01251c69eb6e49771b2acbe2b2b383088ca124f2958903d3a72a6e092040

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page