Salesheader table creates a blank no.

bianconeri

Im trying to import invoices to salesheader table. If i import one invoice it works fine, but if i import multiple invoices then i get this error: "The Sales Header already exists. Identification fields and values: Document type='Invoice,No=''

Here is the code

IF fl.FINDFIRST THEN
REPEAT
MySalesHeader.INIT;
MySalesHeader."Posting Date" := TODAY;
MySalesHeader."Document Date" := TODAY;
MySalesHeader."Document Type" := MySalesHeader."Document Type"::Invoice;
MySalesHeader.VALIDATE("Sell-to Customer No.", fl.debet);
MySalesHeader.INSERT;
UNTIL fl.NEXT = 0;

fl is the table with the imported invoices

Any idea what is wrong here?

Thank you in advance

pawanp

bianconeri wrote:

IF fl.FINDFIRST THEN
REPEAT
MySalesHeader.INIT;
MySalesHeader."Posting Date" := TODAY;
MySalesHeader."Document Date" := TODAY;
MySalesHeader."Document Type" := MySalesHeader."Document Type"::Invoice;
MySalesHeader.VALIDATE("Sell-to Customer No.", fl.debet);
MySalesHeader.INSERT;
UNTIL fl.NEXT = 0;

You are not assigning any value to "No."

Albertvh

Try this

CLEAR(MySalesHeader);

before the INIT statement or MySalesHeader."No." := '';

Hope this helps

bianconeri

When Sales header initializes No. is automatically assigned.. increment by 1

bianconeri

I have tried CLEAR(MySalesHeader) and MySalesHeader."No." := ''

But I keep getting the same error.. Sales Header already exists.

bianconeri

Solved

Instead of typing insert I typed insert(true)

Thank for your help