Options

Idea for posting

JAYESHJAYESH Member Posts: 290
HI Experts,

This is very simple question.
I want to know what are the table effected when purchase order posting is done.

When i do customization which are the thing i have to kept in mind to follow the rules for sales posting / order posting etc. In which table the entry goes.

Thank you
JAYESH PATEL

Comments

  • Options
    AdamRoueAdamRoue Member Posts: 1,283
    Turn on the client monitor and post an order, this should list everything affected, but remember this will depend upon your configuration, if you are using warehouse then more tables will be hit
    The art of teaching is clarity and the art of learning is to listen
  • Options
    Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    When you click on "Navigate" on a posted Order, you'll see the tables where entries are created. The number of tables/records depends on various settings & type of lines (Accounts, Items, etc.).
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Options
    JAYESHJAYESH Member Posts: 290
    Thanks for the reply...
    JAYESH PATEL
  • Options
    diptish.naskardiptish.naskar Member Posts: 360
    Some more which are not shown on the navigate option..

    1. Postd document dimension and ledger entry dimension.
    Diptish Naskar
    For any queries you can also visit my blog site: http://msnavarena.blogspot.com/
  • Options
    ara3nara3n Member Posts: 9,256
    another way you can find out is this.
    Before posting. Goto->file->database->Information->tables.

    Copy it for the company you are in into excel.
    Post the transaction.
    Go back to the table list and copy it into excel.

    Compare the number for records that are different. That'll give all the tables that have inserts or deletes.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.