Skip to Content
0
Former Member
Apr 02, 2014 at 09:41 AM

"Quantity falls into negative inventory" Error when importing Goods Receipt through DTW

498 Views

Hi,

We extending the automation between our production plant an SAP Business one.

We're using DTW import "Goods Receipt PO" currently and want to extend this to internal productions based on Production Orders.

I've created three csv files to create the import. OIGN, IGN1 an SNRT (as we use serial number based products)

Some remarks:

- The stock is sufficient to do the production. No negative stock is created by this the production order.

- The used materials are all based on "backflush", so should be handled automatically

- Using the SAP GUI everything goes well. No errors.

hereby the files I've used (the actual serial number file is of course longer):

OIGN:

DocNum;DocType;HandWritten;DocDate;PartialSupply

DocNum;DocType;Handwrtten;DocDate;PartSupply

1;dDocument_Items;tNO;20140402;Y

IGN1:

ParentKey;LineNum;BaseType;BaseEntry;BaseLine;Quantity

DocNum;LineNum;BaseType;BaseEntry;BaseLine;Quantity

1;0;202;92;;49

SRNT:

ParentKey;LineNum;InternalSerialNumber;ManufactureDate;ReceptionDate;Notes;BaseLineNumber

DocNum;LineNum;DistNumber;MnfDate;InDate;Notes;DocLineNum

1;0;0409001;20140331;20140402;Firmware=SD-TRPE v1.12 y13m10d16;0

1;1;0409002;20140331;20140402;Firmware=SD-TRPE v1.12 y13m10d16;0

1;2;0409004;20140331;20140402;Firmware=SD-TRPE v1.12 y13m10d16;0

1;3;0409005;20140331;20140402;Firmware=SD-TRPE v1.12 y13m10d16;0

....

What am I doing wrong? Do we need the handle the goods issue manually when using DTW instead of the auto backflush method in SAP?

Looking forward to your response.

Kind regards,

Vincent