Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supplier Commission

Status
Not open for further replies.

iwells

Programmer
Oct 2, 2012
284
CA
Time for another odd scenario I'm facing ...

We have a Supplier (currently setup as a vendor) that orders from other vendors for us and because of their bulk purchasing they get better prices than us and we've agreed to pay them commissions based on their savings. For arguments sake let's say they have 2 commissions: 1% and 5%.

When we order something for one of our branches (I work in corporate), we need to create a receipt for the amount of the items plus the commission (accrued to separate accounts preferably).

When we receive the goods they would be invoiced and any differences would be corrected just like the current process surrounding POAAPC and then recorded in liabilities (again with the amount of the items separate from the amount of the commission).

Basically I'm trying to find a way to mimic clearing for a specific vendor and somehow incorporate commissions on top of that. At the end of each month I need to report on items receipted and invoiced with the base amount plus the commission. In theory I can create a report and hardcode the values, but that doesn't help with creating the 1% or 5% in the system.

If I created an item number specifically for each item for we get through this vendor and then a contract for that item with the price and a percentage can I also specify different accounts for the accruals of the goods and the commission? Is there another way to accomplish this or is this even possible?
 
Hi Ettiene,

I like what you're proposing here, but I'll need to fudge the system a bit more. The 5% commission can't be added to the original cost so I'll have to make 5% and -5% taxes in the same schedule so the cost to the vendor is the same, do you see any issues with that?

Second, in Accpac I need the tax calculated at the time of receipt (and adjusted at the time of invoice accordingly if there are price changes in items). Is this possible? I'm looking at the tax setup for tax authorities and see "At time of retainage document" and "at time of original document" for report tax on retainage document. From my research this looks like % of completion contract holdbacks.

Thank for your help again.

Ian
 
Yer not making sense.... your first post and second post contradict each other.
And I don't think you are doing retainage? So that is not applicable.
Maybe just write a report and don't try to complicate things.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top