Hi! We noticed the update in sales invoice batch create with multiple lines from single cell with line breaks to population of multiple columns for each line. We normally have thousand of sales transaction per month and the no. of items sold per transaction differs. This is where making batch crea…

If you want line Items to be under one another you can use Transpose in Excel when copying & pasting the values then use Transpose again when you are done. You would get something like this that is easier to work with when entering line items. [image] There are some issues with this approach so …

it added blank line and increase the size of database

Your link to a PDF was deleted because it was a security risk to others. Illustrate with screenshots.

[image] Please check the images

That is exactly what I would have expected. Blank lines entered manually are records in the database. Blank columns in Batch Create are effectively the same thing, so they produce blank lines.

werent blank lines eleminated before ? [image] Ghost lines in batch create When I batch create multiple transaction with different line counts – suppose 1 transaction has 2 lines and all others have 1 line; those transactions which are supposed to have 1 line only now ha…

What version of Manager are you using @vrushabh ?

[image] Genti_Ge: werent blank lines eleminated before ? That was a different issue, where blank lines were being inserted spontaneously. @vrushabh referred to inserting a spreadsheet template for Batch Create with unused (but present) lines, which therefore appeared as blanks.

No it’s the same issue. Batch create can be used to create transactions with different number of lines when entered correctly in a version of Manager without a bug.

I am using 22.10.27.462 in this version and it is fine and blank lisne issue is not there

Batch Creating Invoice with Multiple Lines Per Transaction

Genti_Ge May 29, 2023, 9:11pm 13

werent blank lines eleminated before ?

Topic		Replies	Views
Column count of batch create/update	20	640	March 23, 2023
Batch Create Sales Invoice Multiple Lines	14	2023	January 18, 2023
Batch Create	3	350	November 17, 2022
Batch Receipts and Payments with Multiple Lines and Inventory	7	1206	January 18, 2023
Batch update,create not working	7	402	January 27, 2024

Batch Creating Invoice with Multiple Lines Per Transaction

Related topics