Sales Invoice line custom fields

1

Hi guys,

Anyone face this issue before? I create the sales invoice line custom field, when i check on the data, it doesn’t have the unique custom field UUID, but just a general line.CustomFields, and the data display is not what i have fill up.
How the display,
image
How the excel display

image
image760×320 4.69 KB

2

Post screen shots of:

  • The Edit screen for the line-item custom field
  • The Edit screen for the sales invoice.
3

Hi @Tut ,

Sorry for late reply, please find below the edit screen.

image
image760×860 13.7 KB

image
image1271×851 42.3 KB

4

So, what exactly do you think is wrong? And what do you think you should see instead? Your earlier screen shots are only small portions of whatever you are trying to show.

5

@Tut ,
If you looking at the excel screenshot, you can see the data is not showing “A1,A2”, but it is showing the system string, so if i’m using template to batch update, i couldn’t do so.
Also, when you look at the Column Name, it is showing only “Lines.CustomFields”", by right it should be “Line.CustomFields120420s284013u” something with UUID right.

6

I honestly do not know how or why the program treats line-item custom fields differently from regular custom fields, but it does. For whatever reason, they are not the same. I suspect you are seeing the result of the difference between the two types of custom fields.

No, on this the program behaves exactly like any other multi-line invoice variable. The column headings never contain UUIDs. Look, for example, at the Lines.Item column. The heading does not contain any UUID, but in this case the cell does.

7

Hi @Tut ,

I have try to create another Custom column, below with the screenshot, also update 1 of the invoice to see how it look like at the batch update once i copy to the excel file. Seem like there is an issue with the sales invoice line custom field, because it is combine all in 1 column instead of 2 column.
Edit screen for my second column:-
image

image
image541×848 13.1 KB

image
image1333×416 20.3 KB

how it look like at excel
image
image1652×605 13.5 KB

8

I can confirm that even prior to version 21.6.39 and upto/including the latest version (21.6.50) if you Edit a record and hit update then if you try a batch Update then the Lines.CustomField column has System.Collections.Generic.Dictionary2[System.Guid,System.String]` inserted at that location.

I’m using Northwind test data and all the old data is intact unless I edit it. It does not seem to be related to if there are custom fields defined or not as I can get this to occur on most tabs where there is a batch update option. e.g. Receipts, Payments, Credit Notes, Invoices etc. but Customer and Suppliers are OK. Actually I’m not sure why when you export some data (Customers, suppliers) it contains a Lines.CustomFields column as you can not define Line item custom fields for these items anyway.

As a test I created a Line Item CustomField for Credit notes but the data does not exist in the exported spreadsheet data. If I view the API data for the item it shows up as follows:

{
  "IssueDate": "2017-07-06",
  "Reference": "1043",
  "Customer": "0d5791f3-e21f-467b-95d2-a0b873b2ec1e",
  "SalesInvoice": "6658f20d-541f-4a42-95eb-35181179327c",
  "BillingAddress": "12 Orchestra Terrace\r\nWalla Walla WA 99362\r\nUSA\r\n",
  "Lines": [
    {
      "Item": "e267dc12-65df-4d6b-a524-f732e273448b",
      "Description": "Aniseed Syrup",
      "CustomFields": {
        "1c4dea51-8ead-4036-b99a-e369a381fb4a": "1"
      },
      "Qty": 25.0,
      "UnitPrice": 10.0
    },
    {
      "Item": "257d4b97-81c8-45ff-a441-f7c42ae1973c",
      "Description": "Gumbär Gummibärchen",
      "CustomFields": {
        "1c4dea51-8ead-4036-b99a-e369a381fb4a": "2"
      },
      "Qty": 8.0,
      "UnitPrice": 31.23
    }
  ],
  "LineDescription": true
}
9

@MarkLL, as I wrote earlier, “I honestly do not know how or why the program treats line-item custom fields differently from regular custom fields, but it does.” This is something for @lubos to look at.

1 Like