Portal | Homepage | Blog

PAM- Supplier Reorder Field

Hi,

New users here, just installed some of the Nitrosell software and we have Retail Management Hero as our EPOS.

Just wondering is there a way to get Supplier Reorder Numbers in PAM.

All our images that we get from our suppliers have the supplier reorder number as their file name. If there was a Supplier Reorder field it would make pulling these images into PAM so much easier.

Maybe there is a simple solution but as I said I’m a completely new user.

Thank,

David

Hi David,
We’re using RMH & NitroSell too, and I’m well used to digging around the guts of RMS/RMH after years of exploring.

How are you recording the number in RMH, or are you doing so yet?

Regards, Gareth

Hi Gareth,

We are recording the number in the Purchase section of an item, please see attached .

Regards,

David

1 Like

I’m not sure that field can be brought into PAM, but it can definitely be brought into field mapping.

The data you need is stored in [SupplierList].[ReorderNumber].

The [SupplierList] table holds information about specific Product<>Supplier relationships, where [SupplierList].[ItemID] is the unique identifier of the product (which will match [Item].[ID] from the table where most product information is stored) and [SupplierList].[SupplierID] is the unique identifier of the supplier (which will match [Supplier].[ID] from the table where general information about the supplier is stored, and should match [Item].[SupplierID] from the table where most product information is stored IF they are the primary supplier).

The best way to proceed will very much depend on how accurate your data is, and whether you always have images for product where there is a valid [ReorderNumber], but if you raise a ticket I’m sure the support guys will be able to advise you.

Regards, Gareth

NB - each of the [ID] fields above is an internal numerical reference in the respective database table, and is NOT a value you can see in RMH or should ever edit.

1 Like

Hi Gareth,

Thanks a million for your help, really appreciate it.

I will open a ticket in relation to this issue and hopefully they can help me with this issue.

Regards,

David