NC实施工具-06管理报表库-报表.xlsVIP

WH04-Dist.Info.StockAging

WH03-库存分析报表

WH02-入库汇总统计表

WH01-收发存汇总表

IN04-Dist.InfoByMat.Hierarchy

IN03-Dist.InfoByRegion.City

IN02-D-StaffInformation

IN01-Dist.Investment

SO09-销售收入分析表-客户

SO08-销售收入分析表-产品

SO07-代销专柜进销存报表

SO06-Dist.OfftakeDaily

SO05-Dist.OfftakeBOMInfo

SO04-销售退货分析

SO03-销售综合报表

SO02-销售满足率报表

SO01-销售毛利分析表

PR01-采购订单执行统计表

BP01-SalesContractInformation

DIS-IIBWReportList

资产损益/ProfitandLoss

销售收入净额/distributorinvoicetostoresw/oVAT

减:销售进价成本/sales2)intoLRLinvoicepricew/oVAT

毛利/GrossProfit

Stocks(Warehosuecounter),AR(credittoretails,LRLAP),APtoLRL,ProfitandLoss(salesinretailpricew/oVAT,distributorinvoicetostoresw/oVAT,salesintoLRLinvoicepricew/oVAT,GrossProfit)

Brand:

DistributorPL

Viewby

Remark

POType:NormalPO,AllocationPO.

PODate:DistributorplacePOdateorSAPcreateallocationorderdate.

LOrealmaterialcode:samewithSAPmaterialcode.

Distributormaterialcode:materialcodemaintainedbydistributorthemselves.

POQty:DistributorplacePOQtyorAllocationordersQtywhichfromSAP.

DeliverQty:CSRissuedQty.

Bymaterial,PONO,MIVNo,date,

Bybrand,materialtype,materialgroup,material,stockmovementtype,date

Bybrand,materialtype,materialtype,material,warehouselocation,date

Bybrand,materialtype,materialtype,material,date,customer,businesstype

Bybrand,customer,date,businesstype,salesorder,

Bybrand,date,returntype,returnreason

ByDistributor,Brand,ContractNumber,ChainStore,Customer,ValidDate,tradingtermitem

Bydistriutor,brand,month

Warehouselocation:FGlocation,PLVlocation,Testerlocation,damagedlocation,Expiredlocation,KALocation

StockValue=stockqty*materialpurchaseprice

Stockcoverageday=stockqty/averageofftakeofPastXmonth

Stock180days=Stockqty-averageofftakeofpastXmonth*6

Businesstype:consignment/purchasemodule

Purchaseprices=basciretailprice*distributordiscount(samewithSAPsalesprice)

Salesvalue=