Nav picking up shipment date from system

kamranshehzad · 2009-03-13

Hi

Gotta strange issue. I am importing in invoices using code unit/xmlport and navision is picking system date instead of work date.

Any idea.

Error :

Microsoft Dynamics NAV Classic

Shipment Date 13/03/09 is before work date 30/01/10

OK

ara3n · 2009-03-13

Are you importing the field in xmlport?

The code that defaults it is in Sales header. Have you modified it?

IF "Document Type" IN ["Document Type"::Order,"Document Type"::Invoice,"Document Type"::Quote] THEN
  BEGIN
  "Shipment Date" := WORKDATE;
  "Order Date" := WORKDATE;
END;

kamranshehzad · 2009-03-13

no I didn't. its exactly the same.

ara3n · 2009-03-13

Are you importing the field from xmlport?

Also search for "Shipment Date" in header.

Also how does your xmlport look like?

When Ever I do integrations, I always load the data into a new 50000 table, and then create orders. This way the user can fix any data that they are required and don't need to mess with the xmlfile.

kamranshehzad · 2009-03-13

Are you importing the field from xmlport?

Yes

Also search for "Shipment Date" in header.
I did it comes up as system date

Also how does your xmlport look like?

OBJECT XMLport 123456794 EE SI Import
{
  OBJECT-PROPERTIES
  {
    Date=13/03/09;
    Time=15:06:49;
    Modified=Yes;
    Version List=;
  }
  PROPERTIES
  {
  }
  ELEMENTS
  {
    { [{7F16EC80-2873-46DF-B46C-F44E1CE0D927}];  ;SalesDocuments      ;Element ;Text     }

    { [{F37B991F-B86A-4616-B30F-0FD962226E57}];1 ;SalesDocument       ;Element ;Table   ;
                                                  VariableName=<Sales Header>;
                                                  SourceTable=Table36;
                                                  SourceTableView=SORTING(Field1,Field3)
                                                                  ORDER(Ascending)
                                                                  WHERE(Field1=FILTER(2)) }

    { [{CB14F7A2-2F64-43E4-9B2C-2624C9BE703D}];2 ;DocumentNumber      ;Element ;Field   ;
                                                  DataType=Code;
                                                  SourceField=<Sales Header>::No. }

    { [{80B3FDC1-2FB3-44CF-ABCE-114AAD60C0F2}];2 ;DocumentType        ;Element ;Field   ;
                                                  DataType=Option;
                                                  SourceField=<Sales Header>::Document Type }

    { [{02C8F3B5-2923-4B6A-AA18-DBBED6888354}];2 ;CustomerOrderRerence;Element ;Field   ;
                                                  DataType=Text;
                                                  SourceField=<Sales Header>::Your Reference }

    { [{4CD9216D-A78B-4AF5-A53F-5CB517655F29}];2 ;PaymentTermsCode    ;Element ;Field   ;
                                                  DataType=Code;
                                                  FieldValidate=No;
                                                  SourceField=<Sales Header>::Payment Terms Code }

    { [{1AEF331A-8047-46DE-8B91-2CC11814DFA3}];2 ;OrderDate           ;Element ;Field   ;
                                                  DataType=Date;
                                                  SourceField=<Sales Header>::Order Date }

    { [{11B34E2A-B6A5-4537-991E-3F7B912D9E46}];2 ;PostDate            ;Element ;Field   ;
                                                  DataType=Date;
                                                  SourceField=<Sales Header>::Posting Date }

    { [{3DEC794D-CE48-4F2B-8B61-EB7153832277}];2 ;DueDate             ;Element ;Field   ;
                                                  DataType=Date;
                                                  SourceField=<Sales Header>::Due Date }

    { [{30F9DE8B-8A69-49ED-B34F-B3E040B4F458}];2 ;ShipmentDate        ;Element ;Field   ;
                                                  DataType=Date;
                                                  SourceField=<Sales Header>::Shipment Date }

    { [{C5622802-EF91-4E03-8242-1FB15F18C2D9}];2 ;LocationCode        ;Element ;Field   ;
                                                  DataType=Code;
                                                  SourceField=<Sales Header>::Location Code }

    { [{627F2639-D7F1-4CDA-89B3-B2B1B45C57B5}];2 ;ShortcutDimensionCode1;Element;Field  ;
                                                  DataType=Code;
                                                  FieldValidate=No;
                                                  SourceField=<Sales Header>::Shortcut Dimension 1 Code }

    { [{A8B4852B-548E-4FC1-82AC-32F67AD4F546}];2 ;ShortcutDimensionCode2;Element;Field  ;
                                                  DataType=Code;
                                                  FieldValidate=No;
                                                  SourceField=<Sales Header>::Shortcut Dimension 2 Code }

    { [{C02FBDCB-3930-4642-969B-DF35CEC9512C}];2 ;CustomerPostingGroup;Element ;Field   ;
                                                  DataType=Code;
                                                  SourceField=<Sales Header>::Customer Posting Group }

    { [{B7A2AE42-13FB-4CDD-932C-D4618AD8CF83}];2 ;CurrencyCode        ;Element ;Field   ;
                                                  DataType=Code;
                                                  SourceField=<Sales Header>::Currency Code }

    { [{00625CB1-D0F3-4280-AA22-4BE080290ACD}];2 ;SalesPersonCode     ;Element ;Field   ;
                                                  DataType=Code;
                                                  SourceField=<Sales Header>::Salesperson Code }

    { [{E8EC9246-6235-4875-9108-605832C20EC3}];2 ;VATRegNo            ;Element ;Field   ;
                                                  DataType=Text;
                                                  SourceField=<Sales Header>::VAT Registration No. }

    { [{B54B784F-9E10-4BB0-A8D8-54F34A309AF7}];2 ;SellToCustomerNo    ;Element ;Field   ;
                                                  DataType=Code;
                                                  SourceField=<Sales Header>::Sell-to Customer No. }

    { [{E5EFC106-B341-42EB-B798-58D17FC01957}];2 ;GenBusPostingGroup  ;Element ;Field   ;
                                                  DataType=Code;
                                                  FieldValidate=No;
                                                  SourceField=<Sales Header>::Gen. Bus. Posting Group }

    { [{E43A232E-CCDA-4265-988D-933D6B81555C}];2 ;VATCountryRegionCode;Element ;Field   ;
                                                  DataType=Code;
                                                  SourceField=<Sales Header>::VAT Country/Region Code }

    { [{84FBBB73-585C-47C9-8991-162E7B2DE0B4}];2 ;DocumentDate        ;Element ;Field   ;
                                                  DataType=Date;
                                                  SourceField=<Sales Header>::Document Date }

    { [{8101C5C6-9CFB-4EF8-B28C-6FD2E79F1897}];2 ;VATBusPostingGroup  ;Element ;Field   ;
                                                  DataType=Code;
                                                  FieldValidate=No;
                                                  SourceField=<Sales Header>::VAT Bus. Posting Group }

    { [{022242A0-E2E9-425B-BA9D-B33FA1798065}];2 ;ERPDocID            ;Element ;Field   ;
                                                  DataType=Integer;
                                                  SourceField=<Sales Header>::ERPDocID }

    { [{3049EDBA-F7CA-436A-86E1-CA136A42FDD0}];2 ;LineItems           ;Element ;Table   ;
                                                  VariableName=<Sales Line>;
                                                  SourceTable=Table37;
                                                  SourceTableView=SORTING(Field1,Field3,Field4)
                                                                  ORDER(Ascending)
                                                                  WHERE(Field1=FILTER(2));
                                                  LinkFields=Field3=FIELD(Field3);
                                                  LinkTable=<Sales Header> }

    { [{B2D77346-04D0-4F50-A3BB-17D38DEF21BB}];3 ;LineDocType         ;Element ;Field   ;
                                                  DataType=Option;
                                                  SourceField=<Sales Line>::Document Type }

    { [{15447070-3B36-4CB1-B6F6-44C00F04F7BD}];3 ;DocumentNo          ;Element ;Field   ;
                                                  DataType=Code;
                                                  SourceField=<Sales Line>::Document No. }

    { [{B88B408F-25AE-4418-B5F5-45214789E003}];3 ;LineNo              ;Element ;Field   ;
                                                  DataType=Integer;
                                                  SourceField=<Sales Line>::Line No. }

    { [{991F1AC2-9D97-4463-8F45-7BB486959149}];3 ;BillToCustomerNo    ;Element ;Field   ;
                                                  DataType=Code;
                                                  SourceField=<Sales Line>::Sell-to Customer No. }

    { [{4DA03DAF-4AE8-4184-BBCE-E5AB158961FA}];3 ;LineItemType        ;Element ;Field   ;
                                                  DataType=Option;
                                                  SourceField=<Sales Line>::Type }

    { [{7B741589-79FD-4535-95C8-C5F9076695CA}];3 ;ItemNumber          ;Element ;Field   ;
                                                  DataType=Code;
                                                  SourceField=<Sales Line>::No. }

    { [{E18AE688-8DFB-4CE4-9571-FA36128D6050}];3 ;LocationCode        ;Element ;Field   ;
                                                  DataType=Code;
                                                  SourceField=<Sales Line>::Location Code }

    { [{B9CEFC80-3382-40AF-A498-FDBEF9D9CA79}];3 ;PostingGroup        ;Element ;Field   ;
                                                  DataType=Code;
                                                  SourceField=<Sales Line>::Posting Group }

    { [{D9A6A848-4393-4451-85F1-F529A88945EC}];3 ;ShipmentDate        ;Element ;Field   ;
                                                  DataType=Date;
                                                  SourceField=<Sales Line>::Shipment Date }

    { [{7EA64F5A-0EF7-4ECA-8E6D-7AA4F1437C14}];3 ;Quantity            ;Element ;Field   ;
                                                  DataType=Decimal;
                                                  SourceField=<Sales Line>::Quantity }

    { [{A722CBAC-EC67-451F-91A3-D824236956CD}];3 ;UnitPrice           ;Element ;Field   ;
                                                  DataType=Decimal;
                                                  SourceField=<Sales Line>::Unit Price }

    { [{88148823-B0CE-4CBA-BE6C-62CFDEF151D3}];3 ;UnitCostLCY         ;Element ;Field   ;
                                                  DataType=Decimal;
                                                  SourceField=<Sales Line>::Unit Cost (LCY) }

    { [{0BF605F5-36F0-4EA4-96D7-F1E77FC36C7E}];3 ;ShortcutDimensionCode1;Element;Field  ;
                                                  DataType=Code;
                                                  FieldValidate=No;
                                                  SourceField=<Sales Line>::Shortcut Dimension 1 Code }

    { [{2BE59EBA-574A-4768-AE1B-575B15834396}];3 ;ShortcutDimensionCode2;Element;Field  ;
                                                  DataType=Code;
                                                  FieldValidate=No;
                                                  AutoCalcField=Yes;
                                                  SourceField=<Sales Line>::Shortcut Dimension 2 Code }

    { [{FFE717CF-7113-4422-916B-C0C4B81E12A6}];3 ;GenBusPostingGroup  ;Element ;Field   ;
                                                  DataType=Code;
                                                  FieldValidate=No;
                                                  SourceField=<Sales Line>::Gen. Bus. Posting Group }

    { [{B256ADBF-245C-4744-BCCB-50EAD506EB80}];3 ;GenProdPostingGroup ;Element ;Field   ;
                                                  DataType=Code;
                                                  FieldValidate=No;
                                                  SourceField=<Sales Line>::Gen. Prod. Posting Group }

    { [{5AC55EB4-DC36-481D-AAD5-B0DC67C5637F}];3 ;VATBusPostingGroup  ;Element ;Field   ;
                                                  DataType=Code;
                                                  FieldValidate=No;
                                                  SourceField=<Sales Line>::VAT Bus. Posting Group }

    { [{745392CB-491E-4A9F-95A7-8FFC1DF49602}];3 ;VATProdPostingGroup ;Element ;Field   ;
                                                  DataType=Code;
                                                  FieldValidate=No;
                                                  SourceField=<Sales Line>::VAT Prod. Posting Group }

  }
  EVENTS
  {
  }
  REQUESTPAGE
  {
    PROPERTIES
    {
    }
    CONTROLS
    {
    }
  }
  CODE
  {
    VAR
      PO@1000000000 : Record 38;

    BEGIN
    {
      // Test Version 0.1
    }
    END.
  }
}

When Ever I do integrations, I always load the data into a new 50000 table, and then create orders. This way the user can fix any data that they are required and don't need to mess with the xmlfile

Yes its a good idea but its my first implementation and I have not got much time to change the flow.

its just the work date on chronus is ahead the system date. I hope it will not cause a major issue in deployment.

ara3n · 2009-03-13

You are importing it from the xml file. So what is the date in xml file?

You need to pay attention to sequence of triggers. OnInsert Trigger is run last so it will run the code I mentioned. Turn on the debugger and put some breakpoint on insert trigger.

kamranshehzad · 2009-03-13

yes reading straight from xml file.

its work date in xml file.

ill try to debug on insert triggers and see how it goes.

regards

Nav picking up shipment date from system

Answers

Categories