Automatically populating another table

david.weeks
david.weeks Member Posts: 96
edited 2004-02-19 in Navision Attain
I need some advice. Once a user has input a quote, another person will need to authorise this quote before they can make an order. My approach is to create a new table to hold the approval records.

Therefore, I have created a button called "confirm quote" within the quote form. I then need this to automatically populate key fields within my new table "Quote approval".

Can anyone assist me with this?
i.e. What approach do I follow to automatically populate another table once a button is clicked?

Thanks

Comments

  • Rabe
    Rabe Member Posts: 27
    Hello David,

    Option 1

    The easiest way would be to make an copy of the Sales Header / Sales Line table and the just use a tranferfields command to copy the records from one table to the other. But I have to say that this should only be done as a workaround seeing that you tend to double up on your data.
    It also depends on what information you plan to store in the additional table.

    Option 2

    I'm going on the presumption that you are using sales quotes

    Table 91 - User Table -> Add a boolean field to the user setup - "Confirm Quote". This would provide you with the abilty to insure that only certain users would be able to press the confirm button.

    Table 36 - Add a couple of fields
    Quote Confirmed - Boolean
    Confirmed User - Code 20
    Confirmed Date - Date
    Confirmed Time - Time

    CodeUnit 83 - "Sales-Quote to Order (Yes/No)" Add code to insure that if the Quote Confirmed field is not set to yes on the Sales Header that the Quote wil not be able to be processed to an order.

    On this new button "Confirm Quote" add code to check on table 91 if the current user has permission to preform this action. If the user has the correct permission mark the Quote Confirmed field on the Sales Header.

    The user,date and time field should be used to record which user and when the quote was confirmed. (Traceability)

    Hope it helps
    Best Regards
    Rabe
  • DenSter
    DenSter Member Posts: 8,307
    OR... you set user permissions on the "Release Sales Document" codeunit (number 414) and remove the code that automatically releases them. You don't always have to create new functionality :).
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories