cancel
Showing results for 
Search instead for 
Did you mean: 

DTW Opening Balance for Itemmaster

former_member312729
Active Contributor
0 Kudos

Dear All,

I am trying to load opening balance for item master with  respect to Batch data through dtw, but i couldnt error message cannot add row  without complete selection of Batch/ Serial data.I have attached my template. Regarding this i have checked the related threads and sap business one notes .

Regards:

Balaji.S

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Balaji,

How many line items you have it in your list?

Also How many batch no's?

If it is less, better go with Inventory Opening balance form and copy the entries in to it.

former_member312729
Active Contributor
0 Kudos

Hi Ranjith,

I have more than 3000 line item and batch varies.

Regards:

Balaji.S

former_member312729
Active Contributor
0 Kudos

Hi Friends,

My SAP VERSION 9.1 , dtw according to this version.

Screen Shot

Former Member
0 Kudos

Hai,

Better Using Direct excel import option.

Use SAP B1 9.1 Features to import Item Opening Balance.

Inventory-->Inventory Transactions--> Inventory Opening Balance.

Copy Data From Excel & Paste in Grid Level & Post the transaction.

Compare DTW, Excel Import easiest way to import OB Datas

Former Member
0 Kudos

Hai,

Prepare Excel As per SAP Transaction Screen.

Like

Item No           Whse                OB QTY             Price

& Then Import.

Batch/Serial Number Also able to import in SAP B1 9.1

former_member312729
Active Contributor
0 Kudos

Hi Mohamed ,

I able to import inventory opening balance through Sap Transaction. But  my requirement through DTW  in order to  import certain attribute with batch data and this is applicable only through DTW.

Regards:

Balaji.S

former_member312729
Active Contributor
0 Kudos

Hi Friends,

Any solution regarding this discussion.

Regards:

Balaji.S

Former Member
0 Kudos

Attach your template here

former_member312729
Active Contributor
0 Kudos

Hi Bharathiraja,

Thanks for response i have attached my template.

Regards:

Balaji.S

Former Member
0 Kudos

Hi,

Check the attached file format and change your template according to that. Attached template is working fine in my DB

former_member312729
Active Contributor
0 Kudos

Hi Bharathi raja,

My file also looks similar .

In batch template if i had Baselinenum  value 0 . Error message Argument must be greater than zero

if i kept 1 then error message cannot add row without complete selection of batch/serial .

Regards:

Balaji.S

Former Member
0 Kudos

Hi,

But No of columns in my template differs from your template.

Note:Don't delete any columns in standard template.

former_member312729
Active Contributor
0 Kudos

Hi Bharathiraja

Thanks For reply , i hadn't deleted any column.  I am using Opening balance template. Still i am facing the issue

Regards:

Balaji.S

Former Member
0 Kudos

Hi Balaji,

In my template I gave Admission Date, Warehouse Location Code,etc. Fill those column and try it.

former_member312729
Active Contributor
0 Kudos

Dear Bharathi raja,

Thanks for your time, I tried with loading with admission date, location. Once again i tried as per your suggestion. Still issue.

Regards:

Balaji.S

former_member312729
Active Contributor
0 Kudos

Dear Bharathi Raja,

In your template IGN1 What are the values 25 1 refer for which field.

Regards:

Balaji.S

Former Member
0 Kudos

Hi,

25 is Unit Price and 1 is Warehouse Location code

former_member312729
Active Contributor
0 Kudos

Thanks Bharathi Raja,

  I tried with inventory opening balance template not loading since it shows successful at run simulation and fails at actual. Also it doesn't generate UDF fields.

Regards:

Balaji.S

rajesh_khater
Active Participant
0 Kudos

How are you able to import Opening Balance with zero price? I think SAP does not allow it?

Former Member
0 Kudos

Hi,

Your SAP B1 Version ??

Former Member
0 Kudos

Hi Balaji,

Post the screen shot of your template

0 Kudos

Hi,

Please check your receipt quantity and Batch quantity should be same