Skip to Content
author's profile photo Former Member
Former Member

Importing beginning item costs

I need to import beginning inventory costs. I found thread (importing-inventory-quantities-on-hand) which points to some helpful links, but nothing about how beginning costs get imported. Can somebody please assist? I don't want my inventory being sold at 0 cost. Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 28, 2009 at 03:59 PM

    Please check SAP Note Number: 841270 & 814125 to find right format and complete templates set.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I figured this out by simply looking at the OSRI table and reviewing the records for serial numbered transactions i had entered manually. It became clear that the sysserial number field simply increases by a value of 1 for every item/serial number combination entered in a transaction. I also noticed that the IntrSerial stores the value of the actual serial numbers.

      Once I switched my serial numbers over to the InternalSerialNumber field and left my SystemSerialNumber field empty my import was successful.

      This being the facts I have no idea why notes 841270 and 814215 indicate that the serial numbers should be stored in the systemserial number field. It's misleading and cost me hours of time.

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2009 at 06:56 PM

    If you use oInventoryGenEntry to DTW initial on hand, you would get item Last Purchase Price updated. In that way, item cost can be calculated.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Ok, thanks i did find the oInventoryGenEntry templates and filled out the Documents and DocumentLines files, but I'm getting errors on the oInventoryGenEntry import. Below is the data in my files.

      Documents (3 rows same data in each field)

      RecordKey = 1

      DocumentDate = 20090401

      Document Lines (3 rows of data)

      RecordKey = 1,1,1

      LineNum = 0,1,2

      AccountCode = _SYS000000003, _SYS000000003, SYS000000003

      ItemCode = 01689BERR, 01689COFF, 01689CHOC

      LineTotal = 100, 120, 280

      Price = 50, 60, 70

      Quantity = 2, 2, 4

      SerialNum = 9999, 8888, 7777

      Below are the 3 errors I am getting in sequence.

      Data cannot be empty in one of the tables, Doc1, Doc3, Doc10, [IGN1.LineNum][line:0]Application-defined or object-defined error oInventoryGenEntry

      [IGN1.ItemCode][line:1], 'VR - 01689BERR' Application - defined Object - defined error oInventoryGenEntry

      Data cannot be empty in one of the tables, Doc1, Doc3, Doc10, [IGN1.LineNum][line:0]Application-defined or object-defined error oInventoryGenEntry

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.