Newbie question - Import Sales Lines and Sales Headers

For both!
In dataport DataItemTable = 36, but set table 37 as a global variable.

and the input file looks like this:


50076 11/17/06 283676/7004 PICKUP WALLACE HARDWARE 5050 S.
CROCKETT PKWY XXXXXXXXXX TN 37813 53917 2 DA
0 0 0 0 1 Item
50076 11/17/06 283676/7004 PICKUP WALLACE HARDWARE 5050 S.
CROCKETT PKWY XXXXXXXXXX TN 37813 53917 2 DA
10000 FS4 100 100 .00000 2 Item
50076 11/17/06 283676/7004 PICKUP WALLACE HARDWARE 5050 S.
CROCKETT PKWY XXXXXXXXXX TN 37813 53917 2 DA
20000 130 400 400 .00000 2 Item

As you can see type 1 and type 2 has same number of fields so I can define dataport fields, using variables, and assign them to the proper table fieldname based on type.

note you can use one dataport for sales header & lines

the data file just needs a space

First part of your text file will be the headers

Sales invoice Header.....
Sales invoice Header.....
Sales invoice Header.....
<space> it's actually changeable using the DataItemSeparator property but it makes it look cleaner
Sales invoice lines.....
Sales invoice lines.....
Sales invoice lines.....

You can see the one we use here :
http://savatage99.googlepages.com/Sales ... Import.doc

When you post a sales order or invoice the infomations is transfered to the sales invoice header table and sales invoice line table.

So you don't or probably can't import anything into these tables!

here is a small sample dataport that you can use as a guide

it's # is 50013 Just import the fob file
http://savatage99.googlepages.com/Sales ... Import.fob

& Sample Datafile
http://savatage99.googlepages.com/test.txt

just edit the test.txt file with some of your own item#'s
just replace 31035,31040,31050 with your #'s
& change 1111 to a customer # of your own

OBJECT Dataport 50013 Import Item Info-Sale Orders
{
  OBJECT-PROPERTIES
  {
    Date=01/17/07;
    Time=[ 7:56:22 PM];
    Modified=Yes;
    Version List=;
  }
  PROPERTIES
  {
    OnPreDataport=BEGIN
                    OrderCount := 0;
                  END;

    OnPostDataport=BEGIN
                     CurrFile.CLOSE;
                     IF CONFIRM(text0001,TRUE,OrderCount) THEN
                     ERASE(CurrDataport.FILENAME);
                   END;

  }
  DATAITEMS
  {
    { PROPERTIES
      {
        DataItemTable=Table36;
        OnAfterImportRecord=BEGIN
                              VALIDATE("Sales Header"."Sell-to Customer No.");
                            END;

      }
      FIELDS
      {
        {      ;     ;"Document Type"      }
        {      ;     ;"No."               ;CallFieldValidate=Yes }
        {      ;     ;"Sell-to Customer No.";
                                           CallFieldValidate=Yes }
      }
       }
    { PROPERTIES
      {
        DataItemTable=Table37;
        OnAfterImportRecord=BEGIN
                              "Sales Line".VALIDATE("No.");
                              "Sales Line"."Qty. Ordered" := Doc_Qty;
                              "Sales Line".Quantity := Doc_Qty;
                              "Sales Line".VALIDATE("Qty. Ordered");

                              OrderCount := OrderCount + 1;
                            END;

      }
      FIELDS
      {
        {      ;     ;"Document Type"      }
        {      ;     ;"Document No."       }
        {      ;     ;Type                 }
        {      ;     ;"Line No."           }
        {      ;     ;"No."                }
        {      ;     ;Doc_Qty              }
      }
       }
  }
  REQUESTFORM
  {
    PROPERTIES
    {
      Width=9020;
      Height=3410;
    }
    CONTROLS
    {
    }
  }
  CODE
  {
    VAR
      Doc_Qty@1000000000 : Integer;
      text0001@1000000001 : TextConst 'ENU=%1 Items Imported / Would You Like To Delete The File?';
      text0002@1000000002 : TextConst 'ENU=Item %1 is Blocked';
      OrderCount@1000000003 : Integer;

    BEGIN
    END.
  }
}

I just noticed I use ("Qty. Ordered");

this is a mod of ours you'll probably have to change it to just "Quantity"

Ilona wrote:

Iselect customer, select GL Account with number 8030, type a discription, quantity =1, unit price excl VAT, and a not standard field called Kostenplaats.

in the sample datafile - you need to change the line file "Item" to "G/L Account" and change the item # to your g/l #

couberpu wrote:

This is cool! I did not know the proper way before, now I do. This Is so cool!!!
I learn something new everyday.
\:D/

I'm glad it helped it's not so hard after you play around with it a few times.
Note if you change "Invoice" to "Order" it's now a sales order.

are you talking about the sample dataport fob & sample datafile I posted?

It works try it with the instructions for slight changes you need to make.

You'll see that it creates a sales invoice. once you got that going we can make changes to fill you needs

Ilona wrote:

No, I'm talking about the mine.

The dimensions code 1 error is solved now. I removed the checkmark for calculate field.

But now I'm back at the beginning, nothing happes while importing. I'm not running in the designer.

Please check if you have INIT; in your
Sales Header - OnBeforeImportRecord()

and also check the "Autosave","Autoupdate" and "Autoreplace" properties.

IF you see the code in my example, I have "Sales Line".INIT under type 2. You need to do this in BeforeImportData to init sales header when you using dataport to import sales header data.

You might want to change the "FieldStart Delimiter", "Fieldend Delimiter" and "Field Separator" if the dataport did not read the imported data correctly.

That is what I could see in your dataport.

Good Luck!