Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OE Invoice need to supress multiple shipments

Status
Not open for further replies.

ZABARVAN

IS-IT--Management
May 24, 2003
186
SA
Hi,

We are using multiple shipments to ship an ordered items. like if we have an oder for item A for 100 tons and we are shipping 10 tons in each shipment. While printing invoice (oeinvo1.rpt or oeinv02.rpt) it is printing each shipment in the invoice. I need only one entry of all the shipments on the invoice instead of multiple shipments. I tried to supress this by modifying the oeinv01.rpt but could't do it. I tried to get the sum of each quantity shipped (sOrdS) but it always includes 1 extra record in the totals.

Would appreciate any help.
Thanks
Zab
 
Use OEINV04, then you can control it. OEINV01 is a datapipe, they're hard to work with.
 
Thanks ...

But I am getting an error "ERROR Load library" while checking this OEINV04. any dll missing or ....

Zab
 
Edit OERPRT.INI and comment out the three datapipe lines for the [OEINV01] section.
 

I found the following code in \sage Accpac\oe54A\OERPT.INI
Which one i have to remove, but there is no reference for
[OEINV04].

Thank u so much.

---------------------

[OEINV01]
type=DATAPIPE
heading=28040
crystal=OEINV01
orientation=portrait
paper size=1
optparams=11
2=SORTFROM STRING 28045
3=SORTTO STRING 28046
4=PRINTED STRING 28047
5=QTYDEC STRING 28260
6=DELMETHOD STRING 28261
7=ECENABLED STRING 28262
8=DIRECTEC STRING 28263
9=BOITEM STRING 28264
10=SWDELMETHOD STRING 28265
11=PRINTKIT STRING
12=PRINTBOM STRING
datapipe path=..\
datapipe query="oeinpr3.dll=OEINV01\n%SORTFROM%\n%SORTTO%\n%PRINTED%\n%DELMETHOD%\n%ECENABLED%\n%DIRECTEC%\n%BOITEM%\n1\n1\n1\n1\n0\n0\n0\n0\n0\n0\n0\n%SWDELMETHOD%\n"

'************** Object id = OE1400 ********************
[OEINV02]
type=DATAPIPE
heading=28050
crystal=OEINV02
orientation=portrait
paper size=1
optparams=11
2=SORTFROM STRING 28835
3=SORTTO STRING 28836
4=PRINTED STRING 28837
5=QTYDEC STRING 28850
6=DELMETHOD STRING 28851
7=ECENABLED STRING 28852
8=DIRECTEC STRING 28853
9=BOITEM STRING 28264
10=SWDELMETHOD STRING 28265
11=PRINTKIT STRING
12=PRINTBOM STRING
datapipe path=..\
datapipe query="oeinpr3.dll=OEINV01\n%SORTFROM%\n%SORTTO%\n%PRINTED%\n%DELMETHOD%\n%ECENABLED%\n%DIRECTEC%\n%BOITEM%\n%SWDELMETHOD%^oeinpr1.dll=OEINVS\n%SORTFROM%\n%SORTTO%\n%PRINTED%\n%DELMETHOD%\n%ECENABLED%\n%DIRECTEC%\n1\n1\n1\n1\n0\n0\n0"

'*
 

Thanks you so much your post really helped a lot.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top