OFFSET A/R and A/P

(0) Share

Report

Posted on by Community Member

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

All responses (12)

Answers (0)

Community Member on at

Like (0)

Report

RE: OFFSET A/R and A/P

You help me already, I was not sure with the posting setup.
L Vail 65,271 on at

Like (0)

Report

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
Community Member on at

Like (0)

Report

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 65,271 on at

Like (0)

Report

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
Community Member on at

Like (0)

Report

RE: OFFSET A/R and A/P

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

Heather Roggeveen 9,146 on at

Like (0)

Report

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 32,738 on at

Like (0)

Report

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 65,271 on at

Like (0)

Report

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 25,195 on at

Like (0)

Report

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.
Community Member on at

Like (0)

Report

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??