Lot Tracking 8.03.407

Yahoo Archive
1
Hello all

I am looking for some ideas on how any of you have handled lot traceability. More specifically I want to trace the heat number of the steel as it is received in the first operation throughout all the operations and all the sub-assemblies on that job. I am thinking of writing a BPM that as quantity is reported against subsequent operations it dumps that lot number into a user-defined field in JobOper and JobAssmbl. Am I overthinking this or is there a better out-of-the-box functionality?

Vantage 8.03.407 with AMM.

This functionality is in E9 with Serial Number Matching which displays all of the top level serial numbers on the job. When one of the serial numbers is selected the system displays a list of all of the serial tracked materials that were issued to the job. The entry of the component serial number then creates the link between the component serial and the parent serial number.
As the individual serial number is entered, the system first determines the source, which could be a purchase order or a job. If it is a purchase order then the method of manufacture is exploded to determine the serial tracked components that require to be matched. If the source is from a job then the serial tracked components to be matched are determined from the job material table..



Ann Fisher

www.advantagebusinesscreations.com







[Non-text portions of this message have been removed]
2
Vantage 8.03.408A Progress

I've recently ran across something about Invoices that I thought I would share with this group. Specialy since I've noticed a few people posting issues about problems getting correct totals on Invoices.

I had a Dashboard that showed daily invoice totals. It was pointed out to me one day that the total was off by $20,000. I found out that you can't just sum up the Invchead.docinvoiceamt. There was an invoice that had a prepayment of $20,000 and the Invchead.docinvoiceamt for that invoice was $20,000 less then the total amount. So to get the total invoice amount, you need to add Invchead.docinvoiceamt and Invchead.docdepositcredit.
3
do you sum up the group to get the invoice total or do you show it in a textbox or field.

I am trying to show the total for canceled orders on a dashbaord in a calculated field. If yuo are using a calc field can yu post it so i can take a look at it.
4
I just use a calculated field in the BAQ to sum up the two fields for each invoice (Invchead.docinvoice + Invchead.docdepositcredit). Its in the dashboard where I filter the invoices by day and then use the "Show Summaries" to Sum the Invoice amounts.




________________________________
From: "michellesatullo@..." <msatullo@...>
To: vantage@yahoogroups.com
Sent: Wednesday, July 29, 2009 3:18:33 PM
Subject: [Vantage] Re: Invoice Totals

Â
do you sum up the group to get the invoice total or do you show it in a textbox or field.

I am trying to show the total for canceled orders on a dashbaord in a calculated field.. If yuo are using a calc field can yu post it so i can take a look at it.







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