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

I have the same question (0)

All responses (12)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Yes, that is called Customer/Vendor Consolidation.

Go to Card->Sales->Customer/Vendor

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Nothing more valuable to add up, just a useful reference for customer/vendor transactions in Dynamics GP

Customer/Vendor Transactions

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

I am a bit curious as well Ms. Leslie,

Would love to hear further considerable illustration from Sir Richard

Was this reply helpful? Yes No
Suggested answer

Heather Roggeveen 9,146 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No