×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

My Supplier is also a Customer

My Supplier is also a Customer

My Supplier is also a Customer

(OP)
We have several suppliers to whom we also ship raw materials because we can obtain these materials either faster or cheaper or the supplier cannot obtain the materials at all. One way to process this is to create a work order with an outside process and issue our raw material to the supplier in this manner.

We are exploring shipping the material to the supplier and then creating a debit/credit memo somehow to offset what we owe to the supplier by the value of the material we shipped to them. I can do this with the actual account numbers perhaps by using a GL journal entry, but what would be the best way to reconcile the sub ledgers? Any ideas?

RE: My Supplier is also a Customer

ES or Progression?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: My Supplier is also a Customer

In ES this is a non issue - vendors and customers actually share the same subledger. You can even write a check to a customer if they have a credit balance without having to enter a voucher.

In Progression they have separate subledgers, APOPNFIL and AROPNFIL for vendors and customers respectively. There is no easy way to do this. I would enter a credit memo in AP to reduce the amount you owe them, charging the credit memo to AR Trade. This amount should in theory wipe out your receivable to them. At this point in time, your AP trade should be correct and reconcile, but the AR trade will still show a receivable when in fact nothing is forthcoming. To account for this, you could write of the AR to an allowance account, and make both sides of the entry AR trade. This has zero net effect on the G/L, but removes the A/R.

A T-account flow of this process is attached, something your CFO and auditors should love.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close