Ben
When you disposition the stock at cost to the job or stock etc
It will debit inventory or wip and credit a cost of return nominal
If you includes credits in your report, you will have to include the
disposition costs too
If does present a cost of return figure in the disposition records, but
not in the credit Invched, Invcdtl records
Gary Parfrey
Dot Net IT Limited
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bbelzer42
Sent: 24 October 2006 21:11
To: vantage@yahoogroups.com
Subject: [Vantage] Gross Profit
In creating a report to show gross profit I uncovered something.
When parts are first shipped they have a cost associated. Then if
there is an RMA and the parts get issued to a job, the cost of those
parts are then added to the new job. What I show now is double
costing because Vantage doesn't issue a negative cost when the parts
arrive back.
Have I lost everyone?
Here is the example:
Parts shipped and billed: (Invoice: 1000, Cost: 900, Profit: 100)
Parts returned: (Invoice: -1000 CM)
Parts reworked and shipped: (Invoice: 1000, Cost: 900 + 100 in rework,
Profit: 0)
End results:
Invoices total: 1000
Costs total: 1900
Profit: -900
Should be:
Invoices total: 1000
Costs total: 1000
Profit: 0
The material portion is being doubled because there are no negative
costs attributed to the credit memo / RMA.
Anyone have any suggestions?
Thanks!
Ben
This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.
[Non-text portions of this message have been removed]
When you disposition the stock at cost to the job or stock etc
It will debit inventory or wip and credit a cost of return nominal
If you includes credits in your report, you will have to include the
disposition costs too
If does present a cost of return figure in the disposition records, but
not in the credit Invched, Invcdtl records
Gary Parfrey
Dot Net IT Limited
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bbelzer42
Sent: 24 October 2006 21:11
To: vantage@yahoogroups.com
Subject: [Vantage] Gross Profit
In creating a report to show gross profit I uncovered something.
When parts are first shipped they have a cost associated. Then if
there is an RMA and the parts get issued to a job, the cost of those
parts are then added to the new job. What I show now is double
costing because Vantage doesn't issue a negative cost when the parts
arrive back.
Have I lost everyone?
Here is the example:
Parts shipped and billed: (Invoice: 1000, Cost: 900, Profit: 100)
Parts returned: (Invoice: -1000 CM)
Parts reworked and shipped: (Invoice: 1000, Cost: 900 + 100 in rework,
Profit: 0)
End results:
Invoices total: 1000
Costs total: 1900
Profit: -900
Should be:
Invoices total: 1000
Costs total: 1000
Profit: 0
The material portion is being doubled because there are no negative
costs attributed to the credit memo / RMA.
Anyone have any suggestions?
Thanks!
Ben
This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.
[Non-text portions of this message have been removed]