Purchase invoices, Duplicate reference number

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

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

Also, all purchase invoices have the supplier’s reference. You can create a custom field for that and show it as a column. This will make it easier to find invoices


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


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

Show a screenshot of the invoice

@Humphrey_musiitwa, based on what you have shown, you entered the purchase invoice twice. You have not shown enough to tell how. In addition to the Edit screen of the invoice, show the Purchase Invoices tab list.

Hello , in my list of purchase invoices there is one invoice with purchase number 57 . But when i try to look at one of my inventory items . It inflates the number by one by showing 2 purchase invoices with reference number 57

Describing your problem without the requested screen shots does not let anyone help you.

It amazes me you have refused to show screenshots. Good luck.


Hello , in my list of purchase invoices there is one invoice with purchase number 57 . But when i try to look at one of my inventory items . It inflates the number by one by showing 2 purchase invoices with reference number 57

Please show the full edit screen of the Purchase Invoice and the Purchases Invoice tab list as requested by Tut - without any filter

As you are using Windows, please use the Windows Sniping Tool to capture and upload the screen shots
The Windows Snipping tool is available by searching for Snipping

A post was split to a new topic: Address not appearing