cancel
Showing results for 
Search instead for 
Did you mean: 

DTW - Inventory Balances

RajuParmar
Participant
0 Kudos

HI all.

I am using SAP 2007A SP01 PL05.

I want to bring in Opening for Items based on Projects and am using te oInventoryGenEntry Template.

I have filled in the details and have also removed thousand separators.

When importing the Template i get a message

'You Cannot change the total for this document Applicatriondefined or Object-defined error65171'

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You should take out DocTotal from the file and try again. The total has to be calculated through line file by system.

RajuParmar
Participant
0 Kudos

Hi Gordon,

I have taken out the DocTotal and now i get the message 'There is a difference between the document total and its components.

[IGN1.SlpCode][line: 0]Application-defined or object-defined error65171.

I am testing only using 1 item before i populate the Template.

Former Member
0 Kudos

Have you taken out the column from the file?

RajuParmar
Participant
0 Kudos

No. the column is there. i have only removed the figure 0.7428

Former Member
0 Kudos

That is not right. I mean to delete the column altogether.

RajuParmar
Participant
0 Kudos

Hi Gordon,

i have deleted the column Doctotal and i still get the message

There is a difference between the document total and its components.

http://IGN1.SlpCodeline: 0Application-defined or object-defined error65171.

RajuParmar
Participant
0 Kudos

Hi Gordon,

I got the Issue sorted out.

I deleted the DocTotal column and also had to remove the Currecy Code from the Header.

Thanks your for your support.

Former Member
0 Kudos

Hi,

The better way to troubleshoot would be posting some of your sample data in the file here.

Thanks,

Gordon

RajuParmar
Participant
0 Kudos

Dear Gordon,

Find below sample of my data in the Template

Header:

Recordkey = 1

DocCurrency = EUR

DocDate = 20100401

DocDueDate = 20100401

DocTotal = 0.7428

Journal Memo = Opening Stocks - 01042010

Reference1 = BAL-040110

Lines:

RecordKey = 1

AccountCode = 152100000100130

Currency = EUR

ItemCode = Athena-35

ItemDesc = Athena-35

PriceAfterVAT = 0.0619

Price = 0.0619

Quantity = 12

UnitPrice = 0.0619

WarehouseCode = GradedPa

I am importing as a TXT file

Former Member
0 Kudos

Hi,

In header the doc type as 'dDocument_Items' should also be there.

Thanks,

Joseph