Sales Order Total

Yahoo Archive
1
You are correct, I was mixing my PO and SO trying do too many things at
the same time. And yes, linking OrderRel to the ShipTo is getting messy
but possible.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Tuesday, April 24, 2007 1:32 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sales Order Total.



> You can do misc charges to the order (POHedMisc) or to line (POMisc)
and
> both are displayed in the Order Tracker.

Actually, for Sales Orders the misc charges are in OrderMsc and the line
number is 0 (or null) for header charges.

> I'm not sure what you mean by the second statement. Of course you can
> link the OrderRel to OrderHed. The key fields in the OrderHed are
> OrderNum and Company, both of which are in the OrderRel record.

Sorry, I meant the OrderRel to the ShipTo. Yes, it includes the
ShipToNum but
you have to link back to the OrderDtl to get the Customer Id. Makes a
BAQ
backlog more difficult than it needs to be.

Mark W.




This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

[Non-text portions of this message have been removed]
2
How do you get the "Sales Order Total" in "Summary" or the Sales Order
Entry screen to display on a BAQ?

I'm looking for the table/field this information is located in.
Version 8.0

Thanks,

--SF
3
OrderHed (who, where), OrderDtl (what, how much), and OrderRel (when).

You can add the Extended Price (ExtPrice) from OrderDtl and then Show
Summaries to get the order total.

What info are you looking for in a BAQ that's not in the Order Tracker
lists? All the data is available here but you may need to reorganize
and/or do some simple customization to it.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sanfranc415
Sent: Monday, April 23, 2007 12:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Order Total.



How do you get the "Sales Order Total" in "Summary" or the Sales Order
Entry screen to display on a BAQ?

I'm looking for the table/field this information is located in.
Version 8.0

Thanks,

--SF




This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

[Non-text portions of this message have been removed]
4
> What info are you looking for in a BAQ that's not in the Order Tracker
> lists?

Misc. charges, which are tricky because the quantity is based on a flag that
indicates that the charge occurs: for each shipment, for the first shipment,
or for every shipment.

> All the data is available here but you may need to reorganize
> and/or do some simple customization to it.

I wish that OrderRel contained all of the keys required to link back to the
header...

Mark W.
5
You can do misc charges to the order (POHedMisc) or to line (POMisc) and
both are displayed in the Order Tracker.

I'm not sure what you mean by the second statement. Of course you can
link the OrderRel to OrderHed. The key fields in the OrderHed are
OrderNum and Company, both of which are in the OrderRel record.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Tuesday, April 24, 2007 10:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sales Order Total.



> What info are you looking for in a BAQ that's not in the Order Tracker
> lists?

Misc. charges, which are tricky because the quantity is based on a flag
that
indicates that the charge occurs: for each shipment, for the first
shipment,
or for every shipment.

> All the data is available here but you may need to reorganize
> and/or do some simple customization to it.

I wish that OrderRel contained all of the keys required to link back to
the
header...

Mark W.




This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

[Non-text portions of this message have been removed]
6
> You can do misc charges to the order (POHedMisc) or to line (POMisc) and
> both are displayed in the Order Tracker.

Actually, for Sales Orders the misc charges are in OrderMsc and the line
number is 0 (or null) for header charges.

> I'm not sure what you mean by the second statement. Of course you can
> link the OrderRel to OrderHed. The key fields in the OrderHed are
> OrderNum and Company, both of which are in the OrderRel record.

Sorry, I meant the OrderRel to the ShipTo. Yes, it includes the ShipToNum but
you have to link back to the OrderDtl to get the Customer Id. Makes a BAQ
backlog more difficult than it needs to be.

Mark W.