Small and medium business | Business Central, N...

Negative Customer Cost

(0) Share

Report

Posted on by O3I

Hi Gurus!

I'm running into an issue with my Business Central instance. We setup resources that includes a unit cost and a unit price. See example below:

But on a customer card, the Cost ($) has a negative amount. See below:

6036.customercard.png

When I look up the Item Ledger Entries and Resource Ledger Entries this is what I get.

4201.resource.PNG

I'm a bit confused on why the cost is negative. I thought that the Unit Cost on the Resource card is the amount incurred by our company.

Thank you,

Your help is appreciated

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Renato Fajdiga 1,853 on at

Like (0)

Report

Hi,

this can be due to posted credit memos if you have some for your customers where they will put your cost to a negative amount.

Best regards,

Renato.

Was this reply helpful? Yes No
O3I 60 on at

Like (0)

Report

Thank you Renato,

I checked my Posted Service Credit Memos as well as my Posted Sales Credit Memos and did not see any for this customer.

Was this reply helpful? Yes No
Suggested answer

Renato Fajdiga 1,853 on at

Like (0)

Report

Hi,

now I see, you are using Service Orders :). When you post consumption of some resource in the ledger entry it will be posted as a positive cost.

On the customer side, you will have a total cost in negative amount for that cost until you post the invoice for that service order. After you post the invoice from the service order it will balance this amount to 0.

In my picture above first I post the usage of Linda for my customer and I get a negative total cost on my customer card. After that, I post the invoice (sale) from my service order and this cost is now 0 on my customer.

Was this reply helpful? Yes No
O3I 60 on at

Like (0)

Report

Thank you Renato,

I'm a bit confused on why the cost would be 0 after invoicing.

Wouldn't there be a cost incurred on my end from using that resource?

Example: It costs me $45/hr to dispatch a service technician from my company, I make $165/hr. If I allocate 1 hour on a Service Order for a customer, ship and invoice the resource. Wouldn't the cost be $45 and the sales amount be $165, therefore the total would be $120?

Was this reply helpful? Yes No
Suggested answer

Renato Fajdiga 1,853 on at

Like (0)

Report

Hi,

this maybe can be a bug, I just show you how it becomes 0 and how it becomes negative. What I see on one my example is that on the Statistics page on the Customer card there is correct cost, profit based on transactions.

Best regards,

Renato

Was this reply helpful? Yes No
O3I 60 on at

Like (0)

Report

Hello,

I am still running into this issue.

The cost is a negative amount on the customer page.

Do I have to invoice the customer if it is a consumption? If so, how do I do that?

Much appreciated!

Was this reply helpful? Yes No