mibuso.com
Home› NAV/Navision Classic Client

Nav picking up shipment date from system

kamranshehzadkamranshehzad Member Posts: 165
edited 2009-03-13 in NAV/Navision Classic Client
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
KS

Answers

  • ara3nara3n Member Posts: 9,256
    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;
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • kamranshehzadkamranshehzad Member Posts: 165
    no I didn't. its exactly the same.
    KS
  • ara3nara3n Member Posts: 9,256
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • kamranshehzadkamranshehzad Member Posts: 165
    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.
    KS
  • ara3nara3n Member Posts: 9,256
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • kamranshehzadkamranshehzad Member Posts: 165
    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
    KS
Sign In or Register to comment.