21 February 2011

Weekly Dynamic: POP Invoice Match Extended Price

Here’s the scenario: in POP you go to match an invoice but you can’t quite get quantity and unit price to equal the extended price you need to match too. Usually this is because there aren’t enough decimal places defined for quantity or unity price.

The fix for this is easy. Set the quantity and force the extended price field to be what you want. GP will automatically adjust the Unit Price. This works even if there aren’t enough decimal places defined, GP still forces the unit price and deals with the decimal places behind the scenes.

This also works for P.O.’s, Receivings and SOP transactions. It’s also a great way to make sure integrations are right. Integrate the quantity and extended price and let GP figure out the unit price.