Hello All!
I am using Vantage 8.03.409C. We periodically remove shipto information form our database through a .p program that Epicore developed for us. (This speeds up customer service order entry).
Last night i ran this .p file on a customer that is now EDI. in doing so this i causing an error when i go to Demand Review which says see app server logs.
When i go to the logs, it says it cant find the Ship To record but all of the orders in Demand Entry have the Ship to record. What can i do to remove this as i can use demand mass review right now. Any help is appreciated.
[15/09/02@11:44:25.318-0400] P-005408 T-007028 1 AS -- (Procedure: 'as/activate.p' Line:380) Incoming call from 2KFGW5JC1:1
[15/09/02@11:44:25.318-0400] P-005408 T-007028 4 AS AS -- TRACE: SINGLE-RUN Procedure bo/DemandEntry.p:GetList START (8458)
[15/09/02@11:44:25.318-0400] P-005408 T-007028 3 AS AS requestID= NULL
[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- ** No ShipTo record is available. (91)
[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- ** 4GL Debug-Alert Stack Trace **
[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- --> getAddrList Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 37660
[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- demandHeadAfterGetRows Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 33005
[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- getListRowLoaded Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 40095
[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- GetList Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 14196
First, that sounds sorta like a bad idea in the first place, but to answer your question, I would suggest you get in touch with Epicor about what your solution should be since the problem has stemmed from a program they wrote for you.
Without knowing any more than what is below, it sounds like the program was written and doesn’t check to make sure that the ShipTo information isn’t tied to an existing order prior to being deleted, thus giving you errors.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 02, 2015 11:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Demand Mass Review - See APPSERVER LOGS
Hello All!
I am using Vantage 8.03.409C. We periodically remove shipto information form our database through a .p program that Epicore developed for us. (This speeds up customer service order entry).
Last night i ran this .p file on a customer that is now EDI. in doing so this i causing an error when i go to Demand Review which says see app server logs.
When i go to the logs, it says it cant find the Ship To record but all of the orders in Demand Entry have the Ship to record. What can i do to remove this as i can use demand mass review right now. Any help is appreciated.
[15/09/02@11:44:25.318-0400] P-005408 T-007028 1 AS -- (Procedure: 'as/activate.p' Line:380) Incoming call from 2KFGW5JC1:1
[15/09/02@11:44:25.318-0400] P-005408 T-007028 4 AS AS -- TRACE: SINGLE-RUN Procedure bo/DemandEntry.p:GetList START (8458)
[15/09/02@11:44:25.318-0400] P-005408 T-007028 3 AS AS requestID= NULL
[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- ** No ShipTo record is available. (91)
[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- ** 4GL Debug-Alert Stack Trace **
[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- --> getAddrList Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 37660
[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- demandHeadAfterGetRows Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 33005
[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- getListRowLoaded Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 40095
[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- GetList Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 14196
It could be empty, not a null value, they are different and when Epicor deletes something they don’t usually make it null, they usually just delete it, thus making it an empty field.
I don’t know the details of the program enough to say for certain, I am just telling you what it sounds like happened, and it sounds like something stripped the ShipTo info out of open orders and based on what you describe, it sounds like  it would be a fault in the program they wrote.
This is something important, you should be on the phone escalating this with Epicor, and in a webex with them showing them the problem, preferably with whatever developer of theirs wrote that .p for you to make sure it’s actually doing what it’s supposed to be doing.
The flaw might be in the program checking closed orders, and deleting the shipto’s from closed orders, but not making sure there are no open orders that have the same shipto also connected to it. I don’t know this for sure is the problem, just a hunch based on what you described.
Hopefully I am wrong and it really is something completely different.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 02, 2015 3:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Demand Mass Review - See APPSERVER LOGS
Thanks Ned. The program does check to make sure that there are no open orders. it only removes the ship to information of closed/payed orders from months prior to the day i remove them. I have a call in with them but trying to see if i figure this out since they take forever and CS cant process the orders.
For a minute if we remove the back story and just focus on the fact that when i do a search in demand entry for this particular customer i get the error about no ship to information.
All the orders that have come into demand entry have the ship to information. It was a ship to prior to demand entry being implemented that was removed
The error points to the get list method finding a null value. When i did a query in sql, i didnt get no null values. Am i missing something?