Pastel Partner 14

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • J Peens
    New Member
    • Nov 2016
    • 4

    #1

    [Question] Pastel Partner 14

    Good day

    Can anyone assist me, what is the best and easiest way to reverse a duplicate GRN in Pastel Partner 14.
  • Neville Bailey
    Diamond Member

    • Nov 2010
    • 2786

    #2
    Process a supplier invoice and link it to the duplicate GRN.

    After updating the supplier invoice, process a return-debit note and link it to the supplier invoice in order to reverse it. This will reverse the stock quantity out of your system.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

    Comment

    • J Peens
      New Member
      • Nov 2016
      • 4

      #3
      Thank you, I was hoping there's an easier way.

      Comment

      • J Peens
        New Member
        • Nov 2016
        • 4

        #4
        Good day Mr Bailey

        Can you advise me on the following issue:

        Our GRN accrual account have supplier invoices with no GRN to cancel the purchase in the control account, hence the control account have a debit balance.

        The supplier account recons (so its not a duplication of supplier invoices) and the stock balances.

        I feels like this shouldn't even be possible.

        I would like to have your thoughts on this issue.

        Comment

        • Neville Bailey
          Diamond Member

          • Nov 2010
          • 2786

          #5
          Originally posted by J Peens
          Our GRN accrual account have supplier invoices with no GRN to cancel the purchase in the control account, hence the control account have a debit balance.
          I don't understand what you are saying here. Please could you elaborate or explain in another way?
          Neville Bailey - Sage Pastel Accounting Consultant
          www.accountingsoftwaresupport.co.za
          neville@accountingsoftwaresupport.co.za
          IronTree Online Solutions

          "Give every person more in use value than you take from them in cash value."
          WALLACE WATTLES (1860-1911)

          Comment

          • J Peens
            New Member
            • Nov 2016
            • 4

            #6
            Sorry about that.

            The GRN accrual account has dt (purchases - which is a result from capturing the supplier invoice) and cr (GRN - which is a result from capturing the delivery note). The two gets linked and the control account should be zero.

            This GRN accrual account has a dt balance which consists of 6 purchase transactions that do not have a GRN cr. It can not be a dupplication of purchases as the supplier accounts recon. And I don't think we can just raise GRN's becuase this will effect the stock.

            Comment

            • Neville Bailey
              Diamond Member

              • Nov 2010
              • 2786

              #7
              That sounds very strange.

              The only way that a supplier invoice can debit the GRN Accrual Account is if it has been linked to an outstanding GRN (which would have credited the GRN Accrual Account).

              For those 6 supplier invoices, do they all have inventory line items or do they have GL line items in them? The reason I ask is that there is a possibility that those supplier invoices might have used the GRN Accrual Account GL code for some reason, resulting in a debit to the GRN Accrual Account.

              If the above is not the case, then I would need to look at the accounts in detail to find out an explanation, either by you sending me a backup or by logging in with TeamViewer.
              Neville Bailey - Sage Pastel Accounting Consultant
              www.accountingsoftwaresupport.co.za
              neville@accountingsoftwaresupport.co.za
              IronTree Online Solutions

              "Give every person more in use value than you take from them in cash value."
              WALLACE WATTLES (1860-1911)

              Comment

              Working...