For whatever reason and I cannot even guess why, the position of the custom fields in Invoices keep changing and therefore end up getting complains from salesmen about the inconsistency
Attached are screen shots of two invoices created back to back after copying the data from their respective sales orders. Both orders are for the same client. Yet, the order in which the line item fields appear are different.
Are you using a custom theme? Or are Qty and Unit price columns omitted only because you have no information in them?
Can you post screen shots that show content of the line items as well as the column headings? (You might also want to edit your first post to leave out all the proprietary information in those screen shots.)
Thanks Tut, I have edited my first post to take out those information but in the process took out the invoice numbers as well. The invoice number on top is 525 and the second is 526.
In the invoice of which I have posted the image, there is no custom theme. The Qty has no info in it. The unit price is where I put the price and that translates to showing only as Amount in the Invoice … no, I did not do anything to remove unit price.
Below are the same two invoice with column headings.
This looks like it is probably a bug. I will move this topic to the bugs category.
As an experiment to help track down the origin of the problem, can you try these things one at a time?
Look at the Edit screens for both invoices to confirm whether the line item custom fields appear in the same order there or not.
Edit invoice #2018 000526 so the fourth line item is the same as in #2018000525. You can change back after determining whether that modified the order.
Temporarily edit the drivers’ names to be the same. See if that affects anything.
Temporarily edit the vehicle numbers to be the same. See if that affects anything.
Obviously, what I’m looking for is to identify what triggers the change.
Opened the two invoices in separate tabs and the order of appearance are identical.
On the Edit screen, order is: Description | Loading From | Destination | Driver Name | Vehicle No. | Vehicle Capacity | Qty | Unit price | Amount |Tax (No data in fields in italics)
On invoice 525, order is: Description | Driver Name | Loading From | Destination | Vehicle No. | Tax | Amount
On invoice 526, order is: Description | Vehicle No. | Loading From | Destination | Driver Name | Tax | Amount
Edited invoice # 000526 so the fourth line item is the same as in # 000525 but there was no change.
Edited drivers’ names to be the same as in invoice 525, but no change in display order.
Edited the vehicle numbers to be the same as in invoice 525, but still no change.
Got a freak thought and tested two more invoices and understood how to replicate the issue:
Inv 546
Basically, the custom fields seem to appearing in the invoice view based on the order in which they were entered! In invoice 546, I entered in the order that can be seen. For invoice 547, I entered based on a different order and got that second output.
