Microsoft Dynamics GP (Archived)

Adjust cost during invoice posting using .Net or SQL

(0) Share

Report

Posted on by Community Member

How to adjust item current cost during invoice posting using .Net or SQL?

For example, adjust rebate amount from cost of goods.

In the step of posting reading current cost, can I capture that event and change the amount?

thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (3)

Verified answer

soma 24,410 on at

Like (0)

Report

While posting transactions for items, GP not only consider the item current cost. It is validating the unit cost of the items based on the Item valuation methods and current cost.

You can write a script to capture the current cost of the items before posting the transactions and pass your manual current cost. But, I would not recommend you to change the GP logic.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Right, after some testing, I found the posting always use item unit cost as cost of goods calculation.

do you which procedure I should call in .net to change item current cost manually?

I still have to adjust unit cost at beginning of posting process. thanks

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Why do you want to do this? You run the risk of throwing your physical inventory value out of balance with the general ledger. Advise you have a very detailed discussion with your accounting department, if you have not yet done so.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Frank is 100% correct. There is a utility for this in GP. Tools->Utilities->Inventory->Adjust Unit Cost. Making back-end adjustments should be done when no other solution is available.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am so glad to get expert's advice. Thanks.

I am not a GP person at all. I am a .Net developer and GP internal process rules are new to me.

I will check the suggested solution.

One last request. What I mean to change unit cost is not try to reset unitcost in IV00100.

I am trying to find out which GP procedure reads that value in IV posting. Perhaps when that even is happening, I can alter the read value in memory before next process start pick them up?

If that will throw the physical inventory value out of balance with the general ledger, I will abandon the idea.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The client want net cost of goods (current - rebate) be posted because they get rebate for certain customer and item.

What's the correct way to accomplish this automatically assume we can set up rebate per customer and item. Thanks

Was this reply helpful? Yes No
Verified answer

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

The IV00103 has the Last_Originating_Cost field. GP will use that when entering a new PO. However, for what you are asking is much more complicated. GP will grab the current cost of at item at the time the invoice is posted. This will be dependent upon the inventory valuation method being used for that item and then what receipts layers are still available. If you are using FIFO Perpetual it will go back to the earliest receipt layer that still has quantity available and use that cost.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

You may want to check out this ISV solution to account for rebates. There is nothing in GP that allows for that.

www.binarystream.com/vendor_contracts.asp

Was this reply helpful? Yes No
Verified answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

I fully agree with Richard's advice. The Binary Stream product was developed for GP for exactly what your client is attempting to do via a customization. And, as Richard points out and you astutely agreed, altering the results coming from GP's logic around product costing is fraught with potential unintended consequences.

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (0)

Report

HI,

I will suggest you to pass line item as 'Rebate' with negative cost ,price is 0 and Qty 1. This way you don't have to re-calculate cost. System will take care of actual costing.

Thanks

Sandip

Was this reply helpful? Yes No