For Sales orders
The transactions described are created when you print invoices for sales orders with NCC stock deliveries. The transactions are created in the DMR343 program.
| Transaction type | Description | Debit/Credit | Additional info |
|---|---|---|---|
| 260 | Sales value – Gross VAT NCC | D/C | Gross sales value if the invoiced item is VAT based. |
| 261 | Line discount VAT NCC | D/C | If there is a line discount connected to the transaction type 260. |
| 262 | Order discount VAT NCC | D/C | If there is an order discount on the order header connected to the transaction type 260. |
| 263 | Sales value invoiced not delivered VAT NCC | D/C | Gross sales value for a component in an order structure that is backlogged, but the whole structure is invoiced. The component is VAT based. |
| 264 | Line discount invoiced not delivered VAT NCC | D/C | If there is an order line discount connected to the transaction type 263. |
| 265 | Order discount invoiced not delivered VAT NCC | D/C | If there is an order discount on the order header connected to the transaction type 263. |
| 266 | Sales value – Gross no VAT NCC | D/C | Gross sales value if the invoiced item is not VAT based. |
| 267 | Line discount no VAT NCC | D/C | If there is a line discount connected to the transaction type 266 |
| 268 | Order discount no VAT NCC | D/C | If there is an order discount on the order header connected to the transaction type 266. |
| 269 | Sales value invoiced not delivered no VAT NCC | D/C | Gross sales value for a component in an order structure that is backlogged, but the whole structure is invoiced. The component is not VAT based. |
| 270 | Line discount invoiced not delivered no VAT NCC | D/C | If there is a line discount connected to the transaction type 269. |
| 271 | Order discount invoiced not delivered no VAT NCC | D/C | If there is an order discount on the order header connected to the transaction type 269. |
| 272 | Cost for goods sold NCC | D/C | Contra account to Stock value. |
| 273 | Cost for goods delivered FOC NCC | D/C | Contra account to Stock value if the invoiced item is free of charge. |
| 274 | Stock value NCC | D/C | Stock value if the invoiced item is a NCC item, delivered from NCC stock. |
| 276 | Fictitious cost NCC | D/C | Stock value if the invoiced item is a fictitious item. |
| 279 | VAT output of order lines NCC | D/C | The VAT amount for each VAT based item line on the invoice. |
| 281 | VAT output invoiced not delivered NCC | D/C | The VAT amount for each VAT based item line if the sales value is transaction type 263. |
For Service orders
The transactions described are created when you print invoices for service orders with NCC stock deliveries. The transactions are created in the DMR343 program.
| Transaction type | Description | Debit/Credit | Additional info |
|---|---|---|---|
| 282 | Sales value – Gross VAT SVC NCC | D/C | Gross sales value if the invoiced item is VAT based. |
| 283 | Line discount VAT SVC NCC | D/C | If there is a line discount connected to the transaction type 282. |
| 284 | Order discount VAT SVC NCC | D/C | If there is an order discount on the order header connected to the transaction type 282. |
| 285 | Sales value invoiced not delivered VAT SVC NCC | D/C | Gross sales value for a component in an order structure that is backlogged, but the whole structure is invoiced. The component is VAT based. |
| 286 | Line discount invoiced not delivered VAT SVC NCC | D/C | If there is an order line discount connected to the transaction type 285. |
| 287 | Order discount invoiced not delivered VAT SVC NCC | D/C | If there is an order discount on the order header connected to the transaction type 285. |
| 288 | Sales value – Gross no VAT SVC NCC | D/C | Gross sales value if the invoiced item is not VAT based. |
| 289 | Line discount no VAT SVC NCC | D/C | If there is a line discount connected to the transaction type 288 |
| 290 | Order discount no VAT SVC NCC | D/C | If there is an order discount on the order header connected to the transaction type 288. |
| 291 | Sales value invoiced not delivered no VAT SVC NCC | D/C | Gross sales value for a component in an order structure that is backlogged, but the whole structure is invoiced. The component is not VAT based. |
| 292 | Line discount invoiced not delivered no VAT SVC NCC | D/C | If there is a line discount connected to the transaction type 291. |
| 293 | Order discount invoiced not delivered no VAT SVC NCC | D/C | If there is an order discount on the order header connected to the transaction type 291. |
| 294 | Cost for goods sold SVC NCC | D/C | Contra account to Stock value. |
| 295 | Cost for goods delivered FOC SVC NCC | D/C | Contra account to Stock value if the invoiced item is free of charge. |
Description
Sales value
The following transaction types are related to the Sales value of one invoice line: 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271. There are two sets of transaction types for each event: one for sales with VAT and one for sales without VAT.
The order discount amount is the part of the total order discount amount that is connected to this line. This is done to enable you to distribute the order discount given to different accounts according to an attribute connected to items. Sales value – Gross and the discounts have different transaction types to enable you to see, on the books, how much discount of each type is given. If you do not want to have separate accounts for discounts, account all three types 260, 261, 262 / 266, 267, 268 or 263, 264, 265 / 269, 270, 271 exactly alike. The accounts will then show net sales value.
If your VAT system involves more than one VAT percentage, you normally should account these according to the VAT handling code table in one of the account parts to see the value of goods that are taxed for each VAT handling code. This is often necessary to meet legal accounting regulations.
Invoiced not delivered
Transactions for Invoiced not delivered are created when you have an order structure with the price connected to the parent and you do only a partial delivery of some of the components (items), but invoice the whole order structure. You will then receive an income from the customer but have no costs for the items that were not delivered. This must therefore be accounted. The cost is booked only for the goods delivered. The sales value invoiced not delivered is booked on the temporary accounts 263, 264 and 265. When these items (i.e. invoiced not delivered) are later delivered, the bookings will be reversed on the temporary accounts 263, 264 and 265 and booked instead on accounts 260, 261 and 262 along with the cost booking for the later delivered items.
The value accounted on 263, 264 and 265 is calculated as each component’s part of the total order structure value, based on the cost price on each component, (i.e. a factor of weight is calculated).
Stock value/Cost for sold items
The following transaction types are related to the Stock value and Cost of one invoice line: 274, 276, 272 and 273. The last two transaction types account the cost value of the goods on the invoice line. The value is determined according to the cost type, i.e. Standard cost, Average purchase cost or FIFO. If the order line has YES defined in the FOC field (Free of charge – FOC), the cost value is not accounted as Cost for goods sold (272), but as Cost for goods delivered FOC (273). This enables you to see the value of goods delivered FOC. If, however, you do not want to see this distinction, account those two (272 and 273) alike.
Fictitious item
If the item is a fictitious item, the stock value is not accounted according to transaction type 274, instead 276 is used. Depending on how the item type is defined (in the Item type table), either a cost price has to be defined when the order line is entered, to calculate the value for transaction type 276, or the cost price is allowed to be zero. If the cost price is not allowed to be zero, either you can enter a cost price manually on the sales order line, or the system can retrieve the cost price automatically from the Standard cost field in the Item file (irrespective of the cost type in the system). If the cost price is allowed to be zero, the system does not create transaction type 276 at all, nor are transaction types 272 or 273 created.
Note: If the cost price is not allowed to be zero, transaction type 276 and 272 or 273 will be created. Then you should not account transaction type 276 like transaction type 274, if you want to be able to reconcile the Stock value account in Financials with the Stock valuation list in Distribution. When you invoice a fictitious item, the stock value in Distribution is not influenced.
No stock update
If the sales order belongs to a sales order type where the Update stock on hand is set to NO, no accounting will be created for a “stock value”. Nor are transaction types 272 or 273 created.
In the accounting the difference between Net sales value and Cost for goods sold is calculated to find the profit. If accounting of Cost for goods sold is not performed, the profit value will have to be found in some other way. This is normally done by adding the decrease (or subtracting the increase) in the total stock value to (from) the total purchase value. By doing this, you can adjust the profit more than with the direct accounting of Cost for goods sold. If you use the old method of calculating Cost of goods sold manually, you can valuate the stock lower that comes up for taxation. This, of course, does not reduce any real gain or value in the company but only reduces the tax. By doing this you create a “hidden reserve”. It is important to be aware that when you reduce the amount in stock, the value of the “hidden reserve” comes up again for taxation, thus you will never entirely get rid of the tax. Instead you postpone the payment, thereby possibly earning/saving you interest (i.e. you are in fact giving yourself an interest free loan from the tax authorities). Also be aware, however, that some companies do it the other way around to make their results look better, (i.e. smaller losses), than actual.
Selection sequence of transaction types for stock value
VAT output
Transaction types 279 and 281 are the different transaction types for the VAT amounts. If you use more than one VAT handling code in the company (different percentage), it is customary to account these transaction types according to VAT handling code in one of the account parts.
The VAT output of order lines (279) is calculated from the Net sales value for each order line (Sales value Gross – line discount – order discount). One VAT transaction is created for each order line on the invoice. In the DIS control file you can also define if the cash discount on the invoice should be reduced before the VAT is calculated (Cash discount deduct field). See (Accounting) Invoice items with cash discount for more information.
The VAT output invoiced not delivered (281) is used when you have an order structure with the price connected to the parent and you do a partial delivery of some of the components (items), but invoice the whole amount (according to Sales value invoiced not delivered – 263).
In the Currency table you can define if you want the VAT amounts to be rounded according to predefined VAT rounding rules.
In DIS control file you can define if you want VAT amounts of zero to be posted to Financials (Post VAT= 0 BASE 0 field). If this field is set to NO, the system will not create the transaction type 281 at all, if the VAT handling code for the item/fee is zero percentage. If the field is set to YES, the system will create the transaction type 281. The VAT amount on the transaction will be zero but the base amount for the VAT calculation contains a value.
If you want to print the VAT quarterly sales report and the VAT declaration, the Post VAT=0 BASE 0 field in DIS control file, must be set tp YES. Otherwise the VAT file (SROVAT) is not updated.