Calculate sales totals for partial quantity in X++

(0) Share

Report

Posted on by Reliable

2,015

Hi Techies,

We have a requirement where we need to get sales invoice totals from 'Totals' form of Sales orders. But here we need to modify the quantity and take the amount only for modified quantity in logic.

salesTotals = SalesTotals::construct(salesTable, SalesUpdate::All);
salesTotals.calc();

For instance - Suppose There is sales order having 2 sales lines with total sales qty 20 and each line is having 10 sales qty. Standard will show invoice amount on Sales totals form based on total qty of Sales order i.e., 20. But in our case , Out of 10 qty of first sales line , if we are doing work creation of partial 4 qty then invoice amount should be calculated based on 4 qty of first sales line and that amount to be shown up on new customize report before doing actual invoicing.

Can anyone guide on this please.

Thanks in advance.

Sangram

Categories:

Development / Customization / SDK

All responses (2)

Answers (0)

Reliable 2,015 on at

Like (0)

Report
RE: Calculate sales totals for partial quantity in X++

Thank you for reply Judy.

I guess we have found the solution.

We've populated SalesParmTable and SalesParmLine tables with Sales order details and updated SalesParmLine.DeliverNow quantity as load line quantity, which we are looking for.

Now constructed SalesTotals with salesParmTable with document status as confirmation.

salesTotals = SalesTotals::construct(salesParmTable, SalesUpdate::All, AccountOrder::None, salesParmTable.ParmId, salesParmTable.SalesId, DocumentStatus::Confirmation); salesTotals.calc();

This code worked with modified quantity (load line quantity) and given the expected result.
huijij 19,801 on at

Like (0)

Report

RE: Calculate sales totals for partial quantity in X++

Hi Sangram,

What have you done so far and have you encountered any challenges?