Why am i having 2 purchase invoices with the same number? It’s affecting my quantity on hand [image]

Welcome to the forum Pkease read the guides before posting a question. Almost all queries will have answers in the guides Please use a screen shot utility, such as Microsoft Snip, to post images Your photo is not clear enough to understand your problem, sorry

It is possible to use the same reference number for two items. I don’t think Manager will prevent that in the future, it may only warn or allow users to detect duplicates. You can prevent this situation by using automatic referencing. You can set automatic referencing as default using form defaults …

I just noted you are actually looking at transactions for an inventory item. If you entered two line items for the same item, the two line items will show up with the same reference if you view the transaction history of the item.

@Abeiku , please can you tell me where to find Supplier Ref: on Purchase invoices? It is also not available in edit Columns.

Sorry, I should have shown how I did it. It is a Custom field [image] [image]

Take Note. Custom fields won’t show on Statements. if you want the supplier’s reference to show on statements, you must enter the supplier reference in the default reference field.

Maybe @Lubos should revisit merging code with name because we now have the edit column functionality and thus can decide to show or not the customer code. You created a custom field to do so but that should be redundant.

Can you explain, I don’t see how that is related to @Humphrey_musiitwa ’s issue or what I said earlier.

His issue was about double counting inventory items purchases - the topic then seemed to move into purchase invoice references, then supplier references and then display of supplier codes Soon it will move on to something even more esoteric

My issue is that I have 2 similar purchase invoices which is affecting my Quantity

Purchase invoices, Duplicate reference number

Topic		Replies	Views
Different supplier same Ref	19	392	February 24, 2024
Twice enter invoice by mistake	15	2697	December 11, 2021
Duplicate Item Code?	56	14456	May 25, 2016
Purchase Invoice Number	6	774	March 2, 2018
Duplicate Purchase Invoice Reference Number	2	61	October 25, 2024

Purchase invoices, Duplicate reference number

Related topics