GRN missing

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • AnnJarvie
    New Member
    • Aug 2019
    • 3

    #1

    [Question] GRN missing

    Hi
    I am using Pastel Partner. A GRN was processed but when i want to link it to the invoice it is no longer there. Could it have been linked and then the invoice was deleted? I can't think of any other explanation. Is there a way to check on the Audit Trail?

    Thanks
    Ann
  • Alec Candiotes
    Full Member

    • Jul 2019
    • 71

    #2
    Hi AnnJarvie

    I can think of 2 possible reasons. 1 is what you mentioned. It was linked and the invoice was deleted. 2 is that the GRN itself was deleted and now it is no longer visible for linking.

    Through Pastel it is not easy to see what happened to it. Try the audit trail and see whether you can pick it up. Alternatively it will be visible in the history header and lines databases. Do you know how to query these databases in Excel?
    Alec Candiotes (CA) SA
    Business Intelligence and Report Automation developer

    www.mybi.co.zaalec@mybi.co.za • 072 997 9553

    Comment

    • AnnJarvie
      New Member
      • Aug 2019
      • 3

      #3
      Hi Alec
      Thanks for the response. I know how to do the audit trail but not the other one?

      Thanks

      Comment

      • Alec Candiotes
        Full Member

        • Jul 2019
        • 71

        #4
        Pleasure AnnJarvie.

        The audit trail report gives you insight to all transactions processed to your GL. However it does not give you insight into transactions that was deleted before it went to GL, like for instance quotations, sales orders and purchase orders that do not yet have financial impact.

        Did you run the Audit trail? Where you able to see the transaction that you are looking for?
        Alec Candiotes (CA) SA
        Business Intelligence and Report Automation developer

        www.mybi.co.zaalec@mybi.co.za • 072 997 9553

        Comment

        Working...