Good Day:
RE: How delete an item from a JOB and TRACK it
Related topic to zero-qty question.
You cannot delete a material from a JOB, but can replace the Part#; so the work around is to have a dummy Part# = " Part Deleted" that is non-stk, non-qty-bearing, etc and replace the real Part# with "Part Deleted" part#.
Anyone know a different way, since changing the qty to zero is not allowed.
Main goal is to have a record of what was taken out of a JOB (or Sales Order) in order to get a handle on why we have so many "Orphan" parts in stock -- defined as being in-stock but there is no record of why it was ever bought\needed. I think the only answer is to write a 'change log" record, but how do you mark the one in 10,000 action that is a problem?
This is, of course part of the BIG picture of reducing inventory. If we can figure out what creates "Orphans" we can reduce the dead inventory.
Sun is on 9.05.605 since 10/2/11 - SQL-Unidata- 64 bit
Live on 9.05.601B since 11/29/10
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)
Len
Leonard C. Hartka, IS Project Manager\ERP Specialist
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@...
www.Sunautomation.com
[Non-text portions of this message have been removed]
RE: How delete an item from a JOB and TRACK it
Related topic to zero-qty question.
You cannot delete a material from a JOB, but can replace the Part#; so the work around is to have a dummy Part# = " Part Deleted" that is non-stk, non-qty-bearing, etc and replace the real Part# with "Part Deleted" part#.
Anyone know a different way, since changing the qty to zero is not allowed.
Main goal is to have a record of what was taken out of a JOB (or Sales Order) in order to get a handle on why we have so many "Orphan" parts in stock -- defined as being in-stock but there is no record of why it was ever bought\needed. I think the only answer is to write a 'change log" record, but how do you mark the one in 10,000 action that is a problem?
This is, of course part of the BIG picture of reducing inventory. If we can figure out what creates "Orphans" we can reduce the dead inventory.
Sun is on 9.05.605 since 10/2/11 - SQL-Unidata- 64 bit
Live on 9.05.601B since 11/29/10
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)
Len
Leonard C. Hartka, IS Project Manager\ERP Specialist
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@...
www.Sunautomation.com
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of PThis e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
> Sent: Thursday, August 09, 2012 9:22 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Large Report Issue?
>
>
>
>
> I called Epicor for that one off for the 'system out of memory' error. IT WORKED!!!!
> THANKS FOR THE INFO.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "b_ordway" <cooner_55421@...> wrote:
> >
> > I received a one-off from Epicor, have you check with them?
> > If you are lucky they already have a fix for your version.
> > In my case they didn't but the tech I worked with really stuck with it and got development to deliver a new one-off for my version.
> > It did take a couple of months though.
> >
> > It was a dll replacement the file - installed on the client(s) workstation.
> > It fixed "out of memory" errors for reports that failed only when selecting big ranges.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "cubcrafters_it" <jason.navarrete@> wrote:
> > >
> > > So this appears like it might be an issue with the size of the XML. If I run the report for June 1st - June 28th, it's successful, with an XML size of 60.2MB and 1513 page, but if i run it through June 29th, it fails, and the XML data is 63.4MB.
> > >
> > > How do you larger companies run the really really big reports?
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Tim <tim@> wrote:
> > > >
> > > > We fixed the same thing by deleting a non alphanumeric character in the customer comment field. You may have a similar thing.
> > > > ... my best guess
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of cubcrafters_it
> > > > Sent: Wednesday, July 25, 2012 7:15 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] "Invalid character in a base-64 string" error running Inventory WIP Recon Report
> > > >
> > > > How do all y'all run your Inventory WIP Reconciliation Report? If we want to run it for an entire month, showing both posted and unposted detail, it'll bomb out with an "Invalid character in a Base-64 string" error.
> > > >
> > > > Finance has gotten around this by running it for half of the month and then the other half of the month, but there's gotta be a better way.
> > > >
> > > > We've gotta be small potatoes in the manufacturing world, so other people must have huge WIP reports...how do you make it work?>
> > > >
> > > > The XML appears to be intact, and opening it up in Crystal Reports Designer shows the report okay, but I have a feeling it's hitting some sort of limit inside of Epicor that makes it bomb out.
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> > > > (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> > > > (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> > > > (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > >
> > >
> >
>
>
>
>
[Non-text portions of this message have been removed]