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@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Greg Wenzloff
Sent: Tuesday, May 31, 2011 11:59 AM
To: mapics-l@xxxxxxxxxxxx
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@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/mapics-l.
midrange.com
