cancel
Showing results for 
Search instead for 
Did you mean: 

BUDGET ERROR Invalid amounts in rows

Y-Yusuf
Explorer
245

Hi,

When I want to upload the budget using DTW templates, I receive the error "Invalid amounts in rows." I am using two templates: OBGT and BGT1. In my OBGT template, there are the following columns:

 

NumeratorTotalAnnualBudgetDebitSysTotalAnnualBudgetDebitLocTotalAnnualBudgetCreditSysTotalAnnualBudgetCreditLocDivisionCodeAccountCodeBudgetScenario
SCNCounterDebSTotalDebLTotalCredSTotalCredLTotalBgdCodeAcctCodeInstance

In my BGT1 template, there are these columns:

 

ParentKeyLineNumRowDetailsBudgetSysTotDebitBudgetTotCreditBudgetSysTotCreditBudgetTotDebit
NumeratorLineNumLineMemoDebSTotalDebLTotalCredSTotalCredLTotal

When I fill in the currency columns and load the templates, I do not encounter an error. However, when I fill in the local currency columns and load them, I receive the "Invalid amounts in rows" error. In the OBGT template, if I fill in the local currency and the system currency columns are filled, I do not get an error. But when I fill in the local currency in the rows as well, I still receive the same error. Please help me!

Accepted Solutions (0)

Answers (2)

Answers (2)

SonTran
Active Contributor

Hi,

The details are the same between 3 and 4 but the header are different, check and try again.

SonTran_0-1730684310054.png

Hope this helps,

SonTran

Y-Yusuf
Explorer
0 Kudos

Here are a few sample lines I would like to import: