Epicor 905.606A Jobs hitting wrong GL account

Yahoo Archive
1
As stated below, when we report using KANBAN reporting, Raw Materials and Finished good hits the GL in the correct accounts.  When we assign job #'s, report to stock, the dollar for the FG is hitting the GL in the suspense account.  The group and class haven't changed from KANBAN reportitn. Is there another facet to the Part Maintence that needs filling in when not using KANBAN?Â
Thanks in advanced
jacqueline


________________________________
From: Jacqueline Restivo <jacqueline_restivo@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, June 24, 2013 12:20 PM
Subject: [Vantage] Epicor 905.606A Jobs hitting wrong GL account

Â
Hi All,
We're reporting jobs in Epicor 905.606A. When inventory is reported on the job, and I viewed the WIP Reconciliation report, the materials are coming out of GL accounts WIP 1301-01 and Raw Materials 1303-01, like it’s supposed to. BUT when Finished Goods are transferred into inventory JOB RECEIPT TO INVENTORY, they are going into the Suspense Account 999-01, not Fin good 1301-01. Â
When we used Kanban Reporting it came out of the correct accounts.Â
Appreciate any help, suggestions, ideas you can offer.
Thanks in advance.

________________________________

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
2
Is there a way to determine whether a Help Desk Case is open or closed for the purpose of filtering in a BAQ. There is no status stored in the tables.
3
The Status is stored in PatchFld table. Tech Tip #: 11545ESC details how to link to the data.

Tech support will have to send you the document.

You could also use a method directive on update and set a checkbox.

/* case status set */

If ttHDCase.CaseStatus = "CLOSED" Then
Assign ttHDCase.Checkbox01 = true.
Else
Assign ttHDCase.Checkbox01 = false.


Greg
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jordan.bullydog
Sent: Wednesday, June 19, 2013 11:50 AM
To: vantage@yahoogroups.com
Subject: [BULK] [Vantage] Help Desk Case Status
Importance: Low



Is there a way to determine whether a Help Desk Case is open or closed for the purpose of filtering in a BAQ. There is no status stored in the tables.


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
4
Thank you very much, that was exactly what I needed.

Jordan

--- In vantage@yahoogroups.com, Greg Payne <gpayne@...> wrote:
>
> The Status is stored in PatchFld table. Tech Tip #: 11545ESC details how to link to the data.
>
> Tech support will have to send you the document.
>
> You could also use a method directive on update and set a checkbox.
>
> /* case status set */
>
> If ttHDCase.CaseStatus = "CLOSED" Then
> Assign ttHDCase.Checkbox01 = true.
> Else
> Assign ttHDCase.Checkbox01 = false.
>
>
> Greg
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jordan.bullydog
> Sent: Wednesday, June 19, 2013 11:50 AM
> To: vantage@yahoogroups.com
> Subject: [BULK] [Vantage] Help Desk Case Status
> Importance: Low
>
>
>
> Is there a way to determine whether a Help Desk Case is open or closed for the purpose of filtering in a BAQ. There is no status stored in the tables.
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
>
> [Non-text portions of this message have been removed]
>
5
Hi All,
We're reporting jobs in Epicor 905.606A. When inventory is reported on the job, and I viewed the WIP Reconciliation report, the materials are coming out of GL accounts WIP 1301-01 and Raw Materials 1303-01, like it’s supposed to. BUT when Finished Goods are transferred into inventory JOB RECEIPT TO INVENTORY, they are going into the Suspense Account 999-01, not Fin good 1301-01. Â
When we used Kanban Reporting it came out of the correct accounts.Â
Appreciate any help, suggestions, ideas you can offer.
Thanks in advance.


________________________________



[Non-text portions of this message have been removed]
6
We are on 905.700B and we found that when transactions apply to the incorrect account, either the account number is not set-up correctly in the GL control for the part class or the part class is not tied to a GL control.

Deirdre Sykes | Senior Cost Accountant
GSI Technologies, LLC | 311 Shore Drive | Burr Ridge, IL 60527
dsykes@...<mailto:dsykes@...> | Phone: 630.590.8112 | Fax: 630.325.8197

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jacqueline Restivo
Sent: Monday, June 24, 2013 11:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 905.606A Jobs hitting wrong GL account



Hi All,
We're reporting jobs in Epicor 905.606A. When inventory is reported on the job, and I viewed the WIP Reconciliation report, the materials are coming out of GL accounts WIP 1301-01 and Raw Materials 1303-01, like it’s supposed to. BUT when Finished Goods are transferred into inventory JOB RECEIPT TO INVENTORY, they are going into the Suspense Account 999-01, not Fin good 1301-01.
When we used Kanban Reporting it came out of the correct accounts.
Appreciate any help, suggestions, ideas you can offer.
Thanks in advance.

________________________________

[Non-text portions of this message have been removed]


CONFIDENTIALITY: The information contained in this email message, including any attachment(s), may be privileged and confidential and protected from disclosure. The email is not intended for transmission to, or receipt by, any unauthorized persons. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication or use of the information contained herein is strictly prohibited. If you have received this electronic mail transmission in error, please delete it from your system without copying or disseminating, and notify the sender by Reply email, so that our address record can be corrected.


[Non-text portions of this message have been removed]
7
Check the GL account of the part class for the finished good part. If there is none or no part class, the default inventory account of the COS/WIP control is being used.



Charlie Smith

2W Technologies Inc., Sr. Business Consultant

Phone: (312) 533-4033 Office

(860) 919-1708 Cell

Fax: (847) 374-3620

www.2WTech.com <http://www.2wtech.com/> 2W Tech on Facebook <https://www.facebook.com/pages/2W-Technologies-Inc/139194569432409>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jacqueline Restivo
Sent: Monday, June 24, 2013 12:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 905.606A Jobs hitting wrong GL account





Hi All,
We're reporting jobs in Epicor 905.606A. When inventory is reported on the job, and I viewed the WIP Reconciliation report, the materials are coming out of GL accounts WIP 1301-01 and Raw Materials 1303-01, like it’s supposed to. BUT when Finished Goods are transferred into inventory JOB RECEIPT TO INVENTORY, they are going into the Suspense Account 999-01, not Fin good 1301-01.
When we used Kanban Reporting it came out of the correct accounts.
Appreciate any help, suggestions, ideas you can offer.
Thanks in advance.

________________________________

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
8
The part in question has a Part Class attached. This is an existing FG with an existing BOM.         We were reporting using Kanban and they went into the correct GL account.   That's whats so puzzling.Â



________________________________
From: CharlieSmith <CSmith@...>
To: vantage@yahoogroups.com
Sent: Monday, June 24, 2013 1:12 PM
Subject: RE: [Vantage] Epicor 905.606A Jobs hitting wrong GL account

Â
Check the GL account of the part class for the finished good part. If there is none or no part class, the default inventory account of the COS/WIP control is being used.



Charlie Smith

2W Technologies Inc., Sr. Business Consultant

Phone: (312) 533-4033 Office

(860) 919-1708 Cell

Fax: (847) 374-3620

www.2WTech.com <http://www.2wtech.com/> 2W Tech on Facebook <https://www.facebook.com/pages/2W-Technologies-Inc/139194569432409>





From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Jacqueline Restivo
Sent: Monday, June 24, 2013 12:21 PM
To: mailto:vantage%40yahoogroups.com
Subject: [Vantage] Epicor 905.606A Jobs hitting wrong GL account





Hi All,
We're reporting jobs in Epicor 905.606A. When inventory is reported on the job, and I viewed the WIP Reconciliation report, the materials are coming out of GL accounts WIP 1301-01 and Raw Materials 1303-01, like it’s supposed to. BUT when Finished Goods are transferred into inventory JOB RECEIPT TO INVENTORY, they are going into the Suspense Account 999-01, not Fin good 1301-01.
When we used Kanban Reporting it came out of the correct accounts.
Appreciate any help, suggestions, ideas you can offer.
Thanks in advance.

________________________________

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
9
Check your Part Class > GL Control on your finished goods.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jacqueline Restivo
Sent: Monday, June 24, 2013 9:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 905.606A Jobs hitting wrong GL account





Hi All,
We're reporting jobs in Epicor 905.606A. When inventory is reported on the job, and I viewed the WIP Reconciliation report, the materials are coming out of GL accounts WIP 1301-01 and Raw Materials 1303-01, like it’s supposed to. BUT when Finished Goods are transferred into inventory JOB RECEIPT TO INVENTORY, they are going into the Suspense Account 999-01, not Fin good 1301-01.
When we used Kanban Reporting it came out of the correct accounts.
Appreciate any help, suggestions, ideas you can offer.
Thanks in advance.

________________________________

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
10
It shouldn’t matter whether you use KanBan job or a regular job, both types of jobs will use the Part Class to determine the Inventory account.



Do you have a BPM that might be changing the Part Class?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jacqueline Restivo
Sent: Monday, June 24, 2013 10:35 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 905.606A Jobs hitting wrong GL account





The part in question has a Part Class attached. This is an existing FG with an existing BOM. We were reporting using Kanban and they went into the correct GL account. That's whats so puzzling.

________________________________
From: CharlieSmith <CSmith@... <mailto:CSmith%40vistaconsultant.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Monday, June 24, 2013 1:12 PM
Subject: RE: [Vantage] Epicor 905.606A Jobs hitting wrong GL account


Check the GL account of the part class for the finished good part. If there is none or no part class, the default inventory account of the COS/WIP control is being used.

Charlie Smith

2W Technologies Inc., Sr. Business Consultant

Phone: (312) 533-4033 Office

(860) 919-1708 Cell

Fax: (847) 374-3620

www.2WTech.com <http://www.2wtech.com/> 2W Tech on Facebook <https://www.facebook.com/pages/2W-Technologies-Inc/139194569432409>

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Jacqueline Restivo
Sent: Monday, June 24, 2013 12:21 PM
To: mailto:vantage%40yahoogroups.com
Subject: [Vantage] Epicor 905.606A Jobs hitting wrong GL account

Hi All,
We're reporting jobs in Epicor 905.606A. When inventory is reported on the job, and I viewed the WIP Reconciliation report, the materials are coming out of GL accounts WIP 1301-01 and Raw Materials 1303-01, like it’s supposed to. BUT when Finished Goods are transferred into inventory JOB RECEIPT TO INVENTORY, they are going into the Suspense Account 999-01, not Fin good 1301-01.
When we used Kanban Reporting it came out of the correct accounts.
Appreciate any help, suggestions, ideas you can offer.
Thanks in advance.

________________________________

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]