Exact Financials

 

Connectivity Manual - Importing budgets for general ledger accounts, cost centers and cost units

Importing budget totals for general ledger accounts, cost centers and cost units

No	Field name	Type	Format	Ref	Description	Remarks	Default
1	version_code	CHAR	X6	bdvers	Budget version	Mandatory	-
2	acc_nr	INT	X9	ledger	Account number	Mandatory	-
3	cost_center	CHAR	X8	ccent	Cost center	-	-
4	cost_unit	CHAR	X8	cunit	Cost unit	-	-
5	amt_budget_debit	DEC	N15,2	-	Budget amount debit	-	-
6	amt_budget_credit	DEC	N15,2	-	Budget amount credit	-	-
7	qty_budget	DEC	N15,2	-	Budget quantity	-	-
8	method_code	CHAR	X8	bdmeth	Period allocation method	-	-
9	ccent_method_code	CHAR	X8	bdccdm	Cost center allocation method	-	-

Clarification of the fields:

Field	Clarification
1	This reference is only mandatory when you do not import the budget version along with the budget.
2	When importing a cost center or a cost unit budget, you should not enter a general ledger account number.

Importing budget periods for general ledger accounts, cost centers and cost units

No	Field name	Type	Format	Ref	Description	Remarks	Default
1	version_code	CHAR	X6	bdvers	Budget version	Mandatory	-
2	acc_nr	INT	X9	ledger	Account number	Mandatory	-
3	cost_center	CHAR	X8	ccent	Cost center	-	-
4	cost_unit	CHAR	X8	cunit	Cost unit	-	-
5	fin_yr	INT	N4	-	Financial year	-	-
6	amt_budget_debit	DEC	N10,2	-	Budget amount debit	-	-
7	amt_budget_credit	DEC	N10,2	-	Budget amount credit	-	-
8	qty_budget	DEC	N15,2	-	Budget quantity	-	-

Clarification of the fields:

Field	Clarification
1	This reference is only mandatory when you do not import the budget version along with the budget.

6-8	These fields must appear 15 times in the csv file. Depending on the number of periods you want to import, the fields will be filled. If you only want to import budgets for the first 3 periods, then you fill the first 3 fields and you leave 12 fields empty.

The attachement budgetperiods_gl_cc_cu.xls is a format for the import file

---

Connectivity > Data import > Available import formats > Budget > Importing budgets for general ledger accounts, cost centers and cost units

---

     

Main Category:	Support Product Know How	Document Type:	Support - On-line help
Category:	On-line help files	Security  level:	All - 0
Sub category:	Details	Document ID:	18.324.829
Assortment:	Exact Financials	Date:	02-10-2015
Release:		Attachment:
Disclaimer