web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Get USD totals from a ...
Microsoft Dynamics AX (Archived)

Get USD totals from a sales packing slip

(0) ShareShare
ReportReport
Posted on by Alberto Tapia 90

Hi,

Can anyone point me in the right direction on how is the best way to get the USD total of an specific packing slip?

Ex.
Lets say I have a sales order with 5 lines, then I ship only 2, so what I need is to get the total USD amount of that packing slilp of 2 lines (Including other charges and taxes, pretty much the same total amount I am going to have when I invoice this shipment, note that I still do not have the invoice of this shipment at the moment I want to get the total amount of the shipment by code)

*This post is locked for comments

I have the same question (0)
  • Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at

    Have you tried a Proforma invoice using Packing slip for the quantity?

    If you're talking about X++, then use the SalesTotals class.

  • Alberto Tapia Profile Picture
    Alberto Tapia 90 on at

    Hi Sukrut,

    I review the SalesTotals class before... and this class works with the SalesTable, so what if I have a partial shipment, I want the total USD for that partial shipment only, not the full sales order, so what I need will be the functionality of SalesTotals class but working against a CustPackingSlipJour table...

    And I just want to be sure that there is nothing out of the box that can help me to accomplish that before I start writing something custom.

  • Verified answer
    Andrew Xu Profile Picture
    Andrew Xu 3,877 on at

    Alberto,

    The SalesTotals class works not only with SalesTable, you can construct an instance of SalesTotals with SalesParmTable which is used to create a CustPackingSlipJour.

    Do this,

    SalesTotals salesTotals = SalesTotals::construct(salesParmTable, salesParmUpdate.SpecQty, salesParmUpdate.SumBy, salesParmUpdate.ParmId, salesParmUpdate.SumSalesId, documentStatus);

    then you can get your total with,

    salesTotals.totalAmount();

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans