You can add the Invoice Date to the report. It is in the aptran.dbf as
DSPINVDT. Just add that to an area of the report that you would like and
everything will work fine.
Ted Kitch
ted@...
DSPINVDT. Just add that to an area of the report that you would like and
everything will work fine.
Ted Kitch
ted@...
----- Original Message -----
From: "Amy Mackay" <amackay@...>
To: <vantage@egroups.com>
Sent: Thursday, December 14, 2000 12:42 PM
Subject: [Vantage] Invoice date on check stub?
> Does anyone have a check stub that references the invoice date? I want
the
> field from AP payment entry = invoice date. Any check stubs out there
with
> that field already on it? I assume it's some kind of linked table to the
> current tables in Crystal. The APtran doesn't have that field available.
> We're using the original Crystal check report CHKPRINT.RPT in version 7.
> Thank you.
>
> Amy T MacKay
>
>
>
> -----Original Message-----
> From: vantage@egroups.com [mailto:vantage@egroups.com]
> Sent: Tuesday, October 31, 2000 6:32 AM
> To: vantage@egroups.com
> Subject: [Vantage] Digest Number 1002
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the link
above
> will work the next time you try it.)
> ------------------------------------------------------------------------
>
> There are 15 messages in this issue.
>
> Topics in this digest:
>
> 1. Re: No Access During Month End Closing
> From: phoorn@...
> 2. Re: [TECH] Fast shut down
> From: phoorn@...
> 3. Re: Financial Statements
> From: "Motovario" <motovari@...>
> 4. RE: [TECH] Fast shut down
> From: "Keith Taylor" <keith@...>
> 5. Report Builder - Graphing Capabilities
> From: "Amy Mackay" <amackay@...>
> 6. RE: Report Builder - Graphing Capabilities
> From: "Podlin, Michael" <michael.podlin@...>
> 7. RE: Report Builder - Graphing Capabilities
> From: "Eric Tolliver" <e.tolliver@...>
> 8. Re: [TECH] Fast shut down
> From: rgors <rgors@...>
> 9. RE: Receipt from mfg. costs
> From: "Wayne Katzenberger" <wkatz@...>
> 10. RE: Job Completion
> From: Orv Rehfeldt <ORehfeldt@...>
> 11. Another RB Calculation
> From: "Wendy Pursche" <wpursche@...>
> 12. Re: Another RB Calculation
> From: "Tim Care" <ecfmis@...>
> 13. RE: Receipt from mfg. costs
> From: Lydia Coffman <lcoffman@...>
> 14. RE: Receipt from mfg. costs
> From: Greg Clauser <gclauser@...>
> 15. Customer Statement Aging
> From: Gary Parfrey <garyp@...>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 1
> Date: Mon, 30 Oct 2000 12:01:02 -0000
> From: phoorn@...
> Subject: Re: No Access During Month End Closing
>
> It may be easier to shutdown the database using ProControl.
> If only 1 user is allowed to access Vantage, create a single
> user .vtg file.
>
> The single user .vtg file is the same file you use to access vantage
> normally, except for the connect options.
> Usually they look like
> connectoptions= -N TCP -H Server -S vantage
>
> for single user replace it with connectoptions = -1
>
> also very handy for patches and data conversions.
>
>
> --- In vantage@egroups.com, Ted Kitch <tedkitch@e...> wrote:
> > From the server console, you can pause the Net Logon service. Goto
> the
> > Control Panel, Services and just pause the Net Logon service. This
> stops
> > the computer from authenticating users access rights to files,
> etc. This
> > will allow only those people that are connected to the server to
> stay
> > connected to the server. Once you are ready to allow users back on
> then just
> > press the Continue button.
> >
> > Ted Kitch
> > tedkitch@e...
> > On Wed, 25 Oct 2000 16:29:17 -0600, vantage@egroups.com wrote:
> >
> > > Does anybody have a sure-fire way to keep users out of the
> database
> > during
> > > the month end closing process? We have multiple sites, are
> nearly 24/7,
> > and
> > > we need a way to lock out users when we upgrade to v4.
> > >
> > > Thanks in advance for any ideas.
> > >
> > > Tom Taylor
> > > I.S. Administrator
> > > Teklution, LLC.
> > > www.teklution.com
> > >
> >
> >
> > Ted Kitch
> > tedkitch@e...
> >
> >
> >
> >
> >
> > _______________________________________________________
> > Say Bye to Slow Internet!
> > http://www.home.com/xinbox/signup.html
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 2
> Date: Mon, 30 Oct 2000 12:04:48 -0000
> From: phoorn@...
> Subject: Re: [TECH] Fast shut down
>
> It's fairly easy:
>
> go to the start menu
> choose 'run.."
> type 'msconfig'
> go to advanced button
> the checkbox is now visible..
>
>
>
> --- In vantage@egroups.com, "Bruce Palmer" <bruce@p...> wrote:
> > I have the same problem.
> >
> > Please help anybody
> >
> > Bruce
> > PPI
> >
> > ----- Original Message -----
> > From: Rick Spriggle <rspriggle@d...>
> > To: <vantage@egroups.com>
> > Sent: Friday, October 27, 2000 7:05 AM
> > Subject: [Vantage] [TECH] Fast shut down
> >
> >
> > > Can anybody tell me how to disable the fast shut down feature in
> Windows
> > 98
> > > Second Edition? I have a number of PCs that won't shut down
> properly,
> > even
> > > with the Microsoft patch installed. I remember this being
> discussed on
> > the
> > > group several months ago.
> > >
> > > Thanks,
> > >
> > > Rick
> > >
> > >
> > >
> > >
> > > We no longer allow attachments to files. To access/share Report
> Files,
> > please go to the following link:
> http://www.egroups.com/files/vantage/
> > > (Note: If this link does not work for you the first time you try
> it, go
> > to www.egroups.com, login and be sure to save your password, choose
> My
> > Groups, choose Vantage, then choose Files. If you save the
> password, the
> > link above will work the next time
> > > you try it.)
> > >
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 3
> Date: Mon, 30 Oct 2000 07:51:12 -0500
> From: "Motovario" <motovari@...>
> Subject: Re: Financial Statements
>
> If you don't mind I would like a copy, could you please e-mail to me at
> sloesel@...
>
> Thanks, Shari
> ----- Original Message -----
> From: "calvin" <calvin@...>
> To: <vantage@egroups.com>
> Sent: Friday, October 27, 2000 4:11 PM
> Subject: Re: [Vantage] Financial Statements
>
>
> > Mike -
> >
> > We rewrote the customer monthly statements in RBuilder.
> > Let me know if you want a copy.
> > Put the date and time stamp in the report builder report.
> >
> > Calvin
> >
> > ----- Original Message -----
> > From: Mike England <mike@...>
> > To: <vantage@egroups.com>
> > Sent: Friday, October 27, 2000 4:06 PM
> > Subject: [Vantage] Financial Statements
> >
> >
> > > Has anyone figured out a way to date/time stamp your statements?
> > >
> > > Mike England
> > > Har Technologies
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > We no longer allow attachments to files. To access/share Report
Files,
> > please go to the following link: http://www.egroups.com/files/vantage/
> > > (Note: If this link does not work for you the first time you try it,
go
> > to www.egroups.com, login and be sure to save your password, choose My
> > Groups, choose Vantage, then choose Files. If you save the password,
the
> > link above will work the next time you try it.)
> >
> >
> >
> > We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> > (Note: If this link does not work for you the first time you try it, go
> to www.egroups.com, login and be sure to save your password, choose My
> Groups, choose Vantage, then choose Files. If you save the password, the
> link above will work the next time you try it.)
> >
> >
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 4
> Date: Mon, 30 Oct 2000 08:36:30 -0500
> From: "Keith Taylor" <keith@...>
> Subject: RE: [TECH] Fast shut down
>
> I do not have a box that says disable fast shut down on version 98
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 5
> Date: Mon, 30 Oct 2000 08:29:10 -0500
> From: "Amy Mackay" <amackay@...>
> Subject: Report Builder - Graphing Capabilities
>
> What kind of, if any, capability does RB have to graph data?
>
> I'm having trouble exporting information to Excel that I want to graph.
So
> I was wondering if I could somehow do that in RB.
>
> Thanks.
>
> Amy MacKay
> Parkinson Machinery
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 6
> Date: Mon, 30 Oct 2000 07:57:04 -0600
> From: "Podlin, Michael" <michael.podlin@...>
> Subject: RE: Report Builder - Graphing Capabilities
>
> Basically None. However, if you are very creative,
> I have been able to do sort of a bar graph. example:
>
> |xxxxxxxxxxx
> |xxxxxxxxxxxxxxxxxxxxxxx
> |xxxxx
> |xxxxxxxxxxxxxxxxx
> |xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> |xxx
> |xxxxxxxxxxxx
>
> What you do is to generate a line of characters
> (in this case "x") using the FILL command.
> Its crude but it does work.
>
> Michael Podlin
>
> -----Original Message-----
> From: Amy Mackay [mailto:amackay@...]
> Sent: Monday, October 30, 2000 7:29 AM
> To: vantage@egroups.com
> Subject: [Vantage] Report Builder - Graphing Capabilities
>
>
> What kind of, if any, capability does RB have to graph data?
>
> I'm having trouble exporting information to Excel that I want to graph.
So
> I was wondering if I could somehow do that in RB.
>
> Thanks.
>
> Amy MacKay
> Parkinson Machinery
>
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the link
above
> will work the next time you try it.)
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 7
> Date: Mon, 30 Oct 2000 07:21:58 -0700
> From: "Eric Tolliver" <e.tolliver@...>
> Subject: RE: Report Builder - Graphing Capabilities
>
> Amy,
>
> Have you tried the export utility. It works great for things like
exporting
> to excel.
>
> Eric Tolliver
> IT\MIS
> Continental Industries Inc.
> 5456 E. Mcdowell Rd.
> Mesa, Az 85215
> http://ciirelays.com/
> mailto:e.tolliver@...
>
> -----Original Message-----
> From: Amy Mackay [mailto:amackay@...]
>
> What kind of, if any, capability does RB have to graph data?
>
> I'm having trouble exporting information to Excel that I want to graph.
So
> I was wondering if I could somehow do that in RB.
>
> Thanks.
>
> Amy MacKay
> Parkinson Machinery
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 8
> Date: Mon, 30 Oct 2000 10:39:08 -0500
> From: rgors <rgors@...>
> Subject: Re: [TECH] Fast shut down
>
> Are you speaking about the situation when I shutdown, but the machine
> stays in shutdown mode for a long time (forever?)?
>
> Rick
> MIS
> Osco
>
> Rick Spriggle wrote:
> >
> > Can anybody tell me how to disable the fast shut down feature in
> > Windows 98
> > Second Edition? I have a number of PCs that won't shut down properly,
> > even
> > with the Microsoft patch installed. I remember this being discussed
> > on the
> > group several months ago.
> >
> > Thanks,
> >
> > Rick
> >
> > eGroups Sponsor
> >
> >
> > We no longer allow attachments to files. To access/share Report
> > Files, please go to the following link:
> > http://www.egroups.com/files/vantage/
> > (Note: If this link does not work for you the first time you try it,
> > go to www.egroups.com, login and be sure to save your password, choose
> > My Groups, choose Vantage, then choose Files. If you save the
> > password, the link above will work the next time you try it.)
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 9
> Date: Mon, 30 Oct 2000 09:49:29 -0600
> From: "Wayne Katzenberger" <wkatz@...>
> Subject: RE: Receipt from mfg. costs
>
> Lydia,
>
> When we do a reciept from manufacturing a cost does not always show up.
If
> no cost show I have instructed my inventory control people to back out of
> the reciept until we can fix or determing the costs manually.
>
> We are costing using average costs.
>
> As far as I can tell, quanities move but the costs stay at zero. We have
> verified this becase we watch for manaufactured items with quanitities but
> costs are zero. Our CFO has been indicating to me that our Inventory $
seem
> to be understated and this may be the problem.
>
> Wayne
>
> -----Original Message-----
> From: Lydia Coffman [mailto:lcoffman@...]
> Sent: Friday, October 27, 2000 4:49 PM
> To: vantage@egroups.com
> Subject: RE: [Vantage] Receipt from mfg. costs
>
>
> Wayne:
>
> A couple of questions: When you do the receipt from manufacturing, does a
> cost show on that data entry screen?
>
> Are you costing your manufactured parts at Average, Standard or Last?
>
> If it is standard, do you have an actual number in the Standard cost for
> that part? This would be found under Inventory Management, General Ops,
> Cost Adjustment. If no cost shows in receipt from manufacturing, nothing
is
> going to move into inventory. Check it out.
>
> Lydia
>
>
> -----Original Message-----
> From: Wayne Katzenberger [mailto:wkatz@...]
> Sent: Friday, October 27, 2000 2:33 PM
> To: 'Vantage User Group'
> Subject: [Vantage] Receipt from mfg. costs
>
> Hi Group,
>
> We seem to be having a problem with bringing costs into inventory from
> reciept manufacturing. Perhaps you guru's out there can give me a tip as
to
> why.
>
> When a job is complete we bring back finished parts and any subassemblies
> back to stock using receipt from manufacturing. On occasion when we do
this
> the costs don't want to roll in. They come in as $0.00. However, when
you
> go to Job tracker and view the costs they are there.
>
> Data collection here is not the swiftest in the world but what I've heard
> from the rest of you ELECPAC is not alone. We tried completing operations
> using job adjustment but that doesn't always work either.
>
> Does anybody know what triggers these costs to roll in to inventory from
> receipt from manufacturing?
>
> Wayne Katzenberger
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the link
above
> will work the next time you try it.)
>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the link
above
> will work the next time you try it.)
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 10
> Date: Mon, 30 Oct 2000 10:32:46 -0600
> From: Orv Rehfeldt <ORehfeldt@...>
> Subject: RE: Job Completion
>
>
>
> For the bottom left browse it's JobProd.ShippedQty + JobProd.ReceivedQty.
>
> For the top right browse of jobs it's JobHead.
> ShippedQty + JobHead.ReceivedQty.
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 11
> Date: Mon, 30 Oct 2000 11:47:46 -0500
> From: "Wendy Pursche" <wpursche@...>
> Subject: Another RB Calculation
>
> Alright everyone..........bear with me! I've been asked in the past 4
> months to write a lot of very technical RB reports so I'm having to ask
> questions from the group!!
>
> Is it possible to total the RECORDS from a GROUP HEADER BAND LINE? I'm
> trying to total the number of Packing Slips I have listed in my
> SHIPHEAD.PACKNUM GROUP HEADER BAND LINE. I would like to total it in my
> SUMMARY section. I have come to realize that RECORD-NUM() in the
calculated
> field area only totals in a RECORD BAND LINE. Any suggestions?
>
> Wendy Pursche
> Network Administrator
> Schmald Tool & Die, Inc.
> (810) 743-1600 ext.323
> wpursche@...
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 12
> Date: Mon, 30 Oct 2000 13:28:57 -0500
> From: "Tim Care" <ecfmis@...>
> Subject: Re: Another RB Calculation
>
> Wendy,
>
> Set up a new aggregate for the Group total. Make it a count
> aggregate, reset the count for whatever group, or no reset for
> entire report, and then under advanced, accumulate on whatever
> group level you are looking to count. Good luck.
>
> Tim Care
> Electro Chemical Finishing
>
> ----- Original Message -----
> From: "Wendy Pursche" <wpursche@...>
> To: "Vantage egroups list" <vantage@egroups.com>
> Sent: Monday, October 30, 2000 11:47 AM
> Subject: [Vantage] Another RB Calculation
>
>
> > Alright everyone..........bear with me! I've been asked in the past 4
> months to write a lot of very technical RB reports so I'm having to ask
> questions from the group!!
> >
> > Is it possible to total the RECORDS from a GROUP HEADER BAND LINE? I'm
> trying to total the number of Packing Slips I have listed in my
> SHIPHEAD.PACKNUM GROUP HEADER BAND LINE. I would like to total it in my
> SUMMARY section. I have come to realize that RECORD-NUM() in the
calculated
> field area only totals in a RECORD BAND LINE. Any suggestions?
> >
> > Wendy Pursche
> > Network Administrator
> > Schmald Tool & Die, Inc.
> > (810) 743-1600 ext.323
> > wpursche@...
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> > (Note: If this link does not work for you the first time you try it, go
> to www.egroups.com, login and be sure to save your password, choose My
> Groups, choose Vantage, then choose Files. If you save the password, the
> link above will work the next time you try it.)
> >
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 13
> Date: Mon, 30 Oct 2000 11:50:32 -0800
> From: Lydia Coffman <lcoffman@...>
> Subject: RE: Receipt from mfg. costs
>
> Wayne:
>
> How new is your database? If you have only recently initialized Vantage,
> then there is no data in there to average. Your accounting dept. needs to
> go in there and enter a cost (Inventory Mgmt, GenOps, Cost Adjustment)-or
> you can have them look at the cost (from the job) at the time of the
receipt
> and enter that. We have a cost in all of our parts - Manufactured are
> Standard Costed and Purchased are Average-this was a decision made by our
> Accountant after attending the Controllers' Workshop. The manufactured
> items are then reviewed periodically and costs are adjusted.
>
> HTH
> Lydia
>
>
> -----Original Message-----
> From: Wayne Katzenberger [mailto:wkatz@...]
> Sent: Monday, October 30, 2000 7:49 AM
> To: vantage@egroups.com
> Subject: RE: [Vantage] Receipt from mfg. costs
>
> Lydia,
>
> When we do a receipt from manufacturing a cost does not always show up.
If
> no cost show I have instructed my inventory control people to back out of
> the receipt until we can fix or determining the costs manually.
>
> We are costing using average costs.
>
> As far as I can tell, quantities move but the costs stay at zero. We have
> verified this because we watch for manufactured items with quantities but
> costs are zero. Our CFO has been indicating to me that our Inventory $
seem
> to be understated and this may be the problem.
>
> Wayne
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 14
> Date: Mon, 30 Oct 2000 14:47:46 -0600
> From: Greg Clauser <gclauser@...>
> Subject: RE: Receipt from mfg. costs
>
> We also use average costing and discovered the same "zero cost"
> transactions. With a new part, if you receive it into stock before all
the
> labor (and subcontract) transactions that produced it are processed the
cost
> will be wrong. What's worse (and even easer to do) is to "backflush" or
> issue a stocked sub-component to another job (or ship it to a customer)
> before it gets a cost established from a MFG-STK transaction.
> These timing problems can play havoc with costs applied all the way down
the
> line. The only practical solution we've found was to establish and enter
a
> "starting point" cost when creating a new part. We're on average costing
> but I have the system calculate the standard cost and plug that in as the
> starting average cost. However, any old ballpark guess at what the cost
> should be is way better than leaving it blank. Wish they had covered this
> little "gotcha" in implementation/training. Average cost in Vantage seems
> to have a lot of potholes you have to watch out for. Negative inventory
> balances, adjustments when jobs close, and backflushing can all screw
things
> up big time. Do not even attempt to "auto-receive" unless you are on
> standard cost.
> Greg Clauser
> Lakin General Corporation
> gclauser@... <mailto:gclauser@...>
>
> Wayne:
>
> How new is your database? If you have only recently initialized Vantage,
> then there is no data in there to average. Your accounting dept. needs to
> go in there and enter a cost (Inventory Mgmt, GenOps, Cost Adjustment)-or
> you can have them look at the cost (from the job) at the time of the
receipt
> and enter that. We have a cost in all of our parts - Manufactured are
> Standard Costed and Purchased are Average-this was a decision made by our
> Accountant after attending the Controllers' Workshop. The manufactured
> items are then reviewed periodically and costs are adjusted.
>
> HTH
> Lydia
>
>
> -----Original Message-----
> From: Wayne Katzenberger [mailto:wkatz@...]
> Lydia,
>
> When we do a receipt from manufacturing a cost does not always show up.
If
> no cost show I have instructed my inventory control people to back out of
> the receipt until we can fix or determining the costs manually.
>
> We are costing using average costs.
>
> As far as I can tell, quantities move but the costs stay at zero. We have
> verified this because we watch for manufactured items with quantities but
> costs are zero. Our CFO has been indicating to me that our Inventory $
seem
> to be understated and this may be the problem.
>
> Wayne
>
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 15
> Date: Tue, 31 Oct 2000 08:51:41 -0000
> From: Gary Parfrey <garyp@...>
> Subject: Customer Statement Aging
>
> Hi Group
>
> A number of companies in the UK have problems with the aging on customer
> statements. In the UK it is accounting convention to age customer
> statements by invoice date or invoice fiscal period, not invoice due
date.
>
> Do you have this same problem in the states? Does anybody know a work
> around or a report that can get me out of trouble? Epicor have stated that
> this option will eventually come. they do not know when and told me not
to
> hold my breath!
>
> Can anybody help?
>
> Gary Parfrey
> Steatite Group Limited
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)