Failed to Import Invoice

(0) Share

Report

Posted on by Community Member

Hai Dudes, I am using Microsoft Dynamics Crm 2013 for my office. I have one doubt. I am trying to import my Invoice file In crm but I got error. Then only I came to know we have to Import "Invoice Product " before Importing Invoice. Then I tried to import Invoice product in crm, I got error in that Extended amount field. Then I asked with some one about this problem. They said we cant import Extended amount. Now my doubt is once we import the "Invoice Product " and "Invoice" files it will automatically calculate the Extended amount . Am I correct or not? I am waiting for your Replies ..

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Rajkumar Rajaraman on at

Like (0)

Report

RE: Failed to Import Invoice

Hi Felish,

Refer this link. It provides the detailed explanation.

thecrmwiz.com/.../extended-amount

Hope this helps.

Regards,

R.Rajkumar

"Please mark my answer as verified if you found it helpful"

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Failed to Import Invoice

I can't understand , Kindly explained me step by step process

Was this reply helpful? Yes No
Suggested answer

purwar purwar 2,836 on at

Like (0)

Report

RE: Failed to Import Invoice

The extended amount is not a manual input. It is automatically calculated one from qty * unit price.

Then you can just manual input the unit price (if you use price overridden, otherwise CRm will calculate it by using the combination of Unit, product, and Price List (or in short word it is Price List Item))

community.dynamics.com/.../381511

community.dynamics.com/.../123202

Was this reply helpful? Yes No
Suggested answer

Rajkumar Rajaraman on at

Like (0)

Report

RE: Failed to Import Invoice

Hi felish,

You can go through Aileen's explanation for the following thread:

community.dynamics.com/.../143114

Hope this helps.

Regards,

R.Rajkumar

"Please mark my answer as verified if you found it helpful"

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Failed to Import Invoice

Yes Priyadarshi Purwar I also read that post . she also got same confusion same like me. I know that the Extended amount is not a manual Input it is calculated automatically , Now I have many old invoice File . I need to import my Invoice file . For thst what shall I do? MY main Doubt is once we import our Invoice Product File and Invoice file it will calculate the Extended amount automatically According to the quantity and unit price in Invoice product file. Am I correct or not?

Was this reply helpful? Yes No
Suggested answer

mscrmba on at

Like (0)

Report

RE: Failed to Import Invoice

You import any fields that are manually selected or input into CRM.

Any fields that are calculated in CRM (and therefore read only for a user) cannot be imported (and you should not try as your import will fail if you do).

CRM will calculate the calculated fields once the other fields are imported.

CRM will also update the calculated fields on Invoice as additional Invoice Product records are added in for that Invoice.

Was this reply helpful? Yes No
Suggested answer

purwar purwar 2,836 on at

Like (0)

Report

RE: Failed to Import Invoice

Yes , Crm will automaticaly update extended amount field. You can try to import only 1 record and check .

Was this reply helpful? Yes No
Suggested answer

Aileen Gusni 44,524 on at

Like (0)

Report

RE: Failed to Import Invoice

Felish,

Yes, CRM Will is the short answer.

You can download the template for importing the Invoice Product under the Settings -> Data Management -> Templates for Data Import.

Then you don't fill the amount, just fill the unit price, unit, product, and qty. And tax if any.

Thanks.

Was this reply helpful? Yes No