Cost price recalculation can be found at
Lager/Maintenance/Cost price recalculation
When selecting
Cost price recalculation, all cost prices are calculated based on the selected inventory principle/cost price model. Recalculation of cost prices is an important part of everyday life when using Uniconta. It will ensure correct cost prices on the items. Everything is calculated according to the principle/model selected on the item card.
Notes: It is recommended to run recalculation at least once a month. The same for "Inventory recalculation". This is the only way to ensure that the cost prices of the items are correct. The cost price on the item card is just the last price. The recalculations provide the correct cost prices for the items after invoicing.
Note: If no fiscal year covering today's date has been created, "Cost price recalculation" cannot be run
.
When creating a purchase credit note.
If sum of number (inventory) <= 0, then there is no change in the way it is calculated.
Example.
An item is purchased for 100 kr. Then there is 1 item in stock.
Now this item is returned, but you only get 95 kr back. It is then given minus one in stock.
Now there are 0 items left, but there is a cost of 5 kr. We adjust the cost price as before.
The change is.
If the sum of quantity (inventory) > 0, then the cost price is not adjusted on a Purchase credit note.
Example.
10 pieces of the same item are purchased at DKK 100 per piece. 10 pieces are in stock.
Now an item is returned, but you only get DKK 95 back. It is then given minus one in stock.
Now there are 9 items left. The cost value of the 9 items will now be higher on sale, as there is a "loss" of 5 kr. The cost price on the purchase credit note is not adjusted. This will remain at the actual cost price.
This does not affect Credit notes from creditors from before this date that have been recalculated.
Warehouse weather regulation
If you see the "Inventory value adjustment" box when recalculating cost prices, you have not set up your system account for inventory value adjustment. In the box, select the desired inventory value adjustment account and click OK. The selected account will be assigned the system account "Inventory value adjustment".
Recommendation!
- When recalculating cost prices, we
recommend using "Invoice" under "Accounting per"
| Field name |
Field Description |
| Number series |
Only used if you select "Draft" under "Accounting per"(This is not recommended). If number series is used, it is recommended to create a unique voucher number series for recalculation. See voucher number series.
Number series is not used if "Invoice" is selected under "Posting per". |
| Posting date |
You can select the date for posting the adjustments. Only to be filled in when using the draft under "Posting per". |
| Comment is optional |
Comment is optional |
| Bookkeeping per |
Under "Accounting per" you can choose between:
- Invoice(Recommended)
- Draft(NOT recommended)
Notes: It is recommended to select 'Invoice' if you want to reconcile using the dashboard. Similarly, selecting 'Draft' will make it impossible to reconcile the individual inventory items against finance. If a draft is selected anyway, this draft, called "Recalculate inventory", shows what the adjustment is on the individual invoices, as the invoice number is in the text. It will be a manual process to reconcile.
|
| Adjustment must not be made before |
To be filled in with the first date of the current fiscal year.
Important! See description below |
| Update cost prices (item table) |
Update Cost: Checking this box will update cost prices on the item card. This also applies if Update cost price is not enabled under preferences.
Read more under Item about "Inventory principle/cost price model" here. |
Adjustments must not be made until
Very important: Fill in the date you want to adjust from. Uniconta will adjust in
ALL open accounting periods if
no date is set. This will mean that cost prices and financial entries will change backwards in time.
Are
the accounting periods open the following happens:
- Cost prices are adjusted from the date set in "Adjustments must not be made before", both on inventory and finance entries, on the original date.
Are
the accounting periods closed/blocked the following happens:
- No adjustments are made in closed/blocked periods. Any adjustments that should have been made in closed/blocked periods are created as drafts and posted.
- It is therefore important not to adjust during closed periods. You must change the date in the Adjustment must not be made before field to the first date in the open period. Set this as a default value to be corrected the next time you close/block a period.
A cost price adjustment cannot be deleted and rolled back. Therefore, it is important to enter a date in the "Adjustment cannot be made before" field. All periods after the date in the "Adjustment cannot be made before" field must be open.
Remember that Uniconta adjusts records at each run. This also applies to records that have been adjusted before.
Certain types such as "Opening" are not regulated.
Example of "Cost price recalculation"
When recalculating cost prices, an entry is made in the stock issue account from the product group, as well as the lower value adjustment account, as a counter account. If there are only stock accounts in the stock draft and not in the product group, the cost price adjustment goes to the error account.
In order to achieve the correct cost prices on line items, you need to recalculate your cost prices. We recommend that you do this often.
In the example, the same item is purchased on two different dates, at two different cost prices
Below are the two inventory transactions for the purchased item.
10 pieces have been purchased for 100,- and later 20 pieces have been purchased for 110,-
The item card is updated with the last purchase price, which is now 110,-
15 pieces of the item are sold.
Below are the invoice entries for the 15 items. The cost of goods sold calculated from 15 items * 110,- which is the cost price on the product card
DB on sale is now 1.350,- =>(15 pcs. * 200,-) - (15 pcs. * 110,-)
A recalculation of cost prices is now run and the changes to the invoice entries are shown below
Remember to select a date in the "Adjustment must not be made before" field
There is now a change in cost of goods sold (1330), which is credited with 100,- and debited to inventory outflow (5540) with 100,-.
DB on sale is now 1.450,- => (15 pcs. * 200,-) - ((5 pcs. * 110,-) + (10 pcs. * 100,-))