VANTAGE 财务借货关系

VANTAGE 财务借货关系

用了三年多VANTAGE,我突然发现,

Epicor Vantage 作为IT要用好的话,一定对借货关系要搞清

一旦借货关系搞清楚,你会发现VANTAGE 财务方面就很简单了, 财务方面就很简单,别的模块就更简单了, 希望我们IT少走些弯路,

举个InventoryWIP借和贷的例子

InventoryWIP Debit Credit.JPG (70.6 KB, 下载次数: 4) MSN:weit0297@yahoo.com.cn

其实Vantage的业务的借贷关系并不算太复杂，在8.03的帮助目录中已经有Job Costing Technical Reference Guide一书，其中已经全面解释了借贷关系。

Transaction Types

Transaction types classify the part transaction. The following abbreviated descriptions identify each type of transaction on a display window or printed report.

Adjustments

ADJ-MTL - Adjustment to job cost material ADJ-SUB - Adjustment to job cost subcontract

ADJ-PUR - Adjustment to purchase cost variance - Note: This transaction is created by the AP Invoice Entry program.

ADJ-CST - Adjustment to stock cost ADJ-QTY - Adjustment to stock quantity

Discrepant Material Reporting DMR-MTL - DMR to job material DMR-REJ - DMR to reject

DMR-SUB - DMR to subcontract

STK-DMR - Stock to DMR - Note: This transaction has been replaced by the STK-INS transaction, but STK-DMR is still recognized by the system for backwards compatibility. SUB-DMR - Subcontract to DMR DMR-STK - DMR to stock

Inspection Processing

ASM-INS - Assembly to Inspection INS-ASM - Inspection to assembly INS-DMR - Inspection to DMR

INS-MTL - Inspection to job material INS-STK - Inspection to stock INS-REJ - Inspection to reject

INS-SUB - Inspection to subcontract STK-INS - Stock to Inspection

SUB-INS - Subcontract to Inspection

Manufacturing

MFG-WIP - Manufacturing receipt to job MFG-PLT - Manufacturing receipt to plant MFG-STK - Manufacturing receipt to stock MFG-VAR - Manufacturing variance

MTL-DMR - Job material to DMR - Note: This transaction has been replaced by the MTL-INS transaction, but MTL-DMR is still recognized by the system for backwards compatibility. MTL-INS - Job material to Inspection

Plant

PLT-ASM - Plant to assembly

ADJ 调整 MTL 物料 SUB 外包 PUR 采购 CST 成本 QTY 数量

DMR 不良待处理 STK 仓库 INS 检验 ASM 装配 REJ 退回 MFG 制造 PLT 工厂 VAR 差异 UKN 未知 RMA 销退 KIT 打包 CUS 客户 SVG 残值 VEN 供应商 SRV 服务

COS 销售成本

transaction codes 1、PUR-STK

借：原材料 INVENTORY RM 贷：在途物资 AP CLEARING 2、STK-MTL

借：生产成本-在制原材料 WIP MTL

贷：原材料 INVENTORY RM 3、PUR-MTL

借：生产成本-在制原材料 WIP MTL 贷：在途物资 AP CLEARING 4、PUR-SUB

借：生产成本-在制外包 WIP SUB 贷：在途物资 AP CLEARING 5、AP INVOICE ADJ-PUR 借：在途物资 AP CLEARING 贷：应付账款 AP 5a、物料

借：在途物资 AP CLEARING

借：生产成本-在制原材料 WIP MTL 贷：在途物资 AP CLEARING

贷：生产成本-在制原材料 WIP MTL 5b、外包

借：在途物资 AP CLEARING

借：生产成本-在制外包 WIP SUB 贷：在途物资 AP CLEARING

贷：生产成本-在制外包 WIP SUB 5c、库存

借：在途物资 AP CLEARING 贷：在途物资 AP CLEARING 贷：材料成本差异 VARIANCE 借：材料成本差异 VARIANCE

6、LABOR TRANSACTIONS人工事务 借：生产成本-在制人工 WIP LABOR 贷：APPLIED LABOR

借：生产成本-制造费用 WIP BURDEN 贷：APPLIED OH 7、MFG-CUS

借：主营业务成本/销售成本 COS 贷：生产成本-在制材料 WIP MTL 贷：生产成本-在制外包 WIP SUB 贷：生产成本-在制人工 WIP LABOR 贷：生产成本-制造费用 WIP BURDEN 8、MFG-STK

借：产成品 INVENTORY FG

贷：生产成本-在制材料 WIP MTL 贷：生产成本-在制外包 WIP SUB 贷：生产成本-在制人工 WIP LABOR 贷：生产成本-制造费用 WIP BURDEN

9、MFG-VAR

借：销售成本 COS 借：MFG VARIANCE

贷：生产成本-在制材料 WIP MTL 贷：生产成本-在制外包 WIP SUB 贷：生产成本-在制人工 WIP LABOR 贷：生产成本-制造费用 WIP BURDEN

ADJ-CST

ADJ-CST Transaction 1 减少物料PARTS成本 ADJ-CST Transaction 2 增加物料成本

ADJ-CST Transaction 3 以标准成本接收PO时

当采购单成本大于标准成本时，创建这个事务3。 整个采购单成本记录于存货账户（原材料RM）

调整差值记录于AP clearing账户（并不一定就是在途物资） 借：原材料 （计划成本/标准成本） 借：AP CLEARING 差异值

贷：在途物资或材料采购（实际成本） 此处的理解，问题很大，待慢慢看书理解 ADJ-CST Transaction 4

当采购单成本小于标准成本时，创建这个事务4。 其余同事务3。

ADJ-CST Transaction 5

PUR-STK

PUR-STK Transaction 1 PO接收入库

PUR-STK Transaction 2 杂项接收入库

PUR-MTL

PUR-MTL Transaction 1

一个制造工单的，PO接收到工单物料 PUR-MTL Transaction 2

一个制造工单的，杂项接收到工单物料 PUR-MTL Transaction 3

一个维修请求相关的维修工单service job，PO接收到工单物料 PUR-MTL Transaction 4

一个维修请求相关的维修工单service job，杂项接收到工单物料

PUR-MTL Transaction 5

一个劳务合同相关的劳务工单service job，PO接收到工单物料 PUR-MTL Transaction 6

一个劳务合同相关的劳务工单service job，杂项接收到工单物料 PUR-MTL Transaction 7

一个保修相关的保修工单service job，PO接收到工单物料 PUR-MTL Transaction 8

一个保修相关的保修工单service job，杂项接收到工单物料