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

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) / How to retrieve Sales ...
Microsoft Dynamics AX (Archived)

How to retrieve Sales Packing slip inventReportDimHistory

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

     I have customized the  AX Pro forma Invoice Report.  Th Site  BatchNo, Warehouse, Sales Qty has been fetched from the following statement.

salesQty    = UnitConvert::qty( inventReportDimHistory.Qty,

                                   custInvoiceTrans.inventTable().inventUnitId(),

                                   custInvoiceTrans.SalesUnit,

                                   custInvoiceTrans.ItemId);

return element.design().lookupLabel(literalstr("@SYS14578")) + strfmt(' : %1',salesQty ) + '   ' +

          FormLetter::inventDimReport(inventReportDimHistory.inventDim(), inventDimSetup, element.design());

My requirement  is to retrieve the same from custPackingSlipTrans table instead of  custInvoiceTrans table.

Is it possible to manipulate this by telling the InventReportDimHistory or InvenDimSetup to look in custPackingSlipTrans table ?

Please note that there could be more than one line returned as there can be manypacking slips per invoice.Hence would I need to iterate the results into a string ?

Your guidance is well appreciated!

Homer

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Good day,

     Any assistance on the above is appreciated. Meantime I will check the same for any possible solutions and post here if I find it.

    Have a good day ahead!

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi All,

      Found the answer. It is standard AX behavior  that is taking place. My requirement was to call the Pro Performa Packing slip dimensions from a duplicated report of Pro forma invoice. However, standard ax always taking the latest  POSTED packing slip's inventory dimensions on the Pro forma Inovice prinout.

    For what it is worth here's the statement to find the Inventory dimension and return the same

    return element.design().lookupLabel(literalstr("@SYS14578")) + strfmt(' : %1',salesQty ) + '  ' +

              FormLetter::inventDimReport(InventDim::find(custInvoiceTrans.InventDimId),inventDimSetup, element.design());

    If I want to do what I need to do here, the only way would be to duplicate the Pro forma packing slip, with a customisation to get the Unit price.

    Trust this may help anyone trying somthing similar.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 24

#2
Michel ROY Profile Picture

Michel ROY 14

#3
Jagadabi Profile Picture

Jagadabi 6

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans