Enter a valid business unit.(AP-810247) Create Invoices In Spreadsheet Second Line Ends In Error Business Unit ADFDI Does Not Allow Multi line Invoices

Issue steps

1.Select Business Unit field value on line 1.

2.Changed the header identifier on line 2 to "1"

3.Business Unit field value is not copied from line1 to line2

4.When double-click "Distribution Combinations" field in line2,system shows error.

Solutions

SOLUTION

Excel's Macros Setting is not "Enable all macros".

This is the reason why Business Unit field value on line 1 is not copied to Business Unit field value on line2 automatically

Please set Macros Settings in Excel "Enable all macros" by following steps;

1.Set Macros Settings in Excel "Enable all macros" and Close Excel

2.Re-open Excel and Select Business Unit field value on line 1.

3.Changed the header identifier on line 2 to "1"

4.Business Unit field value on line 1 is copied to Business Unit field value on line2 automatically

  and we can enter Distribution Combinations value without error.