Loading
Uniconta
Search
Generic filters
Get Uniconta
  • Visit a Country Site
    • Danmark
    • Deutschland
    • Eesti
    • Ísland
    • Lithuania
    • Nederland
    • Norge
    • Österreich
    • United Kingdom
  • Search
  • Uniconta
    • Ledger
    • Customer
    • Sales Order
    • Vendor
    • Purchase
    • Inventory
    • Logistics
    • Project
    • Light Manufacturing
    • CRM
    • Dashboard
    • Company
    • Adaptability
  • Download
    • Uniconta for Windows
    • Uniconta for Mac
  • Resellers
    • Find a reseller
    • Become a reseller
    • Become an integration partner
    • Partner Portal Login
    • Partner Portal sign up
  • Developers
    • Become an integration partner
    • Documentation
    • Downloads
    • Samples
    • Support
  • Accountants
    • Become a Univisor
  • News
  • About us
    • About us
    • Management
    • Contact

Unipedia

  • Introduction
    • Get started with Uniconta
    • Which browser are you using?
    • Get started with an existing set of accounts
  • Converting to Uniconta
    • Conversion tool
    • What can be converted to Uniconta?
    • Converting from NAV to Uniconta
    • Converting from e-conomic to Uniconta
    • Converting from C5 to Uniconta
    • Converting from eCtrl to Uniconta
    • Checking your accounts after conversion
  • General Ledger
    • How to split voucher PDF
    • Chart of Accounts
      • Chart of Accounts
      • Account types
      • System Accounts
      • Import a Chart of Accounts
    • General journals
      • Journal Entries
      • Import from a file
      • Import Bank statement
        • Automatic account selection
      • Posting in foreign currency
      • Posting customer payments
      • How to manage voucher number series
      • Setting up Journals
      • Cancel voucher/delete journal/delete record
    • Bank Reconciliation
      • Bank Management / Bank reconciliation
      • Automatic account selection
    • Budget
      • Budget
    • Reports
      • Account statements
      • Transactions
      • Financial Statement
      • Physical Vouchers
      • Posted Journals
    • VAT reporting
      • VAT reporting – Denmark
      • VAT specification – Denmark
      • EU sales
      • Intrastat
      • EU sales list
    • Pivot table
    • Maintenance
      • Dimensions
      • – Join two dimensions
      • – Reverse charged VAT – Denmark
      • Voucher number series
      • – Automatic allocation of number series
      • Terms of payment
      • – Managing cash discounts
      • Accounting year
      • – Year end closing/opening balances
      • Join two accounts
    • Audit activities
      • Company accounts templates
      • Export transactions
  • Customer
    • Customer
      • Customer
      • – Reconciling Customer Accounts
    • Quick invoice
      • Quick invoice
    • Sales
      • Sales orders
      • – Create purchase/sales order
      • Quotations
      • Mass update
      • – Generate UBL
      • – Purchases and sales without VAT
      • Order journal
    • Reports
      • Statement
      • Transactions
      • Open transactions
      • Payment proposals (SEPA)
      • Ageing report
      • Interest and collection letter
        • – Collection letter messages
      • Invoices
      • Delivery note
      • Stock transactions
      • Order lines
      • Customer statistics
      • Pivot table
    • Maintenance
      • Customer groups
      • Order groups
      • Shipments
      • Terms of delivery
      • Layout groups
      • Number sequences
        • – Error messages
      • Invoice layout
        • – Creating watermarks
      • E-mail setup
        • – Setting up SMTP
        • – Mail server set up
        • – Forwarding e-mails to Uniconta
      • Document messages
      • SEPA set up
      • Mandates (SEPA)
      • Customer Direct Debit
      • Join
        • Join two accounts
        • Join two sales orders
        • Join many
  • CRM
    • – Introduction to CRM
    • Prospects
      • – Creating an quotation for a prospect
      • – Create follow-up
    • Customers & Prospects
    • Follow-up activities
    • Create e-mail list
    • Campaign
    • Maintenance
      • Interests
      • Products
      • CRM groups
      • Follow-up groups
      • Campaign groups
  • Vendor
    • Mass update
    • – Purchases and sales without VAT
    • Reports
      • Statement
      • Merge payments
      • Ageing report
      • Pivot table
    • Maintenance
      • Vendor groups
      • Purchase order groups
      • Vendor layout groups
      • Number sequences
      • File formats for methods of payment
        • – Setting up messages for vendor payments
        • – Setting up bank days
      • Join
      • – Join two accounts
      • – Join two purchase orders
      • – Join many
  • Inventory
    • Items
    • Stock Journal
    • – Posting in the stock journals
    • – BOMs in Uniconta
    • – Handling packaging fees
    • Reports
      • Inventory account statement
      • Inventory transactions
      • Item stock status
      • On-hand
      • Re-order list
      • Pivot table
    • Maintenance
      • – Purchasing number series items
      • Join two items
      • Variants
        • – Default variants
        • – Importing old inventory transactions
  • Project
    • Get started with Project and Time
    • Invoicing in the project module
    • Project Categories
    • Pivot table
    • Project groups
  • Company
    • Company information
    • View a demonstration company
    • User rights
      • Manage users
      • Requests for company access
      • Request company access
    • Maintenance
      • Configure application functionality
      • Preferences
      • Subscription (Administrators)
      • – Create subscription (Administrators)
      • – Create subscription (Client)
      • – From trial period to subscription
      • – Counting financial items
      • Modification URL
      • Create a new company
    • Contacts
  • Administrator
    • Distributor Administration
    • User Login History
    • Partner Plugin
  • Tools
    • Main Menu
    • Save layout as a menu item
    • User Plugin
      • How to change Uniconta’s default plugin path
    • Report Generator
      • Report Generator
        • Acccount statement
        • Collection letter documents
        • Company accounts cover page
        • Picking list
        • Purchase documents
        • Sales documents
      • Create a report to be viewed externally
      • Expression binding for Reports
    • Additional setup
      • Local backup
      • Import e-conomic
  • Data Access
    • Transfer data from Uniconta to Excel
    • OData filter function
  • General
    • User Interface
      • User Profile
      • Shortcut Keys in Uniconta
      • Layout
      • Templates
      • How to search in Uniconta
      • Filter/Clear Filter
      • General tips
    • General Functions
      • Attachments
      • Copy and paste in Uniconta
      • Export data and reports to file format
      • Send documents and data by e-mail
      • Print reports and list forms
      • National company number lookup
      • Excel, export and import
    • Security
      • Who has access to my accounts?
      • Forgot Password
      • Backup
      • Uniconta Security
    • Installation
      • Installation on RDS – Remote Desktop Server
      • Optimal internet access for Uniconta
      • Install Uniconta in Windows 7
      • Uniconta in the Microsoft App-Store
      • Uniconta for Mac

Posting in stock journal

460 views 8 December 2017 12 June 2018
Print Friendly, PDF & Email

Learn more about:

  • Layout
  • Filter/Clear Filter
  • Templates
  • How to search in Uniconta
  • Attachments
June 12th, 2018

Use the navigation panel to go to Inventory/Stock Journal. Select the inventory journal to be posted to.

 

(Click on the screenshot to enlarge.)

Import from file

Inventory journal lines, created in excel for example, can be imported using the ‘Import from file’ button in the toolbar/ribbon shown in the screenshot above.

 

Placing opening number of items into the Inventory module

When getting started in the inventory module, it is possible to copy/paste the opening number of items into the inventory module from an Excel or CSV file.

Read about how to import from excel here.

When placing inventory items into the inventory module for the first time, ‘Opening’ should be chosen in the ’Item transaction’ column under Inventory/Stock journal and the ‘Journal lines’ button as described below. When ‘Opening’ is selected here, no transactions are posted in the General Ledger, since they have been posted previously and the user is only placing the number of items into inventory here, as described below.

 

Delete journal transactions

The ‘Delete journal transactions’ button in the toolbar/ribbon shown above, deletes all transactions in the journal.

 

Journal lines

To create journal entries, click on the ‘journal lines’ button in the toolbar/ribbon. Click on ‘Add post’ or F2 to create a new journal line as shown in the screenshot below.

 

(Click on the screenshot to enlarge.)

 

Item transaction types

The first column allows the user to select ‘Item transaction’ types. The item transaction type selected here will follow the transaction through the system.

 

 

NOTE: Not all item transaction types are posted to the general ledger. However, for those types that are posted in the general ledger, the account entered here in the inventory module will override any standard account settings.

 

MovementUsed to manage inventory WITHOUT entries to the general ledger.

Used to move goods from warehouse to warehouse. Requires the ‘location’ to be switched on in the logistics module.

NOT for opening inventory balances in a new set of accounts.
Use the ‘Opening’ type for opening balance – see description below.

Movements from one warehouse to another are recorded with a negative number. So if moving one item from a warehouse, enter a quantity of -1 in the journal.

SalesUse this type when managing inventory without a sales order.

The customer account can be entered in the stock journal.

An inventory transaction is created which shows up on the customer’s account. Sales transactions are however, NOT created for the customer or in the general ledger.

A sale is recorded with a negative number. So if one item is sold, enter a quantity of -1 in the journal. 

PurchaseThis type is used to manage inventory without a purchase order.

The vendor account can be entered in the stock journal.

An inventory transaction is created, which shows up on the vendor account. However, purchase transactions are NOT created for the vendor or in the general ledger.

A purchase is recorded with a positive number. So if one item is purchased for the warehouse, enter a quantity of +1 in the journal. 

AdjustmentUsed for periodic inventory adjustments.

This item transaction type is posted to the general ledger with the system account type “Inventory value adjustment”.

A post is created in the inventory account with the offset post as “Inventory value adjustment” so both posts affect asset accounts.

Do not use for internal warehouse movements.

 

 

Counting

 

 

 

 

Used for counting inventory.

Inventory counts can either be entered directly in the inventory journal or under Inventory/Reports/Counting list and are posted to the stock journal. If a counting list is used as described above, then the ‘Counting’ item transaction type will automatically be selected for the journal lines. Counting types are posted to the general ledger with the system account type “Journal for entering profits and losses”.

This will be the difference between the recorded and counted inventory items.

Profit/LossUsed for recording profit/loss.

Posted to the general ledger with the system account type “Journal for entering profits and losses”.

A loss in inventory is recorded as a negative quantity ‘-1’ in the journal

ObsoleteUsed to manage obsolete and discontinued inventory items

Posted to the general ledger with the system account type “Journal for entering profits and losses”.

An obsolete inventory item is recorded with a negative number as it is a loss, so a quantity of -1 is entered in the journal for an obsolete item.

Report as finishedUsed to report the completion of production BOMs.

Enter the number of items that are to be reported finished in the quantity field.
Open the BOM list and the associated items.

Included in BOMBOMs shows the items included for this type.
OpeningUsed when placing inventory in the warehouse when creating a new set of accounts. This does not generate any accounting entries.

 

 

 

  • Was this Helpful ?
  • YesNo
Categories: Inventory, Unipedia

Get in touch with us

Uniconta

  • Uniconta
  • Subscription Terms
  • System Status

PARTNER

  • Resellers
  • Get Uniconta
  • Documentation

INFO

  • News
  • Video
  • Security

Support

  • Unipedia
  • API Support
  • Visit a Country Site
    • Danmark
    • Deutschland
    • Eesti
    • Ísland
    • Lithuania
    • Nederland
    • Norge
    • Österreich
    • United Kingdom
Uniconta
© Copyright 2019 | All rights reserved | info@uniconta.com | Terms & Conditions
Facebook Twitter LinkedIn Youtube