Item <-> Item Ledger Entry

valkatamake

Hi I want to do report which shows me in specified period of time what item hasn't been sold but it is in inventory ...

Item - OnPreDataItem()
itemledger.RESET;
SETFILTER(Inventory,'>0');
date1:=CALCDATE(refdate,TODAY);
itemledger.SETRANGE("Posting Date",date1,TODAY);

Item - OnAfterGetRecord()
IF itemledger."Entry Type" = itemledger."Entry Type"::Sale THEN CurrReport.SKIP   ;

but they don't respond with each other

Sandeep_Prajapati

Item - OnPreDataItem()
itemledger.RESET;
SETFILTER(Inventory,'>0');
date1:=CALCDATE(refdate,TODAY);
itemledger.SETRANGE("Posting Date",date1,TODAY);

Item - OnAfterGetRecord()
itemledger.SETRANGE("Item No.",Item."No.");  // here it is linked now
itemledger.SETRANGE("Entry type",itemLedger."entry Type"::sale);
if ItemLedger.findset then
CurrReport.SKIP;

valkatamake

2 setranges ? :shock:

Sandeep_Prajapati

valkatamake wrote:

2 setranges ? :shock:

first one is for linking and
2nd one to filter all Item Ledger Entries of type : Sale
if there is any sale entry type the report skips the iteration for the item


This is what you wanted...?? Isn't it..??

Sandeep_Prajapati

Item - OnPreDataItem() 
SETFILTER(Inventory,'>0'); 
date1:=CALCDATE(refdate,TODAY); 


Item - OnAfterGetRecord()
itemledger.RESET; 
itemledger.SETRANGE("Posting Date",date1,TODAY);  
itemledger.SETRANGE("Item No.",Item."No.");  // here it is linked now 
itemledger.SETRANGE("Entry type",itemLedger."entry Type"::sale); 
if ItemLedger.findset then 
CurrReport.SKIP; 

Try this, as in the previous one ItemLedger Record will not get reset for the iterations of Item DataItem

Revolution1210

You should be able to get what you want from existing reports I think, if not then with a few tweaks here and there.

Inventory - Sales Statistics for example, you can run this with Include Items Not Sold ticked, and add a filter for Inventory > 0

valkatamake

Yes but I have to do it myself i'm applying for job and have to know these things before i get started