Cost of Sales Amount more then Sales Amount

[Former Member]

Hi All

We have an issue at a customer where the cost of sales amount is more then the Sales amount for the month of august...for the a specific customer group.

The account balances also reflect the same.

The customer uses Advance Gl account determination and managed Items by Item Group...where each item group as their own Stock, Sales and Cost of sales account...this is managed with the rules in the advanced GL determination.

We have ran the general ledger report to see if there are any peculiar transactions, but we cant seem to see anything out of the ordinary.

Is there anything else we can check to find out where the problem lies.

Any ideas are welcome.

Thank you.

Jerusha

[Former Member]

Hi All

Thanks for the replies.

I have looked at that..and some of the item cost on the invoices are more then the price..but that still doesnt add up to the difference.

Will investigate some more...

it must be something.

[former_member186712]

Hi Jerusha,

Run this query and check the last column grossprofit .  If it's negative you have a negative profit and then see the document.

SELECT T1.[DocNum], T1.[DocDate], T0.[DocEntry], T0.[LineNum], T0.[ItemCode], T0.[Dscription], T0.[Quantity], T0.[TotalSumSy], T0.[GrssProfit] FROM INV1 T0  INNER JOIN OINV T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[DocDate] >= [%0] and T1.[DocDate] <=[%1]

Regards,

Augusto

[Former Member]

Hi,

Check Item cost (purchase or Receipt from production Entry) of concern item in inventory audit report.

since your purchase or Production Coast is more than Sales price hence cost of good sold is more than sales amount.

regards,

raviraj

[Former Member]

Hi Jerusha,

This suggests that the production cost or purchase cost is higher than the sales.

You can do the following:

• Check the item cost of these items and make a comparison with the sales amount?
• Do you have special prices for these customer group? If yes, check the price and make a comparison?
• Check if you have a separate price list for this customer which is causing this issue.

Hope this helps.

Thanks,

Joseph