Wednesday, May 28, 2014

GP IV SOP Return with COGS

A customer with an integration to SOP was encountering a problem where SOP was insisting on a COGS integration for a Return document with an item that is a "Misc Chg" in inventory.

When they first saw the document it had 4 distribution lines, one each for the RECV and SALES entries, the other two for RETURNS and COGS.  They claim the RETURNS line was blank with respect to account, but that there should rightly be no cost associated with this type of transaction.

When I manually created a SOP Return transaction in GP for the same vendor and item there was no COGS related entry.  When they tried to "Default" the distribution the RETURNS and COGS lines were removed but they got:

"This Cost of Goods Sold distribution amount is incorrect and will not be posted.  Do you want to save with errors?"

According to the KB posted here this is the result of a non-zero cost in either the EXTDCOST or OREXTCST fields for this transaction in the SOP tables.

Sure enough there was a cost amount in those fields, and that happened to be the Current Cost from that IV item.  My guesstimation is the integration saw that IV cost and completed those cost columns in SOP, thus forcing the error.

Zeroing out that cost in the SOP tables per the KB solved the issue.  I also identified one other Misc Chg IV item with a cost and advised they zero those cost values.

No comments:

Post a Comment