Jump to content


Photo

Need help with Order & Account States


  • Please log in to reply
2 replies to this topic

#1 admin

admin

    Supreme Commander

  • Admin
  • PipPipPip
  • 75 posts

Posted 06 April 2006 - 12:58 PM

Here are all the account states as they are listed in the mom database, I have labeled the ones that I am pretty sure I know. Can anyone help me figure out the ones that I don't know or fill in any states that are missing and their associated values?

Order States:

BO = Back Ordered Item In Order
CA = ?
CD = Credit Card Problems
CN = Order Canceled
CP = ?
IN = ?
PE = ?
PI = ?
PS = ?
QO = ?
SH = Order Shipped
UO = Order On Hold


Account States:

BL = ?
CO = ?
HP = ?
QO = ?
RF = ?


FYI, these are the raw states as they are listed in the database.

Thanks,

Dana
Make sure to tell all the MOM users you know about this site!

#2 interwoven

interwoven

    Advanced Member

  • Members
  • PipPipPip
  • 33 posts

Posted 07 April 2006 - 08:58 AM

Here are all the account states as they are listed in the mom database, I have labeled the ones that I am pretty sure I know. Can anyone help me figure out the ones that I don't know or fill in any states that are missing and their associated values?

Order States:

BO = Back Ordered Item In Order
CA = ?
CD = Credit Card Problems
CN = Order Canceled
CP = ?
IN = ?
PE = ?
PI = ?
PS = ?
QO = ?
SH = Order Shipped
UO = Order On Hold
Account States:

BL = ?
CO = ?
HP = ?
QO = ?
RF = ?
FYI, these are the raw states as they are listed in the database.

Thanks,

Dana



Line Item Status Codes

The following status codes apply to each line item. These codes provide an easy way of determining the last completed stage of Order Processing for the item.

For stocked items filled with in-house inventory.

BO - back ordered. The item is currently out-of-stock.

CM - committed for sale to the customer. No processing has been completed. The item has not yet been picked, invoiced, packed or shipped.

PI - picked, but not invoiced or packed. Stage 1, Pick List/Tickets, of order processing has been completed.

PB - partial backorder.

PS - pending shipment - packed but not shipped. Stages 2 (Packing Slips), 3 (Gift Certificates) and 4-5 (Box Labels/COD Tags) of order processing have been completed.

SH - shipped. All order processing has been completed for the item. The ship date is displayed in the Line Item Detail tab in the LINE ITEM STATUS field.

QO - quotation. This indicates that an item is part of a quotation and has not actually been ordered yet.

SV - service item. This indicates that the item is a service item that does not have any physical inventory and is therefore not tracked with the status codes for a regular item that has to be shipped.

For drop-shipped items filled directly by suppliers.

ND - not ordered. The item has been sold to the customer but not ordered from the supplier.

OD - ordered. The item has been ordered from the supplier. If the customer has paid by credit card, the card has been charged and a drop ship purchase order has been generated in Stage 8-9 of order processing.

FD - filled. The item has been recorded as delivered in the Receive Product function, but the item has not been invoiced in Stage 11 of order processing.

SH - drop shipped. All order processing has been completed for the item.

QO - quotation. This indicates that an item is part of a quotation and has not actually been ordered yet.

For all items.

HS - hold shipment. The item has been assigned a future ship date in the SCHEDULE SHIP DATE field of the Line Item Detail tab.

RT - return. The item is a returned item from the customer.

From the MOM Help file but I see it's still not complete.

#3 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 07 April 2006 - 12:16 PM

My 2 cents:

Account type of the transaction, designating
whether this is a Sales transaction or a Payment
transaction.

Sales transactions are:
IN=Invoice and IR=Invoice Reset.

Payment transactions are:
PI=Initial Payment;
PY=Additional Payment;
RF=Refund;
DD=Deferred Credit;
DC=Deferred
Debit (Note that these were misnamed...this is
incorrect in MOM help, but all of the rest of the
debits and credits are named correctly);
AD=Applied Debit;
AC=Applied Credit;
BD=Bad
Debt;
LC=Application of Promotional Credit;
MD=Misc. Debit;
MC=Misc. Credit;
FC=Finance Charge;
FR=Finance Charge Reversal.

Status of the item in the order:
BO=Backordered;
PB=Partially backordered;
HS=On individual line item shipment hold;
CM=Committed;
PI=Picked;
FI=Filled;
PS=Pending shipment (packed, not yet
shipped);
RT=Returned;
OD=Drop shipped,
Ordered;
ND=Drop Shipped, Not yet ordered;
FD=Drop Shipped, Filled but not shipped;
SH=Shipped;
QO=Quotation;
SV=Service item;


Source : Out of Date MOM - Axton book - v4.3.
David Narciso
Ecommerce Operations Manager CVS Inc

dnarciso@cvsinc.ca

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users