Updatable BAQ on PartTran.TranDate Field

Yahoo Archive
1

It was received in 2008, just screwing up transaction history “running totals” because it was dated 10/17/2014.

I updated the PartTran.TranDate with a BAQ.

 

You are correct though, going forward when someone brings me one say just done in the last couple of weeks I will correct it thru Receipt Entry.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Gary Parfrey
Sent: Tuesday, January 07, 2014 14:05
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Updatable BAQ on PartTran.TranDate Field

 

 

Patrick

 

Can’t you delete the receipt, change the receipt date and book back in or have you matched it to an invoice?

 

Gary

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: 07 January 2014 16:34
To: vantage@yahoogroups.com
Subject: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I have a PUR-STK transaction from 10/17/08 entered as 10/17/14.

ISSUE: My TimePhase “Running Total” is off.

I’m thinking of creating an Updatable BAQ and changing the PartTran.TRANDATE field to the 2008 receipt date.

Has anyone done this?

How are others handling this?

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

Patrick Winter

2
Updatable BAQ on PartTran.TranDate Field

I have a PUR-STK transaction from 10/17/08 entered as 10/17/14.

ISSUE: My TimePhase “Running Total” is off.

I’m thinking of creating an Updatable BAQ and changing the PartTran.TRANDATE field to the 2008 receipt date.

Has anyone done this?

How are others handling this?

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

Patrick Winter

3

I believed I used an Updatable BAQ to change this before.  It is the SysDate that you cannot update.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I have a PUR-STK transaction from 10/17/08 entered as 10/17/14.

ISSUE: My TimePhase “Running Total” is off.

I’m thinking of creating an Updatable BAQ and changing the PartTran.TRANDATE field to the 2008 receipt date.

Has anyone done this?

How are others handling this?

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

Patrick Winter

4

I will give it a try, thanks.

 

Patrick

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Cathy
Sent: Tuesday, January 07, 2014 11:18
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I believed I used an Updatable BAQ to change this before.  It is the SysDate that you cannot update.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I have a PUR-STK transaction from 10/17/08 entered as 10/17/14.

ISSUE: My TimePhase “Running Total” is off.

I’m thinking of creating an Updatable BAQ and changing the PartTran.TRANDATE field to the 2008 receipt date.

Has anyone done this?

How are others handling this?

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

Patrick Winter

5

We run into this every so often…

 

We do exactly this.

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

 

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I will give it a try, thanks.

 

Patrick

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Cathy
Sent: Tuesday, January 07, 2014 11:18
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I believed I used an Updatable BAQ to change this before.  It is the SysDate that you cannot update.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I have a PUR-STK transaction from 10/17/08 entered as 10/17/14.

ISSUE: My TimePhase “Running Total” is off.

I’m thinking of creating an Updatable BAQ and changing the PartTran.TRANDATE field to the 2008 receipt date.

Has anyone done this?

How are others handling this?

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

Patrick Winter

6

Her is a fun one. “Back to the Future – Epicor 9”

 

Vantage 6 my rolling century on the database was 1960.

My conversion to Epicor 9 rolling century on the database is 1930

 

I have found a transaction dated for 2040 which I can’t do the 2 adjustment method you mention.

I can see the transaction with a BAQ I created but can’t run the Inventory Quantity Adjustment on that date.

As soon as I enter 01/01/30 my Epicor 9 thinks I’m in the 19th century not the 20th.

I will have to Adjustable-BAQ-Hack this one out of the system.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Miguel Santillan
Sent: Tuesday, January 07, 2014 11:40
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

We run into this every so often…

 

We do exactly this.

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

 

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I will give it a try, thanks.

 

Patrick

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Cathy
Sent: Tuesday, January 07, 2014 11:18
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I believed I used an Updatable BAQ to change this before.  It is the SysDate that you cannot update.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I have a PUR-STK transaction from 10/17/08 entered as 10/17/14.

ISSUE: My TimePhase “Running Total” is off.

I’m thinking of creating an Updatable BAQ and changing the PartTran.TRANDATE field to the 2008 receipt date.

Has anyone done this?

How are others handling this?

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

Patrick Winter

7

enter 1/30/2040

 

if I just enter 1/30/40 it also goes to 1940, but by default my field is XX/XX/XXXX

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

Her is a fun one. “Back to the Future – Epicor 9”

 

Vantage 6 my rolling century on the database was 1960.

My conversion to Epicor 9 rolling century on the database is 1930

 

I have found a transaction dated for 2040 which I can’t do the 2 adjustment method you mention.

I can see the transaction with a BAQ I created but can’t run the Inventor y Quantity Adjustment on that date.

As soon as I enter 01/01/30 my Epicor 9 thinks I’m in the 19th century not the 20th.

I will have to Adjustable-BAQ-Hack this one out of the system.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Miguel Santillan
Sent: Tuesday, January 07, 2014 11 :40
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

We run into this every so often…

 

We do exactly this.

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

 

 

Miguel A. Santill an

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I will give it a try, thanks.

 

Patrick

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Cathy
Sent: Tuesday, January 07, 2014 11:18
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I believed I used an Updatable BAQ to change this before.  It is the SysDate that you cannot update.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I have a PUR-STK transaction from 10/17/08 entered as 10/17/14.

ISSUE: My TimePhase “Running Total” is off.

I’m thinking of creating an Updatable BAQ and changing the PartTran.TRANDATE field to the 2008 receipt date.

Has anyone done this?

How are others handling this?

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

Patrick Winter

8

FYI, an updatable BAQ did fix this.

 

Patrick

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 11:50
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

Her is a fun one. “Back to the Future – Epicor 9”

 

Vantage 6 my rolling century on the database was 1960.

My conversion to Epicor 9 rolling century on the database is 1930

 

I have found a transaction dated for 2040 which I can’t do the 2 adjustment method you mention.

I can see the transaction with a BAQ I created but can’t run the Inventor y Quantity Adjustment on that date.

As soon as I enter 01/01/30 my Epicor 9 thinks I’m in the 19th century not the 20th.

I will have to Adjustable-BAQ-Hack this one out of the system.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Miguel Santillan
Sent: Tuesday, January 07, 2014 11 :40
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

We run into this every so often…

 

We do exactly this.

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

 

 

Miguel A. Santill an

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I will give it a try, thanks.

 

Patrick

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Cathy
Sent: Tuesday, January 07, 2014 11:18
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I believed I used an Updatable BAQ to change this before.  It is the SysDate that you cannot update.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I have a PUR-STK transaction from 10/17/08 entered as 10/17/14.

ISSUE: My TimePhase “Running Total” is off.

I’m thinking of creating an Updatable BAQ and changing the PartTran.TRANDATE field to the 2008 receipt date.

Has anyone done this?

How are others handling this?

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

Patrick Winter

9

WOW.

 

Miguel, thank you for responding, this is rang a bell in my head and this is what I now know.

 

We have set by default on each client PC, (if you right click on the clock) to display the date in short form as MM/dd/yy.

This changes all the date fields and columns in Epicor 9 to dates without century.

We did this to clean up all Dashboards, Crystal Reports, and Crystal forms. Didn’t want to waste extra space always showing the century.

From your response below it made me realize this limited entering the Century when making these exception adjustments.

I could have fixed my example below without an updatable BAQ but will probably use the BAQ going forward because it’s a cleaner fix.

 

Thanks

 

Patrick

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Miguel Santillan
Sent: Tuesday, January 07, 2014 12:21
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

enter 1/30/2040

 

if I just enter 1/30/40 it also goes to 1940, but by default my field is XX/XX/XXXX

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

Her is a fun one. “Back to the Future – Epicor 9”

 

Vantage 6 my rolling century on the database was 1960.

My conversion to Epicor 9 rolling century on the database is 1930

 

I have found a transaction dated for 2040 which I can’t do the 2 adjustment method you mention.

I can see the transaction with a BAQ I created but can’t run the Inventor y Quantity Adjustment on that date.

As soon as I enter 01/01/30 my Epicor 9 thinks I’m in the 19th century not the 20th.

I will have to Adjustable-BAQ-Hack this one out of the system.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Miguel Santillan
Sent: Tuesday, January 07, 2014 11 :40
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

We run into this every so often…

 

We do exactly this.

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

 

 

Miguel A. Santill an

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I will give it a try, thanks.

 

Patrick

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Cathy
Sent: Tuesday, January 07, 2014 11:18
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I believed I used an Updatable BAQ to change this before.  It is the SysDate that you cannot update.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, January 07, 2014 9:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I have a PUR-STK transaction from 10/17/08 entered as 10/17/14.

ISSUE: My TimePhase “Running Total” is off.

I’m thinking of creating an Updatable BAQ and changing the PartTran.TRANDATE field to the 2008 receipt date.

Has anyone done this?

How are others handling this?

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

Patrick Winter

10

Patrick

 

Can’t you delete the receipt, change the receipt date and book back in or have you matched it to an invoice?

 

Gary

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: 07 January 2014 16:34
To: vantage@yahoogroups.com
Subject: [Vantage] Updatable BAQ on PartTran.TranDate Field

 

 

I have a PUR-STK transaction from 10/17/08 entered as 10/17/14.

ISSUE: My TimePhase “Running Total” is off.

I’m thinking of creating an Updatable BAQ and changing the PartTran.TRANDATE field to the 2008 receipt date.

Has anyone done this?

How are others handling this?

Qty Adjust out of future dated receipt and Qty Adjust back in original date?

Patrick Winter