# Batch Create Journal with Description Line Enabled

**URL:** <https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397>\
**Category:** Uncategorized\
**Created:** [September 19, 2024, 10:48pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397 "2024-09-19T22:48:22Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![wdavis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wdavis/32/51798_2.png) [@wdavis](https://forum.manager.io/u/wdavis)\
**Post date:** [September 19, 2024, 10:48pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397/1 "2024-09-19T22:48:22Z")

</div>

I’m batch creating journals w/ descriptions on the line, but I still have to edit the journal and check the “Column — Description” to actually show the description line. Is there a way to enable this column using the batch create upload?

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [September 19, 2024, 11:10pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397/2 "2024-09-19T23:10:48Z")

</div>

Welcome to the forum @wdavis

The Copy to Clipboard button you see when trying to `Batch create` doesn’t expose all available columns, it only shows required and common columns.

If you want to see the field name for a checkbox, use `Batch update` and select a transaction that has the box checked and then Copy to Clipboard.

This will get you the column you want.

---

<div class="post-metadata">

**Author:** ![wdavis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wdavis/32/51798_2.png) [@wdavis](https://forum.manager.io/u/wdavis)\
**Post date:** [September 20, 2024, 2:50pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397/3 "2024-09-20T14:50:01Z")

</div>

Hi,

Thanks for the info, but i used the Batch Update/Copy to clipboard on an existing journal. The only field I see that seems pertinent is “HasLineDescription”. The value is “TRUE”. I set this field value to “TRUE” in my Batch Create, but I still have to open the journal and check the box regardless to get the line descriptions to show.

Any additional advice, or resolution?

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [September 20, 2024, 3:18pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397/4 "2024-09-20T15:18:54Z")

</div>

I can’t reproduce your issue. It’s working fine for me.

Please provide more information like:

- A screenshot of `Batch create` Preview screen
- A screenshot of your spreadsheet used for batch create
- The data type for the value “True”, i.e. text or boolean
- The Version and Edition of Manager

---

<div class="post-metadata">

**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\
**Post date:** [September 20, 2024, 3:36pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397/5 "2024-09-20T15:36:41Z")

</div>

This is a clear example of not providing enough data/information. As a new user you are recommended to read the [FAQ - Manager Forum](https://forum.manager.io/faq) . Except for the developer we are all users like you and to help each other you are kindly asked to:

> **Be specific.** Do not just tell us a feature does not work. Explain what you have done and why you think there is an issue. If your question relates to an apparent software problem (rather than an accounting topic), tell us your operating system (including the version), Manager edition (desktop, server, or cloud), and exactly what you think is wrong. If possible, post screen shots illustrating the problem.

Your first post was ok, but your follow-up one should provide much more details. Thanks.

---

<div class="post-metadata">

**Author:** ![wdavis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wdavis/32/51798_2.png) [@wdavis](https://forum.manager.io/u/wdavis)\
**Post date:** [September 20, 2024, 3:37pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397/6 "2024-09-20T15:37:23Z")

</div>

```auto
Date	Reference	Currency	ExchangeRate	ExchangeRateIsInverse	Narration	Lines.1.Item	Lines.1.InventoryLocation	Lines.1.Account	Lines.1.BankOrCashAccount	Lines.1.AccountsReceivableCustomer	Lines.1.AccountsReceivableSalesInvoice	Lines.1.BillableExpenseCustomer	Lines.1.BillableExpenseSalesInvoice	Lines.1.AccountsPayableSupplier	Lines.1.PurchaseInvoice	Lines.1.WithholdingTaxPayableSupplier	Lines.1.CapitalAccount	Lines.1.SubAccount	Lines.1.Employee	Lines.1.SpecialAccount	Lines.1.FixedAsset	Lines.1.IntangibleAsset	Lines.1.ExpenseClaimPayer	Lines.1.Investment	Lines.1.LineDescription	Lines.1.Qty	Lines.1.Debit	Lines.1.Credit	Lines.1.CurrencyAmount	Lines.1.TaxCode	Lines.1.Project	Lines.1.Division	Lines.2.Item	Lines.2.InventoryLocation	Lines.2.Account	Lines.2.BankOrCashAccount	Lines.2.AccountsReceivableCustomer	Lines.2.AccountsReceivableSalesInvoice	Lines.2.BillableExpenseCustomer	Lines.2.BillableExpenseSalesInvoice	Lines.2.AccountsPayableSupplier	Lines.2.PurchaseInvoice	Lines.2.WithholdingTaxPayableSupplier	Lines.2.CapitalAccount	Lines.2.SubAccount	Lines.2.Employee	Lines.2.SpecialAccount	Lines.2.FixedAsset	Lines.2.IntangibleAsset	Lines.2.ExpenseClaimPayer	Lines.2.Investment	Lines.2.LineDescription	Lines.2.Qty	Lines.2.Debit	Lines.2.Credit	Lines.2.CurrencyAmount	Lines.2.TaxCode	Lines.2.Project	Lines.2.Division	Lines.3.Item	Lines.3.InventoryLocation	Lines.3.Account	Lines.3.BankOrCashAccount	Lines.3.AccountsReceivableCustomer	Lines.3.AccountsReceivableSalesInvoice	Lines.3.BillableExpenseCustomer	Lines.3.BillableExpenseSalesInvoice	Lines.3.AccountsPayableSupplier	Lines.3.PurchaseInvoice	Lines.3.WithholdingTaxPayableSupplier	Lines.3.CapitalAccount	Lines.3.SubAccount	Lines.3.Employee	Lines.3.SpecialAccount	Lines.3.FixedAsset	Lines.3.IntangibleAsset	Lines.3.ExpenseClaimPayer	Lines.3.Investment	Lines.3.LineDescription	Lines.3.Qty	Lines.3.Debit	Lines.3.Credit	Lines.3.CurrencyAmount	Lines.3.TaxCode	Lines.3.Project	Lines.3.Division	ForTaxPurposesThisIs	ItemColumn	HasLineDescription	QuantityColumn	CustomTheme	Theme	HasJournalEntryFooters	CashTransactionForCashFlowStatementPurposes	AutomaticReference	Key
9/20/2024 FALSE	Deposit [Testin] - Testing 111e0a79-3b89-4e26-a3e7-04fd2264372d Testing Vendor Cash #33434 100.00 aadddaa2-69b5-4ee9-9ebb-4dafea645943 Testing Vendor Cash #33434 100.00 SaleOrSaleAdjustment	FALSE	TRUE	FALSE	FALSE FALSE	TRUE	FALSE		

```

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/2/b2e3a416fb8c65062c0fff8cb8411f712213ec55.png)

Version: 24.9.20.1858 [Cloud]

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [September 20, 2024, 3:49pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397/7 "2024-09-20T15:49:13Z")

</div>

I have tested the data you provided and it turns out that the value for the field `HasLineDescription` is set to FALSE.

 ![Screenshot_20240920_184638](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/7/0794f874a20a9d51eb473276b341bf898f0ede1f.jpeg)

---

<div class="post-metadata">

**Author:** ![wdavis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wdavis/32/51798_2.png) [@wdavis](https://forum.manager.io/u/wdavis)\
**Post date:** [September 20, 2024, 4:10pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397/8 "2024-09-20T16:10:43Z")

</div>

Right, but in the data string it is true. What am I missing?

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/f/ffca30cb4e1dfcd0bd2d60e81288dff5240b05fe.png)

---

<div class="post-metadata">

**Author:** ![wdavis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wdavis/32/51798_2.png) [@wdavis](https://forum.manager.io/u/wdavis)\
**Post date:** [September 20, 2024, 4:44pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397/9 "2024-09-20T16:44:31Z")

</div>

Ah, I think I found the issue. If I use Excel, format column widths, the values do not appear to line up correctly to the column. I’ll make some adjustments and report back my findings.

---

<div class="post-metadata">

**Author:** ![wdavis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wdavis/32/51798_2.png) [@wdavis](https://forum.manager.io/u/wdavis)\
**Post date:** [September 20, 2024, 4:54pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397/10 "2024-09-20T16:54:49Z")

</div>

Our external system had extra columns and didn’t push the values accordingly. Thanks @Ealfardan for validating/testing to help me identify the issue!

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [September 20, 2024, 5:39pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397/11 "2024-09-20T17:39:20Z")

</div>

I’m glad you found your solution. 🙂

I will mark this topic closed then

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [September 20, 2024, 5:39pm UTC](https://forum.manager.io/t/batch-create-journal-with-description-line-enabled/56397/12 "2024-09-20T17:39:24Z")

</div>


