LS Retail - Quantity Sold Not Posted

anilkumar

Hi Nav Experts!

Good Evening!

Can any expert suggest or guide me how to store the value of Quantity sold not posted value as a field in table.

As you know we can see the value of Quantity sold not posted in Retail Item Card, it is calling the function (BOUtils.ReturnQtySoldNotPosted), and showing the value in Retail Item Card,
As I am customizing a form, but that form having multiple lines, so I am unable to get the values as per variants.

QtySoldNotPst := BOUtils.ReturnQtySoldNotPosted("No.",
GETFILTER("Store Filter"),
GETFILTER("Variant Filter"),
GETFILTER("Date Filter"));

if I want to store the value of QtySoldNotPst in the Transaction sales entry or any other table. How can I achieve.

Any help would be greatly appriciated!

ara3n

You mentioned you need it on a variant table?

You'll need to change the code to

QtySoldNotPst := BOUtils.ReturnQtySoldNotPosted("No.",
GETFILTER("Store Filter"),
"Variance Code" ),
GETFILTER("Date Filter"));

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

anilkumar

Thanks a lot Rashed.

Is it possible to create a field in Item table for QuantitySoldNotPost??

In my form now getting the values of QtySoldNotPst, but total getting problem.
As for Total, I created one push button, code written on push.

Please guide me.

ara3n

total for one item? or for all item?

anilkumar

Thanks for the reply....

for all items.

anilkumar

As per Variant wise.

ara3n

Is this list on the Item card or item list? or on variant list?

anilkumar

It's a Customized form(looks like Variant list).

ara3n

Add another column Call Total for Item

QtySoldNotPstItemTotal := BOUtils.ReturnQtySoldNotPosted("No.",
GETFILTER("Store Filter"),
'' ),
GETFILTER("Date Filter"));

anilkumar

Thanks Rashed, for the support and guidence.

Its working. but when filters applying that time it is not working.
my customized form, having filters in header part like store filter, division filter, etc.,
in lines have to display Itemno, Variant code, Avaiable stock in stores, etc.,

for available stock in stores, need to caliculate for quantity sold not posted in POS.

I tryed this way, add two flow fields, one to caliculate quantity sold in POS and other caliculating quantity from table "Trans. Sales Entry Status", deducting both the fields, then getting the value of Quantity sold not posted(the same logic used in BOUtils.ReturnQtySoldNotPosted function.

this is ok or any issues.

ara3n

Yes, it's ok.

anilkumar

Thanks a lot Rashed for your support and guidence.