× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MAPICS-L
  3. October 2002

Drop ship report

Hello List:

I need to write a report listing all drop shipments. How do I best
identify these? My first stab at it was to read MBDHREP (shipment header
PF), get the customer number, then read MBDEREP (ship-to PF) for the
default ship-to record for this customer (DEAA9L = 1), and pick up the
address code and address type. Then read MBALREP (address PF) using a
key of customer#, address code and address type. If the address field 1
in this record is different from the address field 1 in MBDHREP, I'm
calling it a drop ship.

It turns out that this is close, but there are lots of exceptions out
there throwing off my results. Does Mapics have a program?

Thanks in advance,

--
John Furniss
Applications Programmer
Allied Machine & Engineering Corp.
mailto:jfurniss@alliedmachine.com
Phone (330) 343-4283 ext. 8371

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.