Customer Account Adjustment through General Journal

  • Customer Account Adjustment through General Journal

    Posted by DSC Communities on May 15, 2017 at 5:44 pm
    • Mark Schurmann

      Member

      May 15, 2017 at 5:44 PM

      We recently when live in production with D365 for Operations.Ā 

      We need to adjustment balances on several customer accounts.Ā  We are attempting to use a General Journal selecting the customer account as the main account and a ledger account as the offset.

      We are getting an error during posting saying that the offset account must be a bank account.Ā  Our functional consultant is recommending us to use the free text invoice or write off journal screen.Ā  Neither of these seem as efficient and flexible as entering the customer accounts and a ledger offset account in a single journal batch.

      The Journal Name (GJ) does not have a fixed offset account and the Account Type under OFFSET ACCOUNT PROPOSAL is Ledger.Ā 

      Does someone know a solution to this?Ā  It seems very strange to design a flexible interface and then limit what you can do with it.

      ——————————
      Mark Schurmann
      Automobile Protection Corp
      Norcross GA
      ——————————

    • Ryan Sorenson

      Member

      May 16, 2017 at 11:14 AM

      Hi Mark,
      Check the method of payment for the customer, that might have a posting restriction of type Bank. Ā If so remove the method of payment from the journal line.

      If that’s not it then I’d check Journal control in the journal setup.

      Ryan

      ——————————
      Ryan Sorenson
      Sunrise Technologies, Inc.
      Salt Lake City, UT
      ——————————
      ——————————————-

    • Steve Latta

      Member

      May 17, 2017 at 9:30 AM

      I’m on AX 2012 R3, so it may be a little different, but it does sound like you have a Method of Payment defaulting onto that line and the method of payment is set up to require a Bank offset. Simply deleting the default Method of Payment on the journal line details should allow it to post.

      ——————————
      Steve Latta
      Accountant
      Ortec, Inc.
      Easley SC
      ——————————
      ——————————————-

    DSC Communities replied 8 years, 10 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Customer Account Adjustment through General Journal’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!