DynamicsAX进销存(I)

第二课进销存(I)2006年5月8日本课讲述《Trade&LogisticsI》的内容内容提要基础资料仓库、物料、客户、供应商等采购订单/销售订单退货超交/短交序列号和批号、物料维度杂费检验ABC分类基础资料—仓库warehouseTypeDefault—正常仓Quarantine—检验仓Quarantinewarehouse正常仓对应的检验仓基础资料—物料itemItemtype物料类型Item物料BOM半成品/成品Service服务改变ItemType:[Functions][Changeitemtype]基础资料—物料itemItemgroup物料组用于定义过帐对应的会计科目InventoryPosting进入方法一：[Itemgroup][posting]进入方法二：[Inventorymanagement][setup][posting][posting]根据item和customer/vendor选择相应会计科目。优先级：tablegroupallItem的优先级高于customer和vendor。基础资料—物料itemIventorymodelgroup库存模型组六种成本计算方法：FIFOLIFOLIFOdateWeightedavg.Weightedavg.dateStandardcost基础资料—物料itemInventorymodelgroup库存模型组Quarantinemanagement检验管理physicalinventory物理库存financialinventory财务库存基础资料—物料itemDimensiongroup维度组itemdimension物料维度configuration配置size大小color颜色storagedimension库存维度warehouse仓库batchnumber批号location货位palletId托盘号serialnumber序列号Dimension维度用于单据中department部门costcenter成本中心purpose用途标准版为3个，如有需要可增加和改名，最多可达8个。基础资料—物料item新建Item其中Itemnumber,Itemtype,Itemgroup,Iventorymodelgroup,Dimensiongroup为必填项。基础资料—物料item成本/价格及计算方式销售价计算方式：None不计算Contributionratio按利润率计算salesprice=baseprice/(1-Contributionratio/100)Misc.chargespct.基于杂费计算salesprice=baseprice*(1+Misc.chargespct./100)Baseprice可以按purchaseprice和costprice.基础资料—物料itempurchases/cost/salespriceprice价格priceunit价格倍数pricemisc.charges杂费价格pricequantity杂费价格倍数incl.inunitprice固定/变动杂费基础资料—物料itempurchases/cost/salesquantityunit单位multiple批量minorderquantity最小订单量maxorderquantity最大订单量standardorderquantity默认订单量基础资料—客户customercusomergroup客户组InventoryPosting进入方法一：[Itemgroup][setup][inventoryposting]进入方法二：[Inventorymanagement][setup][posting][posting]根据item和customer/vendor选择相应会计科目。优先级：tablegroupallItem的优先级高于customer和vendor。基础资料—供应商vendorvendorgroup客户组InventoryPosting进入方法一：[Itemgroup][setup][inventoryposting]进入方法二：[Inventorymanagement][setup][posting][posting]根据item和customer/vendor选择相应会计科目。优先级：tablegroupallItem的优先级高于customer和vendor。采购订单—purchaseorder两种模式:Simple和Advanced六种PurchasetypeJornal草稿Quotation询价单Subscription重复订单Purchaseorder采购订单Ruterneditem采购退货订单Blanketorder协议订单采购订单—purchaseorderStatus单据状态openorderpurchaseorderreceivedlistreceivedpackingslipinvoicedinvoiceQuantity各种数量(计算关系?)quantity订单数量deliverremainer未收货数量received已收货数量invoiceremainer已收货未开票数量invoiced已开票数量采购订单—purchaseorderStatusTransactionPhysicaldateFinancialdateQuotationopenorderQuotationreceiptpurchaseorderopenorderOrdered(registration)registeredreceivedlistopenorderregisteredpackingslipreceivedreceivedinvoiceinvoicedpurchased注:subscription完全开票后单据状态变为openorder.Inventorypostingprofilepurchaseoreder—packingslip条件1：在inventorymodelgroup中选中postphysicalinventory条件2：在APparameter中选中postpackingslipinledger借：packingslip(库存商品—暂估)贷：packingslipoffset(材料采购—暂估)条件3：在inventorymodelgroup中选中postphysicalpurchase借：packingslippurchase(材料采购—暂估)借：packingsliptax(应交税金—进项暂估)贷：packingslippurchaseoffset(应付帐款—暂估)Inventorypostingprofilepurchaseoreder—invoice条件1：在inventorymodelgroup中选中postfinancialinventory首先将packingslip产生的凭证完全回冲。借：receipt(库存商品)借：salestaxreceivable(应交税金—进项)贷：summaryaccount(应付帐款)如果是标准成本,则会增加以下行:借:standardcostloss(标准成本差异—损失)贷:standardcostpiceoffset(库存商品)借:standardcostpiceoffset(库存商品)贷:standardcostprofit(标准成本差异—收益)退货发票产生的借贷方向依靠于creditnoteascorrection的设置.成本与退货价格的差异计入consumption.销售订单—salesorder两种模式:Simple和Advanced六种SalestypeJornal草稿Quotation询价单Subscription重复订单Purchaseorder采购订单Ruterneditem采购退货订单Blanketorder协议订单Itemrequirement用于project销售订单—salesorderStatus单据状态quotationconfirmationopenordersalesorderpickinglistdeliveredpackingslipinvoicedinvoice销售订单—salesorderQuantity各种数量1.quantity订单数量2.deliverremainer未发货数量3.delivered已发货数量4.invoiceremainer已发货未开票数量5.invoiced已开票数量计算关系:1=2+33=4+5销售订单—salesorderStatusTransactionPhysicaldateFinancialdateQuotationOpenorderQuotationIssue(confirmation)SalesorderopenorderOnorder(reservation)Reservedordered(registration)Reservedphysical(pick)PickedpickinglistopenorderpickedpackingslipDeliveredDeductedinvoiceinvoicedsold注:subscription完全开票后单据状态变为openorder.InventorypostingprofileSalesoreder—packingslip条件1：在inventorymodelgroup中选中postphysicalinventory条件2：在ARparameter中选中postpackingslipinledger借：packingslipoffset(销售成本—暂估)贷：packingslip(库存商品—暂估)条件3：在inventorymodelgroup中选中postphysicalrenvenue借：packingsliprevenceoffset(应收帐款—暂估)贷：packingsliprevence(销售收入—暂估)贷：packingsliptax(应交税金—销项暂估)InventorypostingprofileSalesoreder—invoice条件1：在inventorymodelgroup中选中postfinancialinventory首先将packingslip产生的凭证完全回冲。借：consumption(销售成本)贷：issue(库存商品)借：summaryaccount(应收帐款)贷：revence(销售收入)贷：salestaxreceivable(应交税金—销项)借:Commission(销售费用--佣金)贷:Commissionoffset(应付佣金)退货发票产生的借贷方向依靠于creditnoteascorrection的设置.成本取当前库存成本,也可以手工修改.销售订单—salesorderCopyformall从其他单据复制Quantityfactor复制数量的倍数invertsign数量取反recalulate重新计算价格…Copyfromjournal(不知何故,不能用)Createcreditnote只能对invoiced单据起作用。Createpurchaseorder（在SO中）createbasedonsalesorder（在PO中）根据销售订单建立采购订单Createreleaseorder根据blanketorder建立普通的订单SO/PO在blanketorder中可通过attachedorder(lines)查看关联的订单,单头/单行均可。采购退货/销售退货退货的两种方式订单上数量为负订单类型选returnitem输入RMAnumber,returnaction通过createcreditnote复制销售退货