on 01-21-2014 8:24 AM
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Luliana,
Did you check the solution?
Please close the thread if it is answered.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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?
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SAP doesn't provide any template which relates to receipt from production. I will check all the data which relates to DTW
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
9 | |
5 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.