x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 136 subscribers
  • Views 1546 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
211
topics
418
replies
Sage Intelligence Reporting
121
topics
322
replies
HalaX3

Import BOMD Lines successful but not updating BOMs

SUGGESTED
Posted By

I was able to update BOMD with a line detail thru Usage>Import and the report indicated that the record was modified.  However, the Production BOM detail was not updated even though the properties showing that the record was modified?

  • 0
    SUGGESTED

    Possibly the BOM lines have been updated but on a different validity period so you can't see the changes. Try to empty the reference date (DATREF) to display all lines disregarding their validity dates.

  • 0 in reply to Julien Patureau

    Hello Julien

    Thank you for your answer.  Yes, the validity start and end dates in header and detail are blank in the database so I left it blank in the import table for BOMALTTYP = 2 or BOM Production Type

    I ITMREF_0 BOLALT_0 I BOMSEQ CPNITMREF BOMSHO CPNTYP LIKQTYCOD QTYRND LIKQTY BOMQTY BOMUOM BOMSTUCOE SCA BOMSTRDAT BOMENDDAT CPNOPE BOMOFS PICPRN CSTFLG XJB_FORMULA_0
    I BB-1111-5 1 I 65 C-LID-R 1 1 1 2.2727 2.2727 EA 1 2 2 1

    The Standard Script IMPBOMP is listed as (which I unable to follow):

    $ACTION
    Case ACTION
    When "IMP_OUVRE" : Gosub OUVRE
    When "EXPORT" : Gosub EXPORT
    When "EXP_OUVRE" : Gosub EXP_OUVRE
    When "IMPORT" : Gosub IMPORT
    When "IMP_TAB" : Gosub IMP_ZONE
    When "IMP_ZONE" : Gosub IMP_ZONE
    When "AP_IMPORT" : Gosub AP_IMPORT
    Endcase
    Return

    $OUVRE
    Local Integer OKCHAMP, SUPBOD

    If clalev([M:BOD1])>0 : Close Mask [BOD1] : Endif # bug 65549
    If clalev([M:BOD1])=0 : Local Mask BOD1 [BOD1] : Endif
    NOMMSK(1) = "BOD1"
    If clalev ([F:TBO]) <= 0 : Local File TABBOMALT [TBO] : Endif

    Gosub OUVRE_TEXTE
    Return

    #---------------------------------------------------------------------
    $OUVRE_TEXTE

    Gosub DECLARE_TEXTE From TRTX3IMP

    Case ACTION
    When "IMP_OUVRE" : G_IMPORT=1
    When "EXP_OUVRE" : G_EXPORT=1
    Endcase
    # textes BOM : Nomenclature Entête ( texte *71 à *78 )
    TSTCHAMP(1) ="BOH*71" : TSTCHAMP(2) ="BOH*72" : TSTCHAMP(3)="BOH*73" : TSTCHAMP(4) ="BOH*74"
    TSTCHAMP(5) ="BOH*75" : TSTCHAMP(6) ="BOH*76" : TSTCHAMP(7)="BOH*77" : TSTCHAMP(8) ="BOH*78"

    # textes BOMD : Liens de nomenclature ( texte *91 à *98 )
    TSTCHAMP(21)="BOD*91" : TSTCHAMP(22)="BOD*92" : TSTCHAMP(23)="BOD*93" : TSTCHAMP(24)="BOD*94"
    TSTCHAMP(25)="BOD*95" : TSTCHAMP(26)="BOD*96" : TSTCHAMP(27)="BOD*97" : TSTCHAMP(28)="BOD*98"

    Gosub OUVRE_TEXTE From TRTX3IMP
    Return

    #---------------------------------------------------------------------
    $EXP_OUVRE

    I really appreciate your feedback.

  • 0 in reply to HalaX3
    HalaX3 said:
    Yes, the validity start and end dates in header and detail are blank in the database so I left it blank in the import table for BOMALTTYP = 2 or BOM Production Type

    If there no validity dates on the header then there is no need to manage them on the lines. I cannot explain why you succeeded to update the record but cannot see the changes in Sage X3.

    I have noted that the second field of the grid is named BOLALT but I assume it should be BOMALT, right?

    Are you using the standard import template BOMD?

*Community Hub is the new name for Sage City