Cost of Materials on for Specific Customers

Yahoo Archive
1

The product group is changeable on the line in the sales order. We set shared parts on the sales order and can track the sales and costs to the department ( customer ) level this way.

 

We don’t have many, so currently sales changes, but I am planning a bpm to take the product group from the customer and use on the sales line.

 

Greg

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of neverunmacron@...
Sent: Wednesday, February 19, 2014 4:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Cost of Materials on for Specific Customers

 

 

Thank you Cathy. This is a big one but want to make sure that i have research all the options. But i think you are correct. thank you!

 

Claudia,

My first thought was to use the product group but that means i have to associate each part to a group in terms of sales and cogs but the part can be sold to different groups. If i am correct in this matter than i would have to create as many "identical Parts" for each product group i have.

 

Thank you for your input.

 

Jose

 

 

 


CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
2
Hello,
I want to see how people have dealt or is this a unique situation. We are in vantage 8.03.409C. We have a  lot of customer but we can brake these customers into 3 groups. 2 customers and the rest. The CFO wants to be able to show this on the Income Statement. In terms of Sales and Material Cost. He want a line for the 2 customers and another line for all other customer sales along with the corresponding material cost.

We currently break it by AR accounts linked to GL accounts but in AR>Setup>AR Accounts but this does not give me the Cost of the materials option to tie it to a GL account. I have researched and people have done it through Product Groups but i feel like it wont capture the correct cost as a part can be sold to any customer and not just specific customers.

We also know we can get the gross margin by printing the report but want to have it on the financial statements. Can i do a recurring journal entry based on the gross margin report to move it to a specific account (in terms of cost)? Any ideas i would appreciate. thanks!

Jose

3

Just adding my two cents  and maybe more –

 

This is just too complicated for an Income Statement and what are the benefits? (I am sure someone has done what you are requesting  but,  I don’t know how and would steer away from this anyway possible ).Â

 

Why  can’t supporting reports be used?

 

Like the Sales Gross Margin report – easier to modify and it include the breakdown of cost.   Customer groups are part of this report.

 

Hard to sell but, that is why we there are things like Customer Groups, Product Groups, Part Class, etc – to slice and dice the data the way each department needs to see it -

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of neverunmacron@...
Sent: Wednesday, February 19, 2014 1:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Cost of Materials on for Specific Customers

 

 

Hello,

I want to see how people have dealt or is this a unique situation. We are in vantage 8.03.409C. We have a  lot of customer but we can brake these customers into 3 groups. 2 customers and the rest. The CFO wants to be able to show this on the Income Statement. In terms of Sales and Material Cost. He want a line for the 2 customers and another line for all other customer sales along with the corresponding material cost.

 

We currently break it by AR accounts linked to GL accounts but in AR>Setup>AR Accounts but this does not give me the Cost of the materials option to tie it to a GL account. I have researched and people have done it through Product Groups but i feel like it wont capture the correct cost as a part can be sold to any customer and not just specific customers.

 

We also know we can get the gross margin by printing the report but want to have it on the financial statements. Can i do a recurring journal entry based on the gross margin report to move it to a specific account (in terms of cost)? Any ideas i would appreciate. thanks!

 

Jose

 

4

The Product Group allows unique Sales/Revenue, WIP, and COGS accounts.  Look at them and see if they will accomplish what you need.

 

Regards,

 

Claudia Stone

Aspacia Systems, Inc.

 

www.aspacia.com

 

This email, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information.  If you are not the intended recipient of this email, you are hereby notified that any disseminiation, distribution or copying of this email, and any attachments thereto, is strictly prohibited.  If you have received this email in error, please notify me by telephone and permanently delete the original, any copy of any email and any printout thereof.

 

5
Thank you Cathy. This is a big one but want to make sure that i have research all the options. But i think you are correct. thank you!

Claudia,
My first thought was to use the product group but that means i have to associate each part to a group in terms of sales and cogs but the part can be sold to different groups. If i am correct in this matter than i would have to create as many "identical Parts" for each product group i have.

Thank you for your input.

Jose