LS Retail - Quantity Sold Not Posted

anilkumar · 2009-08-24

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 · 2009-08-24

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 · 2009-08-25

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

anilkumar · 2009-08-25

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 · 2009-08-25

total for one item? or for all item?

anilkumar · 2009-08-25

Thanks for the reply....

for all items.

anilkumar · 2009-08-25

As per Variant wise.

ara3n · 2009-08-25

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

anilkumar · 2009-08-26

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

ara3n · 2009-08-26

Add another column Call Total for Item

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

anilkumar · 2009-08-27

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 · 2009-08-27

Yes, it's ok.

anilkumar · 2009-08-27

Thanks a lot Rashed for your support and guidence.

LS Retail - Quantity Sold Not Posted

Answers

Categories