Re: Where are shipping instructions stored?

Greg-

I was thinking it might be in the ship-to/address/override files, so I ran the following SQL to see if there were any inconsistencies.

SELECT C6CVNB, C6CDTX, C6CANB, C6B9CD, C6HECD,                
soldto.ALCDTX, shipto.alcdtx                                  
FROM amflib.mbc6rep                                           
join amflib.mbderep on c6aenb = deaenb and c6canb = decanb and
  c6b9cd = deb9cd                                             
left join amflib.mbalrep SOLDTO on c6aenb = soldto.alaenb     
  and c6canb = soldto.alcanb                                  
  and c6hecd = soldto.alcucd                                  
left join amflib.mbalrep SHIPTO on c6aenb = shipto.alaenb     
  and c6canb = shipto.alcanb                                  
  and decucd = shipto.alcucd                                  
WHERE C6B9CD like '¿·%' and                                   
c6dccd = 1                                                    

I didn't find any problems on our system, but perhaps that is where the problem is at.

-Tom Stieger
IT Manager
California Fine Wire

-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff
Sent: Tuesday, May 31, 2011 11:59 AM
To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]
Subject: [MAPICS-L] Where are shipping instructions stored?

I'm in COM order inquiry.
Pressed 5 on this order then Enter Enter to get to the panel shown:

 

Order/Customer  . . :   CO 643907   170000 ARCO IND SUPPLY CORP

Ship to . . . . . . :            (Override)     Shipment lead time . :

Addressee name  . . :   ARCO IND SUPPLY CORP

Address line 1  . . :   318 TEN EYCK ST

             2  . . :

             3  . . :                                   
City/State/Postal . :   BROOKLYN                            NY  11206

Country . . . . . . :   USA

Contact name  . . . :

Telephone/Fax number    (718)497-1167           (718)381-3755

Shipping instructions   PPD & CHG FRT

Shipping location . :

etc

I first looked in file MBC6REP field C6CDTX but it is empty.
Where else could that PPD & CHG FRT be stored?

Thanks,
Greg

XAR4

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.