Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

OFFSET A/R and A/P

(0) ShareShare
ReportReport
Posted on by

I have customer that buy some merchandise from me but at the same time we bought merchandise from them, They paid us but the took the money that we owe them, which account I have to use, I heard here that GP has an option to use for this purpose. Any help will be appreciate

*This post is locked for comments

  • RE: OFFSET A/R and A/P

    You help me already, I was not sure with the posting setup.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: OFFSET A/R and A/P

    Hi Pat,

    When you change the Posting Setup, it will not change any of the other companies. Of course, if you use one of those companies as a source for copying, those changes will fall over to the new company. You can only create a new company from Dynamics GP Utilities, you cannot create it any other way. There are some things in the Administration section that will affect the whole system, but nothing in the Posting Setup windows will do that.  

    I'm still confused on how we can help you. Do you have an answer to your question, or is there still something outstanding?

    Kind regards,

    Leslie

  • RE: OFFSET A/R and A/P

    Yes, they are database, I have created those company copy the same structure, if you go to Administration you will see the option to create a new company. However, I use one as test and I have noticed that when I changed the posting setup in my test company, the other ones has been affected.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: OFFSET A/R and A/P

    OK, thanks Pat,

    Please help me understand your question regarding how things work between the companies. You mentioned "change the setting", which setting did you have in mind?  Also, are you buying/selling between your companies or with third-party entities?

    Kind regards,

    Leslie

  • RE: OFFSET A/R and A/P

    Yes, three company database, actually I have 6 different companies

  • Suggested answer
    Heather Roggeveen Profile Picture
    Heather Roggeveen 9,144 on at
    RE: OFFSET A/R and A/P

    In answer to the manually doing the transaction part, if this is a one-off situation, I would certainly just do it manually.

    Do a credit note against the Customer Account for the amount that was deducted - code this to a clearing account (accruals or similar).  Do a credit note against the Supplier Account for the same amount, coding it to the same clearing account.

    Don't worry about taxes - there should be no tax implication in the transactions as they are effectively both payments.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: OFFSET A/R and A/P

    I am a bit curious as well Ms. Leslie,

    Would love to hear further considerable illustration from Sir Richard

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: OFFSET A/R and A/P

    Hi Richard,

    I'm confused (it's been one of those days). If Pat has three companies, does that mean there are three company databases, or three companies within a single database. OR does it mean that there are three different companies with which Pat has vendor/customer types of transactions? I got thrown off by the phrase "holding 3 different companies".

    I'm also confused by the reference to changing a 'setting'. Which setting are you all referring to?

    If you would, I'd love to know what is your understanding of the scenario.

    Kind regards,

    Leslie

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: OFFSET A/R and A/P

    Yes, three or more companies can be used with this tool (one pair at a time, of course).  You can move payables from company one to three, for example, then from two to three, then apply the credits to the vendor in three.

    Our Understanding Receivables Management book covers this tool.

  • RE: OFFSET A/R and A/P

    GP, is holding 3 different companies if I change the setting it would be affecting the 3 companies.

    If I want to manual what do you thing my friend??

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans