E9 - Is it possible to add a reason code after Adjust Inventory

Yahoo Archive
1
You'll be fine. Just make sure the Reason Code exists in the Reason table.




From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Tim Vonderhaar
Sent: Friday, October 19, 2012 1:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9 - Is it possible to add a reason code after Adjust
Inventory transaction





Thanks everyone for their input. I was hoping for a UI way to do this, but
can easily write a SQL update to add the InvAdjReason code. Just hate direct
updates without really knowing if there may be other connected tables that
need updating as a result.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Vic
Drecchio" <vic.drecchio@...> wrote:
>
> I know of no way to do this via the UI. But you could use an updatable BAQ
> (not positive the PartTran table is a candidate in E9 for updateable). Or,
> if you're SQL, do it from the MSSQL console (Update PartTran...).
Progress,
> you can use SQuirreL to update PartTran.
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> Tim Vonderhaar
> Sent: Friday, October 19, 2012 11:23 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] E9 - Is it possible to add a reason code after Adjust
> Inventory transaction
>
>
>
>
>
> Pilot testing our GL setup, we have a case where we performed an ADJ-QTY
> transaction, but did not have our Reason Codes setup yet. This in turn
> produced a transaction which has defaulted to our Company's Inventory COS
> and WIP GL which is incorrect. We have not performed a Capture COS/WIP
> Activity, so I'm wondering if there is a way to correct/update the ADJ-QTY
> transaction to use a good reason code.
>
> Thanks,
> Tim
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2441/5341 - Release Date: 10/19/12
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2441/5341 - Release Date: 10/19/12
>
> [Non-text portions of this message have been removed]
>



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5341 - Release Date: 10/19/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5341 - Release Date: 10/19/12

[Non-text portions of this message have been removed]
2
Pilot testing our GL setup, we have a case where we performed an ADJ-QTY transaction, but did not have our Reason Codes setup yet. This in turn produced a transaction which has defaulted to our Company's Inventory COS and WIP GL which is incorrect. We have not performed a Capture COS/WIP Activity, so I'm wondering if there is a way to correct/update the ADJ-QTY transaction to use a good reason code.

Thanks,
Tim
3
Other than reversing the adjustment and then redoing it, I don't think
there is a way to update a PartTran record.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tim Vonderhaar
Sent: Friday, October 19, 2012 11:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E9 - Is it possible to add a reason code after Adjust
Inventory transaction





Pilot testing our GL setup, we have a case where we performed an ADJ-QTY
transaction, but did not have our Reason Codes setup yet. This in turn
produced a transaction which has defaulted to our Company's Inventory
COS and WIP GL which is incorrect. We have not performed a Capture
COS/WIP Activity, so I'm wondering if there is a way to correct/update
the ADJ-QTY transaction to use a good reason code.

Thanks,
Tim










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
4
You could use a BPM or .P to edit the record. Just be careful mucking
around in parttran.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Fri, Oct 19, 2012 at 11:27 AM, Joe Rojas <jrojas@...> wrote:

> **
>
>
> Other than reversing the adjustment and then redoing it, I don't think
> there is a way to update a PartTran record.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Tim Vonderhaar
> Sent: Friday, October 19, 2012 11:23 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] E9 - Is it possible to add a reason code after Adjust
> Inventory transaction
>
> Pilot testing our GL setup, we have a case where we performed an ADJ-QTY
> transaction, but did not have our Reason Codes setup yet. This in turn
> produced a transaction which has defaulted to our Company's Inventory
> COS and WIP GL which is incorrect. We have not performed a Capture
> COS/WIP Activity, so I'm wondering if there is a way to correct/update
> the ADJ-QTY transaction to use a good reason code.
>
> Thanks,
> Tim
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake. Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of the company.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
5
I know of no way to do this via the UI. But you could use an updatable BAQ
(not positive the PartTran table is a candidate in E9 for updateable). Or,
if you're SQL, do it from the MSSQL console (Update PartTran...). Progress,
you can use SQuirreL to update PartTran.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Tim Vonderhaar
Sent: Friday, October 19, 2012 11:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E9 - Is it possible to add a reason code after Adjust
Inventory transaction





Pilot testing our GL setup, we have a case where we performed an ADJ-QTY
transaction, but did not have our Reason Codes setup yet. This in turn
produced a transaction which has defaulted to our Company's Inventory COS
and WIP GL which is incorrect. We have not performed a Capture COS/WIP
Activity, so I'm wondering if there is a way to correct/update the ADJ-QTY
transaction to use a good reason code.

Thanks,
Tim



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5341 - Release Date: 10/19/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5341 - Release Date: 10/19/12

[Non-text portions of this message have been removed]
6
Thanks everyone for their input. I was hoping for a UI way to do this, but can easily write a SQL update to add the InvAdjReason code. Just hate direct updates without really knowing if there may be other connected tables that need updating as a result.

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> I know of no way to do this via the UI. But you could use an updatable BAQ
> (not positive the PartTran table is a candidate in E9 for updateable). Or,
> if you're SQL, do it from the MSSQL console (Update PartTran...). Progress,
> you can use SQuirreL to update PartTran.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Tim Vonderhaar
> Sent: Friday, October 19, 2012 11:23 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] E9 - Is it possible to add a reason code after Adjust
> Inventory transaction
>
>
>
>
>
> Pilot testing our GL setup, we have a case where we performed an ADJ-QTY
> transaction, but did not have our Reason Codes setup yet. This in turn
> produced a transaction which has defaulted to our Company's Inventory COS
> and WIP GL which is incorrect. We have not performed a Capture COS/WIP
> Activity, so I'm wondering if there is a way to correct/update the ADJ-QTY
> transaction to use a good reason code.
>
> Thanks,
> Tim
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2441/5341 - Release Date: 10/19/12
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2441/5341 - Release Date: 10/19/12
>
> [Non-text portions of this message have been removed]
>