Diff between Stock Status & GL Accounts - v8.03.404a

Yahoo Archive
1
Look for any PUR-UKN Part transactions that have hit the balance sheet



Gary

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Nigel Kerley
Sent: 18 June 2008 20:05
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Diff between Stock Status & GL Accounts -
v8.03.404a



Thanks for the reply Scott. But I'm afraid that's not it. There's
only one non-nettable bin setup in one of the companies and the value
of the stock in that doesn't cover the difference.

Nigel.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Scott Litzau" <scott.litzau@...>
wrote:
>
> This is most likely a reach but,
>
> What are the parameters you are using for Stock Status report. If
the "Include Non-Nettable Quantities" is checked and the Parts in
the Non-Nettable bin have a cost in the system (based on your costing
type) Stock Status report will include them in the overall value
>
> We just implemented Non-Nettable Bins and are doing some
reclassification of Parts of being Stock and Non-Stock. So if the
part was stock and had a standard cost in our system and then was
mark as non-stock and move to a Non-Nettable bin when you run Stock
Status report and have that check box check it includes the value,
even though we want it not to have value because it is in a Non-
Nettable bin.
>
> Scott Litzau, MCP
> Olympus Flag & Banner
> Information Systems Manager
> scott.litzau@...
> P: 414-365-9732
> F: 414-355-1931
>





[Non-text portions of this message have been removed]
2
here is the scenario: I am trying to generate e-mails to outside customers - an e-mail alert will be sent everytime something is shipped to them. The e-mail will essentially be the SO information, plus all the line items. In order to get the line items, some kind of looping will be needed to get all the line items in a SO. While this can be done with a select command and a datareader from within the code, I was wondering if anyone knows of an epi data type that does something similar so I can only use the views i define in data tools, instead of having to define connections and credentials in my VB code.

Thanks,
Kunal





[Non-text portions of this message have been removed]
3
What I did using help from another member was use a grid associated
with the dataview and then loop through each row. This was a native
control in the SO form calle grdLineList. Not sure if it will work
for what you are doing but it works great for us.

grdLineList.Rows(0).Selected = True
Dim OrderHed As EpiDataView = Ctype(oTrans.EpiDataViews
("OrderHed"),EpiDataView)
Dim OrderDtl As EpiDataView = Ctype(oTrans.EpiDataViews
("OrderDtl"),EpiDataView)
msgbox(i)
next
-------
I use this in the sales order to go through each line and perform
some code in place of where I have the messagebox.

--- In vantage@yahoogroups.com, Kunal Ganguly <kunal_vantage@...>
wrote:
>
> here is the scenario: I am trying to generate e-mails to outside
customers - an e-mail alert will be sent everytime something is
shipped to them. The e-mail will essentially be the SO information,
plus all the line items. In order to get the line items, some kind
of looping will be needed to get all the line items in a SO. While
this can be done with a select command and a datareader from within
the code, I was wondering if anyone knows of an epi data type that
does something similar so I can only use the views i define in data
tools, instead of having to define connections and credentials in my
VB code.
>
> Thanks,
> Kunal
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Sorry forgot a line.


grdLineList.Rows(0).Selected = True
Dim OrderHed As EpiDataView = Ctype(oTrans.EpiDataViews
("OrderHed"),EpiDataView)
Dim OrderDtl As EpiDataView = Ctype(oTrans.EpiDataViews
("OrderDtl"),EpiDataView)
For i As Integer = 0 to OrderDtl.dataView.Count-1
msgbox(i)
next





--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
>
> What I did using help from another member was use a grid
associated
> with the dataview and then loop through each row. This was a
native
> control in the SO form calle grdLineList. Not sure if it will
work
> for what you are doing but it works great for us.
>
> grdLineList.Rows(0).Selected = True
> Dim OrderHed As EpiDataView = Ctype(oTrans.EpiDataViews
> ("OrderHed"),EpiDataView)
> Dim OrderDtl As EpiDataView = Ctype(oTrans.EpiDataViews
> ("OrderDtl"),EpiDataView)
> msgbox(i)
> next
> -------
> I use this in the sales order to go through each line and perform
> some code in place of where I have the messagebox.
>
> --- In vantage@yahoogroups.com, Kunal Ganguly <kunal_vantage@>
> wrote:
> >
> > here is the scenario: I am trying to generate e-mails to outside
> customers - an e-mail alert will be sent everytime something is
> shipped to them. The e-mail will essentially be the SO
information,
> plus all the line items. In order to get the line items, some kind
> of looping will be needed to get all the line items in a SO. While
> this can be done with a select command and a datareader from
within
> the code, I was wondering if anyone knows of an epi data type that
> does something similar so I can only use the views i define in
data
> tools, instead of having to define connections and credentials in
my
> VB code.
> >
> > Thanks,
> > Kunal
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
5
I am sure you could pull the information from the order rel search
business object into a dataset and loop through it with a for each
statement.

The trickiest part would be only generating the email once per
customer per order, especially is multiple releases / lines get
shipped at any one time.

--- In vantage@yahoogroups.com, Kunal Ganguly <kunal_vantage@...>
wrote:
>
> here is the scenario: I am trying to generate e-mails to outside
customers - an e-mail alert will be sent everytime something is
shipped to them. The e-mail will essentially be the SO information,
plus all the line items. In order to get the line items, some kind of
looping will be needed to get all the line items in a SO. While this
can be done with a select command and a datareader from within the
code, I was wondering if anyone knows of an epi data type that does
something similar so I can only use the views i define in data tools,
instead of having to define connections and credentials in my VB code.
>
> Thanks,
> Kunal
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
Bernie adds:
> The trickiest part would be only generating the email once per
> customer per order, especially is multiple releases / lines get
> shipped at any one time.

Customer/Supplier communication is one of the few places where batch
processing makes sense, IMHO. UPS Worldship does not send out shipping
notices until "End of Day" processing. Why? Unless you're shipping people
are really good, people will ship the wrong order or line or release
occasionally. Do you want those notices going out? Are you going to send a
notice for the "unshipment" and then another for the correct shipment? It
could make you look a little, er, unprofessional. Even if you are, as we are
at times, it seems best to isolate these errors and wait for a period where
you feel the transactions are correct and then transmit your communication.

This holds true for any communication outside your company: orders,
invoices, purchase orders, or even EDI.

Food for thought,

Mark W.
7
Maybe this is semantics.
But are you sure you want to pull sales order data?
In the case of shipping confirmations, I would not pull s/o data per se, but the line data for the shipment.
Then, I might base the email on the unique pack number, or tracking number...however you want, and then run is in a batch form, in case packers are voided at some point before the end of the day...you would not want emails going out and then have shipments voided, and even more emails go out...etc.

Carey


To: vantage@yahoogroups.comFrom: mmcwilliams22@...: Tue, 17 Jun 2008 20:22:15 +0000Subject: [Vantage] Re: looping - code customization




What I did using help from another member was use a grid associated with the dataview and then loop through each row. This was a native control in the SO form calle grdLineList. Not sure if it will work for what you are doing but it works great for us.grdLineList.Rows(0).Selected = TrueDim OrderHed As EpiDataView = Ctype(oTrans.EpiDataViews("OrderHed"),EpiDataView)Dim OrderDtl As EpiDataView = Ctype(oTrans.EpiDataViews("OrderDtl"),EpiDataView)msgbox(i)next-------I use this in the sales order to go through each line and perform some code in place of where I have the messagebox.--- In vantage@yahoogroups.com, Kunal Ganguly <kunal_vantage@...> wrote:>> here is the scenario: I am trying to generate e-mails to outside customers - an e-mail alert will be sent everytime something is shipped to them. The e-mail will essentially be the SO information, plus all the line items. In order to get the line items, some kind of looping will be needed to get all the line items in a SO. While this can be done with a select command and a datareader from within the code, I was wondering if anyone knows of an epi data type that does something similar so I can only use the views i define in data tools, instead of having to define connections and credentials in my VB code.> > Thanks,> Kunal> > > > > > [Non-text portions of this message have been removed]>






_________________________________________________________________
Need to know now? Get instant answers with Windows Live Messenger.
http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Refresh_messenger_062008

[Non-text portions of this message have been removed]
8
Thanks all for the great suggestions. I have changed course quite a bit after reading the thread!

Thanks,
Kunal



----- Original Message ----
From: Carey S <rotary1@...>
To: vantage@yahoogroups.com
Sent: Tuesday, June 17, 2008 4:36:08 PM
Subject: RE: [Vantage] Re: looping - code customization


Maybe this is semantics.
But are you sure you want to pull sales order data?
In the case of shipping confirmations, I would not pull s/o data per se, but the line data for the shipment.
Then, I might base the email on the unique pack number, or tracking number...however you want, and then run is in a batch form, in case packers are voided at some point before the end of the day...you would not want emails going out and then have shipments voided, and even more emails go out...etc.

Carey

To: vantage@yahoogroups .comFrom: mmcwilliams22@ yahoo.comDate: Tue, 17 Jun 2008 20:22:15 +0000Subject: [Vantage] Re: looping - code customization

What I did using help from another member was use a grid associated with the dataview and then loop through each row. This was a native control in the SO form calle grdLineList. Not sure if it will work for what you are doing but it works great for us.grdLineList. Rows(0).Selected = TrueDim OrderHed As EpiDataView = Ctype(oTrans. EpiDataViews( "OrderHed" ),EpiDataView) Dim OrderDtl As EpiDataView = Ctype(oTrans. EpiDataViews( "OrderDtl" ),EpiDataView) msgbox(i) next----- --I use this in the sales order to go through each line and perform some code in place of where I have the messagebox.- -- In vantage@yahoogroups .com, Kunal Ganguly <kunal_vantage@ ...> wrote:>> here is the scenario: I am trying to generate e-mails to outside customers - an e-mail alert will be sent everytime something is shipped to them. The e-mail will essentially be the SO information, plus all the line items. In order to get the line items, some kind of looping will be needed to get
all the line items in a SO. While this can be done with a select command and a datareader from within the code, I was wondering if anyone knows of an epi data type that does something similar so I can only use the views i define in data tools, instead of having to define connections and credentials in my VB code.> > Thanks,> Kunal> > > > > > [Non-text portions of this message have been removed]>

____________ _________ _________ _________ _________ _________ _
Need to know now? Get instant answers with Windows Live Messenger.
http://www.windowsl ive.com/messenge r/connect_ your_way. html?ocid= TXT_TAGLM_ WL_Refresh_ messenger_ 062008

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






[Non-text portions of this message have been removed]
9
We are having a problem in all four of our companies whereby the total stock value as per the Stock Status Report does not agree with the value as per the GL Accounts.

I THINK this difference started with SP404 but I'm not sure. If it was only happening in one of the companies I'd think we were doing something wrong but it's not.

- I've checked that all parts have valid GL codes - and the default is correctly set in Company Maintenance.
- I've checked that all Reason Codes (for Quantity Adjustments or Cost Adjustments) have valid GL codes.
- I've accounted for any COS/WIP left to be posted (Capture COS/WIP Activity).
- I've accounted for the issue re Sales Kits COS in an earlier version - one one of our companies uses Sales Kits.
- We're really only involved in distribution, so it's nothing to do with job costs or anything like that.

On one day last month, one company had a difference (for that day alone) of c.€2,500. I've tried as best I can to print off all PartTrans entries for that day (there's a bug whereby you can't run a SQL filter on the SysDate field) and compare them to all GL entries for that day. They all match.

What am I missing? Is there anything else anyone can suggest I check? Is anyone elst having this problem?


Thanks,

Nigel.





[Non-text portions of this message have been removed]
10
This is most likely a reach but,

What are the parameters you are using for Stock Status report. If the "Include Non-Nettable Quantities" is checked and the Parts in the Non-Nettable bin have a cost in the system (based on your costing type) Stock Status report will include them in the overall value

We just implemented Non-Nettable Bins and are doing some reclassification of Parts of being Stock and Non-Stock. So if the part was stock and had a standard cost in our system and then was mark as non-stock and move to a Non-Nettable bin when you run Stock Status report and have that check box check it includes the value, even though we want it not to have value because it is in a Non-Nettable bin.

Scott Litzau, MCP
Olympus Flag & Banner
Information Systems Manager
scott.litzau@...
P: 414-365-9732
F: 414-355-1931


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Nigel Kerley
Sent: Wednesday, June 18, 2008 1:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Diff between Stock Status & GL Accounts - v8.03.404a

We are having a problem in all four of our companies whereby the total stock value as per the Stock Status Report does not agree with the value as per the GL Accounts.



I THINK this difference started with SP404 but I'm not sure. If it was only happening in one of the companies I'd think we were doing something wrong but it's not.



- I've checked that all parts have valid GL codes - and the default is correctly set in Company Maintenance.

- I've checked that all Reason Codes (for Quantity Adjustments or Cost Adjustments) have valid GL codes.

- I've accounted for any COS/WIP left to be posted (Capture COS/WIP Activity).

- I've accounted for the issue re Sales Kits COS in an earlier version - one one of our companies uses Sales Kits.

- We're really only involved in distribution, so it's nothing to do with job costs or anything like that.



On one day last month, one company had a difference (for that day alone) of c.2,500. I've tried as best I can to print off all PartTrans entries for that day (there's a bug whereby you can't run a SQL filter on the SysDate field) and compare them to all GL entries for that day. They all match.



What am I missing? Is there anything else anyone can suggest I check? Is anyone elst having this problem?





Thanks,



Nigel.







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


------------------------------------

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
11
Thanks for the reply Scott. But I'm afraid that's not it. There's
only one non-nettable bin setup in one of the companies and the value
of the stock in that doesn't cover the difference.

Nigel.

--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...>
wrote:
>
> This is most likely a reach but,
>
> What are the parameters you are using for Stock Status report. If
the "Include Non-Nettable Quantities" is checked and the Parts in
the Non-Nettable bin have a cost in the system (based on your costing
type) Stock Status report will include them in the overall value
>
> We just implemented Non-Nettable Bins and are doing some
reclassification of Parts of being Stock and Non-Stock. So if the
part was stock and had a standard cost in our system and then was
mark as non-stock and move to a Non-Nettable bin when you run Stock
Status report and have that check box check it includes the value,
even though we want it not to have value because it is in a Non-
Nettable bin.
>
> Scott Litzau, MCP
> Olympus Flag & Banner
> Information Systems Manager
> scott.litzau@...
> P: 414-365-9732
> F: 414-355-1931
>