PRODUCT CODE WITH 2 CODES TO BE USED FOR DIFFERENT CUSTOMERS

Patrick_10195009
Patrick_10195009 Member Posts: 10
edited August 2020 in Accounts Hosted
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

Comments

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited 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

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Patrick_10195009
    Patrick_10195009 Member Posts: 10
    edited 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
    PhuongDo Reckon Developer Partner Posts: 314 ✭✭✭
    edited 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


    Phuong Do / Reckon Developer Partner

    phuong@cactussoftware.com.au


  • Patrick_10195009
    Patrick_10195009 Member Posts: 10
    edited August 2020
    Thanks Phuong. I think that will do the trick.
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited 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.

     

    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


    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)