mibuso.com
Home› NAV/Navision Classic Client

GL record and Excise RG books reconciliation

pashya1972pashya1972 Member Posts: 176
edited 2009-02-21 in NAV/Navision Classic Client
There r two types of rG books RG23AII and RG23cII . In Nav rg books r maintained seperately however GL is maintained only one i.e. combination of AII and CII. Also due to substantial volume it is sometimes diffucult to reconcile with GL. Also RG Books r updated on posted receipts basis whereas GL updates at the time of Invoice passing. I found that two types of entry types r updated e.g. "Excise Entry", etc.

How we can reconcilie it may be using excel, vlookup and tables to be used so that it can be easier and faster. It wud be better if NAV cud ve provision for maintiaining two seperate GL for A type and C type but in Nav 4 its not possible.


Prashant

Comments

  • ssinglassingla Member Posts: 2,973
    Vendor Invoice Number and Order number are two good links that can be used.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • pashya1972pashya1972 Member Posts: 176
    Thanx can u pls inf entry type or table names ?
    What is meant for entry type "Excise Entry"?


    Prashant
  • ssinglassingla Member Posts: 2,973
    Table Id : 13720, 13722, 13712.

    Excise Entry field is used in Gen. Jnl. Line to identify the transaction that will be posted in excise table.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • austinaustin Member Posts: 191
    Thanks sandeep Ji,


    The tables what u had given is very use ful.

    in these tables 13720, 13722 we had PO number , Purchase receipt number.


    But in Excise entry table there is no Purchase order number and Purchase receipt number, Just it has only the Invoice number.

    So how can we Reconcile to RG records.

    Please clarify my doubt ?
  • ssinglassingla Member Posts: 2,973
    Use External Document No.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • austinaustin Member Posts: 191
    ssingla wrote:
    Use External Document No.


    Thanks ,

    In purchase process i cannot find any External document no, except Shipment no, Invoice No.

    what about this External document No.

    Please let me Know.
  • pashya1972pashya1972 Member Posts: 176
    Also if u r using GRN functionality then u shd be able to get "Posted Receipt document No" in Purchase Inv.Line table. Just filter on excise appl. lines only and export to excel, now u ve common filed posted receipt doc.no from posted receipt on which rg books get updated and on purch.inv line gl records get updated.

    Also as rightly said by SS u can also use external doc.number field.


    Prashant
Sign In or Register to comment.