Supply chain | Supply Chain Management, Commerce

RECEIVING: How to receive (scan) using MFG part number, not our item number?

(0) Share

Report

Posted on by Michael D365

SITUATION

When receiving products from a MFG, we need to scan their bar / QR code to receive
Many vendor part numbers are the same as our part numbers

ISSUE

During receipt / scan, D365 appears to default to receiving our part number, rather than the MFG part number.

QUESTION

For Receiving,

1) how can I tell D365 to prefer MFG part number, rather than ours?

2) Can I do this on an item by item basis (or based on some item attribute)?

3) Same question for picking, and could I choose a different approach for picking (receive using mfg part number, pick using our part number)

Thanks in advance!

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Danny Bilodeau 4,918 Super User 2025 Season 2 on at

Like (0)

Report

Hello Michael D365,

For receiving you can use any of the following fields:

- Item ID (obviously)

- External number for the vendor (defined on the item using the "external number" table)

- Bar code - from Item

- GTIN - from Item

- Item search name

So if a ny of these fields include your MFG number, you can scan it and work with it. I believe that if using the Vendor External number, that number can only be used for PO receiving (since you would need to know the Vendor ID to relate the External number to your Item IDne).

Do you know teh content of teh QR Code. If it is a GS1 QR code, you could use the vendor or manufacturer GTIN. With the new feature for GS1 Bar code you could configure an Application Identifier to be able to isolate the GTIN and use it everywhere just like your own Item Id.

Was this reply helpful? Yes No
Michael D365 45 on at

Like (0)

Report

Good morning, I haven't found content on it, and don't fully understand the config for it, but our VAR says the scanning logic looks FIRST for a matching item number, THEN at the external vendor item number.

For example:

- if we have a part 123 with a vendor part of 456,

- and we have ANOTHER part 789 with a vendor part of 123

when we are receiving vendor part 123, D365 will think it's our part 123 (which it's not).

I confess, again, I don't understand the bar code (gs-1 or otherwise) setup.

Was this reply helpful? Yes No
Suggested answer

Danny Bilodeau 4,918 Super User 2025 Season 2 on at

Like (1)

Report

Hello Michael D365,

The scenario you painted is accurate. D365 will first look at the Item number before looping through the other numbers to find a match. So in the case of 123, it will detect your item number rather than your 789. I expected that not finding 123 on the PO it would have then looked for 123 in the external number for that vendor and return with 789, but confirmed by testing that it is not looking further than 123 and giving an error that the item is not on the PO :(

It would be worthwhile to find out what is the protocol used for your manufacturerès QR code. It will likely be a GS1 code and which normnally includes the vendor's GTIN. With that in mind, I tested using the GTIN and it worked.

Here are the Items I used for testing. I highlighted where the GTIN would be configured:

Here is the GTIN i used (because of barcdoe format used it has a lot of leading 0 followed by 456):

Here is after scanning the GTIN during PO reception:

For good measure, I created a new item 00000000000456 to validate whether the system uses teh Item number before the GTIN and I got the error that the item is not on the PO. So again, it did not go any further that the item id.

.

So basically, you have to either:

- Change the sequence system used for interpreting the canned number ; or

- Make sure that your item id is different from the Vendor External Number or GTIN so that the system does not confused with Item ID (preferred).

I would suggest using GTIN (or barcode) as that code will be readable outside of the context of receiving a PO (where vendor is known).

Hope that helps!

Rehatds,

Danny

Was this reply helpful? Yes No
Suggested answer

Mehdi AMRANI 1,422 on at

Like (3)

Report

Hi Michael D365,

It’s a known issue especially when vendors are not using GS1 standards for there barcodes.

We have faced the same issue some client, and we add and extension with a parameter on the mobile menu item to say when scanning a barcode what are the first table to look into (In your case it would be the barcodes tables then it will look in the barcode table if there is a match it will see the related Itemid.

Kind Regards,

Was this reply helpful? Yes No