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
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
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.
You may want to check out this ISV solution to account for rebates. There is nothing in GP that allows for that.
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.
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
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.
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.
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.
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
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!!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (