Receipt from Production upload with DTW

[Former Member]

Hi all,

Has any of you ever uploaded Receipts from Production using Data Transfer Workbench?

Do you happen to have a template that works?

(I've tried both on SAP B1 v 2007 and v 8.82)

Thanks,

[Jithink]

Dear All

Use OIGN And IGN1

In IGN1 Template use "BaseType"," BaseEntry"

Leave the item code column blank 

[Former Member]

Hi Luliana,

Did you check the solution?

Please close the thread if it is answered.

[Former Member]

Hi all,

Thank you for your replies.

I've tested your suggestions, yet it doesn't seem to work. So please have a look at the files used:

Header

DocNum	DocType	DocDate
DocNum	DocType	DocDate
1	dDocument_Items	20140114

Lines

ParentKey	LineNum	Quantity	BaseType	BaseEntry	BaseLine
DocNum	LineNum	Quantity	BaseType	BaseEntry	BaseLine
1	0	1	202	8823	0

Status for the Production order is Released.

[Former Member]

Hi,

Could you Share your screen with TV or Ammy?

If Yes please share your Password and User id.

Please mention error details which you got in DTW...

[Former Member]

Hi

You need to check Base Entry and it's line no, these two field are very essential and should be accurate when you uploading receipt from production.

[Former Member]

Well, those details are correct. I am using Base Entry with DocEntry not DocNum.

Production Order type: Standard. Status Released.

Error received when importing files: "referenced production order issue type should be manual for current item [OIGN.DocStatus][line: 1] Application defined or object-defined error65171

Item issue method is Backflush, but I don't see the point of changing the issue method.

[Former Member]

Hi,

If your Issue method Backflush then when you do the receipt from production at the time material will issue automatically.You have to check whether the item which you have mentioned in Receipt from production it's issue method should be Manual.

Is it possible to share your screen through Ammy or TV?

[Former Member]

I've tested by changing it to manual also. But it's the same.

[Former Member]

Hi,

Please share your 'receipt from production' snapshot.

[Former Member]

Hi,

Try to remove Baseline 0 instead of using 0 value put it as blank as blank and save the Line File which you used as Line template for uploading.

Now try to upload it....

[Former Member]

I tried that, but it didn't solve the problem.

Items are o issue method: backflush, and that must not be changed. Is the error only caused by that? Can you upload receipt from production in this case?

[Former Member]

Hi Luliana,

It's working at my end in both cases.

I can resolve your issue but I need your screen.

[Former Member]

Hi iulian,

If you want to import production receipt then issue method should be manual. And follow the below sample template

First you have to import issue production and then receipt. Its working for me.

Header

DocNum	DocType	DocDate
DocNum	DocType	DocDate
1	dDocument_Items	20140208

Line_Issue for production

ParentKey	LineNum	Quantity	BaseLine	BaseType	BaseEntry
DocNum	LineNum	Quantity	BaseLine	BaseType	BaseEntry
1	0	10	0	202	153

Line_Receipt

ParentKey	LineNum	Itemcode	Quantity	BaseLine	BaseType	BaseEntry
DocNum	LineNum	Itemcode	Quantity	BaseLine	BaseType	BaseEntry
1			5		202	153

Regards

Sridharan

[Former Member]

Hi Iuliana Mazilu,

To upload issue for production and receipt from production it is neccessary that your production order should be SAP sytem with status "Released" then after that use template availbale in Inventory folder OIGE and IGE1 to upload detials like issue for production.

Let say i have already created production order in SAP system for your refernce please follow the scrren shot.

Now use template as an attachement for your refernce i have completed issue for production through DTW.

You have to use same concept in "Receipt From Production" (DTW Template Path-- C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\Inventory\Inventory Transactions\Goods Receipt -IGN1 and OIGN

[Former Member]

SAP doesn't provide any template which relates to receipt from production. I will check all the data which relates to DTW

[kothandaraman_nagarajan]

Hi,

Please check this threads

Thanks & Regards,

Nagarajan