You’re offline. This is a read only version of the page.
I was wondering if it is possible to adjust cost through the 10200 table instead of doing a front end adjustment everytime. Is there any downsides to doing it this way?
*This post is locked for comments
Richard how would we get the macro to work? Also the writedown amounts do still goto COGS, i'm not going to go into detail of how the company works, but know that the amount is still going to COGS. The way we process the writedowns we do a GL Transaction for the total amount written down.
No adjustment to the cost in the Item Master will occur (What is this?)
You only get cost adjustments recorded, not posted(10200 seems to record the complete stock status amount, so what would be missed)
Any information will be helpful. We done this is the past and everything worked good, I just want to double check especially cause we just went from 7.5 to 10.
Thanks
Lets make this simple....NO
You only get cost adjustments recorded, not posted
No adjustment to the cost in the Item Master will occur
No GL Transactions will magically occur.
No audit trail exists
Use the front end like Frank has been telling you. And YES the macro will work.
BTW...you should NOT be writing down inventory, you should reserve for loss. Cost of sales is what you paid for the inventory when you purchased it taken to expenses when you sell it. If you pay $100 for an item and take $50 to COGS, you are misrepresenting the cost of sales.
Well, as long as you can make an accurate manual journal entry, you should be okay updating the Unit Cost and Adjusted Unit Cost fields in IV10200. Test it thoroughly in a test company first though.
Good luck.
ya thats my concern also, especially now that we are on 10 where I notice it actually has a record that you can see of the transaction. We don't writedown anything that has any quantity sold, so I don't have to worry bout the CoG aspect. I just want to make sure that I am not missing any other table or if there is something else I might be missing that will cause an issue. I understant that I won't have a record in GP of the transaction, but I do have a record outside of GP.
I see - that complicates things from a macro perspective. My concern with updating the cost directly in the table would be not having a cost adjustment transaction created automatically as it would be using the interface. If any of that receipt had been sold, GP would create a COGS adjustment retroactively but not if you just update the field in the table.
We use macro's for most of our other imports into GP, i'm not sure if a macro would work for this. Main reason is because we need to write down specific parts on a particular transaction date.
For Example
| Site Id | Qty Received | Date | Qty Sold | Cost |
| Distrib | 2 | 06/16/2009 | 1 | 100.00 |
| Distrib | 1 | 07/16/2009 | 0 | 75.00 |
| Distrib | 4 | 09/16/2009 | 0 | 75.00 |
I would only want to write down the transaction on 07/16/2009 no any of the others, I don't think with the macro it would be able to do that. At least from what i've scene with macros.
I would use a macro to process these changes through the front-end. Check here for an explanation of how to use Word's Mail Merge Macro to import transactions in GP - http://blogs.msdn.com/developingfordynamicsgp/archive/2008/10/30/how-to-use-word-mail-merge-and-macros-to-import-data.aspx
Is there a better way to do this or have they made a change to the front end since 7.5?
The main reason is because we have a aggressive write down schedule that every month we write down about 100+ parts at a time, that is a lot of front end entry. I created a front end thru asp that does a mass adjustment on the back end tables. I copy all the information so i have a record and i use the dex row id to keep track of everything. It seems to work, i just want to make sure i'm not missing anything. We are using GP 10.
Why would you want to do this in the tables instead of the front-end, even if there are no downsides?
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (