Related topics
- About setting up accounting parameters
- About setting up the accounting matrix
- Setting up narcotic movement handling in DC1 Pharma
This panel lists all of the DC1 Distribution transaction types.
These entries are used to drive the creation of the different accounting transactions which occur in the DC1 Distribution system and are further on transferred to DC1 Financials. Each accounting transaction that is made is assigned a “type”. For example, type 800 identifies a Cost of goods sold (COGS).
These transactions will be posted to the Bookkeeping transaction file along with other relevant accounting information.
The transaction types ranging from 1-999 are predefined and cannot be deleted. These are loaded during the DC1 installation. Not all of the transaction types are used by the system. The series ranging from 700-749 are reserved for local use, i.e. these can be customised with country or customer specific information.
Note: All existing DC1 transaction types are preloaded into the system regardless of whether or not a particular application is installed. For example if DC1 Service is not installed and activated (i.e. not used by your company) the transaction types that belong to that application will be displayed in this program.
If the transaction types that are preloaded by the system do not meet a specific accounting requirement needed by your company, then one can be created manually to address it. It is important that you ensure that these transaction types are correctly defined.
Options
| Translate/Display translations | Select this option to either update or view information from the Table translation file. Displayed fields can be translated to any of the languages registered in Work with languages. |
| Accounting information | Select this option to define transaction type specific accounting information for the transaction type. |
| Accounting mapping | Select this option to access the Accounting mapping panel to control that the account part specifications for the selected DIS transaction type are properly mapped to the possible FIN account numbers per account part. Any changes made to the selected transaction type are refreshed and retrieved to the account mappings panel upon access. |
Selection fields
- Type
- This column lists the existing transaction types.
- VAT
- Displays the VAT handling code defined for the transaction type.
- Ap1-8
- In these eight columns the fixed account part code or the table value dependent accounting reference defined for the transaction type is displayed.
Work with transaction types (DMR02704)
On this panel you create a new transaction type or maintain an existing one.
Note: As transaction types ranging from 1-999 are reserved by the system, all new transaction types must have a value of 1000 or greater.
- Type
As transaction types ranging from 1-999 are reserved by the system, all new transaction types must have a value of 1000 or greater.
- Text
- Summarise trans
- Indicate if accounting transactions created from this type should be summarised when transferred to the General Ledger in DC1 Financials.
- VAT handling code
- Enter a code from Work with VAT handling codes. This field is mandatory when VAT override on this panel is set to NO. The VAT handling code will be used in DC1 Financials when VAT on G/L level is activated in the G/L control file, when this is required in the legislation.
- Account part 1-8
- In these eight fields you can enter either a fixed account part code or the number of a valid table, using table value dependent accounting. For any fixed account part code that you define in any of these fields, the corresponding pseudo account code and connecting actual account number will eventually be retrieved when an accounting transaction is being created for this transaction type.
It is, therefore, important that the DIS pseudo account code corresponding to each fixed account part code entered, has previously been defined in Work with logistic pseudo accounts.
If you define any of these eight fields using table value dependent accounting, you must define the pseudo account code that will be used for each entry in that table in the Accounting information panel.
Read more about table value dependent default accounting using the Accounting matrix functionality.
- VAT override
- Indicates if the VAT handling code established on this transaction type will be overridden by the VAT handling code established on the item/country/country level or DIS control file level when transactions are transferred to DC1 Financials. This code is preloaded and used internally by the system and cannot be maintained by the user.
- VAT account
- Indicates if this transaction type is a VAT account, meaning that the transactions created for this transaction type are related to the VAT reporting in DC1 Financials. This code is used internally by the system to control aspects regarding VAT handling in DC1 Financials and cannot be maintained by the user.
- Balance type
- Enter the applicable balance type (belonging to Balance group WHC) that you want to link to the transaction type.
Note: As it has become increasingly important to be able to analyse the costs of handling goods in your warehouses, you can link an Inventory transaction to a Balance type, (that belongs to Balance group WHC), and let that Balance type carry the cost. This means that every time the inventory transaction occurs, the system will update the Balance file with the applicable cost for the Balance type. This balance type can, in turn, be included in reports you create via the Profitability Analysis tool in DC1 Analyser and the DC1 Report Writer. Balance information can also be analysed in the Balances and transactions enquiry. (See the Balance type, Trans cost calc code and Transaction cost fields below).
- Trans cost calc code
- Enter a code indicating how the cost should be calculated for the balance type that is linked to the warehouse event (inventory transaction). The cost can either be defined manually in the Transaction cost field, or retrieved from the Cost value field in the Inventory transaction file. You can also use a combination of the two cost values.
Note: Cost values from the Transaction cost field and/or the Cost value field in the Inventory transaction file will not be used in the calculation if this field is left blank.
Code Description BLANK No cost will be retrieved for the transaction. 1 The cost for the event will be retrieved from the Transaction cost field. This code can, for example, be used when you calculate the cost for the transaction of moving an item from one location to another in the warehouse. 2 The cost for the event will be retrieved from the actual transaction (item cost) when the event takes place. This code can, for example, be used if items have been stolen or a lot has expired. The cost will in this case be the cost price of the item(s). This value is retrieved from the Cost value field in the Inventory transaction file. 3 The cost for the event will be retrieved both from the Transaction cost field and the Cost value field in the Inventory transaction file (a combination of code 1 and 2). This code can, for example, be used for expired lots. Not only is there a cost value for the items in the lots that you have to get rid of, but there may also be some miscellaneous/administration costs involved for discovering the expired items.
- Transaction cost
- This field is only valid if code 1 or 3 have been entered in the Trans cost calc code field above. Enter the manual transaction cost for the balance type.
- Stock account
- Indicates if this transaction type affects the stock account. This code is used internally by the system to control aspects regarding stock value when transactions are transferred to DC1 Financials. Note: Transaction types with a setting of YES in this field are preloaded and created specifically to be the matching criteria between DC1 Distribution and DC1 Financials for the Inventory transaction enquiry functionality.
- Narcotics
- Only displayed if DC1 Pharma is activated. Narcotic movement information can be collected for narcotic related items and sent to the applicable authorities. If inventory movements (in and out of stock) are to be collected for a narcotic related item, set this field to YES for the transaction type.
Valid tables
In this section the table numbers and descriptions that are valid for the table value dependent accounting method are listed to be used for the transaction type. Any of the table numbers displayed can be entered in the valid account parts. Table numbers between 60 and 89 are reserved for the Accounting matrix functionality.
Work with transaction types, Copy (DMR02705)
- Type
- Displays the transaction type(s) you selected to copy.
- New type
- Enter a code to identify the new transaction type you are creating.