PRODUCT CODE WITH 2 CODES TO BE USED FOR DIFFERENT CUSTOMERS

Patrick_10195009 · August 2020

Hi,
I am wondering what suggestion people have as a solution for my problem.
I have the same SKU (Product XYZ500) that I sell to different customers and because of their systems they require a different product code.
1 Customer has XYZ500 - which is what I have setup
The other has 500XYZ.
I see there is a field in the Inventory Master "Sub Item". Can I set up 500XYZ to be a "Sub Item" of XYZ500 and will sales for 500XYZ then draw stock from XYZ500 or am I best to create a stock adjustment each time I want to sell 500XYZ to transfer the stock over from XYZ500?
Any suggestions from your experience would be appreciated
Thanks in Advance

Acctd4 · August 2020

Hi Patrick

Bit confused as to why you need to have different product codes for different customers …? The purpose of using an Item Code is to track the Item in your records, not theirs!

They can give it whatever code they like in their own system but you need to be able to track the buy/sell of that particular Item so it needs to have a consistent Item Code in your system to enable you to do that. Any accounting program is only as good/accurate as the information it’s given – it can’t know 2 different Items are the same.

There are a few different uses for Header/Sub Items.

Some like to group by Supplier (This is my Preference & is also useful for generating/printing a Supplier Price List too), some prefer to group by Item categories.

However you choose to format it, the crucial thing is it needs to be consistent for your Stock Item levels to be accurately maintained.

Shaz Hughes Dip(Fin) ACQ NSW, MICB

Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

Accounted 4 Bookkeeping Services

Ballajura, WA

0422 886 003

shazinoz2@bigpond.com

www.accounted4bs.com

Patrick_10195009 · August 2020

Hi Shaz,
Thanks for your reply.
The need for 2 Product codes is because the customers have different product codes set up in their system and their requirements are that the invoice must have their product code, otherwise they will reject the invoice/delivery. It is not possible for the customer to change the product code they have.
I have used other systems that allow for a product to be set up as a kit or Bill of Material, that the end product is made up of 1 or more other items. Do you know if Reckon allows for kitting or Bill of Material, because that may be one way I can get around this problem.
Thanks

PhuongDo · August 2020

Hi Patrick,

Use custom fields!

But I hope you don't have too many customers that required different product codes as at the moment you can have up to 5 custom fields for items.

So your product code can stay the same, you can setup custom field like Customer A, Customer B and it will hold the customer a's expected code and so on.

Then for each customer when you bill them, use a different invoice template. The invoice template will show the custom field code instead of your product code (item name).

And now you can send them the invoice that shows their codes.

If you have more than 5 customers who want different product codes, then let me know. I can build a custom solution for you that will work.

Hope it makes sense.

Thanks,

Phuong

Patrick_10195009 · August 2020

Thanks Phuong. I think that will do the trick.

Acctd4 · August 2020

Hi Patrick

Yes, Reckon Accounts Hosted has that feature which allows you to “Build” Assembly Items.

These are new Items comprising of other existing Items/Services from within your Item List.