PRODUCT CODE WITH 2 CODES TO BE USED FOR DIFFERENT CUSTOMERS
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
-
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
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
(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!)
1 -
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
0 -
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,
PhuongPhuong Do / Reckon Developer Partner
phuong@cactussoftware.com.au
1 -
Thanks Phuong. I think that will do the trick.
0 -
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
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
(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!)
0
Categories
- All Categories
- 6.7K Accounts Hosted
- 16 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 8 📢 Reckon Accounts Desktop - Announcements
- 1.5K Reckon Payroll
- 39 📢 Reckon Payroll - Announcements
- 15 Reckon Payroll Help Videos 🎥
- 28 Reckon Mate App
- 2.7K Reckon One
- 14 📢 Reckon One - Announcements
- 12 Reckon Invoices App
- 23 Reckon Insights
- 100 Reckon API
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 70 About Reckon Community