Is it possible to print Summarize customer invoices based on packing slip numbers into a single Sales Invoice?

(0) Share

Report

Posted on by Community Member

I try to do this procedure:

Summarize customer invoices based on packing slip numbers [AX 2012]

Click Accounts receivable > Periodic > Sales update > Invoice.
In the Quantity field, select Packing slip.
Click Select, and then modify the query, if changes are required. For example, you can select a range of dates for the Ship date field.
Click OK to close the Sales update form.
Select the Posting check box.
In the Print options field group, make any selections that are required.
On the Other tab, in the Summary update for field, select Packing slip.
Click Select packing slip.
In the Select packing slip form, review the list of packing slips in the upper pane. By default, all packing slips that are posted for the sales orders are included on the invoices. If you do not want the invoices to include some packing slips, clear the Include check box for those packing slips.
Click OK to close the Select packing slip form.
Click Arrange. The sales orders and lines are grouped by packing slip number.
Click the Lines tab. This tab displays the packing slip number and ship date. The packing slip number and ship date are also printed on the invoice, if you print invoice documents.
Click OK. The customer invoices are posted and printed.

But i want to print all packing slips from the same Sales Order into a single Sales Invoice without quantities grouped by products.

If i select "Invoice Account" on this point "7. On the Other tab, in the Summary update for field, select Packing slip", the report shown me the quantities of products grouped by Packing Slips, and i don´t want it.

Is it possible to print Summarize customer invoices based on packing slip numbers into a single Sales Invoice? How to do it?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

I am a bit confused about the steps and information provided above.

Can you let us know whether

(a) you can actually select the packing slips and get it invoiced but with a wrong invoice format? or

(b) that you cannot select and get the packing slips summarized and invoiced in the way required.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Really, i don´t know if it is possible or the user is inputting wrong the packing slips...

I select a sales order to invoice with various packing slips:

Note: I tried to select "Summary Update for" option to "Packing Slip" too, but the report show me one invoice for each packing slip of the same sales order, and i want receive all together on a single invoice.

Continuing with the explication...The Sales Order show three packing slips in the "Lines" tab. Two of them with various packing slips into it:

If we see each line of "Lines" tab, in the "Packing Slip" tab, we will see the next:

And print the invoice:

I want print the invoice with each line that there are in the "Packing List" tab, but with all packing slips existing on a sales order together on a single invoice. How i can do it?

Many thanks,

Javier

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Javier,

From what you mentioned above I would believe that this issue is related to your SSRS Report. What you can try doing in Standard AX is the following:

In the AR module navigate to the forms setup section. In the invoice section there is a parameter "print packing slip specifications" and there are a number of parameters that allow you specifying what needs to be shown on the invoice. Can you try activating those parameters and print invoices with those settings?

If those setups do not show you all the information you need then I would suggest that you talk to a developer who can help you modifying the invoice document.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Ludwig,

I´m sorry to reply you too late. But i can't do it before because i was busy for others projects.

If you see the third image, in the Lines tab, the Packing Slips are together in "<multiple>" lines. I want override the original query and see all Packing Slips each in a only line. If i have 7 packing slips, i want see 7 lines without "<multiple>" lines in Lines tab, but i don´t know how do it. I´m the developer in my organization.

Best Regards,
Javier

Was this reply helpful? Yes No