Pro-rate tax and freight to expense lines in AP

• 10-30-2008 9:06 AM

  Ellen Ryan Joined on 10-03-2008 Posts 17

  Pro-rate tax and freight to expense lines in AP Reply Contact We have an unusual way of recording our taxes and freight paid on purchases within our organization.  We record them to the same GL expense account as the items being purchased.  When the invoice arrives and we receive/match it, we cannot use the freight and tax boxes at the bottom of the purchase order entry screen since those are tied to only one GL account.  We have to manually calculate and pro-rate the amount to each item being purchased (especially when the items are being charged to several GL expense accounts).  Does anyone else process tax and freight in this way and have you found a more automated way of calculating?  Our old software had a pro-rate button to handle this, but I have not found that feature in GP. We are using GP v10

  Tags: Dynamics GP 10, Dynamics GP Purchase Order Processing

• 11-07-2008 9:36 AM

  In reply to

  cgardner1031 Joined on 07-17-2007 Posts 1	Re: Pro-rate tax and freight to expense lines in AP Reply Contact We are using GP 9 and have the same problem - would love a solution!

• 11-10-2008 5:18 PM

  In reply to

  Jeffrey Gard Joined on 11-10-2008 Posts 1

  Re: Pro-rate tax and freight to expense lines in AP Reply Contact JeffG: Congruent Software Seattle: For a client of mine I used the landed cost functionality for taxes. I created a landed cost detail and schedule going to AP accrual account. The landed cost detail was based on a % of cost (the tax rate). When the item is received the tax liability gets coded to the GL cost account for the item. The Invoice match would move it from AP Acrual to AP. With shipment/invoice it go to the item cost account and AP.  Landed cost is designed for distributing freight and acquisition cost, so freight works similarly.